Skip to content

Instantly share code, notes, and snippets.

@instaBOT

instaBOT/list-all-rds-instances.sh

Last active September 24, 2015 14:03
Show Gist options
  • Save instaBOT/3b3abcdc115db88858a8 to your computer and use it in GitHub Desktop.
Save instaBOT/3b3abcdc115db88858a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
list-all-rds-instances.sh
#!/usr/bin/env bash
cd
set -e
aws rds describe-db-instances \
--query 'DBInstances[*][DBInstanceIdentifier, DBInstanceClass, DBInstanceStatus, AvailabilityZone, InstanceCreateTime, Endpoint.Address]' \
--output table
# -------------------------------------------------------------------------------------------
# | DescribeDBInstances |
# +-------------------+---------------+-------------+-------------+-------------------------+
# | ig-dev-3eed3 | db.t2.micro | available | us-west-2c | ***.rds.amazonaws.com |
# | ig-dev-5872a | db.t2.micro | modifying | us-west-2c | ***.rds.amazonaws.com |
# | ig-dev-d30b4 | db.t2.micro | backing-up | us-west-2a | ***.rds.amazonaws.com |
# | instagis2015 | db.t2.medium | available | us-west-2c | ***.rds.amazonaws.com |
# | instagisslave2015| db.t2.small | available | us-west-2b | ***.rds.amazonaws.com |
# +-------------------+---------------+-------------+-------------+-------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment