Back to the changelog
v0.19.1
1 min readRemote SQLite databases over SSH
Open a SQLite file that lives on your server, picked in the remote explorer, and browse or query it without downloading it.
Database
SQLite
SQLite joins MySQL, MariaDB and PostgreSQL in the database client.
Opened in place
Queries run on the server through the SSH session; only results travel back.
Picked in the explorer
Select the .sqlite or .db file right from the server explorer when adding the database.
Read-only mode
Protect a production database: browsing and SELECT work, writes are refused.
Requirements
SSH access and Python 3 with the sqlite3 module on the server.
Read more: Open a remote SQLite database over SSH.