How do I install the alibabacloud adb mysql mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `ADB_MYSQL_HOST`, `ADB_MYSQL_PORT`, `ADB_MYSQL_USER`, `ADB_MYSQL_PASSWORD`, `ADB_MYSQL_DATABASE`, `MCP_TOOLSETS`, `ALIBABA_CLOUD_ACCESS_KEY_ID`, `ALIBABA_CLOUD_ACCESS_KEY_SECRET` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Alibabacloud Adb Mysql MCP Server

AnalyticDB for MySQL MCP Server is a universal interface between AI Agents and [AnalyticDB MySQL](https://www.alibabacloud.com/zh/product/analyticdb-f

Local serverstdioPython

What is the Alibabacloud Adb Mysql MCP Server?

AnalyticDB for MySQL MCP Server is a universal interface between AI Agents and AnalyticDB MySQL. It

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
describe_db_clusters	List ADB MySQL clusters in a region
describe_db_cluster_attribute	Get detailed cluster attributes
describe_cluster_access_whitelist	Get cluster IP whitelist
modify_cluster_access_whitelist	Modify cluster IP whitelist
describe_accounts	List database accounts in a cluster
describe_cluster_net_info	Get cluster network connection info
get_current_time	Get current server time
describe_db_cluster_performance	Query cluster performance metrics (CPU, memory, QPS, etc.)
describe_db_cluster_health_status	Query cluster health status
describe_diagnosis_records	Query SQL diagnosis summary records
describe_diagnosis_sql_info	Get SQL execution details (plan, runtime info)
describe_bad_sql_detection	Detect bad SQL impacting cluster stability
describe_sql_patterns	Query SQL pattern list
describe_table_statistics	Query table-level statistics
create_account	Create a database account
modify_db_cluster_description	Modify cluster description
describe_db_cluster_space_summary	Get cluster storage space summary
describe_audit_log_records	Query SQL audit log records
describe_executor_detection	Compute node diagnostics
describe_worker_detection	Storage node diagnostics
describe_controller_detection	Access node diagnostics
describe_available_advices	Get optimization advices
kill_process	Kill a running query process
describe_db_resource_group	Get resource group configuration
describe_excessive_primary_keys	Detect tables with excessive primary keys
describe_oversize_non_partition_table_infos	Detect oversized non-partition tables
describe_table_partition_diagnose	Diagnose table partitioning issues
describe_inclined_tables	Detect data-skewed tables
execute_sql	Execute SQL on an ADB MySQL cluster. Read-only SQL is allowed by default; full SQL execution requires ENABLE_SQL_WRITE_TOOLS=true
get_query_plan	Get EXPLAIN execution plan for a single SELECT or read-only WITH CTE statement
get_execution_plan	Get EXPLAIN ANALYZE actual execution plan for a single SELECT or read-only WITH CTE statement

How to install the Alibabacloud Adb Mysql MCP Server

{
  "mcpServers": {
    "adb-mysql-mcp-server": {
      "name": "adb-mysql-mcp-server",
      "type": "stdio",
      "isActive": true,
      "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_ADB_MYSQL_PASSWORD",
        "ADB_MYSQL_DATABASE": "your_database",
        "MCP_TOOLSETS": "sql"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Variable	Description	Required
ADB_MYSQL_HOST	Declared in the maintainer’s client configuration.	Check documentation
ADB_MYSQL_PORT	Declared in the maintainer’s client configuration.	Optional
ADB_MYSQL_USER	Declared in the maintainer’s client configuration.	Optional
ADB_MYSQL_PASSWORD	Declared in the maintainer’s client configuration.	Check documentation
ADB_MYSQL_DATABASE	Declared in the maintainer’s client configuration.	Check documentation
MCP_TOOLSETS	Declared in the maintainer’s client configuration.	Check documentation

Example prompts to try

“Use Alibabacloud Adb Mysql to describe db clusters.”
“Use Alibabacloud Adb Mysql to describe db cluster attribute.”
“Use Alibabacloud Adb Mysql to describe cluster access whitelist.”

Frequently asked questions

AnalyticDB for MySQL MCP Server is a universal interface between AI Agents and [AnalyticDB MySQL](https://www.alibabacloud.com/zh/product/analyticdb-for-mysql). It Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.