LogoSTMCP
Download
OceanBase MCP Server

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.

Tools

1. execute_sql_query

Execute SQL queries on OceanBase database with proper error handling and secure database access.

2. get_current_tenant

Get information about the current tenant in the OceanBase database system.

3. get_all_server_nodes

Get all server nodes information (available for sys tenant only) to monitor cluster status.

4. get_resource_capacity

Get resource capacity information (available for sys tenant only) to check system resources.

5. get_ash_report

Get ASH (Active Session History) report for database performance analysis and troubleshooting.

6. search_oceanbase_document

Search OceanBase documentation from the official website. This tool is experimental as the API may change.

JSON Config

{
  "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"
      }
    }
  }
}

Useful Links

GitHubHomepageDeepWiki

Information

Categories

Tags

Back

More MCP Server