Overview
The Alibaba Cloud RDS OpenAPI MCP Server is an MCP server that enables programmatic management of Alibaba Cloud RDS resources through the RDS OpenAPI. It exposes a consolidated set of OpenAPI Tools that map to common RDS operations (creating, describing, and modifying DB instances; managing accounts and parameters; configuring network settings; and querying bills, zones, and performance). The server is designed to be used with the MCP framework and can be loaded via clients such as Cherry Studio, Cline, or Claude. Toolsets allow you to enable specific capabilities (rds, rds_custom_read, rds_custom_all) to tailor access. Prerequisites include uv, Python 3.12, and Alibaba Cloud credentials. Configuration is performed via environment variables (AK/SK, optionally STS security token) and optional API keys. Quick Start examples show importing a JSON configuration into Cherry Studio and running the server with uvx, or starting the server in Claude and pointing the client to the local endpoint. The server also notes an automatic read-only SQL account workflow for SQL commands. This MCP server provides a gateway for LLM-based interactions to automate RDS tasks using Alibaba Cloud’s OpenAPI.
Features
add_tags_to_db_instance
Add tags to an RDS instance.
allocate_instance_public_connection
Allocate a public connection for an RDS instance.
attach_whitelist_template_to_instance
Attach a whitelist template to an RDS instance.
create_db_instance
Create an RDS instance.
describe_db_instances
Query RDS instances.
modify_security_ips
Modify RDS instance security IP whitelist.
explain_sql
Execute sql explain and return sql result.
query_sql
Execute read-only sql and return sql result.
Who Is This For?
- RDS admins:Programmatically manage RDS resources via LLM using MCP APIs in production.
- Developers:Developers building LLM-assisted workflows that manage RDS resources via MCP.
- Data engineers:Automate provisioning and monitoring of RDS resources through natural language interfaces.
