Other Articles

RDS DB Cluster – Enable Deletion Protection

Secure Configuration Checks > AWS

This check ensures that deletion protection is enabled on Amazon RDS DB clusters, such as Amazon Aurora clusters. With deletion protection on, a cluster cannot be deleted by mistake or by an attacker until the setting is turned off first. Deleting a cluster removes its data and, unless you keep a snapshot, cannot be undone.

Check Details

  • Resource: RDS DB Cluster
  • Check: Enable RDS cluster deletion protection (DeletionProtectionEnabled)
  • Risk: An accidental or malicious delete request removes the cluster and its data, and causes an outage

Remediation via AWS Console

  1. Log in to the AWS Management Console and open the Amazon RDS console.

    Amazon RDS Console
  2. In the left navigation pane, click Databases. Select the DB cluster (the row with the role Regional cluster or Multi-AZ DB cluster) and click Modify.

    Modify an RDS DB cluster
  3. Expand Additional configuration. Select Enable deletion protection.

    Enable deletion protection for an RDS DB cluster
  4. Click Continue. Under Scheduling of modifications, choose Apply immediately.
  5. Click Modify cluster.
  6. Repeat steps 2 to 5 for every DB cluster without deletion protection.

Remediation via AWS CLI

  1. Log in to the AWS Management Console and click the CloudShell icon (>_) in the top-right corner.

    AWS CloudShell
  2. List the DB clusters that have deletion protection turned off. The output shows the cluster name and the engine:

    aws rds describe-db-clusters \
    --query 'DBClusters[?DeletionProtection==`false`].[DBClusterIdentifier,Engine]' \
    --output text
    

    The command covers one region. Add --region <region> to check another.

  3. Turn on deletion protection:

    aws rds modify-db-cluster \
    --db-cluster-identifier <cluster-name> \
    --deletion-protection \
    --apply-immediately
    
  4. Verify the setting:

    aws rds describe-db-clusters \
    --db-cluster-identifier <cluster-name> \
    --query 'DBClusters[0].[DBClusterIdentifier,DeletionProtection]' \
    --output text
    

    The value must be True.

Replace <cluster-name> with the identifier of the DB cluster, for example prod-aurora-cluster. Repeat steps 3 and 4 for each cluster that step 2 lists. To turn the protection off before a planned deletion, run the same modify-db-cluster command with --no-deletion-protection instead of --deletion-protection.

Updated on 05 November, 2026