Alibaba RDS MCP Server

MCPOfficialOpen SourceApache-2.049.9

by aliyun • Analytics & Monitoring

An open-source MCP server that exposes Alibaba Cloud RDS OpenAPI and SQL tools for agents to manage, monitor, and query RDS instances.

Example Use Cases

1
Provision and configure Alibaba Cloud RDS instances (create, modify specs, allocate public connections, add tags).
2
Collect monitoring and diagnostic data (describe_db_instance_performance, describe_monitor_metrics, describe_error_logs, describe_slow_log_records).
3
Run safe read-only SQL diagnostics or analysis against instances (automatically creating temporary read-only accounts and running query_sql, explain_sql, show_create_table).

Description

This MCP server provides a bridge between MCP clients and Alibaba Cloud RDS services, offering OpenAPI operations (instance management, billing, whitelists, parameters, etc.) and read-only SQL tooling (query_sql, explain_sql, show_create_table). It supports integration with MCP clients like cherry-studio, Cline, and Claude, and can automatically create temporary read-only DB accounts to run SQL safely. Toolsets let you enable only needed capabilities (rds, rds_custom_read, rds_custom_all). Users must supply Alibaba Cloud credentials (AK/SK or STS token) and connectivity to target instances for SQL execution.

Capabilities(34 total)

Tools (34)

describe_db_instances

Queries instances. Args: region_id: queries instances in region id(e.g. cn-hangzhou) :return:

region_id:string*

describe_db_instance_attribute

Queries the details of an instance. Args: region_id: db instance region(e.g. cn-hangzhou) db_instance_id: db instance id(e.g. rm-xxx) :return:

region_id:string*db_instance_id:string*

describe_db_instance_performance

Queries the performance data of an instance using the RDS OpenAPI. This method provides performance data collected from the RDS service, such as MemCpuUsage, QPSTPS, Sessions, ThreadStatus, MBPS, etc. Args: region_id: db instance region(e.g. cn-hangzhou) db_instance_id: db instance id(e.g. rm-xxx) db_type: the db instance database type(e.g. mysql,pgsql,sqlserver) perf_keys: Performance Key (e.g. ["MemCpuUsage", "QPSTPS", "Sessions", "COMDML", "RowDML", "ThreadStatus", "MBPS", "DetailedSpaceUsage"]) start_time: start time(e.g. 2023-01-01 00:00) end_time: end time(e.g. 2023-01-01 00:00)

region_id:string*db_instance_id:string*db_type:string*perf_keys:array*start_time:string*end_time:string*

modify_parameter

Modify RDS instance parameters. Args: region_id: The region ID of the RDS instance. dbinstance_id: The ID of the RDS instance. parameters (Dict[str, str], optional): Parameters and their values in JSON format. Example: {"delayed_insert_timeout": "600", "max_length_for_sort_data": "2048"} parameter_group_id: Parameter template ID. forcerestart: Whether to force restart the database. Default: False. switch_time_mode: Execution time mode. Values: Immediate, MaintainTime, ScheduleTime. Default: Immediate. switch_time: Scheduled execution time in format: yyyy-MM-ddTHH:mm:ssZ (UTC time). client_token: Client token for idempotency, max 64 ASCII characters. Returns: Dict[str, Any]: The response containing the request ID.

region_id:string*dbinstance_id:string*parameters:objectparameter_group_id:stringforcerestart:booleanswitch_time_mode:stringswitch_time:stringclient_token:string

modify_db_instance_spec

Modify RDS instance specifications. Args: region_id: The region ID of the RDS instance. dbinstance_id: The ID of the RDS instance. dbinstance_class: Target instance specification. dbinstance_storage: Target storage space in GB. pay_type: Instance payment type. Values: Postpaid, Prepaid, Serverless. effective_time: When the new configuration takes effect. Values: Immediate, MaintainTime, ScheduleTime. switch_time: Scheduled switch time in format: yyyy-MM-ddTHH:mm:ssZ (UTC time). switch_time_mode: Switch time mode. Values: Immediate, MaintainTime, ScheduleTime. source_biz: Source business type. dedicated_host_group_id: Dedicated host group ID. zone_id: Zone ID. vswitch_id: VSwitch ID. category: Instance category. instance_network_type: Instance network type. direction: Specification change direction. Values: UP, DOWN. auto_pause: Whether to enable auto pause for Serverless instances. max_capacity: Maximum capacity for Serverless instances. min_capacity: Minimum capacity for Serverless instances. switch_force: Whether to force switch for Serverless instances. client_token: Client token for idempotency, max 64 ASCII characters. Returns: Dict[str, Any]: The response containing the request ID.

region_id:string*dbinstance_id:string*dbinstance_class:stringdbinstance_storage:integerpay_type:stringeffective_time:stringswitch_time:stringswitch_time_mode:stringsource_biz:stringdedicated_host_group_id:stringzone_id:stringvswitch_id:stringcategory:stringinstance_network_type:stringdirection:stringauto_pause:booleanmax_capacity:numbermin_capacity:numberswitch_force:booleanclient_token:string

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C51/100

4/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities34 Tools / 0 Prompts / 0 Resources

Owneraliyun

CategoryAnalytics & Monitoring

DependenciesStandalone

Set Your Username