Skip to the content
mantichora_/docs

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

NameWhat the tree and the window call it. Yours to choose.
HostThe server’s address; 127.0.0.1 to begin with.
PortFilled with the kind’s own: 5432 for PostgreSQL, 3306 for MySQL, 1433 for SQL Server, and so on.
DatabaseThe database the session opens in. Redis takes a number here, and is the one kind that may leave it empty.
UserThe account the server knows you by.
PasswordGoes to the secret store, never to the application database.

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

Off

Not encrypted: statements and rows cross the network as they are.

Encrypt

Encrypted, but the server’s certificate is not checked.

Encrypt and verify

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.