SqUIte (pronounced like SQLite but without the 'L') is a small desktop application built to be a quick and dirty UI to visualize SQLite data.

It is built on top of rusqlite and egui.

Install with Cargo:

cargo install squite

Or download the app (for MacOS and Ubuntu/Debian, AMD64 only) from the website.

If you installed with Cargo, you can run with:

squite

Otherwise you can simply double-click on the app icon.

The app will open to a window like this:

You can then run SQL SELECT statements on file-based SQLite databases, and obtain a table of results:

Or you can run statements that modify data (such ass INSERT, UPDATE or DELETE), and get the number of affected rows:

Note that statements that modify data require you to check the "This query modifies data" checkbox, to acknowledge that you are performing a potentially destructive or irreversible operation. If the checkbox is left unchecked, the operation will be rejected.

Take a look at the contributing guidelines to get started with your first contribution!

This project is provided under MIT license.