OceanBase MCP Server

claude mcp add oceanbase --env OB_DATABASE='<OB_DATABASE>' --env OB_HOST='<OB_HOST>' --env OB_PASSWORD='<OB_PASSWORD>' --env OB_PORT='<OB_PORT>' --env OB_USER='<OB_USER>' -- uv --directory path/to/oceanbase_mcp_server run oceanbase_mcp_server

~/.codex/config.toml

[mcp_servers.oceanbase]
command = "uv"
args = ["--directory", "path/to/oceanbase_mcp_server", "run", "oceanbase_mcp_server"]
env = { OB_DATABASE = "<OB_DATABASE>", OB_HOST = "<OB_HOST>", OB_PASSWORD = "<OB_PASSWORD>", OB_PORT = "<OB_PORT>", OB_USER = "<OB_USER>" }

# codex mcp add oceanbase --env OB_DATABASE='<OB_DATABASE>' --env OB_HOST='<OB_HOST>' --env OB_PASSWORD='<OB_PASSWORD>' --env OB_PORT='<OB_PORT>' --env OB_USER='<OB_USER>' -- uv --directory path/to/oceanbase_mcp_server run oceanbase_mcp_server

~/.cursor/mcp.json

{
  "mcpServers": {
    "oceanbase": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/oceanbase_mcp_server",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_DATABASE": "<OB_DATABASE>",
        "OB_HOST": "<OB_HOST>",
        "OB_PASSWORD": "<OB_PASSWORD>",
        "OB_PORT": "<OB_PORT>",
        "OB_USER": "<OB_USER>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "oceanbase": {
      "type": "stdio",
      "command": "uv",
      "args": [
        "--directory",
        "path/to/oceanbase_mcp_server",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_DATABASE": "<OB_DATABASE>",
        "OB_HOST": "<OB_HOST>",
        "OB_PASSWORD": "<OB_PASSWORD>",
        "OB_PORT": "<OB_PORT>",
        "OB_USER": "<OB_USER>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "oceanbase": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/oceanbase_mcp_server",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_DATABASE": "<OB_DATABASE>",
        "OB_HOST": "<OB_HOST>",
        "OB_PASSWORD": "<OB_PASSWORD>",
        "OB_PORT": "<OB_PORT>",
        "OB_USER": "<OB_USER>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "oceanbase": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/oceanbase_mcp_server",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_DATABASE": "<OB_DATABASE>",
        "OB_HOST": "<OB_HOST>",
        "OB_PASSWORD": "<OB_PASSWORD>",
        "OB_PORT": "<OB_PORT>",
        "OB_USER": "<OB_USER>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "oceanbase": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/oceanbase_mcp_server",
        "run",
        "oceanbase_mcp_server"
      ],
      "env": {
        "OB_DATABASE": "<OB_DATABASE>",
        "OB_HOST": "<OB_HOST>",
        "OB_PASSWORD": "<OB_PASSWORD>",
        "OB_PORT": "<OB_PORT>",
        "OB_USER": "<OB_USER>"
      }
    }
  }
}