skills.rest
itsadijmbt
itsadijmbtCOMMUNITY
Explore all skills by this author →
GitHub

alibabacloud-rds-instances-manage

Manage Alibaba Cloud RDS instances and run read-only SQL via OpenAPI.

1|Updated Apr 24, 2026
Search Tags:#monitoring#openapi#rds#aliyun#read-only sql#slow logs#db instance management
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill alibabacloud-rds-instances-manage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: alibabacloud-rds-instances-manage
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/alibabacloud-rds-openapi-mcp-server/skill/alibabacloud-rds-instances-manage
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill alibabacloud-rds-instances-manage

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It eliminates the manual effort of finding RDS instance information, operational metrics, logs, and parameters by letting an AI query Alibaba Cloud RDS through OpenAPI and run read-only SQL safely.

Core Features & Use Cases

  • RDS instance discovery and details: list instances and fetch instance attributes for a specific region and instance id (e.g., region_id, db_instance_id).
  • Operational visibility: retrieve performance metrics, slow logs, error logs, and configuration parameters to diagnose issues.
  • Read-only data exploration: run safe SQL tasks such as query_sql, explain_sql, and show_create_table to inspect schemas and investigate query behavior without write operations.

Quick Start

Use alibabacloud-rds-instances-manage run describe_db_instances with JSON argument {"region_id":"cn-hangzhou"} after setting ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_ACCESS_KEY_SECRET.

Frequently Asked Questions about alibabacloud-rds-instances-manage

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list Alibaba Cloud RDS instances in a specific region?▼

To list Alibaba Cloud RDS instances, use the describe_db_instances command with a JSON argument specifying the region_id. This requires setting ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_ACCESS_KEY_SECRET environment variables for authentication.

Can I run SQL queries on Alibaba Cloud RDS without write permissions?▼

Yes, you can run read-only SQL queries like query_sql, explain_sql, and show_create_table on Alibaba Cloud RDS. This allows safe schema inspection and query behavior investigation without executing write operations on the database.

What authentication is needed to access Alibaba Cloud RDS OpenAPI?▼

Accessing Alibaba Cloud RDS OpenAPI requires ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_ACCESS_KEY_SECRET. You can also optionally provide ALIBABA_CLOUD_SECURITY_TOKEN for temporary credentials to authenticate your CLI commands.

How do I view slow logs and performance metrics for an Alibaba Cloud RDS instance?▼

You can retrieve slow logs, error logs, and performance metrics by calling Alibaba Cloud RDS OpenAPI endpoints. Use the specific db_instance_id to fetch operational visibility data and diagnose instance issues.

Does this approach support fetching configuration parameters for a specific RDS instance?▼

Yes, this approach supports fetching configuration parameters for a specific Alibaba Cloud RDS instance. By providing the db_instance_id, you can view instance attributes and configuration parameters to ensure optimal database settings.

Related Skills

Explore More Data & Analytics Skills→
ciniencecinience
396

alicloud-network-dns-cli-test

Validate Alibaba Cloud DNS CLI authentication and DescribeSubDomainRecords command flow.

Community
Basic
tbroadleytbroadley

read-inspect-eval

Extract samples, messages, events, and metrics from Inspect AI .eval logs.

Community
Intermediate
partme-aipartme-ai
610

cloud-aliyun-rds

Create and configure Alibaba Cloud RDS instances with backup management.

Official
Intermediate
ciniencecinience
396

alicloud-network-alb-test

Validate Alibaba Cloud ALB skill via automated Python smoke tests.

Community
Intermediate