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.