Browse and edit SQLite data
Browse SQLite tables, inspect typed cells, tune session pragmas and stage row-token-checked edits.
SQLite over SSH has been requested in other tools since 2023, with 45 votes.
SQLite opens as a file-backed table surface. The sidebar lists the relations in the selected source, and the grid keeps SQLite’s storage class visible when a value is edited.
Browse the file
- Open a table from the sidebar.
- Use the filter bar and pagination to find the row.
- Inspect a value with Shift+Enter.
- Edit only the cells that should change.
SQLite can store INTEGER, REAL, TEXT, BLOB and NULL values in the same relation. Tablyne carries the chosen storage class through the write path, so changing "42" as text is not silently treated as changing 42 as an integer.
Advanced session settings
The Advanced section contains wait if the file is locked (ms), check foreign keys, journal mode and disk sync. The foreign-key choices are default (on), on and off. The journal-mode selector includes keep the file’s as its default.
The session hint is explicit: the wait applies only to this Tablyne connection and the file is not changed. Journal mode is different. Changing it changes the file, creates -wal and -shm files for WAL, and does not work on a network folder.
Stage and inspect
A grid edit remains staged until Ctrl+S saves pending changes. Ctrl+Z and Ctrl+Y undo and redo. The row token is captured from the raw SQLite values, including their storage class, so a change that is invisible in a formatted cell can still be detected.
Use the row inspector and the query console when a cell needs context. For remote sources, the current form reports that there is no manual transaction in the console, no export to file and no File panel.