Db

Check database health:

aws rds describe-db-instances --db-instance-identifier <id>
aws cloudwatch get-metric-statistics --namespace AWS/RDS ...

• CPU, memory, IOPS, connections, replica lag
• Storage utilization and auto-scaling status
• Backup configuration and retention
• Parameter group settings

migration <description>

Plan a database migration:

1. Assess schema change risk (locking, data loss)
2. Estimate migration duration
3. Plan zero-downtime strategy (expand/contract, dual-write)
4. Define rollback procedure
5. Create pre/post migration validation checks

connections <service or rds-instance>

Analyze connection management:

1. Check connection pool configuration in application
2. Compare pool size vs RDS max_connections
3. Check for connection leaks
4. Review PgBouncer/ProxySQL/RDS Proxy setup
5. Recommend optimal pool sizing