SQLantern

SQLantern is a database tool designed for high productivity, with a fresh concept: displaying multiple database tables side by side in separate panels.

It is a tool for all kinds of database users, professionals and amateurs alike: programmers, QA specialists, database architects, analysts, database administrators.

It turned out to be very useful for educational purposes, demonstrations, teaching, and learning.

It is a parallel, multi-threaded (each panel works independently), multi-server, multi-login, multi-database, multi-table data management tool.

You can view the data horizontally (panels) and/or vertically (screens).

SQLantern has working sessions, meaning you can save and later restore the whole workspace (all open databases, tables, queries, etc). You can save a session, take a break, power off, and return to the project at any later time, not needing to keep the program open all the time.

SQLantern has a dedicated built-in query profiler, which can measure performance of a single query, compare multiple variants of the same query, or profile a sequence of queries. It is especially useful considering you can duplicate panels and compare old and new values side by side. You can also save profiling data in a session and check it later to see if a degradation happened.

SQLantern requires a web browser and a web server or Docker to work. It currently supports MariaDB/MySQL and PostgreSQL. Is has a single-file PHP version. It is open source and free software.