Alibaba Cloud Yaochi DB MCP Server

Alibaba Cloud Yaochi DB MCP Server

Yaochi Database AI Native MCP Server — One MCP Server to manage all Alibaba Cloud databases.

中文版 README

What is Yaochi DB MCP Server?

A database tool service built on Model Context Protocol (MCP), enabling AI coding assistants (Cursor, Claude Desktop, Qoder, etc.) to directly operate Alibaba Cloud databases.

Core Scenario: After AI writes code, it automatically creates a database → creates tables → executes SQL to verify → calls Yaochi Database Agent for performance diagnosis — all without leaving the IDE.

Supported Database Engines

Engine	Operations
RDS MySQL	Create instance, execute SQL, ephemeral account mode
PolarDB MySQL	Create cluster, execute SQL, ephemeral account mode
MongoDB	Create replica set, execute MongoDB commands
Tair (Redis)	Create instance, execute Redis commands

Yaochi Database Agent

Built-in AI database advisor powered by Alibaba Cloud’s official documentation and expert knowledge:

• Knowledge Q&A — Instantly answers database usage questions, reducing support tickets
• Intelligent Diagnosis — Auto-executes performance diagnostics via OpenAPI, pinpointing issues
• Best Practices — Provides architecture recommendations and optimization suggestions tailored to your workload

Supports multi-turn conversations and covers all Alibaba Cloud database engines (RDS, PolarDB, MongoDB, Tair, Lindorm, etc.).

Available Tools

Tool	Description
ask_yaochi_agent	Yaochi Database Agent — AI database advisor (diagnosis, best practices, architecture)
create_instance	Create a database instance
list_instances	List existing instances
execute_instance_sql	Execute SQL via instance ID (ephemeral account, no password needed)
execute_mysql	Direct connect to MySQL/PolarDB and execute SQL
execute_mongo	Direct connect to MongoDB and execute commands
execute_redis	Direct connect to Tair/Redis and execute commands
search_database	Search databases in DMS
execute_sql	Execute SQL via DMS
register_to_dms	Register instance to DMS

Quick Start

Installation

git clone http://gitlab.alibaba-inc.com/cloudmon/alibabacloud-yaochi-db-mcp-server.git
cd alibabacloud-yaochi-db-mcp-server
python3 -m venv .venv
source .venv/bin/activate
pip install .

Verify

yaochi-db-mcp-server

It enters stdio waiting mode (no output) on success. Press Ctrl+C to exit.

Configure AI Client

Add to your AI client's MCP configuration:

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

Environment Variables

Variable	Default	Description
ALIBABA_CLOUD_ACCESS_KEY_ID	—	Alibaba Cloud AccessKey ID (required)
ALIBABA_CLOUD_ACCESS_KEY_SECRET	—	Alibaba Cloud AccessKey Secret (required)
ALIBABA_CLOUD_REGION_ID	cn-hangzhou	Default region
YAOCHI_ENABLE_WRITE_SQL	true	Allow INSERT/UPDATE/DELETE
YAOCHI_ENABLE_DDL_SQL	false	Allow CREATE/ALTER DDL
YAOCHI_PUBLIC_IP	Auto-detect	Manually specify public IP

Security Features

• Ephemeral Accounts: Automatically creates/destroys temporary database accounts per SQL execution — no persistent credentials
• SQL Safety Checks: Blocks DROP/TRUNCATE and other dangerous operations; disallows comments and multi-statements
• Restrictive Whitelist: Auto-provisions public access with current IP only (/32), without affecting existing rules
• Write Control: Fine-grained DML/DDL permissions via environment variables

Usage Example

User: Create a PolarDB MySQL cluster, build an orders table, and set up a Tair cache

AI automatically:
1. create_instance(engine="polardb-mysql")
   → Returns instance_id="pc-bp1xxx"

2. execute_instance_sql(instance_id="pc-bp1xxx", engine="polardb-mysql", database="testdb",
     sql="CREATE TABLE orders (id BIGINT PRIMARY KEY, amount DECIMAL(10,2))", force=true)
   → Auto-provisions public access + whitelist + creates DB + creates table

3. create_instance(engine="tair")
   → Returns instance_id="r-bp1xxx"

4. execute_redis(host="r-bp1xxx.redis.rds.aliyuncs.com", port=6379, password="xxx",
     command="SET order:1001 '{\"amount\":99.9}'")
   → OK

5. ask_yaochi_agent(query="PolarDB cluster pc-bp1xxx performance diagnosis")
   → Returns optimization suggestions from Yaochi Database Agent

License

Apache License 2.0

Contributing

Issues and Pull Requests are welcome.

Links

• MCP Protocol Documentation
• Alibaba Cloud RAM Console
• DMS Console