広告掲載
MCP.so
ログイン

Alibaba Cloud Yaochi DB MCP Server

@aliyun

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0

トランスポート

stdio

作者

aliyun

投稿者

zbl269399

Alibaba Cloud Yaochi DB MCP Server について

概要はまだありません

#alibaba-cloud#database#mysql#mongodb#redis#polardb#tair#sql#cloud#devops#ai-agent#dba

Alibaba Cloud Yaochi DB MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Alibaba Cloud Yaochi DB MCP Server のツール

10

Yaochi Database Agent — AI database advisor (diagnosis, best practices, architecture)

Create a database instance

List existing instances

Execute SQL via instance ID (ephemeral account, no password needed)

Direct connect to MySQL/PolarDB and execute SQL

Direct connect to MongoDB and execute commands

Direct connect to Tair/Redis and execute commands

Search databases in DMS

Execute SQL via DMS

Register instance to DMS

概要

What is Alibaba Cloud Yaochi DB MCP Server?

A database tool service built on the Model Context Protocol (MCP) that allows AI coding assistants (e.g., Cursor, Claude Desktop, Qoder) to directly operate Alibaba Cloud databases. It enables automatic database creation, SQL execution, and AI‑powered performance diagnosis — all without leaving the IDE.

How to use Alibaba Cloud Yaochi DB MCP Server?

Clone the repository, create a Python 3.10+ virtual environment, install with pip install ., and run yaochi-db-mcp-server (it enters stdio waiting mode). Then configure your AI client’s MCP settings with the command path and required environment variables (ALIBABA_CLOUD_ACCESS_KEY_ID, ALIBABA_CLOUD_ACCESS_KEY_SECRET, ALIBABA_CLOUD_REGION_ID).

Key features of Alibaba Cloud Yaochi DB MCP Server

  • Supports multiple database engines: RDS MySQL, PolarDB MySQL, MongoDB, Tair (Redis).
  • Ephemeral account mode – no persistent database credentials.
  • Built‑in Yaochi Database Agent for AI‑driven diagnosis and best practices.
  • SQL safety checks that block DROP/TRUNCATE and dangerous operations.
  • Restrictive whitelist that automatically provisions only the current IP.
  • Fine‑grained write control via environment variables (DML/DDL permissions).

Use cases of Alibaba Cloud Yaochi DB MCP Server

  • AI writes code, then automatically creates a database, builds tables, executes SQL to verify, and diagnoses performance.
  • Developers manage Alibaba Cloud databases directly from their IDE without switching consoles.
  • Automated database provisioning and SQL testing as part of AI‑assisted development workflows.
  • Use the Yaochi Database Agent for instant, expert‑backed database advice and troubleshooting.

よくある質問

1

What Alibaba Cloud databases does the server support?

It supports RDS MySQL, PolarDB MySQL, MongoDB, and Tair (Redis) – with operations like creating instances and executing SQL or commands.

2

How does the server handle security?

It uses ephemeral accounts that are automatically created and destroyed per SQL execution, blocks dangerous SQL (e.g., DROP/TRUNCATE), restricts whitelist to the current IP only, and allows DML/DDL control via environment variables.

3

What are the runtime requirements?

Python 3.10 or higher, and valid Alibaba Cloud AccessKey credentials (ID and Secret). The server expects those credentials as environment variables.

4

Can I perform performance diagnosis?

Yes, the `ask_yaochi_agent` tool provides AI‑powered diagnosis,

コメント

「データベース」の他のコンテンツ

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K
広告掲載