Aws rds describe-db-instances

• aws rds describe-db-instances

https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/describe-db-instances.html

• aws rds describe-db-instances | egrep -w "DBInstanceIdentifier|Address"
• aws rds describe-db-instances | grep -w DBInstanceIdentifier
• aws rds describe-db-instances | grep Address
• aws rds describe-db-instances | grep MultiAZ
• aws rds describe-db-instances --db-instance-identifier MY_DB_NAME
• aws rds describe-db-instances --output table
• aws rds describe-db-instances --output text --query 'DBInstances[*].[DBInstanceArn,Engine,DBInstanceIdentifier,DBInstanceStatus]'

aws rds describe-db-instances | grep -i PreferredMaintenanceWindow
aws rds describe-db-instances | grep -i PerformanceInsightsEnabled
aws rds describe-db-instances | grep -i StorageEncrypted
aws rds describe-db-instances | grep -i AutoMinorVersionUpgrade

Replication

• aws rds describe-db-instances | grep ReadReplicaSourceDBInstanceIdentifier
• aws rds describe-db-instances | grep -w Status
• aws rds describe-db-instances | grep -w StatusType

Storage data

• aws rds describe-db-instances | egrep -w "DBInstanceIdentifier|AllocatedStorage

• StorageType: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
  • Standard: magnetic (also known as standard)
  • io1: provisioned IOPS SSD (also known as io1)
  • gp2: General Purpose SSD (also known as gp2)
• StorageEncrypted, MaxAllocatedStorage

arn:aws:rds:eu-central-1:4523523466:db:my_branches_name	postgres  my_branches_name	available

Version:

• aws rds describe-db-instances | egrep -w "EngineVersion|DBInstanceIdentifier"

Example Output

{
    "DBInstances": [
        {
            "DBInstanceIdentifier": "mydbinstancecf",
            "DBInstanceClass": "db.t3.small",
            "Engine": "mysql",
            "DBInstanceStatus": "available",
            "MasterUsername": "masterawsuser",
            "Endpoint": {
                "Address": "mydbinstancecf.abcexample.us-east-1.rds.amazonaws.com",
                "Port": 3306,
                "HostedZoneId": "Z2R2ITUGPM61AM"
            },
            ...some output truncated...
        }
    ]
}

• Engine: mysql, postgres

Related terms

• DBINSTANCES
• DBInstanceStatus
• DBInstanceIdentifier
• MasterUsername
• aws cloudformation list-stacks --stack-status-filter CREATE_COMPLETE
• aws list all
• VpcId: aws rds describe-db-instances | grep VcpId
• Connect to database: psql
• aws rds describe-db-proxies
• aws rds describe-db-log-files

See also

• AWS RDS: AWS::RDS, aws rds [ create-db-instance | create-db-instance-read-replica | describe-db-instances | modify-db-instance | modify-db-cluster | create-db-subnet-group | delete-db-instance | create-db-snapshot | aws rds create-db-parameter-group ], AllocatedStorage, FreeStorageSpace