Docs

GCP Cloud SQL

Connect dbaBrain to Google Cloud SQL for PostgreSQL.

Connection Methods

Cloud SQL supports two connection methods:

  • -Public IP - direct connection over the internet (requires authorized network)
  • -Cloud SQL Auth Proxy - secure tunnel without exposing a public IP

Using Public IP

Add dbaBrain IP ranges to your Cloud SQL instance's authorized networks in the GCP Console under SQL > Instance > Connections > Networking.

Create a monitoring user

sql
CREATE USER dbabrain_monitor WITH PASSWORD 'your-secure-password';
GRANT pg_monitor TO dbabrain_monitor;
GRANT USAGE ON SCHEMA public TO dbabrain_monitor;

Connect in dbaBrain

text
Host: your-instance-ip (from Cloud SQL overview page)
Port: 5432
Database: your_database
Username: dbabrain_monitor
Password: your-secure-password
SSL Mode: require

GCP Monitoring Integration (Optional)

For Cloud SQL-specific metrics (CPU, memory, connections, disk), provide a GCP service account JSON key with cloudsql.instances.get and monitoring.timeSeries.list permissions. Configure in dbaBrain Settings > Integrations.