Alibaba ADB MySQL
AnalyticDB for MySQL MCP Server
What is Alibaba ADB MySQL?
Alibaba ADB MySQL is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to analyticdb for mysql mcp server
AnalyticDB for MySQL MCP Server
This server falls under the Cloud Services category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- AnalyticDB for MySQL MCP Server
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx alibabacloud-adb-mysqlConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Alibaba ADB MySQL
The Alibaba Cloud AnalyticDB for MySQL MCP Server provides AI assistants with two categories of access to Alibaba Cloud's managed analytical database service: SQL tools for direct database connections to execute queries, view execution plans, and browse schema metadata; and OpenAPI tools for managing clusters, whitelists, accounts, networking, monitoring, diagnostics, and audit logs via the Alibaba Cloud OpenAPI. Read-only tools are annotated with readOnlyHint for client-side safety enforcement. This server is built in Python and requires Python 3.13+ with the uv package manager.
Prerequisites
- Python 3.13 or higher installed
- uv package manager installed (see docs.astral.sh/uv for installation)
- An Alibaba Cloud account with an AccessKey ID and AccessKey Secret (for OpenAPI/cluster management tools)
- AnalyticDB for MySQL cluster credentials: host, port, username, password, database name (for SQL/direct-connection tools)
- An MCP client such as Claude Desktop, Claude Code, or Cherry Studio
Clone the repository
Clone the official Alibaba Cloud ADB MySQL MCP Server repository and sync dependencies with uv.
git clone https://github.com/aliyun/alibabacloud-adb-mysql-mcp-server.git
cd alibabacloud-adb-mysql-mcp-server
uv syncGather your credentials
For SQL tools, you need your ADB MySQL host, port, username, password, and database. For OpenAPI tools (cluster management), you need your Alibaba Cloud AccessKey ID and Secret from the RAM console.
Configure for SQL tools only
To use only direct SQL access, configure with database connection environment variables. OpenAPI tools are automatically disabled when AccessKey credentials are absent.
{
"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": "your_adb_mysql_host",
"ADB_MYSQL_PORT": "3306",
"ADB_MYSQL_USER": "your_username",
"ADB_MYSQL_PASSWORD": "your_password",
"ADB_MYSQL_DATABASE": "your_database"
}
}
}
}Configure for full access (SQL + OpenAPI)
To enable both SQL tools and OpenAPI cluster management tools, combine all environment variables in a single configuration block.
{
"mcpServers": {
"adb-mysql-mcp-server": {
"command": "uv",
"args": [
"--directory",
"/path/to/alibabacloud-adb-mysql-mcp-server",
"run",
"adb-mysql-mcp-server"
],
"env": {
"ALIBABA_CLOUD_ACCESS_KEY_ID": "your_access_key_id",
"ALIBABA_CLOUD_ACCESS_KEY_SECRET": "your_access_key_secret",
"ADB_MYSQL_HOST": "your_adb_mysql_host",
"ADB_MYSQL_PORT": "3306",
"ADB_MYSQL_USER": "your_username",
"ADB_MYSQL_PASSWORD": "your_password",
"ADB_MYSQL_DATABASE": "your_database"
}
}
}
}Restart your MCP client and test
Restart Claude Desktop or your chosen MCP client. Verify the connection by asking the assistant to list tables or describe the database schema.
Alibaba ADB MySQL Examples
Client configuration
Claude Desktop configuration combining SQL tools and OpenAPI management tools for full access to ADB MySQL.
{
"mcpServers": {
"adb-mysql-mcp-server": {
"command": "uv",
"args": [
"--directory",
"/path/to/alibabacloud-adb-mysql-mcp-server",
"run",
"adb-mysql-mcp-server"
],
"env": {
"ALIBABA_CLOUD_ACCESS_KEY_ID": "your_access_key_id",
"ALIBABA_CLOUD_ACCESS_KEY_SECRET": "your_access_key_secret",
"ADB_MYSQL_HOST": "adb-xxxx.mysql.rds.aliyuncs.com",
"ADB_MYSQL_PORT": "3306",
"ADB_MYSQL_USER": "your_username",
"ADB_MYSQL_PASSWORD": "your_password",
"ADB_MYSQL_DATABASE": "your_database"
}
}
}
}Prompts to try
Example prompts for querying and managing your AnalyticDB for MySQL cluster.
- "Show me all tables in the current database and their row counts"
- "Run this query and explain the execution plan: SELECT * FROM orders WHERE created_at > '2024-01-01'"
- "List all AnalyticDB MySQL clusters in my Alibaba Cloud account"
- "Show me the slow query logs for my ADB cluster from the past hour"
- "What are the current whitelist IP rules for my cluster?"
- "Describe the schema of the 'sales_data' table"Troubleshooting Alibaba ADB MySQL
Python version error: requires Python 3.13+
Install Python 3.13 or higher. With uv, you can manage Python versions with 'uv python install 3.13'. The uv package manager will automatically use the correct version when running the server.
OpenAPI tools are not available even with AccessKey credentials
Verify ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_ACCESS_KEY_SECRET are set correctly. The AccessKey must belong to a RAM user or account with permissions for ADB MySQL OpenAPI actions. Also check that ALIBABA_CLOUD_SECURITY_TOKEN is set if using temporary STS credentials.
SQL connection fails with 'Access denied' or 'Connection refused'
Confirm ADB_MYSQL_HOST is the correct endpoint for your cluster (visible in the Alibaba Cloud ADB MySQL console). Ensure the connecting IP address is in the cluster's whitelist. Default port is 3306 — verify this matches your cluster configuration.
Frequently Asked Questions about Alibaba ADB MySQL
What is Alibaba ADB MySQL?
Alibaba ADB MySQL is a Model Context Protocol (MCP) server that analyticdb for mysql mcp server It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Alibaba ADB MySQL?
Follow the installation instructions on the Alibaba ADB MySQL GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Alibaba ADB MySQL?
Alibaba ADB MySQL works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Alibaba ADB MySQL free to use?
Yes, Alibaba ADB MySQL is open source and available under the Apache-2.0 license. You can use it freely in both personal and commercial projects.
Alibaba ADB MySQL Alternatives — Similar Cloud Services Servers
Looking for alternatives to Alibaba ADB MySQL? Here are other popular cloud services servers you can use with Claude, Cursor, and VS Code.
Open WebUI
★ 138.2kUser-friendly AI Interface (Supports Ollama, OpenAI API, ...)
Anything LLM
★ 60.4kThe all-in-one AI productivity accelerator. On device and privacy first with no annoying setup or configuration.
LocalAI
★ 46.4kLocalAI is the open-source AI engine. Run any model - LLMs, vision, voice, image, video - on any hardware. No GPU required.
Nacos
★ 33.0kan easy-to-use dynamic service discovery, configuration and service management platform for building AI cloud native applications.
Xiaozhi ESP32
★ 26.7k本项目为xiaozhi-esp32提供后端服务，帮助您快速搭建ESP32设备控制服务器。Backend service for xiaozhi-esp32, helps you quickly build an ESP32 device control server.
Gateway
★ 11.8kA blazing fast AI Gateway with integrated guardrails. Route to 1,600+ LLMs, 50+ AI Guardrails with 1 fast & friendly API.
Browse More Cloud Services MCP Servers
Explore all cloud services servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Alibaba ADB MySQL in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Alibaba ADB MySQL?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.