Oracle, tamed.
Typed Oracle SQL and PL/SQL over TCPS, mTLS, or host-brokered SSH, with administration, execution-plan profiling, and encrypted logical archives.
Oracle 19c EE · 23ai Free · 26ai Free · TCPS/mTLS
The plan Mongrel would build for your query.
Click any operation below to see cost, cardinality, and what Mongrel would suggest. Same view you get inside the workbench.
// INDEX RANGE SCAN · IX_ORDERS_DATE_STATUS
Range scan on IX_ORDERS_DATE_STATUS over ORDER_DATE > DATE '2026-06-01' with STATUS = 'PAID' as the second key. Proposed composite index applied.
-- SALES@orclpdb1 · TCPS/mTLS SELECT o.order_id, o.order_total, o.status, c.cust_email FROM orders o JOIN customers c ON c.customer_id = o.customer_id WHERE o.order_date > DATE '2026-06-01' AND o.status = 'PAID' ORDER BY o.order_date DESC FETCH FIRST 20 ROWS ONLY; -- 386ms · 6,212 consistent gets -- ✓ Proposal: composite (ORDER_DATE, STATUS) CREATE INDEX ix_orders_date_status ON orders (order_date, status);
What Mongrel ships for Oracle.
Typed SQL & PL/SQL
Write Oracle SQL and PL/SQL with dialect-aware editing. Packages, procedures, and triggers with compile-error surfacing.
Execution plans & profiling
Inspect plans in DBMS_XPLAN format: cost, cardinality, and bytes per operation, with estimated versus actual row counts.
TCPS, mTLS & SSH
Connect over TCPS with wallet-based mutual TLS, or reach locked-down hosts through host-brokered SSH. No plaintext listeners required.
Index management
Create, rebuild, and drop B-tree and bitmap indexes from the UI. See which queries each index actually serves.
Schema compare & drift
Diff schemas across instances or PDBs, generate reversible DDL, and catch drift before a deploy does.
Administration
Browse users, roles, and grants. Tablespace usage, sessions, and activity panels for day-to-day DBA work.
Visual query builder
Assemble SELECTs and joins visually against your data dictionary. Output is real Oracle SQL, editable on both sides.
Encrypted logical archives
Export schema and data into encrypted logical archives, and restore them into another instance or pluggable database.
Bring your own JDBC runtime
Connects through your Java 25 runtime and an unmodified, SHA-pinned Oracle JDBC Thin JAR, verified before every connection.