AWS RDS

Manage relational database instances and clusters.

List instances

aws rds describe-db-instances --query 'DBInstances[].{Id:DBInstanceIdentifier,Engine:Engine,Version:EngineVersion,Status:DBInstanceStatus,Class:DBInstanceClass,Storage:AllocatedStorage}' --output table

Get instance details

aws rds describe-db-instances --db-instance-identifier my-db | jq '.DBInstances[0] | {Id: .DBInstanceIdentifier, Engine, Status: .DBInstanceStatus, Endpoint: .Endpoint.Address, Port: .Endpoint.Port, MultiAZ, StorageType, AllocatedStorage}'

List Aurora clusters

aws rds describe-db-clusters --query 'DBClusters[].{Id:DBClusterIdentifier,Engine:Engine,Status:Status,Endpoint:Endpoint,ReaderEndpoint:ReaderEndpoint}' --output table

Create snapshot

aws rds create-db-snapshot --db-instance-identifier my-db \
  --db-snapshot-identifier my-db-snap-$(date +%Y%m%d) | jq '{SnapshotId: .DBSnapshot.DBSnapshotIdentifier, Status: .DBSnapshot.Status}'

List snapshots

aws rds describe-db-snapshots --db-instance-identifier my-db --query 'DBSnapshots[].{Id:DBSnapshotIdentifier,Status:Status,Created:SnapshotCreateTime,Size:AllocatedStorage}' --output table

Stop instance

aws rds stop-db-instance --db-instance-identifier my-db | jq '{Id: .DBInstance.DBInstanceIdentifier, Status: .DBInstance.DBInstanceStatus}'

Start instance

aws rds start-db-instance --db-instance-identifier my-db | jq '{Id: .DBInstance.DBInstanceIdentifier, Status: .DBInstance.DBInstanceStatus}'

Recent events

aws rds describe-events --source-identifier my-db --source-type db-instance --duration 1440 --query 'Events[].{Date:Date,Message:Message}' --output table

Notes

• Stop/start is not available for Aurora clusters (use scaling to 0 ACUs instead).
• Snapshots are region-specific; copy cross-region for DR.
• Always confirm before stopping, deleting, or modifying instances.