aliyun_alibabacloud-dms-mcp-server
If you are the rightful owner of aliyun_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 30+ data sources, serving as a multi-cloud universal data MCP Server to address cross-source data secure access in a one-stop solution.
AlibabaCloud DMS MCP Server is designed to provide a unified data management gateway that connects to over 30 data sources. It serves as a multi-cloud universal data MCP Server, addressing cross-source data secure access in a one-stop solution. The server supports a wide range of databases and data warehouses, including both Alibaba Cloud services and mainstream databases like MySQL, PostgreSQL, Oracle, and more. The core features of the server include a unified data access layer and metadata access layer, which help in reducing maintenance costs, solving compatibility issues, and mitigating security risks. The server also offers features like NL2SQL for executing SQL via natural language, code generation for schema information retrieval, and fine-grained access control for enhanced security.
Features
- Unified Data Access Layer: Provides a standardized interface to access various data sources, reducing maintenance costs and compatibility issues.
- NL2SQL: Allows execution of SQL queries using natural language, simplifying data retrieval processes.
- Code Generation: Enables retrieval of schema information to generate DAO code or perform structural analysis.
- Security: Offers fine-grained access control and auditability to mitigate security risks.
- Data Retrieval: Automatically routes SQL to the correct data sources for business support.
Tools
addInstance
Add an instance to DMS. If the instance already exists, return the existing instance information.
getInstance
Retrieve instance details from DMS based on host and port information.
searchDatabase
Search for databases in DMS based on schemaName.
getDatabase
Retrieve detailed information about a specific database from DMS.
listTable
Search for data tables in DMS based on databaseId and tableName.
getTableDetailInfo
Retrieve detailed metadata information for a specific data table, including field and index details.
executeScript
Execute an SQL script through DMS and return the results.
nl2sql
Convert natural language questions into executable SQL queries.
