SQLite Viewer: Open and Browse .db Files
Drop a .sqlite or .db file to explore it like a lightweight DB Browser without installing anything. The sidebar lists every table with its row count, the main panel shows each table's schema and first rows, and a query box runs your own read-only SELECT statements. The SQLite engine runs in your browser through WebAssembly, so the database file is opened locally and never uploaded.
How to open a SQLite file
- Drag your .sqlite or .db file onto the drop zone, or click it to pick a file.
- Wait for the SQLite engine to load; it downloads once on first use, then is cached.
- Pick a table from the Tables sidebar to see its columns, PK and NOT NULL flags, and first 100 rows.
- Type a SELECT or PRAGMA statement into the SQL query box and click Run to explore further.
- Use Copy TSV to grab a results grid, or Open another file to load a different database.
Examples
Preview a table from the sidebar
Click the users table
Runs SELECT * FROM "users" LIMIT 100 and shows the schema and rows
An empty cell
A row where the email column has no value
NULL
A binary column
An avatar column storing 2048 bytes of image data
[BLOB 2048 bytes]
Frequently asked questions
Is my database uploaded anywhere?
No. A compiled SQLite build runs inside your browser using WebAssembly, so the file is read directly from your device and never sent to a server. You can even open a database offline once the page and engine have loaded.
Which file types can I open?
Any SQLite database file, regardless of extension. The drop zone accepts the common ones by default: .sqlite, .sqlite3, .db and .db3. If a file uses a different extension but is a real SQLite database, it will still open.
Can I edit the data or only view it?
This is a read-only viewer. SELECT and PRAGMA statements work well for exploring, but any changes are not written back to your original file. To edit a database, use a desktop tool such as DB Browser for SQLite.
Why do I only see the first 100 rows of a table?
When you click a table the tool runs a preview query with LIMIT 100 to stay fast on large tables. The Data heading shows the full row count, so if a table has more you can write your own query with a higher LIMIT or a WHERE clause to see the rest.
How are NULL and binary values shown?
Empty cells display the word NULL in a muted style so they are easy to tell apart from an empty string. Binary BLOB columns are not dumped as raw bytes; instead they show a placeholder like [BLOB 2048 bytes] that reports the size.
Can I run any SQL, including writes?
The query box will attempt whatever you type, but the tool is built for read-only browsing, and results are shown as grids. Stick to SELECT and PRAGMA statements. Statements that would modify data have no lasting effect because nothing is saved back to the file.
How big a file can it handle?
The entire database is loaded into memory, so small and medium files open almost instantly. Very large files, in the hundreds of megabytes or more, may load slowly or hit your browser's memory ceiling, since everything must fit in RAM.
How do I copy query results out?
Each results grid has a Copy TSV button that puts the rows on your clipboard as tab-separated values with a header row. You can paste that straight into a spreadsheet or a text file.
Learn more
- What a SQLite file is and how to open one
Why SQLite stores an entire database in a single file, what .db and .sqlite extensions mean, and safe ways to inspect one.
Related tools
SQL Playground
Write and run SQL in your browser against an in-memory SQLite database. Query a sample dataset or load your own .sqlite file. Nothing is uploaded.
JSON to SQL
Convert JSON to SQL INSERT statements online. Paste an array of objects, set a table name, and get ready-to-run INSERTs. Runs in your browser.
CSV to JSON
Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.
.env to JSON
Convert a .env file to JSON, or JSON back to .env. Parses KEY=value lines, comments, quotes and export. Runs entirely in your browser.
ASCII Table
Full ASCII table for all 128 codes with decimal, hex, octal and binary values, character names and descriptions. Search by code, hex or character.
Aspect Ratio Box Generator
Generate CSS for a responsive aspect-ratio container. Use the modern aspect-ratio property or the padding-top fallback, then copy the ready code.