The database tool phpMyAdmin should have been.

phpMyAdmin's config.inc.php is 400+ lines and requires a blowfish secret you'll immediately forget. Ledger detects a missing config on first request and runs an interactive installer that writes the file for you. No shell, no manual edits.

No composer install, no npm install, no build step, no vendor directory bloat. The entire frontend is hand-written vanilla JS with a custom SQL tokenizer. The repo is exactly the files that ship.

A complete docker-compose.yml with Ledger + MySQL 8.0, healthchecks, persistent volumes for data and config, environment overrides, and a quick-start README. One command to a working database + UI.

Custom-written SQL tokenizer with 612 entries (keywords, functions, types, operators). Autocomplete triggers on dot-access showing columns per table, on FROM showing every table, on function names showing signatures. Ctrl+Enter runs the query; Ctrl+Space forces completion; Ctrl+/ toggles comments.

Click any cell to enter edit mode. Short values use a text input, long values auto-switch to a textarea. Press Enter or click away to save via AJAX. Escape to cancel. Failed edits show the PDO error inline without losing your input. Bulk select + delete with confirmation modal.

Any foreign-key column in a browse view becomes clickable — jump straight to the referenced row in the parent table. This is the one feature every DB tool should have and almost none do. Drill from orders → users → subscriptions → invoices in four clicks.

One search box. Enter a value. Ledger introspects every text-compatible column across every table in the current database, runs LIKE queries in parallel, and returns grouped results with matching columns highlighted. Click any result to jump to that row.

Every query you run in the session is logged with timestamp, type (select/modify), row count, execution result, and full PDO error text on failure. Rows are tinted green/red by outcome. Click any entry to expand; click the load button to drop it back into the editor.

Named, persistent per-user saved queries. Star tables for quick sidebar access. The SQL editor keeps persistent drafts across sessions — close the browser, come back, your half-written query is still there.

Create, edit, and drop views with the same syntax-highlighted editor as the main SQL console. Edit performs a CREATE OR REPLACE atomically. Skeleton template pre-fills the CREATE VIEW statement so you don't have to remember the grammar.

Editing a trigger requires DROP + CREATE (MySQL doesn't support ALTER TRIGGER). Ledger wraps this in a transaction-like flow: the old trigger is saved, dropped, the new one is created, and if creation fails, the old version is restored automatically. No more silently broken triggers.

Stored procedures and functions share the same editor flow. Skeleton templates for both forms. DELIMITER handling is automatic — paste a multi-statement procedure with BEGIN/END and it just works. Dropping is confirmed with the routine's full signature shown in the dialog.

Ledger checks @@event_scheduler on every visit to the Events panel. If it's OFF, you see a red warning banner explaining your events won't fire. Individual events can be enabled or disabled with a toggle. The definition editor shows skeleton examples for both one-shot (AT) and recurring (EVERY) schedules.

Pure SVG diagram generator, no libraries. Introspects FKs from INFORMATION_SCHEMA and renders tables with columns, PK/FK markers, and relationship lines in your choice of straight, orthogonal, or curved style. Drag tables to reposition. Layout auto-saves per database. Right-click any table for a context menu with edit/drop/browse.

Full partition management through the UI — partition an unpartitioned table, add a new partition to an existing scheme, drop or truncate individual partitions, optimize or rebuild in place. Per-partition row counts shown in the panel. All generated SQL is previewable before execution.

SHOW FULL PROCESSLIST rendered with live stats (total, active, sleeping, longest-running), 2/5/10-second auto-refresh, text filter, hide-sleeping toggle, and a marker on your current session. Query duration is color-scaled: gold at 3 seconds, amber at 10, red at 60. One-click kill with a confirmation modal showing the exact query being terminated. Self-session kill is blocked.

OPTIMIZE, ANALYZE, CHECK, and REPAIR all accessible per-table from the Operations panel. Results are shown with full server output including any warnings. Bulk operations let you run analyze or optimize across every table in a database with a single click.

Per-user accounts with bcrypt-hashed passwords (cost 12). Optional per-user TOTP 2FA — scan a QR code with Google Authenticator or any RFC 6238 client. Session tokens, CSRF tokens on every mutating request, lockout after failed attempts, password reset flow. No defaults, no "restrict at the web server level" cop-outs.

Each of the 20 themes is a complete design system — not just accent colors. Covers syntax tokens (20+), data table rows, modal chrome, buttons, badges, panels, editors, and more. 10 dark variants (Dracula, Tokyo Night, Monokai Pro…) and 10 light variants (GitHub Light, Atom One Light, Clean…). Switch instantly from the header dropdown.