Alibaba Cloud Yaochi DB MCP Server
Alibaba Cloud Yaochi DB MCP Server Yaochi DB MCP Server is the official Model Context Protocol (MCP) server from Alibaba Cloud that turns any MCP-compatible AI assistant (Claude Desktop, Cursor, Cline, Qoder, Windsurf, etc.) into a full-stack cloud DBA. From a single chat window you can provision instances, design schemas, run SQL, diagnose slow queries, and apply best practices across Alibaba Cloud's flagship database services — RDS MySQL, PolarDB MySQL, MongoDB and Tair (Redis).
✨ Why Yaochi DB MCP Server 🚀 From Prompt to Production — Ask in natural language, and the agent will create the database, build the tables, load data, and execute SQL for you. 🧠 Built-in Yaochi AI Advisor — A domain-tuned agent that answers Q&A, performs intelligent diagnostics, and recommends best practices grounded in Alibaba Cloud's real-world operational experience. 🔒 Enterprise-Grade Safety — Ephemeral database accounts, SQL safety checks and fine-grained write control keep your production data protected while giving AI the power it needs. 🌐 Multi-Engine, One Protocol — Manage MySQL, PolarDB, MongoDB and Redis (Tair) through a unified MCP interface. No more juggling different SDKs and consoles. 🛠 DMS Integration — One-click register instances into Alibaba Cloud DMS for auditing, change management and long-term collaboration. 🧰 Available Tools Tool Description ask_yaochi_agent Ask the built-in AI DBA about knowledge, diagnostics, or best practices. create_instance Provision a new RDS / PolarDB / MongoDB / Tair instance. list_instances Enumerate database instances in your account. search_database Discover databases and tables across instances. execute_sql / execute_instance_sql Run SQL against a target instance with safety checks. execute_mysql Execute MySQL / PolarDB MySQL statements. execute_mongo Run MongoDB commands and queries. execute_redis Execute Redis / Tair commands. register_to_dms Register the instance to Alibaba Cloud DMS. 📦 Installation
git clone https://github.com/aliyun/alibabacloud-yaochi-db-mcp-server.git cd alibabacloud-yaochi-db-mcp-server python -m venv .venv && source .venv/bin/activate pip install .
Server Config
{
"mcpServers": {
"yaochi-db": {
"command": "<project-path>/alibabacloud-yaochi-db-mcp-server/.venv/bin/yaochi-db-mcp-server",
"env": {
"ALIBABA_CLOUD_ACCESS_KEY_ID": "your-ak",
"ALIBABA_CLOUD_ACCESS_KEY_SECRET": "your-sk",
"ALIBABA_CLOUD_REGION_ID": "cn-hangzhou",
"YAOCHI_ENABLE_WRITE_SQL": "true",
"YAOCHI_ENABLE_DDL_SQL": "true"
}
}
}
}