Connect a database
How do I connect a Postgres database to Squeezle?
Add your database as a connection so your team can run queries against it. You need the Manage data sources capability, which owners and admins have.
- In the left rail, open Admin, then choose Connections.
- Click New connection in the top right.
- Fill in a Name, and pick a Colour to tell connections apart at a glance.
- Enter the Hostname, Port (Postgres uses
5432by default), Database, and Default schema (usuallypublic). - Enter the Username and Password for a Postgres role. Use a read-only, least-privilege role where you can.
- Choose an SSL mode. Pick
requireor stricter for any database reached over the public internet. - Click Test connection. On success you see a line like
Connected · PostgreSQL 14 · user@db. - Click Save.
Your teammates can now write and run queries against this connection.
For the full walkthrough, including connection health and refreshing the cached schema, see the Connections guide.