Open a SQLite database and find the records you need
A SQLite database is often a single file, but its tables and relationships may be difficult to inspect without a database tool. Open the file to see its tables, review columns and records, and understand the data before exporting or troubleshooting it.
Select the SQLite database file supported by the viewer and wait for its table list to load.
Choose a table to inspect its columns and rows. Use the available search or query features to narrow the data you need.
Review important records and relationships before copying or exporting results. Keep an untouched copy of the original database.
Read-only inspection is a safer first step
Start by checking table names, column definitions, row counts, and a few representative records. If a query returns no rows, confirm the table and conditions before assuming the data is missing. Related information may be stored in another table and linked by an ID.
A viewer is useful for inspection, but it does not automatically explain every application's schema or prove that a database file is healthy in every respect. Avoid experimenting on your only copy, and do not share database files that contain private or sensitive records.