A
securityF
licenseA
qualityEnables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management.
Last updated -
7
39
27
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 依赖包：
uv pip install -r pyproject.toml
如果您想在本地调试 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_sqlSQL 查询get_query_plan：获取 SQL 查询的查询计划get_execution_plan：获取 SQL 查询的实际执行计划和运行时统计信息
资源
内置资源
adbmysql:///databases：获取 mysql 集群解析中的所有数据库
资源模板
adbmysql:///{schema}/tables：获取特定数据库中的所有表adbmysql:///{database}/{table}/ddl：获取特定数据库中表的 DDL 脚本adbmysql:///{config}/{key}/value：获取集群中配置键的值
提示
目前未提供。
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 操作。
Related MCP Servers
- AsecurityAlicenseAqualityConnect and interact with MySQL databases seamlessly. Execute SQL queries, manage database connections, and retrieve data directly through AI assistants. Enhance your AI capabilities with structured access to your MySQL data.Last updated -9017MIT License
- -securityFlicense-qualityEnables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.Last updated -
- -securityAlicense-qualityA powerful server that enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.Last updated -286MIT License