Current version: v1.9.13β (public beta) | Changelog
License: GNU General Public License v3.0
Українською
SQLantern is a database manager (more like a data viewer) in a web-browser, 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).
Build a high tower of panels, or a long wall, or combine both to build the Great Wall of Panels.
Organize your work how you like.
SQLantern is an in-browser web-application (a single-page application), written in HTML, CSS, JavaScript, and PHP.
It requires a web browser and a web server or Docker to work.
It currently supports MariaDB/MySQL and PostgreSQL.
It is open source and free software.
This tool is aimed at people who work with databases in the same manner I do:
- ALWAYS with multiple database tables,
- MOSTLY with multiple databases,
- VERY OFTEN with multiple database servers.
SQLantern unifies that kind of work in one browser tab/window.
If that's how you work and what you need, check it out.
Visiting the official demo is highly recommended: https://sqlantern.com/
(It's better to see and try something than read about it, right?)
There are 4 kinds of panels in SQLantern, and any amount of panels of any kind can be open at the same time, and reordered as you like.
There are no limitations on the number of open panels, only your device's resources are the limit (mostly RAM).
Whatever you intend to do and whichever set of panels you end up with, this is always the start.
The Connections panel can display a form to add a new connection, a list of currently available connections, or both.
When you add a connection or click one of the connections in the list, the next kind of panel opens up...
This is the list of databases at the specified server the chosen login has access to.
As usual, you can have multiple different database lists on the screen (different logins and/or servers), or multiple instances of the same list.
This is the list of tables in the chosen database.
Click one of the tables to open the most important type of panel...
Those panels are, in fact, arbitrary SQL requests panels, they just happen to start with a chosen table data for users' convenience.
You can and are supposed to run any queries you need in those panels.
You can have multiple panels with data from different tables side by side:
Or multiple panels with the data from the same table:
All in all, SQLantern displays data side by side from the same table or from different tables, from the same database or from different databases, from the same server or from different servers, all in the same browser tab.
Putting too much side by side is not always logical and convenient, even when working within one database.
To add one more dimension to panels, multiple "screens" are available.
A screen is an independent set of panels.
(You can only see and work on one screen at a time.)
Click the "Add Screen" icon to add a screen:
Click "Previous screen" and "Next screen" to go to the adjacent screens:
Click "Switch screen" to switch to an arbitrary screen or move panels between screens:
SQLantern is not a replacement of the fully-feature-packed alternatives (like DBeaver, Navicat, pgAdmin, and even phpMyAdmin or adminer). SQLantern is designed to complement them, not replace them.
It doesn't have many of the functions the alternatives have, but the alternatives also don't provide what SQLantern offers, which in my mind makes almost any comparisons unreasonable.
In my opinion, popular database managers (even as basic as phpMyAdmin and adminer) are very good in database management and database design, but even the most sophisticated ones are barely acceptable for viewing the data and working with the data. So, that's the gap SQLantern is intended to fill: it has no database management and design features, but focuses on displaying the data conveniently and efficiently.
(And naturally you can run any SQL request and manage the databases with manual commands. There are just no visual features, which would simplify it.)
Use login example to connect as user example to the default host using the default port.
Default host is localhost and default port is 3306 (both are configurable).
Login example is the same as example@localhost, and the same as example@localhost:3306.
To connect to a non-default host, add "@" followed by the host name or IP.
E.g. example@example.com, example@1.1.1.1.
Multi-host must be enabled to connect to other hosts (see server-side options further below).
IPv6 have never been tested and most probably won't work.
Default host can be any host or IP, local or remote.
If you need to connect to only one host, but it's not localhost, don't enable multi-host connections, only change your default host (see server-side options further below).
To connect to a non-default port, add the host (even if it's a default host), followed by ":", followed by the port number.
E.g. example@localhost:33306, example:1.1.1.1:30306.
You have to always specify the host when using a non-default port, even when connecting to the default host.
You must first configure custom ports in the server-side options to use to use any non-default ports at all (see server-side options further below).
You can have a default port other than 3306, that is also changeable in server-side options.
Profiling is a very potent and extremely important feature of SQLantern, hidden behind a small icon, which makes it easy to miss if you don't know it's there.
(Although it is one of the core features and reasons SQLantern was created in the first place.)
The stopwatch icon in any tables' panel will toggle that panel between the tables' list and query profiling.
Profiling has it's own dedicated README file.
SQLantern works both inside a website directory (like https://example.com/sqlantern) or on a subdomain (like https://sqlantern.example.com/).
Any query can be run recurrently, endlessly, with an arbitrary pause between runs.
Although rarely needed, it's a nice feature to have when monitoring some progress or even for the obvious SHOW FULL PROCESSLIST.
Press an arrow next to "Run" to open the timer setting. When this setting is open (visible), the query will run periodically.
Multiple queries can be run recurrently in parallel, in different panels.
Panels can be named to add context (use the pen icon: 
Tab pressed inside the Query inserts a Tab character in place.
Tab when multiple lines are selected adds a Tab character at the start of each line (like you'd expect in a text editor).
Shift + Tab with multiple lines selected removes a Tab character from the start of each line (like you'd expect in a text editor, again).
Enter inserts a new line.
Ctrl + Enter runs the query.
To go to an arbitrary page of a multi-page data list, you can click the page number input, change it to a desired value, and press Enter.
SQLantern supports MariaDB/MySQL and PostgreSQL out of the box.
If you need other database systems, please help me write the server-side code for it (it's not a big deal, I promise).
Only single query execution in each Query field is implemented and it will stay this way.
(A possible workaround is abusing the text input in "Import", but you won't get results for SELECTs, only the overall quantity of executed queries.)
There is a built-in Notepad for text notes, which is saved to an internal browser storage per-domain ("LocalStorage").
I.e. this text is only there as long you are in the same browser on the same domain. Different browser = different Notepad. Different domain = different Notepad. (Same browser in incognito mode = different Notepad, as well.)
There are no database design features and there won't be any, to keep the code lightweight. Please, do not treat it as an issue, database design features are not planned to be added.
The project is intended to be used as one of the tools (alongside phpMyAdmin, Adminer, PgAdmin, or any other software of preference), not the one and only tool.
A server with PHP 5.6+ or Docker
Sessions enabled in PHP
A web browser with enabled cookies
DOES NOT need internet connection (contains no external links/resources)
Tested with:
- MariaDB 10.1.37+ (released in 2018)
- MySQL 5.5.52+ (released in 2016)
- PostgreSQL 11.12 (released in 2021)
There is no installation procedure, SQLantern works right away after deploying the source files.
There is a full version, a single-file version, and CMS-integrated versions (for Joomla and OpenCart).
The version to choose depends on your needs.
As of SQLantern 1.9.13, the single-file version is fully configurable on the server-side, which makes it as flexible as the full version.
If you're experienced with git and want easy updates or need a customly configured fork, you should clone this repository.
I see no real reasons to use the full version without git since version 1.9.13.
Maybe if you require custom configuration, but cannot set environment variables.
This is my top recommendation, because these versions are the most secure, easy to install and straightforward, giving a two-click immediate access to the website database.
If you only need to work with that single database, check this version out.
The downside is, of course, that you can only access a single database. Adding other connections is not possible.
Currently only available for Joomla (v3.x, v4.x) and OpenCart/ocStore (v2.3, v3.x).
Read more in the dedicated GitHub repository.
Download the zip files from sqlantern.com or the dedicated GitHub repository and install it just like any other extension inside your CMS.
This is my second recommendation for most users which works in 99% of situations.
If you can't or don't want to use git, or unzip files on the server (and maybe you only have FTP access and that's it), or upload multiple files, this is the version to use.
I believe it's the "one size fits all" version for the widest audience. It's the fastest one to deploy (the most portable) and works in all cases. And it's also more friendly for the less experienced folks.
Even I myself always use it with the new projects, it's just faster.
The only difference from the full version is that single-file SQLantern doesn't read configuration files at all ("config.sys.js" and "config.sys.php"), but it is rarely important, because it can be configured via environment variables since version 1.9.13.
Download the file "sqlantern.php" from sqlantern.com or "Releases" of this GitHub repository, and copy it to a desired location.
If you don't use PHP in your stack (or just prefer Docker over other options), there is a small footprint SQLantern Docker container (~30MB).
Read details in the Docker hub repository, or download and build the Dockerfile from GitHub.
Clone this repository to a location of your choice:
git clone https://github.com/nekto-kotik/sqlantern.git (will create "sqlantern" subdirectory)
or
git clone https://github.com/nekto-kotik/sqlantern.git . (will clone into current directory)
The only upside of this version, in my opinion, is easy further updates with git pull.
Download the full version zip from sqlantern.com or "Releases" of this GitHub repository, and unzip it in a desired location.
If your browser discards the tab, SQLantern automatically restores itself when you return to it.
However, it won't (can't, really) automatically self-restore after the browser has been closed or the page is manually refreshed.
So, if you need to continue your work from where you left it, save your session and restore it when you return (under the Sessions icon, 
The other option is not closing the browser at all (put your device into sleep or hybernation).
Read more about it in the "Save your current workspace" section in docs/sqlantern-how-to.md
SQLantern uses "LocalStorage", which requires enabling cookies (at least for the domains where you're using SQLantern).
(That's right, enabling cookies also enables LocalStorage, don't ask...)
LocalStorage is used to store settings, working sessions, saved queries and the built-in Notepad.
If LocalStorage is disabled, SQLantern doesn't run at all, and no error is given.
Be advised that working with confidential data on untrustworthy devices is always risky.
SQLantern should not be used on devices shared with random or suspicious users, or strangers.
You might accidentally unknowingly erase your whole LocalStorage completely when clearing browsing data.
Different browsers do it a bit differently: some clear LocalStorage when deleting cookies, others have a dedicated "clear data" checkbox, etc.
What's important is that you can accidentally lose all your SQLantern data on all domains (settings, sessions, saved queries, notepad).
You can mitigate it by using the built-in backups.
Read about it in the "Save your current workspace" section in docs/sqlantern-how-to.md
Two languages are shipped with SQLantern: Ukrainian and English.
Any translation volunteers out there? :-)
Export/Import are currently only available with MariaDB/MySQL. PostgreSQL support will be added in version 2.
There are no export issues I'm aware of.
Exported data is a standard SQL dump and can be imported in any other program.
On the other hand, import is built on compromises and sometimes fails with "Server has gone away" or "Server not responding".
The only reason I was able to discover is that it can run the server completely out of RAM.
It is some weird interaction between PHP and MariaDB/MySQL, because the database import in SQLantern can go far beyond PHP memory limitations and use all the server's RAM (and swap!).
That's when you may get "Server has gone away" - the server runs out of all RAM (and swap!) and restarts MariaDB/MySQL service to free it (because technically speaking it's MariaDB/MySQL using all the memory when that happens, not PHP).
The good news is that I've only seen it on very resource-limited servers with relatively small amounts of RAM (4Gb or below).
I don't consider this a high-priority issue, because SQLantern wasn't initially supposed to have Export and Import at all.
These functions are an afterthought and bonus content, so enjoy them if they work for you, and I'm sorry if they don't, but it probably won't be fixed.
Export and Import of MERGE tables are not supported.
PROCEDUREs, FUNCTIONs, TRIGGERs and EVENTs are not exported because of the very widespread DEFINER conflict when importing.
Please, read the Won't Fix list further below, too, for more Known Issues, which I don't consider issues.
Many settings are configurable visually, but they are only stored in the browser per-domain, and if you need multiple copies with the same settings, here is another way to configure SQLantern for mass-deployment.
Besides, there are configurable options absent from the visual settings.
When php/config.sys.php or js/config.sys.js are mentioned below, you must create those files yourself or edit existing files (under the SQLantern root directory).
This way, when you update your copy of SQLantern, your custom configuration is left intact (php/config.sys.php and js/config.sys.js are not part of SQLantern, they are designed to be custom-only and per-client).
This also allows you to have your own fork (with your own configuration) to clone/deliver on your servers instead of the official SQLantern repository (and get the same custom configuration on multiple locations with zero merge issues).
Add "config.language = 'uk';" into js/config.sys.js.
Use "en" for English, "uk" for Ukrainian. Those are the only two languages available currently out of the box.
Auto-resize is enabled by default, but this can be changed by adding "config.default_auto_resize = false;" into js/config.sys.js.
The Query textarea is visible by default, but you can hide it by clicking the Query text.
It can be hidden by default (in all new panels), if you don't usually write your own queries.
Add "config.default_open_query = false;" into js/config.sys.js to make it hidden by default.
Automatic colour coding in SQLantern is enabled by default: each new open database gets a random colour, and then the tables open from this database inherit that colour.
Or, in other words, all tables of the same database are colour coded automatically.
This auto-colouring can be disabled by adding "config.auto_color = false;" into js/config.sys.js. All new panels will be the same default colour in this case.
You can add your own CSS on top of the existing default style without changing the original CSS (and update without merge later)!
Add "config.styles = '{filename}'" into js/config.sys.js to do that.
All paths must be inside the "css" directory, and file names must be written without the ".css" extension.
(In other words, remove "css/" from the beginning and ".css" from the end.)
E.g. "config.styles = 'sqlantern/td-400';" to enable a CSS file actually named "css/sqlantern/td-400.css".
You can add multiple CSS files! Separate them with a space in this case.
E.g. "config.styles = 'sqlantern/td-400 my/custom';" to add two files: "css/sqlantern/td-400.css" and "css/my/custom.css".
There are two ways to configure the server-side of SQLantern:
- It is usually easier to use environment variables to set the values
The most common way is to use.htaccess:
E.g.SetEnv SQLANTERN_DEFAULT_HOST "remotehost"to set the default host,SetEnv SQLANTERN_MULTIHOST "true"to enable multi-host connections.
You can also usually useSetEnvIfto set the environment variables only when certain conditions are met (e.g. only allow server-side backups for certain IP address or addresses). - Create the
php/config.sys.phpfile
Adddefine("{optionName}", {desiredValue});intophp/config.sys.phpto change default values.
E.g.define("SQLANTERN_DEFAULT_HOST", "remotehost");to set the default host.
Single-file version does not read the php/config.sys.php file and is only configurable via environment variables.
Only the most important options are listed below. See the top of php/index.php for all the options with explanations.
SQLANTERN_DEFAULT_HOST (string) sets default host.
Default host is applied when a login without a host is used ("notroot" being a login without host, "notroot@192.168.0.0" being a login with host). A hostname or an IP address can be used.
Default value is "localhost".
SQLANTERN_DEFAULT_PORT (string) sets the default port.
Default port is applied when a login without a port is used ("notroot" being a login without a port, "notroot@localhost:33006" being a login with a port).
Default value is "3306".
SQLANTERN_SHORTENED_LENGTH (int) sets the length, to which the values are shortened, when "Full texts" is not checked.
Default value is 200.
SQLANTERN_MULTIHOST (boolean) enables and disables multi-host operation.
When false (default), the SQLantern instance will only exclusively connect to the SQLANTERN_DEFAULT_HOST host and won't allow other hosts.
Default value is false.
Beware that enabling it basically allows using your copy of SQLantern to brute force or DDOS attack other servers.
Please, protect your SQLantern instances with additional measures when you enable multi-host operation (e.g. filter access by IP).
What should you do when you get CONNECTION FAILED while working with the database?
How to connect to PostgreSQL?
How to use non-standard ports?
How to connect to a database with SSL?
How to configure single-file version?
Answers to these questions and other tips and tricks are gathered in the dedicated how-to document.
Running multiple queries from one Query input isn't supported and isn't planned.
Trying to run multiple queries in one Query box (separated by ";", which is legal directly in console or in e.g. phpMyAdmin) results in an error.
There are no data editing features. And I don't think we'll implement any, ever.
Again, SQLantern is not intended to replace or imitate classical powerful database managers, it is made to complement them.
There are no limits/breaks/pages in database lists and table lists.
E.g. if the login you use has access to 1000+ databases or tables, all of them will be listed in one big list, without any pagination.
There is no grouping or tree-like display of databases or tables, and there won't be any.
When querying large tables with a high LIMIT value, server or browser might run out of memory (or the server might run into a timeout).
SQLantern doesn't force break the results into pages for queries with LIMIT, because I assume that if your query has LIMIT/LIMIT ... OFFSET, you need it and that's your resposibility.
(But results for queries without LIMIT are broken into pages.)
There is no auto-complete and it is not planned, as I hate it and disable it everywhere for myself (where possible).
This project is published under a "viral" license, which many find pretty hardcore, be wary of it.
If you're only using SQLantern for yourself for ANY purpose without changing the source code and/or redistributing it, this does not affect you at all - you can use the program for free in any way you want, don't worry about it.
A reasonable complete guide will be published somewhere before version 2.
Version 2 should be released until the end of 2025 and will have the following improvements:
Support Views(since version 1.9.2)A way to backup the whole LocalStorage (configuration, sessions, saved queries, notepad) on to the server or to the client(since version 1.9.13)
(against accidental erase by the user)Rows per page will be a customizable drop-down select (per-panel)(since version 1.9.13)More settings will be visually configurable(everything planned for Version 2 is implemented in version 1.9.13; there will be more later)- PostgreSQL export and import
- SQLite driver (PHP)
- Download "binary" data
MS SQL driver (PHP)(it takes more effort than I expected and is not planned in Version 2 anymore)
Version 3 should be released in 2026, with only one new major feature:
- Sharing sessions
- Ability to share everything you have open with just a single link.
- It sounds dangerous and there are risks involved, but the idea is well-thought-through and will be as secure as possible with some additional security options (like self-remove after the first use).
Beyond Version 3...
There are no more detailed further plans.
But the further (very low priority) desired features look like that (in random order):
- Fully working mobile version
- More GUI settings
- Restore closed panels/screens (panels history)
- Manual panel resizing (width)
- RTL support
- More database drivers
- Horizontal split for 4K and higher resolution displays (fit two screens on one, maybe four screens)
- Prolong/renew PHP sessions automatically
- I'm on the fence, there are importants cons against doing that
- Back-end in other program languages
- Fully local portable desktop version (still working in browser, but not needing a server for the back side; the Docker version sort of solves it however)
SQLantern PHP code:
(C) 2022, 2023, 2024, 2025 Misha Grafski aka nekto
SQLantern JS, HTML, CSS code:
(C) 2022, 2023, 2024, 2025 Svitlana Militovska
Simplebar:
Made by Adrien Denat from a fork by Jonathan Nicol
https://github.com/Grsmto/simplebar
If you feel an absolutely unstoppable desire to make a donation to the SQLantern authors, you can buy us a coffee.
GitHub Sponsors are not available in Ukraine yet (where we reside).
If you are making a proprietary or closed source app and would like to integrate SQLantern into it, contact sqlantern@sqlantern.com for non-GPLv3 licensing options.