Advertise
MCP.so
Sign In

AlibabaCloud DMS MCP Server

@aliyun

Repository

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

aliyun

About 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 config

Add this server to your MCP-compatible client using the configuration below.

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

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Frequently asked questions

1

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.

2

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`).

3

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.

4

Does the server support access control and audit logs?

Yes, by default the server provides fine-grained access control (instance/table/field/row) and SQL audit logs for all listed data sources.

5

Can I approve or reject orders through the server?

Yes, the `approveOrder` tool allows approving or rejecting orders in DMS, and the `submitOrderApproval` tool submits orders for approval.

Comments

More Other MCP servers

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Advertise