AnalyticDB for MySQL MCP Server

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

@MCP-Mirror

Repository

About AnalyticDB for MySQL MCP Server

Mirror of

#mathgpt #math-solver #math-assistant

Basic information

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"
      ]
    }
  }
}

Tools

No tools detected

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

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.