Alibabacloud Adb Mysql MCP Server

🚀 AnalyticDB for MySQL Multi-Computing Engine (MCP) Server

The AnalyticDB for MySQL MCP Server serves as a universal interface between AI agents and the AnalyticDB for MySQL database. It enables seamless communication between AI agents and AnalyticDB for MySQL, facilitating AI agents to retrieve metadata from the AnalyticDB for MySQL database and execute SQL operations.

🚀 Quick Start

✨ Features

The AnalyticDB for MySQL MCP Server offers the following features:

• Acts as a bridge between AI agents and the AnalyticDB for MySQL database.
• Enables seamless communication and data interaction.
• Allows AI agents to access database metadata and execute SQL operations.

📦 Installation

Mode 1: Using Local Files

• Download the GitHub Repository

git clone https://github.com/aliyun/alibabacloud-adb-mysql-mcp-server

• Integrate MCP 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

• Installation Install the MCP Server using the following package:

pip install adb-mysql-mcp-server

• Integrate MCP 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"
      }
    }
  }
}

💻 Usage Examples

Basic Usage

If you want to develop your own AnalyticDB for MySQL MCP Server, you can use the following steps:

1. Download the source code from GitHub.
2. Install the uv package manager.
3. Install Node.js (which provides a node package tool called npx).
4. Install Python dependencies in the project root directory using the following command:

uv pip install -r pyproject.toml

5. If you want to debug the MCP Server locally, you can start an MCP Inspector and run 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

📚 Documentation

AnalyticDB for MySQL MCP Server Component Introduction

• Tools
  • execute_sql: Execute SQL queries.
  • get_table_schema: Retrieve table structure information.
  • list_tables: List all tables.
• Resources
  • Built-in Resources:
    • Database metadata (e.g., tables, columns, etc.).
  • External Resources:
    • Support for extending other data sources through plugins.

With the above configuration and tools, you can easily use the AnalyticDB for MySQL MCP Server for data analysis and processing.