Free Online SQLite Viewer for .db Files
Open a local app database or backup and find the answer you need.
Find a record in an app database without installing SQLite
You have a .db backup and need an answer, not another database setup. Here it takes three steps:
- 1Drop the .db or .sqlite file in.
- 2Browse its tables, then use SQL only to narrow the record, period or total you need.
- 3Export that result as CSV or JSON.
SQLite ER diagram and schema visualizer
The Diagram tab draws every table and view with the foreign keys the file declares: N at the referencing column, 1 at the key. Select a table and its relations stand out while the rest fades; with several databases open, each gets a frame of its own.
What it shows in a .db file
The schema, read out of the file itself:
- Tables and views with their row counts
- Every column with its declared type, the primary key, the indexed ones
- Triggers
- BLOB values by kind and size, with a preview of images, audio and video
- An integrity check on the file as a whole
Most .db files are SQLite databases, but the extension is only a convention: Paradox and a few other engines use it too. A file that is not SQLite is reported as such rather than opened.
Nothing leaves the tab
The file is opened from your disk and read where it sits, so there is no upload and no copy on a server. Queries are read-only, which means the file you opened is the file you still have, and closing the tab leaves nothing behind.
From one file to a complete data workflow
Need to move the database rather than inspect it? DBConvert converts SQLite data to and from popular database formats with schema and data migration support.
Need help with a file? Contact us