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
A staged write, the way Mongrel runs it.
Click any step below to see what Mongrel reports back at each stage. Same flow you get inside the workbench.
// ROLLBACK TO · before_purge
Changed your mind about the purge? Roll back to the savepoint and the DELETE is gone; the UPDATE survives.
-- stores_demo@ol_informix · orders BEGIN WORK; UPDATE orders SET status = 'S' WHERE status = 'O' AND order_date < '2026-01-01'; -- matched 12 rows · staged, not committed SAVEPOINT before_purge; DELETE FROM items WHERE order_num IN (1023, 1024, 1025); -- matched 31 rows · undone below ROLLBACK TO SAVEPOINT before_purge; COMMIT WORK;
What Mongrel ships for Informix.
Database & object browsing
Browse databases, tables, and views from sysmaster and the Informix system catalogs - 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.
Paging & cancellation
Page through large result sets instead of loading them whole. Cancel a runaway query mid-flight - Mongrel forces the interrupt and quietly reconnects.
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.
Table & column inspection
Columns, types, defaults, and primary keys in one panel, read straight from the Informix catalogs.
Import & export
CSV, JSON, and JSON Lines in and out of any table - with dry-run, column mapping, and conflict handling before a row is written.
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.