AlibabaCloud DMS MCP Server

@aliyun

代码仓库

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

aliyun

关于 AlibabaCloud DMS MCP Server

A universal multi-cloud data MCP Server supporting over 40 types of data source connections, providing secure, unified data access in a single platform. Supports full range of Alibaba Cloud services and Mainstream databases/data warehouses.

#mysql #redis #ai #mongodb #clickhouse #postgresql #oracle #mariadb #cursor #db2 #sqlserver #claude #dify#analyticsdb#oceanbase#polardb#polardb-x#starrocks #mcp-server #dify-plugins

AlibabaCloud DMS MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "alibabacloud-dms-mcp-server": {
      "command": "python3",
      "args": [
        "skills/database/dms/alicloud-database-dms-enterprise/scripts/list_openapi_meta_apis.py"
      ]
    }
  }
}

AlibabaCloud DMS MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is AlibabaCloud DMS MCP Server?

AlibabaCloud DMS MCP Server is an AI-era data security access gateway and intelligent data query engine that integrates with Alibaba Cloud DMS to provide secure, unified access to over 40 data sources. It is designed for DBAs, developers, and data analysts who need centralized, permission-controlled database management and natural-language-driven querying.

How to use AlibabaCloud DMS MCP Server?

The server supports two modes: Multi-instance Mode (for managing and querying multiple database instances via DMS) and Single Database Mode (for direct access to a fixed database by configuring the CONNECTION_STRING parameter). Users invoke tools such as addInstance, listInstances, executeScript, askDatabase, and others to manage instances, run SQL, or pose natural-language questions.

Key features of AlibabaCloud DMS MCP Server

Secure account and password management without manual maintenance.
Intranet access to keep data within the premises.
Fine-grained permission control at instance, database, table, field, and row levels.
Built-in NL2SQL algorithm for natural-language querying.
High-risk SQL identification and blocking plus full SQL audit trails.
Supports over 40 mainstream databases and data warehouses.

Use cases of AlibabaCloud DMS MCP Server

A DBA managing and accessing heterogeneous database instances across production, test, and development environments.
A developer frequently querying a fixed database for daily development and testing tasks.
A data analyst using natural language to ask business questions (e.g., order totals, user counts) and receive SQL-generated answers.

常见问题

How do I connect to a single database?

Set the `CONNECTION_STRING` parameter (format: `dbName@host:port`) in the server configuration. The server will then access only that database without needing instance switching.

What modes are available?

Two modes are supported: **Multi-instance Mode** (requires adding instances to DMS) and **Single Database Mode** (direct connection via `CONNECTION_STRING`).

Which data sources are supported for NL2SQL?

NL2SQL is supported for MySQL, MariaDB, PostgreSQL, Oracle, SQLServer, StarRocks, Clickhouse, SelectDB, DB2, OceanBase, Gauss, BigQuery, PolarDB, and others. Redis and MongoDB do not support NL2SQL.