← Toolz / Developer Tools / SQLite Viewer

SQLite Viewer

Open a SQLite database file and explore it — browse every table, read its schema, and run your own read-only SQL queries, all in your browser. The database is loaded by the sql.js engine (SQLite compiled to WebAssembly) on your device: nothing is uploaded, and because queries are read-only, the file cannot be changed by accident.

Open a database file and its tables, schemas and query results will appear here.

For app databases, exports and backups — look inside without installing a thing.

100% free · No sign-up · No daily limits · No watermarks · Processed in your browser — files never leave your device

UNDERSTAND YOUR RESULTS

SQLite Viewer — Open & Query .db Files in Your Browser guide

Open SQLite database files (.db, .sqlite, .sqlite3) in your browser and explore them properly: every table and view listed with its row count, the full CREATE schema and column definitions, one-click browsing, and a read-only SQL console with CSV export. The file is opened locally by SQLite itself (compiled to WebAssembly) — it is never uploaded and never modified.

How to use this tool

  1. Choose or drop a database file. The sidebar lists its tables and views with live row counts, and the main panel opens on the database structure so you can see what you are holding.
  2. Click any table to browse its first 100 rows and read its schema — column names, types, primary keys and defaults are shown under the CREATE statement. Click a view to see its rows the same way.
  3. Write your own query in the console (SELECT, WITH, PRAGMA and EXPLAIN are allowed) and run it with the button or Ctrl+Enter. Export any result set to CSV for spreadsheets and reports.

A worked example

A shop app keeps its data in a local orders.db: open it here, click the orders table to sanity-check the latest rows, then run SELECT city, COUNT(*) FROM customers GROUP BY city to see where the customers actually are — and export that straight to CSV for the weekly report.

How it works

The viewer is powered by sql.js: the real SQLite C library compiled to WebAssembly, running entirely in your browser tab. It reads the genuine SQLite file format — pages, b-trees and all — so what you see is exactly what the database contains, including its SQLite version, reported in the file panel. Queries are executed by that same engine against the in-memory copy.

Frequently asked questions

Is my database uploaded to a server?

No. The file is read by JavaScript/WebAssembly inside your browser tab. Nothing is sent anywhere, which is why this viewer is safe for production exports and backups.

Can I edit the data here?

No — deliberately. Viewing and querying are read-only so a slip cannot damage the only copy of a database. Editing needs a tool that can also handle backups and transactions properly.

What files does it open?

Any standard SQLite 3 database: .db, .sqlite, .sqlite3, .db3 and extension-less files from apps, browsers and phones. SQLCipher-encrypted files and other formats (MySQL dumps, Access) are not SQLite files and will not open.

How much of a big table can I browse?

Table browsing shows the first 100 rows with the exact total count alongside. For more, write a query with your own LIMIT and OFFSET — results of any query can be exported to CSV in full.

What is the schema panel useful for?

It shows the exact CREATE statement and each column’s type, key and default — what you need when writing queries, debugging an app, or documenting a database you inherited.