Your first connection
A connection is a server and the way to reach it. You make it once, and it waits in the tree for a double-click.
1 Open the form
In a window with no connections yet, press Make one here. Otherwise press + above the object tree and choose New connection, or press Ctrl+Shift+C (⌘⇧C on a Mac) for the Connections window, where + starts a new one.
2 Choose the kind
A new connection starts as PostgreSQL. The Database kind cards hold all sixteen, and the fields below them ask only for what the chosen kind needs: SQLite and DuckDB want a Database file, ODBC a DSN or connection string, every other kind a host and a port. Kinds of connection says what each one asks.
3 Fill the fields
127.0.0.1 to begin with.NoteLeave the password empty and nothing is stored: when the server asks for one, the window asks you as you connect, with Remember this password unticked.
4 Choose the encryption
Not encrypted: statements and rows cross the network as they are.
Encrypted, but the server’s certificate is not checked.
Encrypted, and the server’s certificate is checked, host name included.
With Encrypt and verify, the CA file box says which authority signed the server’s certificate. Leave it empty to trust the authorities this computer trusts. SQLite and DuckDB have nothing to encrypt, and over ODBC the driver decides.
CautionEncrypt without verify protects against a listener, not against a server pretending to be yours.
5 Test, save, connect
Test connection reaches the server with what the form holds, and only that: it never reads a stored password. It answers The connection can be opened. Nothing has been saved yet., or what the server said instead.
Save puts the connection in the tree. A double-click on it, or Enter, connects; its right-click menu has Connect, Edit connection… and Delete.
To reach the server through another machine, see SSH jump hosts; to keep a database from being changed by accident, Production and read-only.