OceanBase MCP Server

@yuanoOo

代码仓库

基本信息

分类

数据库

许可证

Apache-2.0

传输方式

stdio

作者

yuanoOo

关于 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.

#oceanbase#mcp #database-server

OceanBase MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "oceanbase_mcp_server": {
      "command": "python",
      "args": [
        "-m",
        "oceanbase_mcp_server"
      ]
    }
  }
}

OceanBase MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is OceanBase MCP Server?

A Model Context Protocol (MCP) server that enables secure interaction with OceanBase databases. It 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.

How to use OceanBase MCP Server?

Install via pip install oceanbase-mcp-server, set environment variables (OB_HOST, OB_PORT (defaults to 2881), OB_USER, OB_PASSWORD, OB_DATABASE), then either configure in Claude Desktop's claude_desktop_config.json or run standalone with python -m oceanbase_mcp_server.

Key features of OceanBase MCP Server

List available OceanBase tables as resources
Read table contents
Execute SQL queries with proper error handling
Secure database access through environment variables
Comprehensive logging

Use cases of OceanBase MCP Server

AI-assisted database exploration and analysis
Querying data without exposing raw credentials to the assistant
Controlled read and list operations on OceanBase tables
Secure database interaction from AI assistants like Claude Desktop

常见问题

How do I install OceanBase MCP Server?

Run `pip install oceanbase-mcp-server` in your Python environment.

What environment variables are required?

`OB_HOST`, `OB_USER`, `OB_PASSWORD`, and `OB_DATABASE` are required; `OB_PORT` defaults to 2881 if not set.

Can I run OceanBase MCP Server standalone?

Yes, after installing dependencies, run `python -m oceanbase_mcp_server`.

What security measures should I take?

Create a dedicated OceanBase user with minimal permissions, never use root credentials, restrict database access, enable logging, and always follow the principle of least privilege.

What tools does OceanBase MCP Server expose?

It lists tables as resources, reads table contents, and executes SQL queries with error handling — all through the Model Context Protocol.

数据库分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note