SQLite Database Viewer and Editor
Inspect, query, and edit SQLite databases in memory.
Drop your SQLite file here
Supports .sqlite, .db, and .sqlite3. Your database stays in your browser.
About SQLite Studio
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.