How do I install the alibabacloud dms mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `ALIBABA_CLOUD_ACCESS_KEY_ID`, `ALIBABA_CLOUD_ACCESS_KEY_SECRET`, `ALIBABA_CLOUD_SECURITY_TOKEN`, `CONNECTION_STRING`, `ALICLOUD_ACCESS_KEY_ID`, `ALICLOUD_ACCESS_KEY_SECRET`, `ALICLOUD_REGION_ID` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Alibabacloud Dms MCP Server

Configure the following parameters in DMS MCP Server: ```ini CONNECTION_STRING = ecommerce@10.20.30.40:3306 ``` Simply ask questions in natural

Local serverstdioPython

What is the Alibabacloud Dms MCP Server?

Alibabacloud dms mcp server lets Claude, Cursor and other MCP clients work with Alibabacloud Dms directly. Configure the following parameters in DMS MCP Server: ini CONNECTION_STRING = ecommerce@10.20.30.40:3306 Simply ask questions in natural language, and DMS MCP will parse the question into SQL and return the results.

What Alibabacloud Dms does

Configure the following parameters in DMS MCP Server: ini CONNECTION_STRING = ecommerce@10.20.30.40:3306 Simply ask questions in natural language, and DMS MCP will parse the question into SQL and return the results.

Requirements

uv is installed - Python 3.10+ is installed - An AK/SK or STS Token with access rights to Alibaba Cloud DMS(AliyunDMSFullAccess).Add permission operations, see [Authorization

Practical notes

Maintained by aliyun, written in Python.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
addInstance	Adds an instance to DMS. Only Aliyun instances are supported.
listInstances	Search for instances from DMS.
getInstance	Retrieves detailed information about an instance based on host and port.
searchDatabase	Searches databases based on schemaName.
getDatabase	Retrieves detailed information about a specific database.
listTables	Lists tables under a specified database.
getTableDetailInfo	Retrieves detailed information about a specific table.
executeScript	Executes an SQL script and returns the result.
createDataChangeOrder	Creates a data change order in DMS.
getOrderInfo	Retrieves order information from DMS.
submitOrderApproval	Submits the order for approval in DMS.
approveOrder	Approves or rejects an order in DMS.
generateSql	Converts natural language questions into SQL queries.
askDatabase	Natural language querying of a database (NL2SQL + execute SQL).
fixSql	Analyzes and fixes SQL errors.
answerSqlSyntax	Answers SQL syntax-related questions.
optimizeSql	Analyzes and optimizes SQL performance.

How to install the Alibabacloud Dms MCP Server

{
  "mcpServers": {
    "dms-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/alibabacloud-dms-mcp-server/src/alibabacloud_dms_mcp_server",
        "run",
        "server.py"
      ],
      "env": {
        "ALIBABA_CLOUD_ACCESS_KEY_ID": "YOUR_ALIBABA_CLOUD_ACCESS_KEY_ID",
        "ALIBABA_CLOUD_ACCESS_KEY_SECRET": "YOUR_ALIBABA_CLOUD_ACCESS_KEY_SECRET",
        "ALIBABA_CLOUD_SECURITY_TOKEN": "YOUR_ALIBABA_CLOUD_SECURITY_TOKEN"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

uv is installed - Python 3.10+ is installed - An AK/SK or STS Token with access rights to Alibaba Cloud DMS(AliyunDMSFullAccess).Add permission operations, see [Authorization

Variable	Description	Required
ALIBABA_CLOUD_ACCESS_KEY_ID	Declared in the maintainer’s client configuration.	Check documentation
ALIBABA_CLOUD_ACCESS_KEY_SECRET	Declared in the maintainer’s client configuration.	Check documentation
ALIBABA_CLOUD_SECURITY_TOKEN	Declared in the maintainer’s client configuration.	Yes

Frequently asked questions

Configure the following parameters in DMS MCP Server: ```ini CONNECTION_STRING = ecommerce@10.20.30.40:3306 ``` Simply ask questions in natural language, and DMS Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.