SQLite Viewer Online
Drop a SQLite database to browse its tables and views, filter and sort rows, read the schema and run SQL. Read-only, with no account and no upload.
SQLite Editor & Viewer for VS Code and Cursor, free
Edits cells and rows with Undo, saves with a backup, imports a CSV of a million rows and reloads when the file changes.
Optional Zovo Pro, USD 19 once: compare two databases, ER diagram and export of all tables.
Drop a SQLite database here
or
.db, .sqlite, .sqlite3 and any SQLite 3 file up to 500 MB. Pick its -wal file too for changes not yet checkpointed.
DB tools (compare two databases, ER diagram, export all tables) are Zovo Pro tools in the SQLite Editor extension. See the Zovo Pro card below.
Open this in VS Code or Cursor
This page runs the viewer of the SQLite Editor extension. In VS Code and Cursor the same view also edits cells and rows with Undo, saves with a backup, imports a CSV of a million rows and reloads when the file changes.
Free, MIT license. About SQLite Editor for VS Code.
Zovo Pro
Compare two databases, ER diagram and export of all tables. Zovo Pro, USD 19 once.
In the SQLite Editor extension, Zovo Pro compares two databases (schema and rows, with a SQL sync script), draws an ER diagram and a schema document, and exports every table at once as an Excel workbook or CSV files. Each Pro tool works 3 times for free. One payment covers the Pro tools in 22 Zovo extensions. Everything that is free stays free.
After a card payment you get a key on the page. With GitHub Sponsors you sign in from the extension. Details on the Zovo Pro page.
Related tools
- SQLite Editor & Viewer on the VS Code Marketplace (also on Open VSX). Opens .db and .sqlite files as tables, edits cells and runs SQL.
- Postgres & MySQL Query Client. Runs SQL against Postgres, MySQL and SQLite from VS Code.
- Excel, CSV and Parquet Viewer. Opens xlsx, csv and parquet files as a sortable table.
- Large JSON Viewer & JSON Tree. Browses big JSON files as a tree in VS Code.
- Excel Viewer Online, free in your browser.
- Hex Viewer Online, free in your browser.
- DOCX Viewer Online, free in your browser.
Questions
Is my database uploaded anywhere?
No. The page reads the file inside this tab, and SQLite itself (compiled to WebAssembly) runs in a background worker of the page. The Content Security Policy sets connect-src to none, and the worker has no network functions at all. Open the Network tab of your browser tools and you will see no request when a database opens.
Which files does it open?
SQLite 3 databases up to 500 MB, whatever their name: .db, .sqlite, .sqlite3, .db3, and app files such as browser history or a phone backup. Pick the -wal file together with the database to see changes that are not checkpointed yet. Encrypted (SQLCipher) databases need their key and a desktop tool.
Can I run my own SQL?
Yes. The SQL tab runs reading statements (SELECT, WITH, VALUES, EXPLAIN and reading PRAGMA), one at a time, with a history of the last 30. Results show in the same grid, with sorting, filters and copy. The database is opened read-only, and it is a copy in memory anyway, so your file never changes. A query that runs for a long time can be stopped.
Can I edit the database?
This page is read-only. The free SQLite Editor extension for VS Code and Cursor edits cells and rows, stages every change with Undo, and saves with a backup.
Can I export the data?
Yes. Copy as CSV, TSV, JSON or SQL INSERT from the toolbar, or Export the rows in view (filtered and sorted) as a CSV, JSON or SQL file. Images stored in BLOB cells show as pictures, and any BLOB can be saved as a file.
Is a hostile database safe to open?
Cell values are written as plain text, never as HTML, and the page allows only its own scripts. The database runs in a worker inside a separate frame, so a broken or crafted file can at worst stop the worker; a Stop button replaces it.
What is free and what is Zovo Pro?
Browsing, filters, sorting, the schema, SQL, copy and export are free here and in the extension. Comparing two databases, the ER diagram and exporting every table at once are Zovo Pro in the VS Code extension. One USD 19 payment covers the Pro tools in every Zovo extension.