Name: OceanBase MCP Server
Author: yuanoOo

LABSCO SUMMARY

The security section is the part to read, not skip.

The README is direct about what this is: a server that hands database access to a model. It tells you to create a dedicated OceanBase user with minimal permissions, never to use root or an administrative account, to restrict access to the operations actually needed, and to consider query whitelisting before production. Take that literally — the connection you configure defines the blast radius, and nothing in the server narrows it for you.

What it is

An MCP server for OceanBase that exposes tables as resources and lets a model read data and execute SQL against them, with connection details supplied through environment variables rather than embedded in prompts.

What you get

Available OceanBase tables surfaced as resources, so the schema is discoverable without a query
Table contents readable directly
SQL execution with proper error handling, so a malformed query returns a message rather than a stack trace
Comprehensive logging of database operations, which is what makes an audit trail possible

Requirements

An OceanBase database and a user for it. Five environment variables: OB_HOST, OB_USER, OB_PASSWORD, OB_DATABASE, and OB_PORT which defaults to 2881 if unset. The documented install line names oceanbase-mcp-server, which PyPI does not have; the project is oceanbase_mcp_server (version 0.1.0) and runs as python -m oceanbase_mcp_server or through uv against a checkout. Apache licensed.

Setup effort

Build from source — git clone https://github.com/yuanoOo/oceanbase_mcp_server.git

See installation options

USE CASES

01

Understanding an unfamiliar schema

List the tables as resources and read a sample of their contents before writing any query.

02

Answering a data question without writing SQL yourself

Describe what you want and let the model compose and run the query against the database.

03

Giving an analyst read-only reach

Point the server at a dedicated user with only the permissions that role needs, so exploration cannot mutate anything.

BEFORE YOU INSTALL

What to know first

Requires

uv on PATH
OB_PASSWORD in your environment
OB_USER in your environment

Where it runs

The documented client runs the server on your machine.

INSTALLATION

Connect your client

You clone this one yourself.

Server setup

TERMINAL

git clone https://github.com/yuanoOo/oceanbase_mcp_server.git

Put the full path of the oceanbase_mcp_server folder the clone created after --directory in the block below.

TERMINAL

oceanbase_mcp_server

MCP Clients

Claude Desktop

CLAUDE DESKTOP · JSON

{
  "mcpServers": {
    "oceanbase": {
      "command": "uv",
      "args": [
        "--directory",
        "<YOUR_PATH_TO_OCEANBASE_MCP_SERVER>",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_HOST": "localhost",
        "OB_PORT": "2881",
        "OB_USER": "<YOUR_OB_USER>",
        "OB_PASSWORD": "<YOUR_OB_PASSWORD>",
        "OB_DATABASE": "<YOUR_OB_DATABASE>"
      }
    }
  }
}

OceanBase MCP Server