Sqlite Page Explorer icon
Sqlite Page Explorer icon

Sqlite Page Explorer

 Like

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 from Sqlite website.

Sqlite Page Explorer screenshot 1

License model

  • FreeOpen Source

Application type

Country of Origin

  • IN flagIndia

Platforms

  • Mac
  • iPhone
  • iPad
  No rating
0likes
0comments
0news articles

Features

Suggest and vote on features
  1.  SQLite
  2.  Database Management Tool

 Tags

Sqlite Page Explorer News & Activities

Highlights All activities

Recent activities

Show all activities

Sqlite Page Explorer information

  • Developed by

    IN flagSiara Logics
  • Licensing

    Open Source (Apache-2.0) and Free product.
  • Alternatives

    118 alternatives listed
  • Supported Languages

    • English

AlternativeTo Categories

Office & ProductivityDevelopment

GitHub repository

  •  23 Stars
  •  4 Forks
  •  3 Open Issues
  •   Updated Jul 2, 2025 
View on GitHub

Popular alternatives

View all

Our users have written 0 comments and reviews about Sqlite Page Explorer, and it has gotten 0 likes

Sqlite Page Explorer was added to AlternativeTo by Paul on May 28, 2019 and this page was last updated Sep 18, 2019.
No comments or reviews, maybe you want to be first?
Post comment/review

What is Sqlite Page Explorer?

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 from Sqlite website.

Applications:

  • 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

Features

  • 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

Usage

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.