Cloud SQL Proxy Connection Helper
A media-monitoring / data-orchestration platform
Overview
A small developer-experience utility: a shell helper that starts a Google Cloud SQL Proxy to the platform’s staging database so engineers can connect locally with environment-overridable settings.
Why It Exists
Working against a managed Cloud SQL instance requires a proxy with the correct project, instance, region, and port. This script standardizes that connection so any developer can spin up the proxy consistently rather than memorizing connection names.
What We Built
A single, well-parameterized Bash script (hits-station-staging-proxy.sh) targeting the hits-station Cloud SQL instance in the staging project. All settings, project, instance, region, local port, are overridable via environment variables with sensible defaults, and the script echoes the resolved connection details before launching the proxy.
Technologies & Approach
Plain Bash with set -euo pipefail and Google Cloud SQL Proxy. Intentionally minimal and dependency-free for fast onboarding.
Outcome / Impact
A reliable, repeatable way to reach the staging database during local development of the API and data layers.
Capabilities Demonstrated
- Practical developer tooling for cloud database access
- Clean, override-friendly shell scripting
- Consistent local-to-cloud connectivity for the team