DB Browser for SQLite

DB Browser for SQLite (DB4S) is an open source visual tool for creating, searching, and editing SQLite or SQLCipher database files. It provides a spreadsheet-like interface for working with database records alongside a full SQL query facility, addressing the need to inspect and modify database contents without relying solely on command-line tools. It runs on Windows, macOS, and most versions of Linux and Unix.

The application includes controls and wizards for creating and compacting database files; creating, modifying, and deleting tables and indexes; browsing, editing, adding, and deleting records; sorting and searching records; importing and exporting records as text; importing and exporting tables from and to CSV files; importing and exporting databases from and to SQL dump files; issuing SQL queries and inspecting results; examining a log of SQL commands issued by the application; plotting simple graphs based on table or query data; and adding, changing, or removing SQLCipher encryption from database files. It also supports SQLite extensions.

DB Browser for SQLite is intended for people working with SQLite or SQLCipher database files who need both a visual interface and direct SQL access. The project is open source and released into the public domain. The current official released version is 3.13.0, with nightly builds also available. Documentation is provided on the project wiki.