Open Sqlite databases and explore the internal organisation of various objects such as schema, tables and indices. To understand how Sqlite3 data is organised, please see [Database file format](https://www.sqlite.org/fileformat.html ) from Sqlite website.
- Viewing internal organisation of Sqlite databases for software development and troubleshooting
- Studying the format of Sqlite databases for academic purposes
- Forensic investigators may use it to view data from deleted pages More Info »
- Opening Sqlite databases, displaying first page (containing header and schema root)
- Opening internal pages which may be a B-Tree page, Freelist page or Overflow page
- Exploring root, internal and leaf pages of B-Tree pages hierarchically.
- Parsing and displaying cell content for B-Tree pages
- Exploring Freelist (deleted) trunk and leaf pages
On clicking the `Open database` button, the user can select the database file to explore. The application opens the header, finds out the page size and provides links for the user to expand the `Header` and `Page 1`.
The first page invariably contains the header and the schema (definitions of tables and indices). If the schema fits into the first page, the definitions can be seen on the `Page details` section in the form of table under `Cells` heading.
For exploring data of tables and indices, the `Open` button against each table/index under `Cells` section may be clicked. This opens the `root` page of the table or index. Further exploration can be carried out from there by clicking on buttons in the `Page details` sections.
If the schema spills over more than one page, the first page contains links to the different pages in which schema information is stored. These links can be seen in the `Page details` section under `Cells` heading and `Open` button against `Right most pointer` just above `Cells`.