Open a SQLite database file and work on it in three panels: a data grid for browsing and editing rows, a schema inspector, and a SQL editor. The editor reads .db, .sqlite, and .sqlite3 files and exports the changed database when you are done.
Table browsing
The sidebar lists every user table and view with its row count. Clicking a name loads its rows immediately; a filter box narrows long lists, and Ctrl+K jumps to it.
Large tables page instead of truncating: pick 50 to 1000 rows per page and step through with Prev and Next. Clicking a column header sorts by that column with ORDER BY, so the sort covers the entire table, not only the visible page. Headers also show each column’s declared type.
Cell editing
Click a cell to edit it in place. Enter or clicking away keeps the change as a pending edit, marked in the category tint; Escape cancels. Typing NULL stores a SQL NULL, and numeric columns keep their numeric type when the text parses as a number. BLOB cells display their byte size and stay read-only.
Add draft rows or mark existing rows for deletion, then press Apply (or Ctrl+S) to write all pending changes in one transaction. If any statement fails, the transaction rolls back and nothing is written. Revert discards the pending edits without touching the database.
Views, WITHOUT ROWID tables, and virtual tables open read-only because row edits address rows by SQLite’s rowid.
SQL editor
The SQL panel runs full SQLite syntax with highlighting, bracket matching, and autocomplete for the loaded database’s table and column names. Press Ctrl+Enter to execute. Results display as a grid or as aligned text, with one tab per result set when a script returns several.
Statements that change data or schema refresh the sidebar counts and the data grid. DROP and DELETE without a WHERE clause ask for confirmation first. Every executed query lands in the history panel (Ctrl+Shift+H) with its execution time and row count.
Schema inspector
The schema panel shows each column’s declared type, nullability, default value, and primary-key position, plus the table’s indexes, foreign keys, triggers, and original CREATE statement.
Exports
Download the edited database as a .sqlite file, export the current page or any query result as CSV or JSON, or generate a full SQL dump with CREATE TABLE and INSERT statements. Single rows copy as INSERT statements from the grid.
Keyboard shortcuts
| Shortcut | Action |
|---|---|
| Ctrl+Enter | Run query |
| Ctrl+S | Apply pending edits |
| Ctrl+K | Focus the object filter |
| Ctrl+Shift+H | Toggle query history |