# 6.6 Ensure That Cloud SQL Database Instances Do Not Have Public IPs (Automated)

- Source: https://support.icompaas.com/support/solutions/articles/62000233049-6-6-ensure-that-cloud-sql-database-instances-do-not-have-public-ips-automated-
- Section: [Solutions](https://support.icompaas.com/support/solutions) › [GCP Benchmarks](https://support.icompaas.com/support/solutions/62000112667) › [GCP Knowledge Bases](https://support.icompaas.com/support/solutions/folders/62000169178)
- Last updated: 2026-05-29
- Publisher: iCompaas, Inc. (https://www.icompaas.com)

Profile Applicability:

-   Level 2

Description:

Cloud SQL database instances should use private IPs instead of public IPs to enhance network security and reduce the attack surface.

Rationale:

Assigning private IPs to Cloud SQL database instances improves security by limiting exposure to the public internet. It also reduces latency and simplifies compliance with security policies. Public IPs increase the attack surface and should be avoided wherever possible.

Impact:

Removing public IP addresses may disrupt applications that rely on public IPs for database connectivity. Ensure all applications are reconfigured to use private IPs before making this change.

#### Default Value:

By default, Cloud SQL instances are assigned public IP addresses.

Audit Steps:

##### Using Google Cloud Console:

1.  Navigate to the [Cloud SQL Instances](https://console.cloud.google.com/sql/instances) page.
    

                ![](https://support.icompaas.com/assets/kb/d882a9aaa807df18.png)

2.  Confirm that each database instance has a private IP and does not have a public IP configured.
    

        ![](https://support.icompaas.com/assets/kb/d29408a9eb550b4b.png)

##### Using Google Cloud CLI:

List all Cloud SQL instances:

gcloud sql instances list

For each instance of type CLOUD\_SQL\_INSTANCE with backendType: SECOND\_GEN (excluding replicas of type READ\_REPLICA\_INSTANCE):

gcloud sql instances describe <INSTANCE\_NAME>

1.  Ensure the ipAddresses section shows an address of type PRIVATE and no address of type PRIMARY (indicating public IP).
    

Remediation Steps:

##### Using Google Cloud Console:

1.  Navigate to the [Cloud SQL Instances](https://console.cloud.google.com/sql/instances) page.
    

                          ![](https://support.icompaas.com/assets/kb/34b178d2f8016927.png)

2.  Click the instance name to open its details page.
    

           ![](https://support.icompaas.com/assets/kb/a242add340ac7ab2.png)

3.  Go to the Connections tab.
    

                     ![](https://support.icompaas.com/assets/kb/192c7e0abc3b1442.png)

4.  Uncheck the Public IP checkbox.
    

           ![](https://support.icompaas.com/assets/kb/867cb4432b69a638.png)

5.  Click Save to apply the changes.
    

              ![](https://support.icompaas.com/assets/kb/c52f8001707fb964.png)

##### Using Google Cloud CLI:

Remove the public IP from each instance and assign a private IP:

gcloud sql instances patch <INSTANCE\_NAME> --network=<VPC\_NETWORK\_NAME> --no-assign-ip

Verify the changes:

gcloud sql instances describe <INSTANCE\_NAME>

Prevention:

To prevent new Cloud SQL instances from being configured with public IPs, enable the Restrict Public IP Access on Cloud SQL Instances organization policy:[Restrict Public IP Access Policy](https://console.cloud.google.com/iam-admin/orgpolicies/sql-restrictPublicIp).

## Backout Plan:

Step 1: Revert Configuration

If removing public IP access causes service disruption, re-enable it using:

gcloud sql instances patch <INSTANCE\_NAME> --assign-ip

Alternatively, use Cloud SQL Console to re-enable public IP access.

Step 2: Notify Stakeholders

-   If rollback is required, inform developers and database administrators about temporary access adjustments.

Step 3: Restore from Backup (If Necessary)

-   If access configuration issues persist, restore the SQL instance from a previously taken snapshot or backup.  
    

Step 4: Validate Rollback Success

-   Run the audit steps again to confirm that public IP access has been restored.
    
-   Ensure that applications function normally with the restored public IP.

References:

1.  [Configuring Private IP for Cloud SQL](https://cloud.google.com/sql/docs/mysql/configure-private-ip)
    
2.  [Using Private IP for Cloud SQ](https://cloud.google.com/sql/docs/mysql/private-ip)
    
3.  [Restrict Public IP Access Policy](https://console.cloud.google.com/iam-admin/orgpolicies/sql-restrictPublicIp)
    

Additional Information:

-   Replicas automatically inherit the private IP status from their primary instance. Private IPs cannot be directly configured on replicas.
    
-   Public IP addresses cannot be assigned to first-generation Cloud SQL instances.
    

CIS Controls

<table style="border:none;border-collapse:collapse;font-family:&quot;Helvetica Neue&quot;"><tbody style="font-family:&quot;Helvetica Neue&quot;"><tr style="height:40pt;font-family:&quot;Helvetica Neue&quot;"><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;text-align:justify;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:700;font-family:&quot;Helvetica Neue&quot;">Control</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;text-align:justify;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:700;font-family:&quot;Helvetica Neue&quot;">Description</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;text-align:justify;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:700;font-family:&quot;Helvetica Neue&quot;">IG 1</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;text-align:justify;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:700;font-family:&quot;Helvetica Neue&quot;">IG 2</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;text-align:justify;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:700;font-family:&quot;Helvetica Neue&quot;">IG 3</span></span></span></p></td></tr><tr style="height:54.25pt;font-family:&quot;Helvetica Neue&quot;"><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:left;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-family:&quot;Helvetica Neue&quot;">3.3 Configure Data Access Control Lists</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:left;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">Apply data access controls, restricting connections to only authorized users or networks.</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td></tr><tr style="height:54.25pt;font-family:&quot;Helvetica Neue&quot;"><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:left;font-size:14px"><span style="font-size:14px"><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-family:&quot;Helvetica Neue&quot;">14.6 Protect Information Through Access Control Lists</span></span></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:left;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">Use access control lists to ensure only authorized users have access based on their responsibilities.</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td><td style="padding:5pt;overflow:hidden;overflow-wrap:break-word;font-family:&quot;Helvetica Neue&quot;;font-size:14px"><p dir="ltr" style="line-height:1.38;margin-bottom:0pt;font-family:&quot;Helvetica Neue&quot;;text-align:justify;font-size:14px"><span style="font-size:14px"><strong><span style="font-family:Helvetica Neue"><span style="color:rgb(0, 0, 0);font-weight:400;font-family:&quot;Helvetica Neue&quot;">✅</span></span></strong></span></p></td></tr></tbody></table>

## Related compliance guidance

- [SOC 2 compliance: a practical implementation guide for cloud-native SaaS teams](https://support.icompaas.com/compliance/soc-2-trust-services-criteria): Configuration checks like this one are the technical half of a SOC 2 / ISO 27001 programme — the guide shows where they fit, what else an auditor expects, and how to evidence them.
- [ISO/IEC 27001:2022 compliance: a practical implementation guide](https://support.icompaas.com/compliance/iso-27001-2022): ISO 27001 Annex A.8 (technological controls) is where cloud hardening evidence lands; the guide shows how to run the ISMS around it.
