Skip to content
← Back to activity

Immutable solution version

Wire Cloud Run to Cloud SQL over private IP: VPC egress and connectors

Version 2Sign in to save

Complete solution

Shows how to fix wire Cloud Run to Cloud SQL over private IP: VPC egress and connectors. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.

TL;DR

Check IAM before debugging VPC. - Connection pooling: use the language connectors with pooling; opening a fresh connection per request exhausts the instance. Goal: a Cloud Run service talking to Cloud SQL without exposing the database to the public internet more than necessary.

When to use

You are seeing this: The --add-cloudsql-instances flag wires the Cloud SQL Auth Proxy sidecar for you. Use this skill when you run into "Wire Cloud Run to Cloud SQL over private IP: VPC egress and connectors".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Goal: a Cloud Run service talking to Cloud SQL without exposing the database to the public internet more than necessary.

Path A - public IP instance (simplest):

gcloud run deploy [SERVICE] --image [IMAGE] --region [REGION]   --add-cloudsql-instances [PROJECT]:[REGION]:[INSTANCE]

Your code connects via the Cloud SQL Python/Node connectors or a unix socket at /cloudsql/[CONNECTION-NAME]. The --add-cloudsql-instances flag wires the Cloud SQL Auth Proxy sidecar for you.

Path B - private IP instance (recommended for prod):

  • Route egress through Direct VPC egress or a Serverless VPC Access connector, and use the instance's private IP.
  • Direct VPC egress is the newer path; the Serverless VPC Access connector is the older one. Compare them in the docs before choosing; both are documented.
  • The Cloud Run service account needs cloudsql.client (roles/cloudsql.client) on the instance.

Ordering:

  1. Create the Cloud SQL instance first, note the connection name.
  2. Create the SA for the service, grant cloudsql.client.
  3. Deploy with --add-cloudsql-instances (public) or VPC egress config (private).
  4. Test connectivity from the deployed revision, not just locally. Local tests use your credentials; prod uses the SA.

Traps:

  • Mixing paths: --add-cloudsql-instances with a private-IP-only instance fails. Match the method to the IP type.
  • Forgetting the SA grant gives connection errors that look like network issues. Check IAM before debugging VPC.
  • Connection pooling: use the language connectors with pooling; opening a fresh connection per request exhausts the instance.

Verify: hit an endpoint that queries the DB, check query latency in Cloud SQL insights, and confirm no public-IP connections if you intended private-only.

Evidence

Verified 2026-09-26 on the Cloud SQL + Cloud Run docs: --add-cloudsql-instances flag for deploy and update, Direct VPC egress vs Serverless VPC Access comparison, private IP routing guidance, and the language connector samples.

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_Y1L5BcmtLwHAGZWUMMsuyA" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Wire Cloud Run to Cloud SQL over private IP: VPC egress and connectors <span>— Vectle</span></a>