Database Connection

How to connect to the SQL API

Connection Details

Setting	Value
Host	analytics-sql.seconddoor.app
Port	5432
SSL	Required
Credentials	Provided by the SDH team

Connecting

You can connect using psql or any PostgreSQL-compatible client, driver, or BI tool (e.g., Metabase, Tableau, Power BI, DBeaver).

psql "host=analytics-sql.seconddoor.app port=5432 sslmode=require user=YOUR_USER dbname=YOUR_DB"

Verify Your Connection

Run a quick query to confirm everything is working:

SELECT * FROM export_user LIMIT 5;

You should see a list of user accounts in your organization.