aliyun/alibabacloud-dms-mcp-server
If you are the rightful owner of alibabacloud-dms-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
AlibabaCloud DMS MCP Server is an AI-powered unified data management gateway that supports connection to over 40+ data sources, serving as a multi-cloud universal data MCP Server to address cross-source data secure access in one-stop solution.
Tools
Functions exposed to the LLM to take actions
addInstance
Add an instance to DMS. The username and password are required. Only Aliyun instances are supported. Either instance_resource_id or host and port must be provided. The region is optional, but it's recommended to include it.If the instance already exists, it will return the existing instance information.
listInstances
Search for instances from DMS.
getInstance
Retrieve detailed instance information from DMS using the host and port.
searchDatabase
Search databases in DMS by name.
getDatabase
Obtain detailed information about a specific database in DMS when the host and port are provided.
listTables
Search for tables by databaseId and (optional) table name. If you don't know the databaseId, first use getDatabase or searchDatabase to retrieve it.(1)If you have the exact host, port, and database name, use getDatabase.(2)If you only know the database name, use searchDatabase.(3)If you don't know any information, ask the user to provide the necessary details.Note: searchDatabase may return multiple databases. In this case, let the user choose which one to use.
getTableDetailInfo
Retrieve detailed metadata information about a specific database table including schema and index details. If you don't know the table_guid parameter, retrieve it using listTables.
executeScript
Execute SQL script against a database in DMS and return structured results.If you don't know the databaseId, first use getDatabase or searchDatabase to retrieve it.(1)If you have the exact host, port, and database name, use getDatabase.(2)If you only know the database name, use searchDatabase.(3)If you don't know any information, ask the user to provide the necessary details.Note: searchDatabase may return multiple databases. In this case, let the user choose which one to use.
generateSql
Generate SELECT-type SQL queries from natural language input.
configureDtsJob
Configure a dts job.
startDtsJob
Start a dts job.
getDtsJob
Get a dts job detail information.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client
