跳至正文
OpenAgentSkill
浏览已开放 · 目录记录日期 2026-11-21 · 自动更新和账户服务暂时关闭。
浏览器与自动化

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 is ResourceName and 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 DB
  • logs.DescribeLogGroups with prefix:
    • Instances: /aws/rds/instance/<dbInstanceIdentifier>/
    • Aurora: /aws/rds/cluster/<dbClusterIdentifier>/

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)

idmetricNamestatunit
cpuCPUUtilizationAverage%
freeMemFreeableMemoryMinimumbytes
freeSpaceFreeStorageSpaceMinimumbytes
readIopsReadIOPSAveragecount/s
writeIopsWriteIOPSAveragecount/s
readLatReadLatencyAverages
writeLatWriteLatencyAverages
dbConnDatabaseConnectionsMaximumcount
swapSwapUsageAveragebytes
netInNetworkReceiveThroughputAveragebytes/s
netOutNetworkTransmitThroughputAveragebytes/s
binLogBinLogDiskUsageAveragebytes
replLagReplicaLagMaximums

5.2 Aurora Clusters (dimension DBClusterIdentifier)

idmetricNamestatunit
cpuCPUUtilizationAverage%
freeMemFreeableMemoryMinimumbytes
dbConnDatabaseConnectionsMaximumcount
replLagAuroraReplicaLagMaximumms
bufCacheBufferCacheHitRatioAverage%
commitLatCommit
阅读完整来源 ↗