SQLite Viewer

1. Choose a file with the button above, or drag it onto the drop zone. No file at hand? Open the sample database to see how the viewer works.
2. Pick a table or view from the list. Each entry shows its row count, so you can spot the large tables first.
3. Switch between Data and Schema. Data shows 100 rows per page, and long text values are shortened until you click show. Schema lists the columns with their types, the foreign keys, the indexes and the original CREATE statement, which you can copy.

How to tell a file is SQLite

Every SQLite database starts with a 16 byte header: the text SQLite format 3 followed by a NUL byte. Common extensions are .db, .sqlite and .sqlite3, but the extension proves nothing. Not every .db file is SQLite, so the viewer checks the header first and tells you when a file is something else.

Where SQLite files come from

SQLite is the database inside many mobile apps, web browsers and desktop applications, which keep history, settings and caches in it. Small web apps often use one SQLite file as their whole database, and data exports are sometimes shipped as a .sqlite file too.

Limits

• The viewer is read-only. Nothing is written back to your file.
• The whole file is loaded into memory, so very large files depend on how much memory your device has.
• Databases in WAL mode keep recent changes in a separate -wal file. Those changes are not included unless the database was checkpointed before you copied it.