ToolDash
SQLite Database Viewer

SQLite Viewer — View .db Database Files Online

Open a SQLite database file and browse its tables, filter rows without writing SQL, or run your own queries, all inside your browser. The database is read locally and never uploaded.

  • Free, no sign-up
  • Runs in your browser — nothing is uploaded
  • Instant results, no waiting on a server

Select a table from the sidebar to start filtering.

Run a query or select a table to see results.

How to open and query a SQLite database

  1. 1Click Open Database and choose a .sqlite, .db, .sqlite3, .db3 or .sqlitedb file. The sidebar lists every table with its row count, and the first table opens automatically.
  2. 2Click a table name to browse it. Click a column header to sort ascending, then descending, then back to the original order, and use the pager and rows-per-page menu (25 to 200) to move through the data.
  3. 3On the Filters tab, click Add filter and pick a column, an operator (equals, contains, starts with, >, is null and more) and a value. Results update as you type.
  4. 4Switch to the SQL Editor tab for anything else: write a query and press Run or Cmd/Ctrl+Enter. Click CSV or JSON above the results to download them.

How a SQLite database runs in your browser

SQLite is the most widely deployed database in the world. Instead of a server, the whole database lives in a single file, so it's what you'll find inside mobile apps, browsers, desktop software, embedded devices and many local dev setups. That convenience has a catch: to view SQLite database contents you normally need the sqlite3 command-line shell or a desktop app. This tool removes that step by putting a SQLite viewer online, in a browser tab, with nothing to install.

It works by running SQLite itself in the browser. The viewer uses sql.js, the real SQLite C library compiled to WebAssembly. When you open a file, it's read into memory on your machine and queried there, so you get genuine SQLite behavior, including its SQL dialect, PRAGMA statements, joins, CTEs and window functions. The engine's code is fetched from a CDN the first time it's needed, but your database file never leaves your device.

The Filters tab builds a SELECT with a WHERE clause for you, joining multiple filters with AND. Values are passed as bound parameters rather than pasted into the SQL, so quotes and special characters in a search value just work. When you need more, such as joins, GROUP BY or aggregates, the SQL Editor runs any statement you type. Sorting and pagination still apply to SELECT results, and recent queries are kept in the sidebar so you can rerun them in one click.

Because the database is held in memory, write statements like INSERT, UPDATE or DELETE only change that in-memory copy. Your original file on disk is never modified, which makes it safe to experiment. Very large databases are limited by how much memory your browser can allocate.

When developers reach for it

Inspecting app databases

Open a SQLite file pulled from an iOS or Android app, an Electron app or a browser profile to see what's actually stored.

Checking local dev data

Browse the dev.db from a Django, Rails, Prisma or Drizzle project without installing a GUI client.

Exporting data

Run a query and download the results as CSV for a spreadsheet or as JSON for a script or test fixture.

Open DB file online on a locked-down laptop

On a work machine where you can't install DB Browser for SQLite or the sqlite3 CLI, open the file in a browser tab instead.

Practicing SQL

Load a sample database and try queries safely, since nothing you run changes the original file.

Frequently asked questions

Is my database uploaded to a server?

+

No. The file is read into your browser's memory and queried there with SQLite compiled to WebAssembly. Only the SQLite engine itself is downloaded from a CDN, never your data.

Which file types can I open?

+

Any SQLite 3 database, typically with a .sqlite, .db, .sqlite3, .db3 or .sqlitedb extension. Encrypted databases, such as those made with SQLCipher, can't be opened. Not every .db file is SQLite, though: Windows Thumbs.db and some apps' private formats use the same extension, so this isn't a universal DB file reader. If a file won't open, it probably isn't a SQLite database.

Does this online database viewer open MySQL, PostgreSQL or SQL Server databases?

+

No. It reads SQLite files only. MySQL, PostgreSQL and SQL Server (MSSQL) store data on a server in their own formats, so use that database's own client, or export the tables you need into a SQLite file first.

Can I open a .sql file in this SQL viewer?

+

Not directly. A .sql file is a text script of CREATE and INSERT statements, not a database. If the dump was written for SQLite, build a database from it with sqlite3 my.db < dump.sql and open my.db here. MySQL and PostgreSQL dumps usually need their syntax converted first.

Can I edit the database?

+

You can run INSERT, UPDATE, DELETE and CREATE statements in the SQL Editor, but they only affect the in-memory copy. The original file is not changed, and there's no option to save a modified database.

How do I export SQLite to CSV or JSON?

+

Run a query or open a table, then click CSV or JSON above the results. The export contains every row the query returns, not just the current page, in the current sort order, so narrow your query with WHERE or LIMIT to export exactly what you need.

How is this different from DB Browser for SQLite?

+

DB Browser for SQLite is a desktop app that can edit a database and save it back to disk. This is a SQLite browser online for reading and querying: there's nothing to install, but any changes stay in memory and can't be saved to the file.

Do I need to know SQL?

+

No. Click a table to browse it and use the Filters tab to narrow rows by column, operator and value. The SQL Editor is there when you want joins, aggregates or anything more complex.