Skip to content

RDS Commands

List RDS instances and diagnose MySQL connectivity problems.

troubleshoot-mysql checks the things that actually break connections - security group rules, subnet routing, public accessibility, parameter group settings, and instance state - and reports what it finds rather than making you check each one by hand.

Commands

rds list-instances

List RDS instances in the current region.

aws-cloud-utilities rds list-instances [OPTIONS]
Option Value Description
--engine TEXT Filter by database engine (e.g., mysql, postgres)
--status TEXT Filter by instance status (e.g., available, stopped)
--tag-key TEXT Filter RDS instances by tag key (e.g., Environment)
--tag-value TEXT Filter RDS instances by tag value (requires --tag-key)

rds troubleshoot-mysql

Troubleshoot MySQL RDS connection issues.

aws-cloud-utilities rds troubleshoot-mysql DB_INSTANCE_IDENTIFIER [OPTIONS]
Option Value Description
--output-file TEXT Save detailed results to JSON file

Examples

# Instances in the current region
aws-cloud-utilities rds list-instances

# Filter by engine, status, or tag
aws-cloud-utilities rds list-instances --engine mysql
aws-cloud-utilities rds list-instances --status available
aws-cloud-utilities rds list-instances --tag-key Environment --tag-value production

# Diagnose a MySQL instance
aws-cloud-utilities rds troubleshoot-mysql my-mysql-instance

# Save the full diagnostic output
aws-cloud-utilities rds troubleshoot-mysql my-mysql-instance --output-file rds-diagnosis.json

Notes

list-instances operates on the current region only; there is no --all-regions flag. Loop over regions with the global --region option if you need a full picture:

for r in us-east-1 us-west-2 eu-west-1; do
  aws-cloud-utilities --region "$r" rds list-instances
done