Browse and edit databases: SQLite and H2 files, MariaDB/MySQL, PostgreSQL, SQL Server, Redis and MongoDB — tables, SQL console, export. Ships executable code.
Install in Lumen: add the server, then pick Databases from the list.
http://localhost:8730
Browse and edit databases directly in Lumen — files and servers:
| | | | --- | --- | | SQLite | .db, .sqlite, .sqlite3, .db3 — works on the file itself, no copy | | H2 | .mv.db — needs Java 11+; the H2 driver is downloaded from Maven Central on first open | | MariaDB / MySQL | all databases of the server as schemas | | PostgreSQL | schemas, tables, views | | SQL Server | also with an ADO.NET connection string | | Redis | search keys, edit values per type (string, hash, list, set, sorted set, stream), TTL | | MongoDB | databases, collections, documents as Extended JSON with filter and sort |
+), open a file, connect.A database file in the explorer can also be opened directly — Lumen asks whether it should go into the database view.
sortable by clicking the column headers, filterable with a SQL condition.
pending change until you click Commit. Then everything runs in one transaction; if a statement fails, nothing is written. Show SQL shows the statements beforehand.
statement; the results appear below.
Scopes. A connection is either application-wide (stored in Lumen, available in every window) or project-wide (stored in .lumen/database-connections.json of the open folder, so it can be committed and shared; the Available in field of the form appears when a folder is open). Passwords are never part of that file — each person is asked once or saves it in their own key store. Switching the scope moves the connection.
Passwords are stored encrypted in the system keychain, never in the settings. If you prefer not to save a password, you are asked for it when connecting.
Rows per page, confirmation before committing, CSV separator, maximum rows shown for a query, query timeout, keys per Redis search, path to Java and the H2 version.
rowid) and PostgreSQL(ctid), which can address every row that way.
be cancelled through the timeout.
This extension ships executable code (the drivers are bundled in it) and is shown for approval before installation.
pageSize — Rows per pageconfirmCommit — Ask before committingcsvSeparator — CSV separatormaxRows — Maximum rows in a query resultqueryTimeout — Query timeout (seconds)redisScanLimit — Maximum keys per searchjavaPath — Path to javah2Version — H2 version