New v1.0.0-beta — first public release

The database tool
phpMyAdmin should have been.

A modern, lightweight alternative for MySQL and MariaDB. Pure PHP and vanilla JavaScript. Zero dependencies, no build step, no Composer. Drop a folder. Run the installer. Manage your databases.

Get started Explore features
MIT licensed PHP 7.4+ Self-hosted Open source
612 SQL tokens
Live processes
ER diagrams

A real database admin tool

Browse Edit Query Visualize Search Export Manage
Built for daily use

Designed around how you
actually work with databases.

No more textareas with color. No more page reloads on every edit. No more opening tables one by one to search.

Real SQL editor

A custom 612-token tokenizer with context-aware autocomplete. Type a table alias and a dot — get its columns, not every column in the database.

Inline cell editing

Click any cell, type, press Enter. AJAX save with a green flash on success. No full-page reloads, no redirect cycles, no losing your scroll position.

Interactive ER diagrams

Pure-SVG entity diagrams with crow's foot notation. Drag tables, auto-layout, save per database. Right-click for context menu — Browse, Structure, SQL.

Search every table at once

Find a value across an entire database in a single query. Skips BLOBs, prepared statements throughout, results grouped by table with matched columns highlighted.

Live process monitor

SHOW FULL PROCESSLIST with 2/5/10s auto-refresh, color-scaled query time, one-click kill, current-session marker, filter, hide-sleeping toggle.

Security built-in

Bcrypt + optional TOTP 2FA, CSRF on every mutation, brute-force lockout, IP whitelist, read-only mode, query audit log. No default admin/admin.

Beyond the basics

Full schema management,
not just CRUD.

Editing tables and writing queries is the floor. Ledger handles the parts most tools wave at: views, triggers, stored routines, scheduled events, partitions, foreign keys.

  • Full CRUD for views with syntax-highlighted definitions
  • Triggers, routines, and scheduled events — created and edited inline
  • Index management with composite key support and per-key drop
  • Partition management — create, add, drop, optimize, rebuild
  • Scheduler status warnings when event_scheduler = OFF
users ⚷ id BIGINT name VARCHAR email VARCHAR created_at DATETIME active TINYINT orders ⚷ id FK user_id total status items ⚷ id FK order_id qty
3 tables · 2 relationships drag · zoom · save
Security from the first request

A 12-layer security chain,
not a checkbox.

Most database tools treat security as an afterthought. Ledger ships every layer enabled-by-default at install time, including the parts other tools skip.

  • Bcrypt password hashing + optional TOTP 2FA per user
  • CSRF tokens validated on every state-changing request
  • Brute-force lockout, configurable threshold and duration
  • IP whitelist with CIDR support, read-only mode toggle
  • No default credentials — installer enforces setup before first login
  • Query audit logging with timestamp, user, IP, and duration
01 Security headers ●
02 HTTPS enforcement ●
03 IP whitelist + CIDR ●
04 Session hardening ●
05 Bcrypt + TOTP 2FA ACTIVE
06 Brute force lockout ●
07 CSRF tokens ●
+5 more layers
By the numbers

Built right, from scratch.

612 SQL tokens
12× Security layers
20 Built-in themes
0 Runtime deps
Ready to install

Three steps. No build chain.

Drop the folder into your web root. Open it in a browser. Run the 3-step installer. You're managing databases.

# clone into your web root
cd /path/to/htdocs
git clone https://github.com/ClearanceClarence/Ledger.git ledger

# open in browser
open http://localhost/ledger/
Full install guide Download release