SQLite viewer: tables, filters and queries right in your browser

Drop a SQLite database or SQL script here

.db, .sqlite, .sqlite3, files with no extension and SQL scripts (.sql) from SQLite, PostgreSQL and MySQL. You can select the database’s -wal file too.

The database opens in your browser and is not uploaded to a server. The original file is not changed.

What the viewer does

Shows the tables and views of a SQLite database: sorting, a filter in every column, search, and cell selection you can copy into a spreadsheet. The file is read in parts, so large databases open without loading into memory. SQL queries run read-only. You can download a table or a query result as CSV or JSON.

If an app was using the database in WAL mode, select its file ending in -wal as well, because the latest records are in it. Numeric timestamps can be shown as dates. Long text and JSON are readable in the value panel, and images stored in BLOBs can be viewed and saved.

A SQL script — a database dump or a script that creates a database — runs right in your browser, and the resulting database opens like any other. PostgreSQL and MySQL dumps are translated to SQLite: tables, columns, keys, indexes, comments and data from INSERT and COPY. What SQLite lacks — functions, triggers, permissions — is listed on the page, and the built database can be downloaded as a .sqlite file.

Frequently asked questions

Is it free to use?

Yes, this tool is free and needs no sign-up. The file opens right in your browser and is not uploaded to a server.