SQLite Studio

Single binary, single command SQLite database explorer.

sqlite-studio <sqlite_db>

Features

• Overview page with common metadata.
• Tables page with each table's metadata, including the disk size being used by each table.
• Infinite scroll rows view.
• A custom query page that gives you more access to your db.

More features available on the releases page.

Screenshots

Home Page

Tables Page

Query Page

How To Run It

Pre-Built Binaries

You can find pre-built binaries for the following targets on the releases page.

• Linux sqlite-studio_<release>_x86_64-unknown-linux-musl.zip
• Windows sqlite-studio_<release>_x86_64-pc-windows-gnu.zip
• MacOS x86 sqlite-studio_<release>_x86_64-apple-darwin.zip

After downloading the ZIP archive, you can extract it and get the binary.

Nix

If you are using Nix, to build it from source.

nix shell github:frectonz/sqlite-studio
sqlite-studio <sqlite_db>

Contributing

Before executing cargo run you need to build the UI because the rust app statically embedded the UI files in the binary.

git clone git@github.com:frectonz/sqlite-studio.git
cd sqlite-studio
nix develop # if you use nix
cd ui
npm install
npm run build
cd ..
cargo run <sqlite_db>