Boneyard Tools

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

  1. Drag your .sqlite or .db file onto the drop zone, or click it to pick a file.
  2. Wait for the SQLite engine to load; it downloads once on first use, then is cached.
  3. Pick a table from the Tables sidebar to see its columns, PK and NOT NULL flags, and first 100 rows.
  4. Type a SELECT or PRAGMA statement into the SQL query box and click Run to explore further.
  5. 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

Related tools