aibangjuxin/knowledge/cloud-sql-psc-ports

Claude Code and agent skill by aibangjuxin/knowledge

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Cloud SQL PSC port mapping — MySQL vs PostgreSQL, direct connection vs Auth Proxy. Captures that Auth Proxy for PostgreSQL uses port 3307, not 5432.

Install

npx vskill@latest install aibangjuxin/knowledge/cloud-sql-psc-ports

SKILL.md

Cloud SQL PSC Port Reference

Overview

Domain knowledge about Cloud SQL Private Service Connect (PSC) port mapping for MySQL and PostgreSQL. Captures the non-obvious insight that Cloud SQL Auth Proxy uses different ports than the database default.

MySQL PSC Ports

PortPurpose
3306Direct connection / Managed Connection Pooling
3307Cloud SQL Auth Proxy

PostgreSQL PSC Ports

PortPurpose
5432Direct connection
6432PgBouncer (Managed Connection Pooling)
3307Cloud SQL Auth Proxy (NOT 5432)

Key Insight

Auth Proxy for PostgreSQL uses port 3307 for outbound connections, not PostgreSQL's default 5432.

Traffic path:

Pod → Auth Proxy (local:5432) → PSC Endpoint (:3307) → Cloud SQL (:5432)

If NetworkPolicy only allows 5432, Auth Proxy outbound connections will be blocked even though the local proxy listens on 5432.

Sources

  • https://cloud.google.com/sql/docs/postgres/about-private-service-connect
  • https://cloud.google.com/sql/docs/mysql/about-private-service-connect

Trigger

Use when:

  • Designing PSC-based Cloud SQL connectivity from GKE
  • Debugging NetworkPolicy issues with Cloud SQL connections
  • Investigating why only opening the database port (e.g., 5432) doesn't work with Auth Proxy

Security

  • Security scanPassed, 100 of 100Pattern checks on the skill's files.
  • Model reviewPassed

See the full security report

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

See evaluation results

Source

Popularity

7-day trend score
5

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/aibangjuxin/knowledge/cloud-sql-psc-ports/badge)](https://verified-skill.com/skills/aibangjuxin/knowledge/cloud-sql-psc-ports)

Something wrong with this skill or its page? Tell us.