OceanBase MCP
by OceanBase
Distributed HTAP database for SQL queries and schema management via MCP
database Python Intermediate Self-hostable
⭐ 50 stars 📅 Updated: 1mo ago
Description
MCP server for OceanBase, a distributed database that supports both transactional (OLTP) and analytical (OLAP) processing in a single system — known as HTAP (Hybrid Transactional/ Analytical Processing). This server enables AI assistants to execute SQL queries, explore table schemas, list tables, and manage database objects on OceanBase clusters. OceanBase is designed for mission-critical applications requiring high availability, horizontal scalability, and strong consistency. It is MySQL-compatible and supports multi-tenancy, making it suitable for large enterprises managing multiple workloads on shared infrastructure.
✅ Best for
Enterprise teams running mixed transactional and analytical workloads on a distributed database with high availability requirements
⏭️ Skip if
You need a lightweight local database or your workloads are small enough for a single-node setup
💡 Use cases
- Executing SQL queries on distributed HTAP databases from AI assistants
- Exploring table structures and schema relationships in OceanBase clusters
- Managing database objects (tables, indexes, views) through natural language
- Running both transactional and analytical queries on a single database
👍 Pros
- ✓ True HTAP — handles both OLTP and OLAP in one system without data replication
- ✓ MySQL-compatible SQL dialect makes it familiar for LLMs to generate queries
- ✓ Distributed architecture with strong consistency and high availability
- ✓ Multi-tenant support for isolating workloads on shared infrastructure
👎 Cons
- ✗ Requires an OceanBase cluster deployment, which has significant resource requirements
- ✗ Smaller community outside of China compared to other distributed databases
- ✗ Configuration complexity — multi-tenant setup adds operational overhead
🔧 Exposed tools (4 tools)
| Tool | Category | Description |
|---|---|---|
| list_tables | discovery | List all tables in the current database or schema |
| describe_table | discovery | Get column details, types, and indexes for a table |
| manage_schema | management | Create, alter, or drop tables and database objects |
| execute_query | query | Execute a SQL query on the OceanBase database |
⚡ Installation
Prerequisites:
- • python v3.10+
- • OceanBase database credentials (host, port, user, password, tenant)
- • API key required
Check Claude Code documentation to configure this MCP server.
💡 Tips & tricks
OceanBase is MySQL-compatible, so standard SQL works for most operations. Always specify the tenant when connecting. Use list_tables to discover available objects before querying. For analytical queries on large datasets, OceanBase's columnar storage engine kicks in automatically — no special syntax needed.
🔄 Alternatives
Quick info
- Author
- OceanBase
- License
- Apache-2.0
- Runtime
- Python 3.10+
- Transport
- stdio
- Category
- database
- Difficulty
- Intermediate
- Self-hostable
- ✅
- Auth
- —
- Docker
- —
- Version
- latest
- Updated
- Feb 28, 2026
Client compatibility
- ✅ Claude Code
- ✅ Cursor
- ✅ VS Code Copilot
- ❓ Gemini CLI
- ✅ Windsurf
- ✅ Cline
- ❓ JetBrains AI
- ❓ Warp
Platforms
🍎 macOS 🐧 Linux 🪟 Windows