Does this really run SQLite, or just approximate it?

It runs real SQLite, compiled to WebAssembly via the sql.js library. Your uploaded file is opened as an actual SQLite database in the browser's memory, and the tables you browse are read with real SQL queries, not a hand-rolled file parser.

Is my database file uploaded to a server?

No. Everything, loading the WASM SQLite engine, opening the file, and running queries against it, happens entirely client-side. The uploaded file never leaves your browser.

Why does it only show up to 500 rows?

Each table is read with a LIMIT 500 query to keep the page responsive for large databases. A note appears when a table may have more rows than that, so you know the view is capped rather than showing the complete table.

What file extensions can I upload?

Any SQLite database file, regardless of its exact extension, .sqlite, .db, and .sqlite3 are all accepted since they're the same underlying file format.

SQLite Viewer - Browse a .sqlite/.db File Online

Overview

Introduction

SQLite files are everywhere, mobile app data, local caches, small analytics exports, but peeking inside one usually means installing a database browser or reaching for a command-line client.

SQLite Viewer skips that: upload a .sqlite file, see every table listed, click one, and browse its rows as an actual table, no install required.

What Is SQLite Viewer?

A browser-based SQLite database browser built on sql.js, a genuine build of SQLite compiled to WebAssembly, not a custom binary-format parser.

Once a file is uploaded, its table names are listed as tabs, and selecting a table runs a real SQL query against the open database to fetch and display its rows.

How SQLite Viewer Works

The uploaded file's bytes are handed to sql.js's Database constructor, which opens them as an in-memory SQLite database. Table names are discovered with a query against SQLite's own sqlite_master catalog table.

Selecting a table tab runs a SELECT * FROM "table" LIMIT 500 query against the already-open database, so switching between tables is fast and never re-parses the uploaded file. The sql.js WebAssembly module itself is only loaded when a file is actually uploaded, keeping the page itself lightweight.

When To Use SQLite Viewer

Use this whenever you have a .sqlite, .db, or .sqlite3 file and just want to see what's inside it, table names, columns, and sample rows, without installing a database client.

It's also handy for quickly checking a SQLite export from another tool on this site, or a database file from an app or script, before deciding what to do with it next.

Often used alongside CSV to SQLite Converter, SQLite to CSV Converter and Query CSV with SQL.

Features

Advantages

Opens and queries a real SQLite database, not a custom parser guessing at the file format.
The heavy WebAssembly SQLite engine only loads when you actually upload a file, keeping the page itself fast.
Switching between tables is instant since the database stays open in memory rather than being re-parsed each time.

Limitations

Each table view is capped at 500 rows for responsiveness, larger tables are truncated rather than fully loaded.
This is read-only browsing, there's no editing or writing changes back to the database file.

Examples

Browsing a two-table database

Input

Upload app.sqlite (tables: "users", "orders")

Output

Tabs for "users" and "orders", clicking "orders" shows up to 500 of its rows as a table

Table names come from SQLite's own sqlite_master catalog, and clicking a tab runs a fresh LIMIT 500 query against that table without re-reading the uploaded file.

Best Practices & Notes

Best Practices

If a table shows the truncation note, narrow down what you're looking for with Query CSV with SQL-style filtering elsewhere, since this viewer's row cap is fixed.
Check every table tab in an unfamiliar database file before assuming you've seen everything it contains.
Use Query CSV with SQL after exporting a table if you need to actually filter or transform it, this viewer's own query surface is read-only browsing by design.

Developer Notes

openSqliteFile in sqlite-viewer.ts accepts the already dynamically-imported initSqlJs function (the component awaits import("sql.js") inside its file-handling handler, not at module scope, so the ~660KB WASM engine isn't part of the page's initial bundle), calls initSqlJs({ locateFile: () => "/sql-wasm.wasm" }) to load the WASM binary served from the public directory, opens a new SQL.Database from the file's bytes, and lists tables via sqlite_master. readSqliteTable runs a LIMIT-bounded SELECT against the already-open Database instance on every tab switch, typed with sql.js's own Database and QueryExecResult types.

SQLite Viewer Use Cases

Inspecting a SQLite database file's tables and sample data without installing a database browser
Quickly checking the output of this site's CSV to SQLite Converter before downloading or sharing it further
Verifying what's inside a .sqlite file received from an app, script, or another person

Common Mistakes

Assuming all rows of a large table are shown, only the first 500 are loaded per table, watch for the truncation note.
Expecting to edit and save changes back to the file, this tool is read-only browsing, not an editor.

Tips

Use Query CSV with SQL if you need to run a custom filtered or aggregated query rather than just browsing raw table rows.
Pair with SQLite to CSV Converter if you ultimately want a specific table's data out as a CSV file.

SQLite Viewer