rds-operation-review
Comprehensive Amazon RDS and Aurora operational review aligned with the
yakiratz-aws · 已有静态检查记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add aws/tools-for-devops-agent --skill rds-operation-review技能说明
name: rds-operation-review description: Comprehensive Amazon RDS and Aurora operational review aligned with the AWS Well-Architected Framework and RDS/Aurora best practices. Use this skill when a user asks to review, audit, or assess RDS instances or Aurora clusters for best practices compliance, security posture, reliability, performance, cost optimization, backups, encryption, or operational readiness. Triggers on requests like "RDS review", "Aurora best practices audit", "database operational assessment", "review my RDS instance", "RDS health check", or "ORR for RDS". metadata: author: yakiratz-aws version: "1.0.0" aws-devops-agent-skills.agent-types: "Chat tasks, Evaluation" aws-devops-agent-skills.aws-services: "Amazon RDS" aws-devops-agent-skills.technical-domains: "Databases"
RDS / Aurora Operational Review
Conduct a comprehensive operational review of Amazon RDS instances and Amazon Aurora clusters aligned with the AWS Well-Architected Framework and the Amazon RDS and Aurora best-practices guides.
This skill uses the AWS RDS, Aurora, CloudWatch, CloudWatch Logs, EC2, and Cost
Explorer APIs only — no Kubernetes (k8s) or eks MCP tools. All data is
collected through native AWS APIs available to the DevOps Agent's primary cloud
source role.
When to Use
Activate this skill when the user asks to:
- Review, audit, or assess RDS instances or Aurora clusters
- Check RDS / Aurora best-practices compliance
- Evaluate database security, cost, reliability, performance, or backups
- Perform an RDS / Aurora operational readiness review (ORR)
- Investigate database health or configuration drift
Step 1: Identify Target Resources
Ask the user which databases to review. Accept:
- Specific instance / cluster identifiers and regions
- "all instances" / "all clusters" in specific regions
- "all RDS in all regions"
If no scope is given, default to all configured account regions.
Step 2: Discover RDS / Aurora Resources
Per region (skip empty regions):
rds.DescribeDBInstances # RDS instances + Aurora cluster member instances
rds.DescribeDBClusters # Aurora clusters (skip if user said "Provisioned only")
rds.DescribeDBClusterEndpoints # Aurora reader/writer endpoints
rds.DescribeGlobalClusters # Aurora Global Database (cross-region)
rds.DescribeDBProxies # RDS Proxy
Capture per resource:
- Engine, engineVersion, dbInstanceClass / serverlessV2 capacity
- Multi-AZ, AvailabilityZones, subnetGroup, VpcId
- AllocatedStorage, MaxAllocatedStorage, StorageType, Iops, StorageThroughput, StorageEncrypted, KmsKeyId
- BackupRetentionPeriod, PreferredBackupWindow, PreferredMaintenanceWindow, AutoMinorVersionUpgrade
- DeletionProtection, PubliclyAccessible, IAMDatabaseAuthenticationEnabled
- PerformanceInsightsEnabled, PerformanceInsightsRetentionPeriod, MonitoringInterval (Enhanced Monitoring), MonitoringRoleArn
- EnabledCloudwatchLogsExports, AssociatedRoles
- ReadReplicaSourceDBInstanceIdentifier / ReadReplicaDBInstanceIdentifiers
- Tags (
rds.ListTagsForResource— param name isResourceNameand value is the resource ARN)
Step 3: Discover Configuration Dependencies
For each database, collect:
rds.DescribeDBParameterGroups # custom vs default
rds.DescribeDBClusterParameterGroups # Aurora
rds.DescribeOptionGroups # RDS option groups
rds.DescribeDBSubnetGroups # subnet AZ spread
ec2.DescribeSecurityGroups # vpcSecurityGroupIds → ingress rules
kms.DescribeKey # for KmsKeyId (encryption at rest)
Step 4: Collect Backups, Snapshots, Maintenance
rds.DescribeDBSnapshots # manual + automated, per instance
rds.DescribeDBClusterSnapshots # Aurora
rds.DescribeDBInstanceAutomatedBackups
rds.DescribeDBClusterAutomatedBackups
rds.DescribeDBEngineVersions # current vs latest minor/major
rds.DescribePendingMaintenanceActions
rds.DescribeEvents # last 14 days; duration in MINUTES (20160)
rds.DescribeEventSubscriptions
For each instance/cluster, also fetch:
rds.DescribeDBLogFiles— list of logs available locally on the DBlogs.DescribeLogGroupswith prefix:- Instances:
/aws/rds/instance/<dbInstanceIdentifier>/ - Aurora:
/aws/rds/cluster/<dbClusterIdentifier>/
- Instances:
Step 5: Collect CloudWatch Metrics (7-Day Historical)
One cloudwatch.GetMetricData call per resource. Period: 21600 (6 hours).
StartTime: 7 days ago. EndTime: now.
5.1 RDS Instances (dimension DBInstanceIdentifier)
| id | metricName | stat | unit |
|---|---|---|---|
cpu | CPUUtilization | Average | % |
freeMem | FreeableMemory | Minimum | bytes |
freeSpace | FreeStorageSpace | Minimum | bytes |
readIops | ReadIOPS | Average | count/s |
writeIops | WriteIOPS | Average | count/s |
readLat | ReadLatency | Average | s |
writeLat | WriteLatency | Average | s |
dbConn | DatabaseConnections | Maximum | count |
swap | SwapUsage | Average | bytes |
netIn | NetworkReceiveThroughput | Average | bytes/s |
netOut | NetworkTransmitThroughput | Average | bytes/s |
binLog | BinLogDiskUsage | Average | bytes |
replLag | ReplicaLag | Maximum | s |
5.2 Aurora Clusters (dimension DBClusterIdentifier)
| id | metricName | stat | unit |
|---|---|---|---|
cpu | CPUUtilization | Average | % |
freeMem | FreeableMemory | Minimum | bytes |
dbConn | DatabaseConnections | Maximum | count |
replLag | AuroraReplicaLag | Maximum | ms |
bufCache | BufferCacheHitRatio | Average | % |
commitLat | Commit |