aws-list-rds.sh

#!/bin/bash

# Parse arguments:
VERBOSE=0
while getopts ":r:p:v" opt; do
  case $opt in
    r) REGION="--region $OPTARG";;
    p) PROFILE="--profile $OPTARG";;
    v) VERBOSE=$(( VERBOSE + 1 ));;
    :) echo "Option -$OPTARG requires an argument." >&2; exit 1;;
    \?) echo "Invalid option: -$OPTARG" >&2;;
  esac
done
shift $((OPTIND-1))

if ! which jq > /dev/null 2>&1; then echo "The 'jq' command is not installed, aborting." >&2; exit 1; fi


if [[ "$VERBOSE" == 0 ]]; then
  aws $PROFILE $REGION rds describe-db-instances | jq -r '.DBInstances[] | select ( .DBInstanceStatus != "deleting" ) | .DBInstanceIdentifier'
  exit 0
fi

if [[ "$VERBOSE" == 1 ]]; then
  aws $PROFILE $REGION rds describe-db-instances  \
    | jq -r '.DBInstances[] | [.DBInstanceIdentifier,.DBInstanceStatus] | @csv'
  exit 0
fi

if [[ "$VERBOSE" == 2 ]]; then
  aws $PROFILE $REGION rds describe-db-instances  \
    | jq -r '.DBInstances[] | "\(.DBInstanceIdentifier)  \"DB_HOST\": \"\(.Endpoint.Address)\""'
  exit 0
fi

if [[ "$VERBOSE" == 3 ]]; then
  aws $PROFILE $REGION rds describe-db-instances 
  exit 0
fi