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
Returns information about all DB instances for an account if no DB instance identifier is specified, or displays information about a specific DB instance.
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
--region parameter or pass in the URL of the regional
endpoint using the
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:
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.
The command returns the following information:
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:
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-immediatelyoption 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
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
Maintenance Window—The period during which patching and instance modifications will be performed. This column appears only in the
Backup Window—The daily period during which automated backups are created. This column appears only in the
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
Name—DB security group name.
Status—Status of authorization. Valid values:
Group Name—Name of DB parameter group applied to.
Apply Status—Status of applying the DB parameter group. Valid values:
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.
Get a Description of All Database Instances
This example returns a description of all DB instances for the account.
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
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