Single binary, single command SQLite database explorer. SQLite studio supports opening both local SQLite DB files, libSQL servers and PostgreSQL.
sqlite-studio sqlite [sqlite_db]sqlite-studio libsql [url] [auth_token]sqlite-studio postgres [url]- 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.
curl --proto '=https' --tlsv1.2 -LsSf https://github.com/frectonz/sqlite-studio/releases/download/0.1.8/sqlite-studio-installer.sh | shpowershell -c "irm https://github.com/frectonz/sqlite-studio/releases/download/0.1.8/sqlite-studio-installer.ps1 | iex"sqlite-studio-updatenix shell github:frectonz/sqlite-studioBefore 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>