Skip to main content
Glama
Sign In
enesjakozh

Adb MySQL MCP Server

Official
by aliyun
GitHub
Python
Apache 2.0
1
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Provides a universal interface for AI agents to interact with Alibaba Cloud AnalyticDB for MySQL, enabling database metadata retrieval, SQL query execution, query plan analysis, and access to table structures across databases.

AnalyticDB for MySQL MCP 服务器

AnalyticDB for MySQL MCP Server 作为 AI Agent 与AnalyticDB for MySQL数据库之间的通用接口，实现 AI Agent 与 AnalyticDB for MySQL 之间的无缝通信，帮助 AI Agent 获取 AnalyticDB for MySQL 数据库元数据并执行 SQL 操作。

1. MCP 客户端配置

方式一：使用本地文件

  • 下载 GitHub 存储库
git clone https://github.com/aliyun/alibabacloud-adb-mysql-mcp-server
  • MCP 集成

在MCP客户端配置文件中添加如下配置：

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

模式 2：使用 PIP 模式

  • 安装

使用以下软件包安装 MCP 服务器：

pip install adb-mysql-mcp-server
  • MCP 集成

在MCP客户端配置文件中添加如下配置：

{ "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. 开发自己的 AnalyticDB for MySQL MCP 服务器

如果您想开发自己的 AnalyticDB for MySQL MCP Server，可以使用以下命令安装 python 依赖包：

  1. 从 GitHub 下载源代码。
  2. 安装uv包管理器。
  3. 安装Node.js ，它提供了一个名为npx的 node 包工具
  4. 使用以下命令在项目根目录中安装 python 依赖项：
uv pip install -r pyproject.toml
  1. 如果您想在本地调试 mcp 服务器，您可以使用以下命令启动MCP Inspector ：
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. AnalyticDB for MySQL MCP Server组件介绍

  • 工具

    • execute_sql SQL 查询
    • get_query_plan ：获取 SQL 查询的查询计划
    • get_execution_plan ：获取 SQL 查询的实际执行计划和运行时统计信息

  • 资源

    • 内置资源
      • adbmysql:///databases ：获取 mysql 集群解析中的所有数据库
    • 资源模板
      • adbmysql:///{schema}/tables ：获取特定数据库中的所有表
      • adbmysql:///{database}/{table}/ddl ：获取特定数据库中表的 DDL 脚本
      • adbmysql:///{config}/{key}/value ：获取集群中配置键的值

  • 提示

目前未提供。

This server cannot be installed

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

通用接口，使 AI 代理能够与 Adb MySQL 数据库无缝通信，从而允许它们检索数据库元数据并执行 SQL 操作。

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

    Related MCP Servers

    • mcp-mysql-server

      f4ww4z
      A
      security
      A
      license
      A
      quality
      This server enables AI models to interact with MySQL databases through a standardized interface.
      Last updated -
      5
      618
      58
      JavaScript
      MIT License
      • Linux
      • Apple

    • MCP-MySQL Server

      enemyrr
      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
      16
      JavaScript

    • MySQL MCP Server

      Mineru98
      -
      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

    • Hologres MCP Serverofficial

      aliyun
      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
      17
      Python
      Apache 2.0

    View all related MCP servers

    Appeared in Searches

    ID: 0059oonfht