Database · Developer Tools

Alibabacloud Adb MySQL MCP Server logo

Alibabacloud Adb MySQL MCP Server

aliyun/alibabacloud-adb-mysql-mcp-server

AnalyticDB for MySQL MCP Server is a universal interface between AI Agents and AnalyticDB MySQL. It provides two tool groups. : Read-only tools are annotated with ToolAnnotations(readOnlyHint=True) per the MCP protocol, allowing clients to distinguish them from mutating operations.

Install

Client configuration

{
  "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": "<ADB_MYSQL_HOST>",
        "ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
        "ADB_MYSQL_USER": "<ADB_MYSQL_USER>",
        "ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
        "ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
        "MCP_TOOLSETS": "<MCP_TOOLSETS>"
      }
    }
  }
}

Environment variables

ADB_MYSQL_HOSTADB_MYSQL_PORTADB_MYSQL_USERADB_MYSQL_PASSWORDADB_MYSQL_DATABASEMCP_TOOLSETSALIBABA_CLOUD_ACCESS_KEY_IDALIBABA_CLOUD_ACCESS_KEY_SECRETENABLE_SQL_WRITE_TOOLSSERVER_TRANSPORTSERVER_HOSTSERVER_PORT
GitHub stars
7
Author
@aliyun
Category
Database, Developer Tools
License
Apache-2.0
Updated
Oct 6, 2026

About Alibabacloud Adb MySQL MCP Server

AnalyticDB for MySQL MCP Server is a universal interface between AI Agents and AnalyticDB MySQL. It provides two tool groups:

Read-only tools are annotated with ToolAnnotations(readOnlyHint=True) per the MCP protocol, allowing clients to distinguish them from mutating operations.

Tools (31)

  • 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.

  • 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

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Cline logo

Cline

Desktop · Free · MIT

An AI coding assistant integrated into the IDE. Supports MCP servers for enhanced functionality.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database