Adb MySQL MCP Server provides a universal interface between AI Agents and Alibaba Cloud's Adb MySQL databases, enabling seamless metadata retrieval and SQL operations. Developed by Alibaba Cloud, this Python-based implementation offers tools for executing SQL queries, analyzing query plans, and retrieving execution statistics, along with resource templates for accessing database schemas, table definitions, and configuration values. The server requires minimal configuration through environment variables and supports both local development and pip installation, making it ideal for data analysts and developers who need AI-assisted database interactions with Adb MySQL clusters.
No reviews yet. Be the first to review!
Sign in to join the conversation
List ADB MySQL clusters in a region.
Get detailed cluster attributes.
Get cluster IP whitelist.
Modify cluster IP whitelist.
List database accounts in a cluster.
Get cluster network connection info.
Get current server time.
Query cluster performance metrics (CPU, memory, QPS, etc.).
Query cluster health status.
Query SQL diagnosis summary records.
Get SQL execution details (plan, runtime info).
Detect bad SQL impacting cluster stability.
Query SQL pattern list.
Query table-level statistics.
Create a database account.
Modify cluster description.
Get cluster storage space summary.
Query SQL audit log records.
Compute node diagnostics.
Storage node diagnostics.
Access node diagnostics.
Get optimization advices.
Kill a running query process.
Get resource group configuration.
Detect tables with excessive primary keys.
Detect oversized non-partition tables.
Diagnose table partitioning issues.
Detect data-skewed tables.
Execute SQL on an ADB MySQL cluster. Read-only SQL is allowed by default; full SQL execution requires ENABLE_SQL_WRITE_TOOLS=true.
Get EXPLAIN execution plan for a single SELECT or read-only WITH CTE statement.
Get EXPLAIN ANALYZE actual execution plan for a single SELECT or read-only WITH CTE statement.