SQLite Editor Online & SQLite Viewer Online — Edit .sqlite and .db Locally in Your Browser
Need a fast SQLite editor online or SQLite viewer online without installing a desktop database client or uploading sensitive .db files to a remote server? Drop any .sqlite, .sqlite3, .db or .db3 file into your browser to browse tables and views, edit typed cell values in place, and save straight back to disk via local WebAssembly.
Why developers choose XJY as their online SQLite editor
-
Color-coded SQLite storage classes & type badges: Every cell clearly distinguishes
INTEGER,REAL,TEXT(with semantic highlighting for ISO dates, booleans and empty strings),NULLand read-onlyBLOBvalues alongside a clear row index badge. -
Exact 64-bit integer safety: 64-bit integer primary keys, snowflake IDs and timestamps beyond JavaScript’s
MAX_SAFE_INTEGER(9007199254740991) are read, displayed and bound without floating-point rounding. -
Honors constraints, foreign keys, FTS5 & triggers: Edits, row inserts and deletes execute inside atomic SQLite transactions; any
UNIQUE,CHECK,NOT NULLor foreign-key violation rolls back cleanly with an immediate diagnostic message. -
Handles composite keys,
WITHOUT ROWID& shadowed rowids: Safely locates individual rows even in tables with composite primary keys,WITHOUT ROWIDtables, or user columns namedrowid. -
Schema DDL inspector & one-click table export: Switch between Data and Structure tabs to inspect column definitions, indexes, foreign keys and raw
CREATE TABLESQL, or convert and export any table to CSV, TSV, Excel (.xlsx), JSON, XML or YAML.
Supported SQLite database files & features
| Feature | XJY Online SQLite Editor & Viewer |
|---|---|
| Supported extensions | .sqlite, .sqlite3, .db, .db3 |
| Execution engine | 100% local in-browser WebAssembly (zero server uploads) |
64-bit INTEGER precision |
Exact text-bound 64-bit integers (`-9223372036854775808` to `9223372036854775807`) |
| Undo / Redo | Full-database snapshot undo & redo across table edits and triggers |
| Air-gapped / offline edition | Single-file SQLiteEditor.html with embedded WebAssembly engine |
Frequently asked questions (FAQ)
- How do I open and edit a .sqlite or .db file online without installing software?
-
Launch the XJY Online SQLite Editor and open your
.sqlite,.sqlite3or.dbfile. Select any table or view in the left sidebar to filter rows, double-click cells to edit values with explicit SQLite storage types (INTEGER,REAL,TEXT,NULL), and pressCtrl+Sto save back to disk. - Is my database uploaded to a server when using this online SQLite viewer?
-
No. The SQLite engine runs entirely inside your browser via WebAssembly, and strict Content-Security-Policy headers block external network connections. You can also download the standalone
SQLiteEditor.htmlfile (which embeds the Wasm engine) for completely offline or air-gapped machines. - Can I export a SQLite table to Excel (.xlsx), CSV or JSON online?
-
Yes. Open your database, select a table or view, and click “Convert and export…” in the top toolbar to export the table directly to Excel (
.xlsx), CSV, TSV, JSON, XML or YAML. See SQLite help for details.