mcp · Global

oceanbase-mcp

Read-only MCP server for OceanBase metadata discovery and SQL access.

Claim this listing

Represent oceanbase-mcp? Send a claim for review so we can discuss listing updates. Claims do not automatically grant ownership or verification.

Data offered docs-verified: table structure · DDL · indexes · constraints · partitions · statistics · Oracle object metadata · query plans · ER relationship diagrams · metadata snapshots and diffs · impact reports · limited sample data
Formats docs-verified: MCP stdio · MCP HTTP · Mermaid · JSON · HTML
Access docs-verified: Open source under Apache-2.0; requires the user's own OceanBase database connection, configured via .env (OB_CONFIG_PATH); Node.js 20 or newer

Use cases llm-inferred: Map table relationships in a client's OceanBase-hosted monitoring or asset database into an ER diagram for a data handover pack · Review indexes and query plans on large gauge or survey tables before running reporting queries · Snapshot and diff database metadata between project iterations to produce a schema change impact report · Audit a client database's schema and sample rows (masked) during data due diligence
Audience llm-inferred: database administrators · data engineers · software developers

Constraints llm-inferred: Read-only by design: no MCP tool can write data or change database objects · SELECT * is blocked, and user SQL is limited to SELECT, WITH and read-only EXPLAIN · Requires an OceanBase instance in MySQL or Oracle compatibility mode and user-supplied connection config · Requires Node.js 20 or newer · Database access tool only; provides no UK water, civils or environmental datasets · Sample data is limited and masked

Auto-extracted, unverified fields: tools, install, auth. Check upstream documentation.

Tools/install/auth auto-extracted from README; quality score heuristic (stars, recency, tool count, licence).

Metadata observed 15/10/2026 · research sweep: github-search