Five decades of Firebird 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.
Copy & data sync
Copy compatible tables between Firebird databases with stable keys, and plan and apply data synchronization with cancellation.
PLAN & profiling
See the optimizer's PLAN output per statement, with index usage and NATURAL scans flagged.
Index advisor
Point the advisor at a slow query. It reads the PLAN, flags NATURAL full scans, and writes the CREATE INDEX DDL for the filter columns.
Schema sync & drift
Compare schemas with deterministic snapshots and diffs, then plan, validate, and apply table changes through the schema designer.
Relationships & foreign keys
Inspect foreign keys and table relationships in the schema browser, with update/delete rules and constraint types spelled out.
Generators & triggers
Browse triggers, stored procedures, and sequences - sources, parameters, and descriptions included, straight from the system tables.
WireCrypt connections
Authenticated WireCrypt-encrypted connections with Srp256 or Srp auth. No credentials or traffic in the clear.
Scheduled backups
Scheduled, encrypted logical backups on a cadence you set. Restore from any archived snapshot, down to selected objects and their dependencies.
Monitoring & archives
Live monitoring of attachments, transactions, and statements. Import CSV, JSON, and JSON Lines; export CSV, JSON, JSON Lines, and SQL INSERTs.