← All docs

Google Cloud SQL

Cloud SQL provides fully managed PostgreSQL instances on Google Cloud.

Connection

Use Cloud SQL Auth Proxy or direct IP connection. Enable the Cloud SQL Admin API.

Setup

# Using Cloud SQL Proxy
cloud-sql-proxy myproject:us-central1:mydb &

# Then connect via localhost
migrationpilot analyze migration.sql \
  --database-url "postgresql://user:pass@localhost:5432/mydb"

# Or use direct IP
migrationpilot analyze migration.sql \
  --database-url "postgresql://user:pass@34.123.45.67/mydb"

Tips

  • •Cloud SQL supports all PostgreSQL versions from 12 to 16
  • •Use database flags to set statement_timeout at the instance level
  • •High availability instances use synchronous replication — DDL operations may be slower
  • •Use Cloud SQL Insights to identify table access patterns
← All docsConfiguration guide