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 a remote sqld 0.24.32–0.24.33 endpoint over the Hrana protocol (HTTP or WebSocket), with system-trusted TLS and host-brokered SSH tunneling.
Token & namespace profiles
Save auth tokens per database and per sqld namespace. Dev, staging, and prod profiles stay one click apart.
Schema designer
Plan schema changes, validate them against the live database, and apply them transactionally - no hand-written DDL required.
EXPLAIN QUERY PLAN
See SCAN vs SEARCH, temp B-tree sorts, and index usage per step. The Index Advisor flags full scans and writes the CREATE INDEX for you.
Transactions & savepoints
Run interactive transactions with savepoints over Hrana. Inspect open transactions, commit or roll back from the UI.
Data sync & drift
Plan and apply stored-plan data synchronization between libSQL profiles. Schema drift between environments is fingerprinted and 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 logical archives of schema and typed rows, AES-256-encrypted with your own password. Checksum-verified restore to any libSQL target.
Import, export, copy
CSV, JSON, JSON Lines, and SQL dumps. Copy and sync data between libSQL and other engines - schema-aware.