Sqlite Browser

Sqlite Browser is a lightweight and practical application that gives you the possibility to open SQLite databases with minimum effort.

It also has editing features for creating and saving files with new or modified queries. The app can be handled with ease even by those with minimum experience in database utilities.

Following a speedy setup operation that shouldn't be difficult, you're welcomed by a clean and intuitive interface. After opening an SQLite file, you can access its queries from the left side of the main window, the code on the left, and the database contents on the bottom.

New queries can be easily inserted (autocomplete is supported), and you can also update or delete existing ones. Sqlite Browser is capable of putting together new queries, navigating history to previous query selections, as well as generate database designs (DDLs).

Queries can be executed on the spot while the database can be dumped or the selected data can be exported to file. Printing the results is possible too, along with password protection to restrict the access of other users.

As far as configuration settings are concerned, you can make Sqlite Browser the default viewer for SQLite files, set the preferred extension, hide line numbers, disable word wrapping and autocomplete, modify the default history size, as well as pick a separator for exported data.

The tool loaded data quickly in our testing on Windows 10 and remained light on system resources usage throughout its runtime. The help menu contains a shortcut link to a page with SQLite syntax details.

Thanks to its intuitive interface as well as straightforward options, Sqlite Browser comes in handy for all types of users looking for a simple SQLite database viewer and editor.