AnalyticDB for MySQL MCP Server

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0 license

トランスポート

stdio

作者

MCP-Mirror

AnalyticDB for MySQL MCP Server について

Mirror of

#mathgpt #math-solver #math-assistant

AnalyticDB for MySQL MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "aliyun_alibabacloud-adb-mysql-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "-r",
        "pyproject.toml"
      ]
    }
  }
}

AnalyticDB for MySQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is AnalyticDB for MySQL MCP Server?

AnalyticDB for MySQL MCP Server is a universal interface that enables AI Agents to communicate with AnalyticDB for MySQL databases. It helps AI Agents retrieve database metadata and execute SQL operations.

How to use AnalyticDB for MySQL MCP Server?

Configure the server by adding an entry to your MCP client configuration file, setting environment variables for host, port, user, password, and database. Two deployment modes are supported: using a local clone of the GitHub repository with uv, or installing via pip with the adb-mysql-mcp-server package.

Key features of AnalyticDB for MySQL MCP Server

Connects AI Agents to AnalyticDB for MySQL databases
Provides three SQL-related tools: execute_sql, get_query_plan, get_execution_plan
Exposes database resources and resource templates via URI schemes
Allows retrieval of all databases, tables in a schema, table DDL, and config values
Supports both local source and pip-based installation

Use cases of AnalyticDB for MySQL MCP Server

AI Agents running ad-hoc SQL queries against AnalyticDB for MySQL
Retrieving database metadata (schemas, tables, DDL) for automated analysis
Obtaining query plans and runtime execution statistics for performance tuning
Building custom MCP servers on top of the provided Python package

よくある質問

What does the AnalyticDB for MySQL MCP Server do?

It acts as a bridge between AI Agents and AnalyticDB for MySQL, allowing agents to fetch database metadata and execute SQL queries.

How do I install and configure the server?

Use either a local clone of the GitHub repository with `uv` or install via `pip install adb-mysql-mcp-server`. Then add the corresponding JSON entry to your MCP client configuration, setting the required environment variables.

What tools and resources are available?

The server offers three tools: `execute_sql`, `get_query_plan`, and `get_execution_plan`. Built-in resources include fetching all databases (`adbmysql:///databases`) and resource templates for tables (`adbmysql:///{schema}/tables`), DDL (`adbmysql:///{database}/{table}/ddl`), and config values (`adbmysql:///{config}/{key}/value`).

What dependencies are needed for development?

You need to install the `uv` package manager, `Node.js` (for `npx`), and the Python dependencies from `pyproject.toml`. The project source is available on GitHub.

Does the server include any prompts?

No, prompts are not provided at the present moment.

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

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