DB Viewer

DB Viewer is a free in-browser SQLite database viewer. Drag and drop any .db, .sqlite, or .sqlite3 file to browse tables, filter and sort rows, run read-only SQL, draw charts, and export to CSV or JSON. All processing happens locally; your data never leaves your device.

Upload a SQLite DB to get started.

Smart filters
Graphs
SQL console (read-only) Press Enter to run

How to view a SQLite database in your browser

  1. Load your database. Drag and drop a .db, .sqlite, or .sqlite3 file onto the page, or click the file picker. The file is read locally.
  2. Pick a table. Choose any table from the sidebar to see its columns, row count, and contents.
  3. Filter, sort, and search. Click column headers to sort. Use the search box to filter rows. Apply smart filters for top N, bottom N, NULL checks, or specific values.
  4. Run SQL or chart the data. Use the read-only SQL console (SELECT, WITH, PRAGMA, EXPLAIN), or switch to Graphs to draw histograms, bar charts, pie charts, or line graphs.
  5. Export. Send your current view to CSV or JSON with one click.

Features

  • Supports .db, .sqlite, and .sqlite3 files
  • Sortable data tables with quick search
  • Smart filters: top N, bottom N, value filters, NULL checks
  • Charts: histograms, bar charts, pie charts, line graphs
  • Read-only SQL console (SELECT, WITH, PRAGMA, EXPLAIN)
  • CSV and JSON export
  • Keyboard shortcuts: Ctrl+O to open, Enter to run SQL, Esc to clear search
  • Runs 100% client-side; no uploads

Frequently Asked Questions

Is the DB Viewer free?

Yes. DB Viewer is completely free, with no signup, no ads, and no upload. It runs entirely in your browser.

Does my database leave my device?

No. All processing happens locally in your browser using sql.js (a WebAssembly build of SQLite). Your data is never uploaded to a server.

What file types are supported?

DB Viewer supports SQLite database files with .db, .sqlite, and .sqlite3 extensions.

Can I run SQL queries?

Yes, with limitations. The built-in SQL console is read-only and accepts SELECT, WITH, PRAGMA, and EXPLAIN statements. INSERT, UPDATE, DELETE, and schema changes are blocked to protect your file.

Can I export the data?

Yes. Export the current table or query results to CSV or JSON with the Export buttons.

What charts can DB Viewer draw?

Histograms for numeric columns, bar and pie charts for categorical columns, and line graphs for time-series data.

Are there keyboard shortcuts?

Yes. Ctrl+O opens the file picker, Enter runs a SQL query while the console is focused, and Escape clears the search box.

More from Ghillie

Like DB Viewer? Try the Wordle Solver, browse the full portfolio, or read more about Ghillie.