Open a SQLite database file, browse its tables, run SQL queries, and export results to CSV or JSON. The file is opened locally and never uploaded.
This tool opens .sqlite, .sqlite3, .db and .db3 files with a WebAssembly build of SQLite, so the database is read on your device instead of being sent to a server. After loading, a sidebar lists every user table with its row count. Clicking a table shows its first 1,000 rows in a grid with a text filter and 25 rows per page.
The SQL console accepts any statement SQLite understands, including joins, aggregates and changes such as UPDATE or CREATE TABLE. The first result set appears in the grid along with the execution time. You can export the current result (after filtering) as CSV or JSON, or save the whole database back to a file, including any changes you made. A small sample shop database is included if you just want to try it out.
No. The file is read in your browser and queried with a WebAssembly copy of SQLite. Only the SQLite engine itself is downloaded when the tool starts.
Clicking a table runs a SELECT with LIMIT 1000 to keep the page responsive. Edit the query in the SQL console to change the limit or add a WHERE clause.
Yes. Statements like INSERT, UPDATE or ALTER TABLE run against the in-memory copy, and Save Database downloads the modified file. Your original file on disk is not changed.