Db2 LUW, from one window.
SQL editing, schema browsing, 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. The same operators, costs, and cardinality the workbench's EXPLAIN view reports.
// 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);
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 an operator-by-operator breakdown - RETURN, SORT, HSJOIN, FETCH, IXSCAN, TBSCAN - with timeron costs and cardinality at every operator.
Index advisor
See which indexes a plan uses and which it wishes it had. Verified-EXPLAIN advice generates CREATE INDEX statements you can review and run.
Schema browsing
Navigate schemas, tables, views, aliases, nicknames, and indexes. Drill from a foreign key straight into the referenced rows.
Data movement
Import CSV, JSON, and JSON Lines; export to CSV, JSON, JSON Lines, or SQL INSERT. Copy data between Db2 schemas - keyset-paged, with plan/apply and cancel.
Users & authorities
Browse users and roles, and manage grants. Create and drop roles, and grant or revoke role memberships and object privileges without writing catalog queries by hand.
Admin & monitoring
Server service level, active connections, buffer pool pages, and bounded table and query profiling. Snapshot views of database health without leaving the workbench.
Encrypted archives
Logical archive backup and restore with encryption at rest. Take checksummed 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.