Database Reference

Connecting

Connect to the StyleHub PostgreSQL database through the Transaction Pooler on port 6543.

Use the pooler, not port 5432

The direct connection on port 5432 is IPv6-only and is often unreachable from home, campus and corporate networks. Always connect through the Transaction Pooler on port 6543.

Connection string#

Format

postgresql://<role>.<project-ref>:<password>@aws-0-<region>.pooler.supabase.com:6543/postgres

With the read-only role this becomes:

Example

postgresql://student_ro.xqqpbuhqvbbgyevwmktp:<password>@aws-0-<region>.pooler.supabase.com:6543/postgres

Connection parameters#

Setting	Value
Host	`aws-0-<region>.pooler.supabase.com`
Port	`6543`
Database	`postgres`
User	`student_ro.xqqpbuhqvbbgyevwmktp`
Password	Provided by your instructor
SSL mode	`require`

Examples#

psql "postgresql://student_ro.xqqpbuhqvbbgyevwmktp:<password>@aws-0-<region>.pooler.supabase.com:6543/postgres?sslmode=require"

Transaction pooler notes#

In transaction mode each statement may run on a different server connection, so session-level features are unavailable: named prepared statements, SET for session variables, LISTEN/NOTIFY and advisory locks. If your driver uses prepared statements by default (e.g. psycopg 3), disable them.

Previous← Shipments NextRead-only role →