What can you do with this server?

The AnalyticDB for MySQL MCP Server enables AI agents to interact with AnalyticDB for MySQL databases through a standardized interface, providing comprehensive database querying, analysis, and metadata retrieval capabilities. **Core Capabilities:** * **Execute SQL queries** - Run SQL operations directly on AnalyticDB for MySQL clusters * **Analyze query performance** - Get query execution plans and actual execution plans with runtime statistics to optimize query performance * **Browse databases and tables** - List all databases in the cluster and tables within specific databases * **Access table schemas** - Retrieve DDL scripts to understand table structure and definitions * **Check cluster configuration** - Fetch configuration values for specific keys **Key Features:** * Flexible deployment options via pip package or local source code * Local debugging support using the MCP Inspector tool * Seamless integration for AI agents to perform data retrieval, SQL operations, and performance optimization

Which integrations are available for this server?

Provides a universal interface for AI agents to interact with Alibaba Cloud AnalyticDB for [MySQL](/mcp/servers/integrations/mysql), enabling database metadata retrieval, SQL query execution, query plan analysis, and access to table structures across databases.

The AnalyticDB for MySQL MCP Server enables AI agents to interact with AnalyticDB for MySQL databases through a standardized interface, providing comprehensive database querying, analysis, and metadata retrieval capabilities.

Core Capabilities:

Execute SQL queries - Run SQL operations directly on AnalyticDB for MySQL clusters
Analyze query performance - Get query execution plans and actual execution plans with runtime statistics to optimize query performance
Browse databases and tables - List all databases in the cluster and tables within specific databases
Access table schemas - Retrieve DDL scripts to understand table structure and definitions
Check cluster configuration - Fetch configuration values for specific keys

Key Features:

Flexible deployment options via pip package or local source code
Local debugging support using the MCP Inspector tool
Seamless integration for AI agents to perform data retrieval, SQL operations, and performance optimization

AnalyticDB for MySQL MCP Server

AnalyticDB for MySQL MCP Server serves as a universal interface between AI Agents and AnalyticDB for MySQL databases. It enables seamless communication between AI Agents and AnalyticDB for MySQL, helping AI Agents retrieve AnalyticDB for MySQL database metadata and execute SQL operations.

1. MCP Client Configuration

Mode 1: Using Local File

Download the GitHub repository

git clone https://github.com/aliyun/alibabacloud-adb-mysql-mcp-server

MCP Integration

Add the following configuration to the MCP client configuration file:

{ "mcpServers": { "adb-mysql-mcp-server": { "command": "uv", "args": [ "--directory", "/path/to/alibabacloud-adb-mysql-mcp-server", "run", "adb-mysql-mcp-server" ], "env": { "ADB_MYSQL_HOST": "host", "ADB_MYSQL_PORT": "port", "ADB_MYSQL_USER": "database_user", "ADB_MYSQL_PASSWORD": "database_password", "ADB_MYSQL_DATABASE": "database" } } } }

Mode 2: Using PIP Mode

Installation

Install MCP Server using the following package:

pip install adb-mysql-mcp-server

MCP Integration

Add the following configuration to the MCP client configuration file:

{ "mcpServers": { "adb-mysql-mcp-server": { "command": "uv", "args": [ "run", "--with", "adb-mysql-mcp-server", "adb-mysql-mcp-server" ], "env": { "ADB_MYSQL_HOST": "host", "ADB_MYSQL_PORT": "port", "ADB_MYSQL_USER": "database_user", "ADB_MYSQL_PASSWORD": "database_password", "ADB_MYSQL_DATABASE": "database" } } } }

Related MCP server: MySql MCP Server

2. Develop your own AnalyticDB for MySQL MCP server

If you want to develop your own AnalyticDB for MySQL MCP Server, you can install the python dependency packages using the following command:

Download the source code from GitHub.
Install uv package manager.
Install Node.js which provides a node package tool whose name is npx
Install the python dependencies in the root diretory of the project using the following command:

uv pip install -r pyproject.toml

If you want to debug the mcp server locally, you could start up an MCP Inspector using the following command:

npx @modelcontextprotocol/inspector \ -e ADB_MYSQL_HOST=your_host \ -e ADB_MYSQL_PORT=your_port \ -e ADB_MYSQL_USER=your_username \ -e ADB_MYSQL_PASSWORD=your_password \ -e ADB_MYSQL_DATABASE=your_database \ uv --directory /path/to/alibabacloud-adb-mysql-mcp-server run adb-mysql-mcp-server

3. Introduction to the components of AnalyticDB for MySQL MCP Server

Tools
- execute_sql: Execute a SQL query in the AnalyticDB for MySQL Cluster
- get_query_plan: Get the query plan for a SQL query
- get_execution_plan: Get the actual execution plan with runtime statistics for a SQL query
Resources
- Built-in Resources
  - adbmysql:///databases: Get all the databases in the analytic for mysql cluster
- Resource Templates
  - adbmysql:///{database}/tables: Get all the tables in a specific database
  - adbmysql:///{database}/{table}/ddl: Get the DDL script of a table in a specific database
  - adbmysql:///config/{key}/value: Get the value for a config key in the cluster
Prompts

Not provided at the present moment.

Adb MySQL MCP Server

AnalyticDB for MySQL MCP Server

1. MCP Client Configuration

Mode 1: Using Local File

Download the GitHub repository

MCP Integration

Mode 2: Using PIP Mode

Installation

MCP Integration

2. Develop your own AnalyticDB for MySQL MCP server

3. Introduction to the components of AnalyticDB for MySQL MCP Server

Tools

Resources

Built-in Resources

Resource Templates

Prompts

Resources

Tools

Appeared in Searches

New MCP Servers

Latest Blog Posts

MCP directory API