AnalyticDB for MySQL MCP Server

Name: AnalyticDB for MySQL MCP Server
Author: MCP-Mirror

@MCP-Mirror

リポジトリ

AnalyticDB for MySQL MCP Server について

Mirror of

#mathgpt #math-solver #math-assistant

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0 license

ランタイム

python

トランスポート

stdio

公開者

MCP-Mirror

設定

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

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from AnalyticDB for MySQL MCP Server

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.

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

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