Google Cloud SQL for PostgreSQL + CHION

Text-to-SQL for Google Cloud SQL PostgreSQL

Connect your Google Cloud SQL for PostgreSQL instance to Chion and ask questions in plain English. Chion generates verified SQL, executes it read-only against your Cloud SQL public IP, and renders interactive charts. No Cloud SQL Auth Proxy required for initial setup — direct IP with SSL works.

Example question & SQL

See what Chion generates from a plain-English question.

You ask

"Average order value by product category last month"

Chion generates

SELECT
  p.category,
  AVG(oi.unit_price * oi.quantity) AS avg_order_value
FROM order_items oi
JOIN products p ON p.id = oi.product_id
JOIN orders o ON o.id = oi.order_id
WHERE o.created_at >= date_trunc('month', now()) - interval '1 month'
  AND o.created_at < date_trunc('month', now())
GROUP BY p.category
ORDER BY avg_order_value DESC;

Finding your Google Cloud SQL for PostgreSQL credentials

GCP Console → SQL → [your instance] → Overview page

Field	Where to Find	Default
Server (Host)	Overview → Connect to this instance → Public/Private IP	IP address (e.g., 34.x.x.x)
Port	Not prominently displayed — always default	5432
Database	Databases tab in left sidebar	postgres
Schema	Not in console — default is public	public
User	Users tab in left sidebar	postgres
Password	Users tab → three-dot menu → Change password	Set at creation or via Users tab

Quick steps

1.Log in at console.cloud.google.com
2.Navigate to SQL from the left sidebar
3.Click your PostgreSQL instance name
4.Overview page → under "Connect to this instance," copy the Public IP address
5.Click Databases in the left sidebar to see available databases
6.Click Users to see usernames — use the three-dot menu to change/reset a password
7.Port is always 5432

Google recommends using the Cloud SQL Auth Proxy for production connections. For Chion, direct IP + SSL works for initial setup.

Open Google Cloud SQL for PostgreSQL console

Google Cloud SQL for PostgreSQL troubleshooting

Common issues and how to fix them.

Connection refused — no authorized network

In the GCP Console, go to your Cloud SQL instance → Connections → Networking → add an authorized network with the Chion IP range. For initial testing, add 0.0.0.0/0 (remove after verifying).

Cannot find Public IP

On the instance Overview page, look for "Connect to this instance" → Public IP address. If only Private IP is shown, you need to enable a public IP under Connections → Networking.

Password reset

Go to Users tab → click the three-dot menu next to your user → Change password. The change is immediate.

Your credentials are encrypted

All connection credentials are encrypted with AES-256-GCM and stored in an isolated vault. Chion connects with read-only permissions — no INSERT, UPDATE, or DELETE is ever possible. Row-level security policies are honored on every query.

Read our security model

Frequently asked questions

Common questions about using Chion with Google Cloud SQL for PostgreSQL.

Do I need the Cloud SQL Auth Proxy?

No. Chion connects via direct IP with SSL (sslmode=require). The Auth Proxy is optional and recommended by Google for production workloads, but direct IP works for Chion.

Does Chion support Cloud SQL Private IP?

Chion connects over the public internet. If your instance only has a private IP, enable a public IP or set up a Cloud NAT / VPN peering arrangement.

Which Cloud SQL tiers does Chion work with?

All tiers — shared-core, lightweight, standard, and high-memory. Chion's read-only queries are lightweight and work within any tier's connection limits.

Ready to connect your Google Cloud SQL for PostgreSQL database?

Open Chion, enter your credentials, and start asking questions in plain English.

Start your trial