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|PubliclyAccessible"
• aws rds describe-db-instances | egrep "DBInstanceIdentifier|AllocatedStorage"
• aws rds describe-db-instances | grep -w DBInstanceIdentifier
• aws rds describe-db-instances | grep Address
• aws rds describe-db-instances | egrep -iw "Address|SubnetIdentifier"
• aws rds describe-db-instances | grep MultiAZ
• aws rds describe-db-instances | grep MasterUsername
• 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 DBInstanceStatus

• aws rds describe-db-instances | jq -r '.DBInstances[0].Endpoint.Address'
• 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
• aws rds describe-db-instances | grep -i PubliclyAccessible
• aws rds describe-db-instances | egrep -i "Address|VpcId"

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 "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

• aws rds describe-db-clusters
• DBINSTANCES, DBInstanceStatus, DBInstanceIdentifier, MasterUsername
• aws cloudformation list-stacks --stack-status-filter CREATE_COMPLETE
• Connect to database: psql, mysql
• aws rds describe-db-proxies
• aws rds describe-db-log-files
• aws list all
• aws cloudwatch get-metric-statistics
• aws redshift describe-clusters
• InvalidDBSubnetGroupStateFault
• aws rds describe-db-engine-versions
• aws rds describe-db-security-groups
• gcloud sql instances describe

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
• Terraform RDS, Terraform module: rds, aws_db_instance, aws_rds_cluster, aws_rds_cluster_instance, aws_db_parameter_group, aws_db_subnet_group, aws_rds_global_cluster, aws_rds_cluster_parameter_group