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.
Execute SQL queries on OceanBase database with proper error handling and secure database access.
Get information about the current tenant in the OceanBase database system.
Get all server nodes information (available for sys tenant only) to monitor cluster status.
Get resource capacity information (available for sys tenant only) to check system resources.
Get ASH (Active Session History) report for database performance analysis and troubleshooting.
Search OceanBase documentation from the official website. This tool is experimental as the API may change.
{
"mcpServers": {
"oceanbase": {
"command": "uv",
"args": [
"--directory",
"path/to/mcp-oceanbase",
"run",
"oceanbase_mcp_server"
],
"env": {
"OB_HOST": "localhost",
"OB_PORT": "2881",
"OB_USER": "your_username",
"OB_PASSWORD": "your_password",
"OB_DATABASE": "your_database"
}
}
}
}