Connects to an Alibaba Cloud AnalyticDB for MySQL cluster to read database and table metadata and query and analyze data.
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add analyticdb-for-mysql --env ADB_MYSQL_DATABASE='<ADB_MYSQL_DATABASE>' --env ADB_MYSQL_HOST='<ADB_MYSQL_HOST>' --env ADB_MYSQL_PASSWORD='<ADB_MYSQL_PASSWORD>' --env ADB_MYSQL_PORT='<ADB_MYSQL_PORT>' --env ADB_MYSQL_USER='<ADB_MYSQL_USER>' -- uv sync~/.codex/config.toml
[mcp_servers.analyticdb-for-mysql]
command = "uv"
args = ["sync"]
env = { ADB_MYSQL_DATABASE = "<ADB_MYSQL_DATABASE>", ADB_MYSQL_HOST = "<ADB_MYSQL_HOST>", ADB_MYSQL_PASSWORD = "<ADB_MYSQL_PASSWORD>", ADB_MYSQL_PORT = "<ADB_MYSQL_PORT>", ADB_MYSQL_USER = "<ADB_MYSQL_USER>" }
# codex mcp add analyticdb-for-mysql --env ADB_MYSQL_DATABASE='<ADB_MYSQL_DATABASE>' --env ADB_MYSQL_HOST='<ADB_MYSQL_HOST>' --env ADB_MYSQL_PASSWORD='<ADB_MYSQL_PASSWORD>' --env ADB_MYSQL_PORT='<ADB_MYSQL_PORT>' --env ADB_MYSQL_USER='<ADB_MYSQL_USER>' -- uv sync~/.cursor/mcp.json
{
"mcpServers": {
"analyticdb-for-mysql": {
"command": "uv",
"args": [
"sync"
],
"env": {
"ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
"ADB_MYSQL_HOST": "<ADB_MYSQL_HOST>",
"ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
"ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
"ADB_MYSQL_USER": "<ADB_MYSQL_USER>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"analyticdb-for-mysql": {
"type": "stdio",
"command": "uv",
"args": [
"sync"
],
"env": {
"ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
"ADB_MYSQL_HOST": "<ADB_MYSQL_HOST>",
"ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
"ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
"ADB_MYSQL_USER": "<ADB_MYSQL_USER>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"analyticdb-for-mysql": {
"command": "uv",
"args": [
"sync"
],
"env": {
"ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
"ADB_MYSQL_HOST": "<ADB_MYSQL_HOST>",
"ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
"ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
"ADB_MYSQL_USER": "<ADB_MYSQL_USER>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"analyticdb-for-mysql": {
"command": "uv",
"args": [
"sync"
],
"env": {
"ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
"ADB_MYSQL_HOST": "<ADB_MYSQL_HOST>",
"ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
"ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
"ADB_MYSQL_USER": "<ADB_MYSQL_USER>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"analyticdb-for-mysql": {
"command": "uv",
"args": [
"sync"
],
"env": {
"ADB_MYSQL_DATABASE": "<ADB_MYSQL_DATABASE>",
"ADB_MYSQL_HOST": "<ADB_MYSQL_HOST>",
"ADB_MYSQL_PASSWORD": "<ADB_MYSQL_PASSWORD>",
"ADB_MYSQL_PORT": "<ADB_MYSQL_PORT>",
"ADB_MYSQL_USER": "<ADB_MYSQL_USER>"
}
}
}
}需要的环境变量
ADB_MYSQL_DATABASEADB_MYSQL_HOSTADB_MYSQL_PASSWORDADB_MYSQL_PORTADB_MYSQL_USER
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。