Menu
Amazon Relational Database Service
Command Line Interface Reference (API Version 2014-10-31)

rds-describe-db-instances

The Amazon RDS Command Line Interface (RDS CLI) has been deprecated. Instead, use the AWS CLI for RDS. To learn how to download and use the AWS CLI, see AWS Command Line Interface User Guide. For RDS commands available in the AWS CLI, see AWS CLI Reference for Amazon RDS.

The AWS CLI does not currently support the DownloadCompleteDBLogFile REST API action. To download an entire log file at once, rather than in parts using the download-db-log-file-portion command, use the last published RDS CLI and the rds-download-db-logfile command.

Description

Returns information about all DB instances for an account if no DB instance identifier is specified, or displays information about a specific DB instance.

Note

This command returns only active DB instances in the current default region. To see DB instances created in another region, you can change the region using the --region parameter or pass in the URL of the regional endpoint using the --url parameter.

Syntax

rds-describe-db-instances [db-instance-identifier]

[General Options]

Options

Name Description Required

--db-instance-identifier value

DB instance identifier. This is the unique key that identifies an DB instance. Stored as a lowercase string.

This parameter is the default parameter and can be passed as the first value in the command and without a parameter name, for example: rds-describe-db-instances my-db-instance-identifier.

Type: String

Default: None

Constraints: Must contain from 1 to 63 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens.

Example: myinstance

No

Output

The command returns the following information:

Note

Output values list the possible values returned by CLI commands. Not all values are returned for every call to a command. If a value is null or empty, it will not be included in the command output. For example, CLI commands to create or restore a DB instance will not return the Endpoint Address value because that value is null until the DB instance has finished being created or restored.

  • DBInstanceId—User-supplied database identifier; this is the unique key that identifies a DB instance

  • Created—When the instance was created, in UTC

  • Class—The compute and memory capacity of the DB instance

  • Engine—Name of the database engine used for this DB instance

  • Storage—Initially allocated storage size specified in GBs

  • Storage Type—The type of storage specified

  • Storage Encrypted—Indicates whether the DB instance is encrypted

  • KmsKeyId—If Storage Encrypted is true, the KMS key identifier for the encrypted DB instance

  • Resource Id—If Storage Encrypted is true, the region-unique, immutable identifier for the encrypted DB instance. This identifier is found in AWS CloudTrail log entries whenever the KMS key for the DB instance is accessed.

  • Master Username—The master username for the instance

  • Status—The current status of the instance. Valid values: available | backing-up | creating | deleted | deleting | failed | incompatible-restore | incompatible-parameters | modifying | rebooting | resetting-master-credentials | storage-full

  • Endpoint Address—Address of the DB instance

  • Port—Port used to connect to the DB instance

  • AZ—The instance's Availability Zone

  • SecondaryAZ—When the DB instance has multi-AZ support, this value is the secondary AZ.

  • Backup Retention—The number of days that automated backups are retained before deletion

  • PendingClass—The class to which the instance will be scaled during the next maintenance window, or to which it is currently being scaled if the --apply-immediately option was specified.

  • PendingCredentials—The (hidden) master user password that will be applied to the DB instance.

  • PendingVersion— The pending database engine version number. This column appears only in the --show-long view.

  • DB Name—Name of the initial database created when the instance was created or the Oracle System ID (SID) of the created DB instance (for the Oracle engine). This column appears only in the --show-long view

  • Maintenance Window—The period during which patching and instance modifications will be performed. This column appears only in the --show-long view.

  • Backup Window—The daily period during which automated backups are created. This column appears only in the --show-long view.

  • Version—The version number of the database engine.

  • Iops—The provisioned storage IOPS, expressed as I/O operations per second.

  • Auto Minor Version Upgrade—Indicates that minor version upgrades will be applied to the DB instance during the maintenance window. This column appears only in the --show-long view.

  • Name—DB security group name.

  • Status—Status of authorization. Valid values: authorizing | authorized | revoking

  • Group Name—Name of DB parameter group applied to.

  • Apply Status—Status of applying the DB parameter group. Valid values: in-sync | pending-reboot | applying

  • Multi-AZ—Indicates if this is a Multi-AZ DB instance.

  • EngineVersion—Database engine version number.

  • Replication State—The status of the Read Replica replication.

  • Change Date—The date of the last replication state change for the Read Replica.

  • CACertificateIdentifier—Specifies the name of the CA certificate associated with the DB instance.

  • PendingCACertificateIdentifier—Specifies the name of the CA certificate to be associated with the DB instance.

Examples

Get a Description of All Database Instances

This example returns a description of all DB instances for the account.

Copy
PROMPT> rds-describe-db-instances DBINSTANCE mydbinstance 2010-08-04T23:27:36.420Z db.m1.small mysql 50 sa available mydbinstance.ab7c2d4uz396.us-east-1.rds.amazonaws.com 3306 us-east-1a 3 n 5.1.49 SECGROUP default active PARAMGRP default.mysql5.1 in-sync DBINSTANCE simcoprod01 2010-08-06T07:51:10.154Z db.m1.large mysql 10 master available simcoprod01.cu7u2t4uz396.us-east-1.rds.amazonaws.com 3306 us-east-1a 1 n 5.1.49 SECGROUP default active PARAMGRP default.mysql5.1 in-sync

Get a Description of a Specific Database Instance, Showing Headers

This example returns a full description of a specific DB instance and shows table headers

Copy
PROMPT> rds-describe-db-instances simcoprod01 --show-long --headers DBINSTANCE,DBInstanceId,Created,Class,Engine,Storage,Master Username,Status, Endpoint Address,Port,AZ,Backup Retention,PendingBackupRetention,PendingClass, PendingCredentials,PendingStorage,PendingMulti-AZ,PendingVersion,DB Name, Maintenance Window,Backup Window,Latest Restorable Time,Multi-AZ,Version, Auto Minor Version Upgrade DBINSTANCE,simcoprod01,2010-07-16T00:06:59.107Z,db.m1.large,mysql,60,master,avai lable,simcoprod01.cu7u2z4zz123.us-east-1.rds.amazonaws.com,3306,us-east -1d,1,(nil),(nil),(nil),(nil),(nil),(nil),(nil),sun:05:00-sun:09:00,23:00-01:00, 2010-08-05T00:00:00Z,n,5.1.47,n SECGROUP,Name,Status SECGROUP,default,active PARAMGRP,Group Name,Apply Status PARAMGRP,default.mysql5.1,in-sync