OceanBase MCP Server
@yuanoOo
About OceanBase MCP Server
A Model Context Protocol (MCP) server that enables secure interaction with OceanBase databases. This server allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"oceanbase_mcp_server": {
"command": "python",
"args": [
"-m",
"oceanbase_mcp_server"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is OceanBase MCP Server?
A Model Context Protocol (MCP) server that enables secure interaction with OceanBase databases. It allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
How to use OceanBase MCP Server?
Install via pip install oceanbase-mcp-server, set environment variables (OB_HOST, OB_PORT (defaults to 2881), OB_USER, OB_PASSWORD, OB_DATABASE), then either configure in Claude Desktop's claude_desktop_config.json or run standalone with python -m oceanbase_mcp_server.
Key features of OceanBase MCP Server
- List available OceanBase tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging
Use cases of OceanBase MCP Server
- AI-assisted database exploration and analysis
- Querying data without exposing raw credentials to the assistant
- Controlled read and list operations on OceanBase tables
- Secure database interaction from AI assistants like Claude Desktop
FAQ from OceanBase MCP Server
How do I install OceanBase MCP Server?
Run pip install oceanbase-mcp-server in your Python environment.
What environment variables are required?
OB_HOST, OB_USER, OB_PASSWORD, and OB_DATABASE are required; OB_PORT defaults to 2881 if not set.
Can I run OceanBase MCP Server standalone?
Yes, after installing dependencies, run python -m oceanbase_mcp_server.
What security measures should I take?
Create a dedicated OceanBase user with minimal permissions, never use root credentials, restrict database access, enable logging, and always follow the principle of least privilege.
What tools does OceanBase MCP Server expose?
It lists tables as resources, reads table contents, and executes SQL queries with error handling — all through the Model Context Protocol.
Frequently asked questions
How do I install OceanBase MCP Server?
Run `pip install oceanbase-mcp-server` in your Python environment.
What environment variables are required?
`OB_HOST`, `OB_USER`, `OB_PASSWORD`, and `OB_DATABASE` are required; `OB_PORT` defaults to 2881 if not set.
Can I run OceanBase MCP Server standalone?
Yes, after installing dependencies, run `python -m oceanbase_mcp_server`.
What security measures should I take?
Create a dedicated OceanBase user with minimal permissions, never use root credentials, restrict database access, enable logging, and always follow the principle of least privilege.
What tools does OceanBase MCP Server expose?
It lists tables as resources, reads table contents, and executes SQL queries with error handling — all through the Model Context Protocol.
Basic information
More Databases MCP servers
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
MCP Server for Milvus
zilliztechModel Context Protocol Servers for Milvus
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Comments