An Oracle database GUI and PL/SQL workbench.
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 advice
The index advisor runs EXPLAIN PLAN on a read query, spots predicate-driven full table scans, checks existing usable indexes, and proposes reviewable CREATE INDEX statements.
Schema compare & drift
Snapshot and diff schemas across instances or PDBs, 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.
Schema designer
Plan, validate, and apply reviewable DDL for new tables - columns, defaults, primary and foreign keys - with dependency checks before any replace.
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 Oracle JDBC Thin JAR, pinned by SHA-256 and verified at build and install.