Connect to SQLite

Choose a local file, Turso/libSQL or a server over SSH, then configure the SQLite source and read-only behavior.

SQLite over SSH has been requested in other tools since 2023, with 45 votes.

The connection form is titled SQLite connection. Its first choice is where the database is, with three source options: File on this computer, Turso / libSQL and Server over SSH.

Local file

  1. Choose File on this computer.
  2. Fill in database file or use browse….
  3. Confirm that the file already exists.
  4. Optionally open Advanced to configure file behavior.

The form deliberately has no host, port, user or password for a local file. The path is the database identity. read-only opens the file read-only, so neither this connection nor operations through it can write.

Turso / libSQL

Choose Turso / libSQL, then enter address and token. The token stays in the system vault, never in the connections file. The form can also enable Reach the server through an SSH tunnel when the service is reachable only inside the server network.

Server over SSH

Choose Server over SSH, fill in database file on the server, and configure SSH server. The shared tunnel fields include SSH host, SSH port, SSH user, authentication, SSH password, private key path, key passphrase and optional jump host / bastion.

Each remote action starts sqlite3 on the server, reads or writes, then exits. No file is copied and no port is opened. Read-only opens the remote file with -readonly.

Use Ctrl+S for staged edits. The connection’s test connection action checks the selected source before saving.