SQLite Page Explorer is a GUI app created in redbean that allows you to explore SQLite databases “page by page.” By delving into the page level, you can gain insights into the structure of indexes, optimize storage for faster queries, identify issues not visible at the schema level, and develop an understanding of B-Trees. Additionally, the app is conveniently portable, running on various operating systems with a single executable file. While not perfect, as it was an experiment with redbean and Lua, the app welcomes contributions and suggestions for improvement. To try it out, simply download the necessary files and enjoy exploring your SQLite databases in a new way.
https://github.com/QuadrupleA/sqlite-page-explorer