Find AWS RDS Instances lacking automated backups

Queries & Insights
,
1

Automated backups are essential for disaster recovery and business continuity, as manual backup processes are prone to human error and may not capture data consistently.

Here’s a simple PostgreSQL query to list all RDS instances without automated backup configured:

SELECT
    account_id, db_instance_identifier, backup_retention_period, tags
FROM
    aws_rds_instances
WHERE
    backup_retention_period = 0;