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 — all without leaving the IDE.

Related MCP server: AlibabaCloud DevOps MCP Server

Supported Database Engines

Available Tools

Quick Start

Installation

git clone https://github.com/aliyun/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

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 an RDS MySQL and build a users table

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

2. execute_instance_sql(instance_id="rm-bp1xxx", database="testdb",
     sql="CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(50))", force=true)
   → Auto-provisions public access + whitelist + creates DB + creates table

3. execute_instance_sql(instance_id="rm-bp1xxx", database="testdb",
     sql="SELECT * FROM users")
   → Returns query results

License

Apache License 2.0

Contributing

Issues and Pull Requests are welcome.

Links

• MCP Protocol Documentation

• Alibaba Cloud RAM Console

• DMS Console