Skip to main content
Glama

Adb MySQL MCP Server

Official
by aliyun

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" } } } }

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:

  1. Download the source code from GitHub.
  2. Install uv package manager.
  3. Install Node.js which provides a node package tool whose name is npx
  4. Install the python dependencies in the root diretory of the project using the following command:
uv pip install -r pyproject.toml
  1. 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:///{schema}/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.

-
security - not tested
A
license - permissive license
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A universal interface that enables AI Agents to seamlessly communicate with Adb MySQL databases, allowing them to retrieve database metadata and execute SQL operations.

  1. MCP Client Configuration
    1. Mode 1: Using Local File
    2. Mode 2: Using PIP Mode
  2. Develop your own AnalyticDB for MySQL MCP server
    1. Introduction to the components of AnalyticDB for MySQL MCP Server

      Related MCP Servers

      • A
        security
        A
        license
        A
        quality
        This server enables AI models to interact with MySQL databases through a standardized interface.
        Last updated -
        5
        646
        61
        JavaScript
        MIT License
        • Linux
        • Apple
      • A
        security
        F
        license
        A
        quality
        Enables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.
        Last updated -
        7
        152
        22
        JavaScript
      • -
        security
        A
        license
        -
        quality
        A server that enables AI models to interact with MySQL databases through a Model Control Protocol, providing tools for table creation, schema inspection, query execution, and data retrieval.
        Last updated -
        20
        Python
        MIT License
        • Linux
        • Apple
      • A
        security
        A
        license
        A
        quality
        A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.
        Last updated -
        6
        18
        Python
        Apache 2.0

      View all related MCP servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/aliyun/alibabacloud-adb-mysql-mcp-server'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server