Skip to content
IvapoPublic

About

A friendly, read-only SQLite/DuckDB/parquet files content viewer. Desktop GUI and TUI

Resources

Stars

1 star

Watchers

0 watching

Forks

Repository files navigation

DBiewLite

Website

A friendly, read-only database viewer for data analysis. Open SQLite, DuckDB, and Parquet files — browse tables, inspect schemas, run SQL queries, and export to CSV — in a desktop GUI, your terminal, or the browser.

Built with Tauri v2 + Rust + TypeScript.

Features

  • Open .sqlite / .db / .duckdb / .parquet files and browse tables with row counts
  • Paginated, sortable data grid with a cell cursor — scrolling past an edge turns the page
  • Column details and database details, each a keystroke away
  • SQL query panel, opened when wanted, with readable and resizable results
  • Export a table in the order you are viewing it, or export a query's results
  • Terminal UI (TUI) with the same feature set
  • Web demo — runs entirely in the browser via WASM
  • Three themes: dark, light, 3.1
  • Read-only — your data is never modified

Download

Download the latest release from the website or the releases page.

macOS: If you see "app is damaged", open Terminal and run:

xattr -cr /Applications/DBiewLite.app

Terminal UI

Install via Cargo:

cargo install dbiewlite-tui

Then run:

dbiew path/to/database.sqlite    # or .duckdb, .parquet

See the TUI README for details.

Keyboard Shortcuts

Press ? in either the GUI or the TUI for the full list, which is generated from the bindings themselves.

Action GUI (Mac) GUI (Win/Linux) TUI
Open database Cmd+O Ctrl+O CLI arg
Toggle sidebar Cmd+B Ctrl+B Ctrl+B
Focus the table list Tab Tab Tab
Leave the list for the grid Enter Enter Enter
Navigate up/down ↑/↓ or k/j ↑/↓ or k/j ↑/↓ or k/j
Move column cursor ←/→ or h/l ←/→ or h/l ←/→ or h/l
Pan sideways Shift+←/→ or H/L Shift+←/→ or H/L Shift+←/→ or H/L
First/last row g/G g/G g/G
Sort column s or click header s or click header s
Half screen up/down Ctrl+U/Ctrl+D Ctrl+U/Ctrl+D Ctrl+U/Ctrl+D
Prev/next page [/], PgUp/PgDn, or scroll to an edge same PgUp/PgDn or [/]
Open the query panel / or : / or : / or :
Run query Enter Enter Enter
New line in a query Shift+Enter Shift+Enter —
Clear query and results Clear button Clear button Ctrl+U
Resize results drag the divider drag the divider +/-
Close the query panel Esc Esc Esc
Export to CSV Cmd+E Ctrl+E Ctrl+E
Database details i i i
Column details c c —
Show help ? ? ?
Cycle theme Cmd+T Ctrl+T —
Quit Cmd+Q Ctrl+Q q

Tech Stack

  • Backend: Rust (Tauri v2, rusqlite with bundled SQLite, duckdb with bundled DuckDB)
  • Frontend: TypeScript + HTML/CSS (no framework)
  • TUI: ratatui + crossterm
  • Web: sql.js (SQLite compiled to WASM)

Building from Source

Prerequisites

GUI (Desktop App)

bun install
bun run tauri dev      # development
bun run tauri build    # production

TUI (Terminal)

cargo run -p dbiewlite-tui -- path/to/database.sqlite  # or .duckdb, .parquet

Need something to browse? This generates a demo database that exercises every feature — 28 tables, a 27-column table, 12k rows, NULLs, BLOBs and wide characters. The file itself is not tracked:

python3 scripts/make_sample_db.py
cargo run -p dbiewlite-tui -- samples/sample.db

Support

If you find DBiewLite useful, consider supporting development on Ko-fi.

License

MIT.

The binaries are statically linked and bundle SQLite (public domain) and DuckDB (MIT). dbiew --licenses prints the notice covering both, and the C and C++ libraries DuckDB compiles in.

About

A friendly, read-only SQLite/DuckDB/parquet files content viewer. Desktop GUI and TUI

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages