A friendly, read-only SQLite database viewer for data analysis.
macOS: If you see "app is damaged", open Terminal and run:
xattr -cr /Applications/DBiewLite.app
DBiewLite is also available as a standalone terminal app — same table browsing, queries, and export, right in your shell.
cargo install dbiewlite-tui
Or download pre-built binaries from the latest release.
Sidebar with all tables, views, and indexes. Row counts at a glance.
Scroll through large tables with fast pagination. 50 rows per page, instant navigation.
Click any column header to sort ascending or descending. Works on all data types.
See column names, types, primary keys, and nullability at the top of every table view.
Write and run arbitrary SQL queries. Results appear in a scrollable grid below.
Export any table to a CSV file with one click. Full table export, not just the current page.
Dark, Light, Retro 3.1, and TUI. Switch instantly with the theme button or keyboard shortcut.
Full keyboard navigation in both GUI and TUI. Open, browse, query, and export without touching the mouse.
Same features in your terminal. Vim-style navigation, runs anywhere with a shell.
Try it in your browser — no install needed. SQLite runs client-side via WASM.
Your data is safe. DBiewLite never modifies your database files.
Built with Rust and Tauri. Small binary, low memory, instant startup.
| Action | GUI (Mac) | GUI (Win/Linux) | Web | TUI |
|---|---|---|---|---|
| Navigation | ||||
| Open database | ⌘+O | Ctrl+O | Ctrl+O | CLI arg |
| Toggle sidebar | ⌘+B | Ctrl+B | Ctrl+B | Ctrl+B |
| Switch panel | Click | Tab | ||
| Move up | — | ↑ / k | ||
| Move down | — | ↓ / j | ||
| Select table | Click | Enter | ||
| Data | ||||
| Sort column | Click header | 1–9 | ||
| Previous page | Click ◀ | ← / h | ||
| Next page | Click ▶ | → / l | ||
| Query | ||||
| Enter query mode | Click textarea | / or : | ||
| Run query | ⌘+Enter | Ctrl+Enter | Ctrl+Enter | Enter |
| Exit query mode | — | Esc / Tab | ||
| Other | ||||
| Export to CSV | ⌘+E | Ctrl+E | Ctrl+E | Ctrl+E |
| Cycle theme | ⌘+T | Ctrl+T | Ctrl+T | — |
| Quit | — | q | ||