AlibabaCloud DMS MCP Server
by aliyun
AI-powered unified data management gateway that supports connection to over 30+ data sources. It serves as a multi-cloud universal data MCP Server to address cross-source data secure access in one-stop solution.
Last updated: N/A
What is AlibabaCloud DMS MCP Server?
AlibabaCloud DMS MCP Server is an AI-powered unified data management gateway that provides a unified data access and metadata access layer, solving maintenance costs, compatibility issues, and security risks associated with fragmented data sources.
How to use AlibabaCloud DMS MCP Server?
To use the server, first download the code using git clone. Then, configure the MCP client by adding the provided configuration to the configuration file, ensuring to set the necessary environment variables for Alibaba Cloud access.
Key features of AlibabaCloud DMS MCP Server
NL2SQL
Code Generation
Data Retrieval
Security - Fine-grained access control and auditability
Use cases of AlibabaCloud DMS MCP Server
Executing SQL via natural language
Generating DAO code from schema information
Automatically routing SQL to accurate data sources
Securing data access with fine-grained control and audit logs
FAQ from AlibabaCloud DMS MCP Server
How do I add an instance to DMS?
How do I add an instance to DMS?
Use the addInstance tool, providing the required db_user, db_password, and optional instance_resource_id, host, port, and region.
How do I retrieve instance details?
How do I retrieve instance details?
Use the getInstance tool, providing the host and port of the instance. For Oracle-like databases, the sid is also required.
How do I search for databases in DMS?
How do I search for databases in DMS?
Use the searchDatabase tool, providing the search_key (schemaName) and optional page_number and page_size.
How do I execute an SQL script?
How do I execute an SQL script?
Use the executeScript tool, providing the database_id (obtained via getDatabase) and the script content.
How do I convert natural language to SQL?
How do I convert natural language to SQL?
Use the nl2sql tool, providing the question, database_id, and optional knowledge for context.