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.

  1. In the left rail, open Admin, then choose Connections.
  2. Click New connection in the top right.
  3. Fill in a Name, and pick a Colour to tell connections apart at a glance.
  4. Enter the Hostname, Port (Postgres uses 5432 by default), Database, and Default schema (usually public).
  5. Enter the Username and Password for a Postgres role. Use a read-only, least-privilege role where you can.
  6. Choose an SSL mode. Pick require or stricter for any database reached over the public internet.
  7. Click Test connection. On success you see a line like Connected · PostgreSQL 14 · user@db.
  8. 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.