SQLite Database Viewer and Editor

This tool opens a SQLite database in your browser. You can read the tables, run a SQL query, change a cell, and export the result as CSV or JSON.

The database engine runs on WebAssembly in the browser tab. The file is never uploaded, so you can open a production copy or a database that holds personal data.

Open a file, or start with a blank database or the sample. Select a table to see its rows. Search the text columns, add a filter, sort a column, and page through the rows. Each control writes the SQL that it runs into the editor, so you can read it, change it, and run it. Select a row to duplicate it or delete it. Double-click a cell to edit it. Then download the database to keep your changes, because the browser does not save the file for you.

Unsaved changes: The toolbar counts each change that you have not downloaded. The tool asks for confirmation before it closes a database that holds a change, because closing loses it.

Two kinds of export: Export results gives the rows of the current result as CSV or JSON. Export database gives the whole .sqlite file. A result export is not a backup.

Many statements: Run more than one statement at a time, and the tool gives a tab for each one. An INSERT, an UPDATE, and a DELETE show the count of the rows that changed.

Stop a query: Select Stop to end a query that runs too long. SQLite cannot interrupt a busy call, so the tool restarts the database engine and loads the last saved state. A change that you did not download is lost.

Import a CSV file: Drop a .csv file to open a preview. Set the type of each column, then import. The tool writes a typed CREATE TABLE and inserts every row inside one transaction, so a failure writes nothing. A value with a leading zero, such as a postal code, stays text.

Autocompletion: The editor completes a table name and a column name from the schema of the open database, next to the SQLite keywords. The sidebar lists the tables, the views, the indexes, and the triggers.

Limits: The database stays in memory, so the browser keeps nothing after you close the tab. A result shows the first 1000 rows; add a LIMIT or a filter to see the rest. A BLOB cell shows its size and the first bytes as hex, never the whole value. The tool reads no remote database and sends no file to a server.