Everything you'd expect.
And the things you wouldn't.

The tokenizer recognizes 612 SQL constructs across keywords, functions, types, and constants. Each gets its own color in every theme. Strings, comments, hex literals, binary literals, session variables — all handled.

Autocomplete is two-pass and context-aware. Type a table alias and a dot, and you get its columns — not every column in the database. The system understands FROM, JOIN, INTO, and UPDATE clauses, then re-classifies identifiers throughout the query so aliases work backward as well as forward.

• EXPLAIN visualizer. Color-coded access types, warning badges on filesort and temporary, row counts highlighted.
• Multi-statement execution. Paste a migration with multiple CREATE / INSERT / ALTER statements — each runs in sequence with its own result card.
• DELIMITER directives parse correctly. Stored procedure bodies with BEGIN...END// work.
• USE works mid-script. CREATE DATABASE bootstrapping scripts run end-to-end.
• Persistent drafts. Editor content auto-saves per database. Navigate away and back — your query is still there.

Click any cell, type, press Enter. AJAX save, green flash on success. The page doesn't reload. Your scroll position holds. Your filters hold.

Tab moves to the next cell. Long values auto-promote to a resizable textarea between 60 and 300 pixels tall. NULL is a checkbox for nullable columns.

• FK drill-down. Foreign-key values render as clickable links. Click to jump to the referenced row in the target table with an exact-match filter applied.
• Row detail panel. Eye button slides out a panel with every column vertically, full untruncated values, type badges, drill-down links.
• Bulk operations. Checkbox select-all with indeterminate state, themed confirmation modal, single DELETE WHERE IN (...) under the hood.
• Insert Row. Auto-generated form per table — date pickers for DATE, enum dropdowns, NULL checkboxes, "Insert another" toggle for batch entry.
• Favorites. Star tables from anywhere. Starred ones surface in a dedicated section at the top of the sidebar.

The feature phpMyAdmin doesn't have. Type a value, get back every match across every table in the database — grouped by table, with matched columns highlighted.

Useful for tracing FK values, finding where an email is stored, locating orphans, or just asking "where the hell is this id?" without opening tables one by one.

• Prepared statements throughout. No string concatenation, no injection risk.
• BLOB / BINARY / GEOMETRY skipped automatically.
• Up to 5 sample rows per table with the search term wrapped in highlights.
• "View all matches" link opens the table's Browse tab with the filter pre-applied.

Every table renders as a card with key icons, column types, and nullable indicators. Relationships use crow's foot notation — three-pronged fork at the FK end, double bars at the PK end.

Drag tables to reposition. Pan with empty-space drag. Zoom with scroll wheel. Auto-layout runs a force-directed physics simulation if you want to start fresh.

• Layout saves per database to logs/er/. Reopen and everything is exactly where you left it.
• Reset button deletes the saved layout and rebuilds from auto-layout against the live schema.
• Right-click context menu — Browse Data, Structure, SQL Editor, Export SQL.
• Hover to highlight relationships — connected lines brighten, unrelated tables dim.
• Three line styles: curved, elbow, straight.

Most database tools wave at these. Ledger gives every one the same treatment as tables: full CRUD with syntax-highlighted definitions, skeleton templates for new objects, drop-then-recreate with rollback for edits.

• Views — listed alongside tables in the sidebar, full CRUD, browse view data like a table.
• Triggers — timing + event color-coded badges (BEFORE/AFTER, INSERT/UPDATE/DELETE), inline editor.
• Routines — stored procedures and functions, parameter modes shown (IN/OUT/INOUT), DETERMINISTIC flag, skeleton templates.
• Scheduled events — full schedule display, one-click enable/disable, last-execution timestamps.
• Scheduler status check — warning banner when event_scheduler = OFF and events exist. Easy to miss otherwise.

A dedicated top-level Processes tab turns Ledger from a schema editor into a tool you keep open. It shows SHOW FULL PROCESSLIST with header stats, auto-refresh, and color coding so the things that need attention pop visually.

• Auto-refresh — off, 2s, 5s, or 10s. Filter and scroll position preserved across refreshes.
• Color-scaled query time — gold at 3s, amber at 10s, red at 60s. Sleeping connections stay dim regardless.
• Hide-sleeping toggle for quiet servers where 90% of connections are idle.
• Current-session marker — a green star marks your own connection. Self-kill blocked in UI and enforced server-side.
• Kill button shows the query being terminated in the confirm modal so you don't kill the wrong thing.

Every query you run is logged with its target database, execution time, result count, success/error state, and on failure the full PDO error message.

• Tinted rows — success green, error red — that adopt each theme's accent colors.
• Click to expand for the result summary or error detail. Click again to collapse.
• Load button pastes the SQL back into the editor.
• Search/filter entries by SQL content as you type.
• Duplicate suppression — re-running the same query updates the existing entry instead of stacking a new one.

Create tables with a visual form and a live SQL preview that updates as you type. Edit columns inline. Manage indexes with composite-key support. Run maintenance from one panel.

• Visual CREATE TABLE form with column rows, type datalist, auto-wiring (Auto Increment → PK), and live syntax-highlighted SQL preview.
• Inline column editing via ALTER TABLE CHANGE COLUMN with type, nullable, default, comment all editable.
• Index management — composite keys on one row, kind badges, click-to-select column picker with numbered order badges.
• Partition management — RANGE, LIST, HASH, KEY methods. Per-partition Optimize, Rebuild, Truncate, Drop.
• Maintenance panel — Optimize, Analyze, Check, Repair with inline status.
• Foreign key visualization — both incoming and outgoing constraints with cascade rules color-coded.

Import SQL or CSV with drag-and-drop. The SQL splitter handles backticks, doubled-quote escapes, hash comments, conditional /*! */, and DELIMITER directives — so stored procedure dumps from mysqldump import cleanly.

Export gives you a mode selector (Structure / Data / Both) and a style selector (Single-statement / phpMyAdmin-compatible). The phpMyAdmin format is byte-for-byte interchangeable with their dumps — useful when migrating between tools.

• 4-pass phpMyAdmin format — tables → data → indexes → constraints. All tables created before any FK references them.
• Per-statement results on import — success/error counts, rows affected, execution time per statement.
• CSV import with delimiter (comma / semicolon / tab / pipe), enclosure, header-row toggle. NULL strings auto-convert.
• Drag-and-drop for both SQL and CSV with hover preview.

Security is built in from the first request, not bolted on. The installer enforces credential setup before anything else loads — there's no default admin/admin to forget about.

• Bcrypt password hashing ($2y$10$). Per-user TOTP 2FA, RFC 6238 compliant.
• CSRF tokens generated per session, validated on every POST and AJAX mutation.
• Brute-force lockout — configurable threshold and duration. Counts password and 2FA failures.
• IP whitelist with CIDR support, checked before anything else loads.
• Read-only mode with multi-statement-aware enforcement — USE foo; DROP TABLE bar; is rejected as a write.
• Hidden databases filtered from the sidebar, autocomplete, URL access, and exports.
• Query audit log with timestamp, username, database, IP, execution time.
• .htaccess rules blocking direct access to config.php, includes/, logs/.