List all RDS
aws rds describe-db-instances --region YOUR-REGION
Output:
{
"DBInstances": [
{
"DBInstanceIdentifier": "demo1-instance",
"DBInstanceClass": "db.r5.large",
"Engine": "mysql",
"DBInstanceStatus": "available",
"MasterUsername": "admin",
"DBName": "demo1db",
"Endpoint": {
"Address": "demo1-instance.cmdg3vme9ij2.us-west-2.rds.amazonaws.com",
"Port": 3306,
"HostedZoneId": "Z1PVIF0B656C1W"
},
"AllocatedStorage": 100,
"InstanceCreateTime": "2022-11-01T05:54:07.715000+00:00",
"PreferredBackupWindow": "07:04-07:34",
"BackupRetentionPeriod": 1,
"DBSecurityGroups": [],
"VpcSecurityGroups": [
[...]