Useful one liners calling aws api through cli

awscli_EC2_oneliners.txt

# Retrive list of running EC2 instances name and private ip address
aws ec2 describe-instances --query 'Reservations[].Instances[?State.Name==`running`].[Tags[?Key==`Name`]|[0].Value,PrivateIpAddress]' --output text

awscli_ECR-EKS_oneliners.txt

# List ECR repositories
aws ecr describe-repositories --query 'repositories[*].repositoryName' --output text

awscli_RDS_oneliners.txt

# Retrieve supported RDS engine version of a specific engine
aws rds describe-db-engine-versions --query 'DBEngineVersions[?Engine==`mysql`].[Engine,EngineVersion]' --output table

# List RDS instances
aws rds describe-db-instances --query 'DBInstances[].[DBInstanceIdentifier,Engine,AvailabilityZone,Endpoint.Address,Endpoint.Port]' --output table

# Force AZ failover of a RDS instance (for a single-AZ)
aws rds modify-db-instance --db-instance-identifier DBNAME --multi-az --apply-immediately
aws rds reboot-db-instance --db-instance-identifier DBNAME --force-failover # it takes some time to report AZ change
aws rds modify-db-instance --db-instance-identifier DBNAME --no-multi-az --apply-immediately