Open SQLite Online
A SQLite database — from a mobile app, an accounting program or a browser — opens as a table: with filters, grouping, editing and export to Excel. The file stays on your computer.
Free for personal use. .db, .sqlite, .sqlite3, .db3 and files without an extension work — the database is recognized by its content. Windows version — 3.4 MB, no installation: details. Organizations: license.
Pick a table
The first table of the database opens; choose another in “File parsing” — or open all tables at once, a tab for each.
A big database is no problem
A table is read directly, page by page, without an SQL engine. On opening only the table structure is walked; rows are fetched as you scroll.
Types as in the database
Dates written as ISO text are shown as dates, BOOLEAN as boolean, 64-bit identifiers without rounding. A BLOB is shown as its size.
Editing with the real engine
Cells, new and deleted rows are saved to the database by the official SQLite engine — in one transaction. Indexes, triggers and constraints work as in any program; on an error the file is left unchanged.
What is supported
| What | How |
|---|---|
| Encodings | UTF-8, UTF-16le, UTF-16be — from the database header |
INTEGER PRIMARY KEY | this is the rowid; for tables without such a key the rowid is a service column, hidden by default |
WITHOUT ROWID | supported, up to 2 million rows |
ALTER TABLE ADD COLUMN | rows written before the column was added have an empty value |
| Long values | text and BLOBs that did not fit in a page are assembled from the chain of overflow pages |
| Views (VIEW) | open as tables — executed by the SQLite engine; read-only |
| Virtual tables | full-text FTS5 and R-Tree — also through the engine, read-only |
| WAL mode | a -wal journal opened together with the database is attached: the latest changes are visible, an unfinished tail is discarded; without the journal there is a warning |
| Encrypted database | SQLCipher and similar do not open without the key — with a clear message |
Where to find the files and how to read them: how to open a SQLite .db file, SQLite to Excel and a database from a phone app.
How edits are saved
The app reads the database itself, but only the official SQLite engine, built for the browser, writes it. It is loaded the first time you save a database — about a megabyte — and only then: for those who do not edit databases it costs nothing.
- One transaction. All edits — changed cells, new rows, deleted ones — are applied at once. If a constraint is violated (UNIQUE, NOT NULL, CHECK, foreign key), everything is rolled back, the file is unchanged, and the message names the record and the field.
- Indexes and triggers are updated and run by the engine itself, like in any program that works with a database.
- Generated columns (
GENERATED ALWAYS AS) are not editable: the database calculates their value. - WAL mode. If the database was opened together with a
-waljournal, the full database is saved and an empty journal is left beside it, so the old one cannot be applied on top of the new database. - UTF-16 databases open and export, but edits to them cannot be saved: the browser build of the engine does not support UTF-16.
Before editing the working database of a program that is running right now, close that program — or edit a copy: two programs writing to one database from different places know nothing about each other.
SQL queries
“Data” → “SQL query”: SELECT with JOIN, GROUP BY, subqueries and SQLite functions. The result opens in a separate tab — as one more table: filters, grouping and export to Excel work on it too.
- Read-only.
UPDATE,DELETEand other commands that change the database are not executed — the query is checked before it runs. And it works on a copy of the database in the tab's memory: the file on disk is not touched. - The journal is taken into account. If the database was opened together with
-wal, the query sees the latest changes. - How much it handles. For a query the database is copied into memory, so up to 1 GB; the result is up to 2 million rows. Tables of large databases open without a query too — directly.
Why this when there is DB Browser
DB Browser for SQLite and similar programs can do more — for example change table structure and write to the database with queries. But they must be installed, and on a work computer that is often not allowed. Here a browser is enough, and the database is not sent anywhere: you can see that in the developer tools.
For tasks like “see what is in the database, make a selection, fix a couple of values and export the table to Excel” this is enough.
FAQ
Can I run an SQL query?
Yes, read-only: “Data” → “SQL query”. A SELECT with JOIN, GROUP BY and SQLite functions is executed by the official engine, and the result opens in a tab. Commands that change the database are not executed — edit the data in the tables themselves.
Can I change data in the database?
Yes: edit cells, add and delete rows, then Save. Edits are written by the official SQLite engine in one transaction; if the database does not accept them — for example, a duplicate in a unique field — the file stays as it was. Table structure (columns, indexes) is not changed here.
Why don't I see the latest changes in the table?
The database is most likely in WAL mode and the changes are still in the file ending in -wal beside it. Open the database together with this file — drag both in at once and the journal is attached.
Does the database file go to a server?
No. The database is parsed in the browser tab; the page technically cannot send its content to a third-party address.
In depth
- How to open a .db or .sqlite fileA .db file is not always SQLite: how to tell from the first bytes what it is, how to open SQLite without installing software, and why Thumbs.db isn't worth opening.
- SQLite table to Excel or CSVExport a table from a SQLite database to Excel, CSV or DBF in the browser: pick a table, filter it, dates as dates, long IDs without rounding, all tables in one workbook.
- A database from a phone appAndroid app .db files are SQLite databases: how to open them on a computer, what android_metadata is, why -wal and -shm files sit beside it and where new records are.