AnalyticDB for MySQL MCP Server

@MCP-Mirror

Repository

Basic information

About AnalyticDB for MySQL MCP Server

Mirror of

#mathgpt #math-solver #math-assistant

AnalyticDB for MySQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

AnalyticDB for MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.