Firebird, five decades of uptime respected.
Authenticated WireCrypt connections, typed SQL with PLAN inspection, schema and relationship tooling, scheduled encrypted logical backups, and live monitoring — a modern workbench for a database that earned its keep.
Firebird 5+ · authenticated WireCrypt
The plan Mongrel would build for your query.
Click any node below to see row estimates and what Mongrel would suggest. Same view you get inside the workbench.
// Index range read · IDX_ORDERS_STATUS_CREATED
Proposed composite index on orders (status, created_at). Turns the NATURAL scan into a range read and feeds the sort pre-ordered rows — NATURAL disappears from the plan.
-- orders · fb5-prod (SuperServer) SELECT FIRST 20 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.created_at > '2026-06-01' AND o.status = 'paid' ORDER BY o.created_at DESC; -- PLAN SORT (JOIN (O NATURAL, U INDEX (PK_USERS))) -- 412ms · 80,000 rows scanned -- ✓ Proposal: composite (status, created_at) CREATE INDEX idx_orders_status_created ON orders (status, created_at);
What Mongrel ships for Firebird.
Visual query builder
Build SELECTs, JOINs, and aggregations visually. Output is real Firebird SQL — both sides stay editable.
PLAN & profiling
See the optimizer's PLAN output per statement, with row estimates, index usage, and NATURAL scans flagged.
Index management
Create, drop, and recompute index statistics from the UI. See selectivity, usage, and the queries that would benefit.
Schema sync & drift
Compare schemas, generate reversible migrations, detect drift between embedded, Classic, and SuperServer environments.
ER diagrams & relationships
Auto-generated ER diagrams from foreign keys. Click a relationship to drill into rows, audit constraints.
Generators & triggers
Browse and edit triggers, stored procedures, and generators. Inspect generator values and PSQL dependencies in place.
WireCrypt connections
Authenticated WireCrypt-encrypted connections with Srp256 or legacy auth. No credentials or traffic in the clear.
Scheduled backups
Scheduled, encrypted logical backups on a cadence you set. Restore to a point in time from any archived snapshot.
Monitoring & archives
Live monitoring of attachments, transactions, and statements. Import and export CSV, JSON, and SQL across engines.