renzume.

Database Tools

GitHub - nexsol-technologies/pgassistant: PgAssistant is an open-source tool designed to help developers understand and optimize their PostgreSQL database performance.

PgAssistant is an open-source tool that helps developers analyze and optimize PostgreSQL database performance through features like schema optimization, query management, and AI-powered assistance. The tool integrates with OpenAI and local LLMs for query optimization while offering practical features like SQL linting, DDL generation, and PGTune integration.

GitHub - QuadrupleA/sqlite-page-explorer: Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them.

SQLite Page Explorer is a cross-platform GUI application that allows developers to examine SQLite databases at the page level, providing insights into B-Trees, index structures, and storage efficiency. Built with redbean, it's distributed as a single 6.5MB executable that runs natively on multiple operating systems and architectures.