SQLite Viewer - Browse Tables & Run SQL Queries Online

Open SQLite database files, browse their tables, and run SQL queries — the database is processed locally in your browser and never uploaded to any server.

Choose a .db, .sqlite, or .sqlite3 file to list its tables with row counts, click a table to preview its rows, or type your own SQL. Not sure what to expect? The demo schema button shows a worked example first.

SQLite Viewer - Browse Tables & Run SQL Queries Online
Open SQLite database files, browse their tables, and run SQL queries — the database is processed locally in your browser and never uploaded to any server.
Queries run on an in-memory copy — any changes are discarded and your original file is never modified.

How it works: the file is opened by sql.js, a WebAssembly build of the real SQLite engine that runs entirely inside your browser. Your database never leaves your device.

About the SQLite viewer

SQLite is everywhere: mobile apps store their settings in it, browsers keep history and cookies in it, and countless desktop tools, games, and embedded devices use a single .db or .sqlite file as their entire backing store. When one of those files ends up in your hands — an app backup, an export from a logging tool, a dataset from a research project — you usually just want to peek inside without installing a database client. This viewer does exactly that. It runs sql.js, a WebAssembly compilation of the genuine SQLite engine, directly in your browser, so the file is opened locally and its contents are never transmitted to any server. That matters, because database files routinely contain personal messages, credentials, and business records that should not be uploaded to a stranger's backend just to be read. After you choose a file, the viewer reads the database catalogue and lists every table together with its row count, giving you an immediate map of what the file contains. Click any table to preview its first two hundred rows in a scrollable grid; binary columns are summarised by size so huge blobs do not swamp the page. For anything more specific there is a full SQL box: filter with WHERE clauses, join tables, aggregate with GROUP BY, or inspect the schema itself — the entire SQLite dialect is available because it is the real engine executing your statements. One detail worth understanding: the viewer works on an in-memory copy of your file. You can even run UPDATE or DELETE statements to experiment, but those changes live only in the browser session and are thrown away when you leave the page. Your original file on disk is never touched, which makes the tool safe to use even on databases you cannot afford to corrupt. The practical limits are your device's memory — multi-gigabyte databases are better explored with desktop tooling — and encryption: password-protected or SQLCipher-encrypted files cannot be opened, since the standard engine does not include the decryption layer. WAL sidecar files (-wal, -shm) are also not merged, so checkpoint the database first if recent writes are missing. For the everyday jobs of inspecting an app's data, verifying an export, or answering a quick question with one SELECT, a private, zero-install viewer in the browser is the fastest path there is.

SQLite viewer examples

Common tasks and the queries or clicks that accomplish them.

TaskHow to do itNote
See what an app backup containsOpen the .db file and read the table list with row countsThe catalogue is queried from sqlite_master automatically.
Preview a table's contentsClick the table's button to load its first rows into the gridPreviews are capped so even huge tables stay responsive.
Find specific recordsRun a query such as SELECT * FROM users WHERE email LIKE '%@example.com';The full SQLite SQL dialect is supported, including joins and aggregates.
Inspect a table's column definitionsRun PRAGMA table_info(table_name); in the SQL boxPRAGMA statements work because this is the real SQLite engine.

How to open a SQLite database online

  1. Click the file picker and choose a .db, .sqlite, or .sqlite3 file from your device.
  2. Review the table list and row counts that appear once the database is opened.
  3. Click any table button to preview its rows in the grid.
  4. Type a SQL statement in the query box and press Run query for filtered or joined results.
  5. Close the tab when done — the in-memory copy is discarded and your file is unchanged.

SQLite viewer FAQ

Is my database uploaded to a server?
No. The file is loaded into a WebAssembly build of SQLite (sql.js) running inside your browser tab. Nothing is sent over the network, and closing the page removes the data from memory.
Which file extensions and formats are supported?
Any standard SQLite 3 database, regardless of extension — .db, .sqlite, and .sqlite3 are the common ones. Encrypted or SQLCipher-protected files cannot be opened, and other database formats such as Access .mdb are not SQLite.
Can I modify the database with UPDATE or DELETE?
You can execute such statements, but they apply only to the in-memory copy inside the browser session. Your original file is never written to, so all modifications disappear when you leave or reload the page.
What SQL can I run?
Everything the SQLite engine understands: SELECT with joins, subqueries, window functions, aggregates, PRAGMA statements for schema details, and more. Query results appear in the same grid used for table previews.
Why do some recent rows seem to be missing?
If the database uses write-ahead logging, the latest changes may live in a -wal sidecar file that is not part of the main file you opened. Checkpoint or cleanly close the database in its source application, then open it here again.
How large a database can I open?
The whole file is loaded into browser memory, so files up to a few hundred megabytes are typically fine on a desktop. For multi-gigabyte databases a native desktop client will be more comfortable.