SQLantern - a unique multi-panel database tool

SQLantern is free, open-source software.
Published under the GNU GPLv3 License, free to use for anybody anywhere.
Check out the
Demo
Supported databases
PostgreSQL
Under development
SQL Server
Single-file SQLantern
  • Download sqlantern.php
  • Rename it (optional, recommended)
  • Copy it to your FTP
  • Open it in your browser
  • (Configure via `.htaccess` if needed)
Dockerized SQLantern
  • Run `docker run --rm -d --network host nektowastaken/sqlantern`
  • Open http://localhost:1111/
  • (Recommended to run locally)
Using Joomla or OpenCart?
Joomla Opencart
Check out our other products
mintyPoint - chrome extension
Leave comments on web pages and meet new people as you surf the web
mintyPoint
Ultimate OpenCart Profiler
A diagnostic tool for OpenCart to find and reveal all the slow places and irregularities precisely, fast and easy
Profiler

SQLantern provides...

Open database tables side by side
Construct complex database queries step by step and side by side
Construct and comprehend complex database queries step by step and side by side
SQLantern works with MariaDB/MySQL and PostgreSQL
Save and restore sessions when working with databases
← prev
next →
  • A unique way to work with databases truly side by side
Display database tables side by side
  • A unique way to construct complex queries step by step and side by side
Write complex database query side by side
  • A unique way to deconstruct complex queries step by step and side by side
Deconstruct complex database query side by side
  • Working with MariaDB/MySQL and PostgreSQL
    side by side if so desired
SQLantern for MariaDB/MySQL and PostgreSQL
  • A unique ability to save and restore working sessions
Save and restore sessions working with databases

And also...

← prev
next →
Flexible panels' organization
Use one "screen" or multiple "screens".
Drag and drop panels as you need, on the same screen and between screens, both full size and minimized panels.
A dedicated flexible multi-step profiler
Measure performance of a single query, compare multiple variants of the same query, or profile a sequence of queries.
Convenient auto-resize of the query input
The input grows and shrinks, adapting to the query.
No wasted empty space.
Panels' minimization
Minimize panels for better work management and clutter control.
Per-panel comments
Visible in both full size and minimized panels.
Panels' comments are saved into sessions.
Multiple internal screens
Panels can be moved between screens.

But wait, there's more!

Auto-repeat queries
Monitor processes, statistics and data changes
Duplicate panels for smooth query evolution
Don't lose intermediate working queries
Per-panel history of queries
Contextual queries' history, preserved after panel duplication
Helpful panels' colour-coding
For both full size and minimized panels
Parallel multi-server and multi-database connections
Work with multiple databases side by side