Db2 LUW, from one window.
SQL editing, schema browsing, visual access plans, data movement, user and admin tooling, and encrypted archive backup/restore — for Db2 LUW 11.5 and 12.1, over the IBM clidriver you already have.
Supports Db2 LUW 11.5 & 12.1
The access plan Mongrel would build for your query.
Click any operator below to see timeron cost, cardinality, and what Mongrel would suggest. Same view you get inside the workbench.
// TBSCAN · ORDERS
Full table scan of ORDERS — 2.1M rows read to keep 84,120. No usable index on CUST_ID + ORDER_DATE. This is the bottleneck.
-- ORDERS · PRODDB (Db2 12.1) SELECT o.ORDER_ID, o.TOTAL, o.STATUS, c.EMAIL AS CUSTOMER_EMAIL FROM ORDERS o JOIN CUSTOMERS c ON c.CUST_ID = o.CUST_ID WHERE o.ORDER_DATE > DATE '2026-06-01' AND o.STATUS = 'SHIPPED' ORDER BY o.ORDER_DATE DESC FETCH FIRST 20 ROWS ONLY; -- 3.8s · TBSCAN on ORDERS (2.1M rows) -- ✓ Proposal: composite (CUST_ID, ORDER_DATE) CREATE INDEX IX_ORDERS_CUST_DATE ON ORDERS (CUST_ID, ORDER_DATE); RUNSTATS ON TABLE ORDERS AND INDEXES ALL;
What Mongrel ships for Db2.
SQL editor
Typed Db2 SQL with completion, formatting, and bound parameters. FETCH FIRST, OLAP functions, and MERGE all understood.
Visual access plans
EXPLAIN output as a clickable operator tree — RETURN, SORT, HSJOIN, FETCH, IXSCAN, TBSCAN — with timeron costs and cardinality at every node.
Index & RUNSTATS advisor
See which indexes a plan uses and which it wishes it had. Generate CREATE INDEX statements and refresh optimizer statistics from the UI.
Schema browsing
Navigate schemas, tables, views, aliases, indexes, and packages. Drill from a foreign key straight into the referenced rows.
Data movement
Import and export CSV, JSON, and delimited formats. Copy data between Db2 and any other engine — schema-aware, in both directions.
Users & authorities
Browse users, groups, roles, and grants. Review DBADM, SECADM, and table-level privileges without writing catalog queries by hand.
Admin & monitoring
Tablespaces, buffer pools, lock waits, and active application handles. Snapshot views of database health without leaving the workbench.
Encrypted archives
Logical archive backup and restore with encryption at rest. Schedule snapshots of schemas and data you can verify and restore later.
Runs on IBM clidriver
Connects through a user-installed IBM clidriver obtained from IBM — Mongrel discovers it, you keep the license. Windows ARM64 is unsupported for this engine.