Lists tables, reads data and runs SQL on OceanBase databases through a controlled interface.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
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>"
}
}
}
}需要的环境变量
OB_DATABASEOB_HOSTOB_PASSWORDOB_PORTOB_USER
把占位值换成你自己的密钥；不要把密钥提交到代码仓库。