Connect your PostgreSQL database

Chion needs six fields to connect: Server, Port, Database, Schema, User, and Password. Below are step-by-step instructions for each provider.

What you need

Find your credentials

Select your PostgreSQL provider for step-by-step instructions.

Amazon RDS for PostgreSQL

AWS Console → RDS → Databases → [your instance] → Connectivity & security

Field	Where to Find	Default
Server (Endpoint)	Connectivity & security tab → Endpoint	<instance>.<id>.<region>.rds.amazonaws.com
Port	Same tab, next to Endpoint	5432
Database	Configuration tab → DB name	postgres (or what you set at creation)
Schema	Not in console — default is public	public
User	Configuration tab → Master username	postgres (or what you set)
Password	Set at instance creation. Modify → change Master password to reset	(not retrievable)

Quick steps

1. 1.Log in at console.aws.amazon.com/rds
2. 2.Click Databases in the left sidebar
3. 3.Click your PostgreSQL instance name
4. 4.Connectivity & security tab → copy the Endpoint and Port
5. 5.Configuration tab → note the DB name and Master username
6. 6.Password is what you entered during creation (use Modify to reset if needed)

Open Amazon RDS for PostgreSQL console

Azure Database for PostgreSQL

Azure Portal → your PostgreSQL server → Overview page

Field	Where to Find	Default
Server (Host)	Overview page → Server name	<server>.postgres.database.azure.com
Port	Overview or Connection strings page	5432
Database	Created by default. Check via Connection strings or psql	postgres
Schema	Not in portal — default is public	public
User	Overview page → Admin username	What you set at creation
Password	Set at creation. Reset via Settings → Reset password	(not retrievable)

Quick steps

1. 1.Log in at portal.azure.com
2. 2.Search for "Azure Database for PostgreSQL servers"
3. 3.Click your server name
4. 4.On the Overview page: copy the Server name (this is your host) and note the Admin username
5. 5.Click Connection strings in the left sidebar for pre-built connection strings
6. 6.Password is what you set during creation — reset via Settings → Reset password if needed

Azure Flexible Server uses port 5432 for direct connections and 6432 for the built-in PgBouncer pooler.

Open Azure Database for PostgreSQL console

Google Cloud SQL for PostgreSQL

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

Neon

Project Dashboard → Connect button

Field	Where to Find	Default
Server (Host)	Connect modal → displayed in connection string	ep-<name>-<id>.us-east-2.aws.neon.tech
Port	Connect modal	5432
Database	Connect modal — selectable dropdown	neondb
Schema	Not in UI — default is public	public
User (Role)	Connect modal — selectable dropdown	neondb_owner
Password	Shown in the connection string in the Connect modal	(always visible in modal)

Quick steps

1. 1.Log in at console.neon.tech
2. 2.Select your project
3. 3.Click the Connect button on the Project Dashboard
4. 4.The "Connect to your database" modal opens
5. 5.Select your Branch, Compute, Database, and Role from dropdowns
6. 6.All connection parameters including password are displayed in the connection string
7. 7.Toggle Connection pooling on/off to switch between pooled and direct connections

Password is always visible in the Connect modal — no need to reset.

Open Neon console

Supabase

Project Dashboard → Connect button (top of page)

Field	Where to Find	Default
Server (Host)	Connect → View parameters under "Direct connection"	db.<project-ref>.supabase.co
Port	Same panel — Direct: 5432, Transaction pooler: 6543	5432
Database	Same panel	postgres
Schema	Not shown in UI — default is public	public
User	Same panel	postgres
Password	Set at project creation. Reset in Settings → Database	(not displayed after creation)

Quick steps

1. 1.Log in at supabase.com/dashboard
2. 2.Select your project
3. 3.Click the Connect button at the top of the page
4. 4.Click "View parameters" under the Direct connection string
5. 5.All fields (host, port, database, user) are displayed individually
6. 6.Password must be the one you set at project creation (or reset it in Settings → Database)

Open Supabase console

Universal defaults

Schema discovery query

Once connected, run this to list all available schemas:

SELECT schema_name 
FROM information_schema.schemata 
WHERE schema_name NOT IN ('pg_catalog', 'information_schema', 'pg_toast')
ORDER BY schema_name;