Connects to an Alibaba Cloud AnalyticDB for MySQL cluster to read database and table metadata and query and analyze data.
Setup
Choose your client, copy the config, then fill in any required environment variables.
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>"
}
}
}
}Environment variables
ADB_MYSQL_DATABASEADB_MYSQL_HOSTADB_MYSQL_PASSWORDADB_MYSQL_PORTADB_MYSQL_USER
Replace the placeholders with your own credentials and keep them out of version control.