DB Browser for SQLite3.13.1

Open SQLite database files in a browser-style workspace, inspect their contents, and make changes without resorting to a general-purpose database application. DB Browser for SQLite combines a familiar spreadsheet-like data view with a full SQL query interface, so users can work visually or run precise commands against SQLite and SQLCipher files. It suits developers, testers, analysts, and anyone examining an application database during debugging, data cleanup, prototyping, or routine maintenance.

Controls and guided wizards let you create or compact database files, define, alter, and remove tables, and create or delete indexes. Records can be browsed, added, edited, deleted, sorted, and searched directly in the grid. SQL queries can be executed with their results inspected, while the application’s complete command log helps users review the operations performed.

The program transfers records as text, moves tables to and from CSV files, and imports or exports whole databases through SQL dump files. It can produce simple graphs from table or query data and add, change, or remove SQLCipher encryption on database files. As an open-source project, it exposes the full capabilities of the underlying SQLite engine through a visual interface.

The macOS release is version 3.13.1, offered as freeware for Intel and Apple Silicon Macs in the Developer Tools category. DB Browser for SQLite also runs on Windows and most Linux and Unix versions, with documentation maintained in its wiki.