DB Browser for SQLite

DB Browser for SQLite is a Qt desktop front end for SQLite database files. The window is organised as tabs: one for the database structure, one for browsing data, one for pragmas and one for running SQL. Tables, columns, types, constraints and indexes are created and altered through dialogs, and the corresponding DDL is shown for every object.

The browse tab presents a table as an editable grid with per-column filtering and a side panel for the current cell, which can display text, a number, binary content or an image. Query results from the SQL tab appear in the same kind of grid. Data moves in and out as CSV per table, and a whole database can be exported as a SQL dump or built from one.

Edits are held in a transaction rather than written immediately. Changes accumulate until Write Changes commits them, and Revert Changes throws away everything since the last commit, which makes exploratory editing recoverable. Builds compiled against SQLCipher can open encrypted database files once the passphrase is supplied.