Informix, without the terminal.
SQL, database, object, and table browsing over DRDA — with row and bulk CRUD, transactions and savepoints, and import/export. Connects through your own IBM clidriver install.
Informix over DRDA · TLS
The plan Mongrel would build for your query.
Click any node below to see cost, row estimates, and what Mongrel would suggest. Same view you get inside the workbench.
// SEQUENTIAL SCAN · orders
Full scan of orders: 42,118 rows read, 31,880 discarded by the status filter. Mongrel suggests a composite index on (status, order_date) to kill both the scan and the sort.
-- stores_demo@ol_informix · orders SELECT FIRST 20 o.order_num, o.order_date, o.status, c.company AS customer_name FROM orders o JOIN customer c ON c.customer_num = o.customer_num WHERE o.status = 'O' AND o.order_date >= '2026-06-01' ORDER BY o.order_date DESC; -- 1.9s · 42,118 rows scanned · sort 84% of cost -- Proposal: composite (status, order_date) on orders CREATE INDEX ix_status_order_date ON orders (status, order_date);
What Mongrel ships for Informix.
Database & object browsing
Browse databases, tables, views, synonyms, procedures, and triggers from sysmaster and syscat — no dbaccess required.
SQL editor & grid
Write and run SQL with syntax-aware editing. Results land in an editable grid, from plain SELECTs to FIRST n queries.
EXPLAIN & plan viewer
Runs SET EXPLAIN under the hood and renders the plan tree: QUERY, SORT, HASH JOIN, INDEX PATH, SEQUENTIAL SCAN — with cost and row estimates per node.
Row & bulk CRUD
Edit rows in place, or stage bulk INSERT, UPDATE, and DELETE batches. Preview affected row counts before committing.
Transactions & savepoints
Start a transaction, set savepoints, roll back to one, commit when satisfied — against logged databases, with isolation level selection.
Table & index inspection
Columns, types, constraints, fragments, and index paths in one panel. See which indexes the optimizer actually uses.
Import & export
CSV, JSON, and delimited unload/load in and out of any table. Copy data between Informix and other engines, schema-aware.
clidriver under the hood
Mongrel talks DRDA through a user-installed IBM clidriver. Point it at your existing install — no server-side agents or proxies.
TLS connections
Encrypted DRDA sessions over TLS with certificate verification. Save multiple connection profiles per host and database.