libSQL and sqld, synced.
Remote Hrana SQL with token and namespace profiles, transactions, data movement and sync, schema drift detection, and encrypted logical backups.
Remote Hrana protocol · tokens · namespaces
The plan Mongrel would build for your query.
Click any node below to see row estimates and what Mongrel would suggest. Same EXPLAIN QUERY PLAN view you get inside the workbench.
// SCAN orders · full table
Reads all 80,412 rows of orders to test status = 'paid' and created_at. This is where the 388ms goes.
-- orders · replica eu-1 (hrana) SELECT o.id, o.total, o.status, u.email AS customer_email FROM orders o JOIN users u ON u.id = o.user_id WHERE o.status = 'paid' AND o.created_at > '2026-06-01' ORDER BY o.created_at DESC LIMIT 20; -- 388ms · SCAN orders: 80,412 rows -- ✓ Proposal: composite (status, created_at) CREATE INDEX idx_orders_status_created ON orders (status, created_at);
What Mongrel ships for libSQL.
Hrana connections
Connect to sqld over the Hrana protocol (HTTP or WebSocket), open local SQLite files, or attach embedded replicas.
Token & namespace profiles
Save auth tokens per database and per sqld namespace. Dev, staging, and prod profiles stay one click apart.
Visual query builder
Build SELECTs, JOINs, and aggregations visually. Output is real SQLite-dialect SQL — both sides stay editable.
EXPLAIN QUERY PLAN
See SCAN vs SEARCH, temp B-tree sorts, and index usage per step. Mongrel proposes the index and shows the predicted plan.
Transactions & batches
Run interactive transactions or batched statements over Hrana. Inspect open transactions, commit or roll back from the UI.
Replica sync & drift
Watch embedded replicas catch up — sync interval, frame lag, last sync. Schema drift between primary and replica flagged before it breaks a query.
Schema compare
Diff tables, indexes, triggers, and views across namespaces or environments. Generate reversible migration scripts.
Encrypted logical backups
One-click SQL dumps, encrypted at rest with your own key. Restore to any libSQL or SQLite target.
Import, export, copy
CSV, JSON, SQL dumps. Copy data between libSQL and any other engine — schema-aware.