A friendly, read-only database viewer for SQLite, DuckDB, and Parquet files.
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 and views. Row counts at a glance.
Open SQLite, DuckDB, and Parquet files. Format detected automatically by extension.
Scroll through large tables 50 rows at a time — reaching an edge turns the page for you.
Click a header or press s on the cursor's column. Exports follow the order you chose.
Column names, types, primary keys and nullability, a keystroke away and out of the way when you don't need them.
Write and run SQL. Opens when you want it, results are scrollable and resizable, and exportable.
Export a whole table in the order you're viewing it, or export a query's results. Choose where it goes.
Dark, Light, and Retro 3.1. Switch from the status bar or with a 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 |
| Focus the table list | Tab | Tab | Tab | Tab |
| Leave the list for the grid | Enter | Enter | Enter | Enter |
| Move up / down | ↑ ↓ or k j | |||
| First / last row | g G | |||
| Data | ||||
| Move column cursor | ← → or h l | |||
| Pan sideways | H L or ⇧ + arrows | |||
| Sort column | s or click header | s | ||
| Half screen up / down | Ctrl + U Ctrl + D | |||
| Prev / next page | [ ], PgUp PgDn, or scroll to an edge | [ ] or PgUp PgDn | ||
| Column details | c | — | ||
| Query | ||||
| Open the query panel | / or : | |||
| Run query | Enter | |||
| New line in a query | ⇧ + Enter | — | ||
| Clear query and results | Clear button | Ctrl + U | ||
| Resize results | drag the divider | + - | ||
| Close the query panel | Esc | Esc | ||
| Other | ||||
| Export to CSV | ⌘ + E | Ctrl + E | Ctrl + E | Ctrl + E |
| Database details | i | |||
| Keyboard shortcuts | ? | |||
| Cycle theme | ⌘ + T | Ctrl + T | Ctrl + T | — |
| Quit | ⌘ + Q | Ctrl + Q | — | q |