Control: GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.09 - Ensure Cloud SQL Database Instances Have Deletion Protection Enabled

Configures auditing against a CIS Benchmark item.

Level: 1

Ensure that deletion protection is enabled on all Cloud SQL database instances to prevent accidental or unauthorized deletion. This setting safeguards critical databases by requiring explicit disabling of deletion protection before deletion, reducing the risk of data loss through human error or malicious activity.

Resource Types

This control targets the following resource types:

GCP > SQL > Instance

Policies

This control type relies on these other policies when running actions:

In Your Workspace

Developers

Control Type URI

tmod:@turbot/gcp-cisv5-0#/control/types/r0609

Category URI

tmod:@turbot/cis#/control/categories/v071001

GraphQL

query controlType(id: "tmod:@turbot/gcp-cisv5-0#/control/types/r0609") { … }

query controls(filter: "controlTypeId:'tmod:@turbot/gcp-cisv5-0#/control/types/r0609'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/gcp-cisv5-0#/control/types/r0609"