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.

「データベース」の他のコンテンツ

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.