Monghoul 2.0.0
Monghoul 2.0 opens four more databases beside MongoDB: PostgreSQL, ClickHouse, SQLite, and Redis with Valkey. They share one window, one sidebar and the same tools, from write protection and operation logs to import, export and AI access, wherever the engine has what a tool reads. SQL drafts plan each statement and ask before one can lose data, and grid edits are reviewed before they apply. AI assistants call version 2 of the tools, and this release closes gaps in write protection, approvals and file access. The first launch copies your 1.x data file and never changes it.
Highlights
- PostgreSQL — Completion from your schemas and joins from your foreign keys, Explain with real rows and times, grid edits in one transaction, and Manual commit.
- ClickHouse — Explain counts the granules a read selects, drafts take
{name:Type}parameters, and a mutation asks first because ClickHouse cannot undo it. - SQLite — A database file opens with no server, and every value shows exactly as SQLite stored it.
- Redis and Valkey — A key browser on SCAN, an editor for each key type that checks your values before it writes, and a command console.
- Writes that ask first — A SQL statement that can drop data or change every row names its reasons, and Run all checks a whole script before any of it runs.
- AI tools, version 2 — 77 tools with strict arguments, runs that never repeat, and approvals that hold exactly what you saw.
Before you update
- Your 1.x data file stays as it is — The first 2.0 launch copies your data into a new file and never changes the old one, so 1.14 can still open it, without the changes made in 2.0.
- AI tools have new names — AI access offers version 2 of its tools,
server_infomaps each 1.x name, and a tool that replaces 1.x tools you set differently stays off until you decide. - Trust each SSH server once — The first connect through an SSH tunnel asks you to check and trust the server's key, and until then an assistant cannot use that connection.
New
- Connect to PostgreSQL — Write SQL with completion from your schemas and joins from your foreign keys, read plans with real rows and times, and hold writes in one transaction with Manual commit.
- Connect to ClickHouse — Explain plans a read without running it and counts the granules it selects, and Run all, drafts with parameters and grid edits by sorting key work too.
- Open SQLite files — A
.db,.sqliteor.sqlite3file opens with no server, and a 64-bit integer, a REAL and a BLOB show exactly as SQLite stored them. - Connect to Redis and Valkey — A key browser on SCAN, editors for hash, list, set, sorted set, stream and JSON keys, and a console that asks before a command can delete data.
- Edit SQL results in the grid — Changes are staged and reviewed with the old value above the new one, and Apply writes them in one transaction, or stage by stage on ClickHouse.
- SQL writes ask before they can lose data — A statement that drops data or changes every row names its reasons first, and Run all checks a script of up to 200 statements before any of it runs.
- The same tools on every engine — Write protection, operation logs, import, export, the Database Map and AI access work on the new engines, wherever the engine has what the tool reads.
- A detached window runs and searches — A tab in its own window now answers Run, close, Save favorite and Ctrl+K, and its search can open tabs and collections in the main window.
- Connections are safer to edit and delete — The form never shows a saved password's value, and deleting a connection keeps its query tabs and its saved queries, which open through a connection picker.
- Menus open from the keyboard everywhere — Shift+F10 or the Menu key opens the focused tab's, row's or cell's menu, and right-clicking a text field shows Cut, Copy and Paste.
- Connection attempts and a calmer Operation Logs — Connection attempts show their failed step under the query, filters are chips, connections hide until shown, Export writes every filtered entry, and generations and previews are logged.
- Startup explains a data upgrade and any stop — The start screen says when your data upgrades, and if startup stops it shows why, the data folder, the backup and the steps to restore it.
- Offer to map a database you open — Opening a never-scanned MongoDB database offers a scan in a background Database Map tab, and collection sizes, empty in 1.14.1, show again.
Improved
- Menus fit what they act on — A menu says why an item is off, a header's menu sorts the page, a
$groupresult offers no document writes, and Ctrl+K searches one connection. - Copies, charts and exports keep exact values — Copy Value keeps exact types and a 64-bit integer's digits, every copy says when it fails, a chart notes when it rounds, and results export as TSV.
- Values edit where they are — Editing opens on the cell, the tree row or the nested value with a small toolbar, and a value with line breaks edits in a box that keeps them.
- Pro is one $59 lifetime license — The license view leads with one offer and the trial, the footer badge shows trial days and the nearest limit, and existing subscriptions keep working.
- The Cluster Monitor says what needs attention — A health panel explains the worst check and links to its card, charts show the last 1 to 15 minutes, and an operation's details open beside the list.
- AI Activity shows what was sent and what ran — A reviewed request shows what the assistant sent and what you approved, and a declined or timed-out query can be copied to a new tab as your own.
- The All tabs menu says which tab is which — Its rows show each tab's kind, connection and marks, the menu lists every tab, and from seven tabs a search finds one by title or connection.
- Updates cover skipped versions and failed installs — The first launch after an update shows the notes of every release since your version, newest first, and a failed install says so and installs again.
- The builder opens a find() as its stages — A collection tab's
find()opens in the aggregation builder as its$match,$sortand$limitstages, with no warning.
Accessibility
- The result table works from the keyboard — Tab leaves the table at its first and last cell, header sort buttons keep Enter and Shift+F10, and the row numbers are one Tab stop with Up and Down.
- Value colours read in every theme — Numbers in Nord Aurora and the JSON view's null in Ink and Paper were faint, and value colours now read at 4.5:1 on every row of the result grid.
Fixed
Connections
- Typed passwords and SSH tunnels are safer — A typed password is asked again after the address or login changes, and a tunnel takes a free local port and refuses a server whose key you did not trust.
- Edits and disconnects apply at once — A new address, login, SSH, TLS or timeout, a disconnect or a delete closes the old connection, stops its work and cancels a connect still opening.
- Two windows no longer overwrite a connection unseen — A save after another window changed the connection offers Reload, which takes in the other changes and keeps yours.
- A changed Atlas secret takes effect at once — Replacing or removing a service account's secret, or deleting its connection, ends the use of the old access token, which stayed valid until it expired.
Queries
- Deleting documents without an
_iddeletes nothing — A bulk delete of a selection that holds a document with no_idis refused, where it deleted every document of the collection. - Edits reach the right document — Edits and deletes change the document in the result's own database, reach an
_idof any type, and no longer act on old positions after a new run. - Saving a document keeps its number types — Editing, cloning or copying a document keeps a whole-number double, a 64-bit integer and negative zero as the types they were.
- Generated code quotes every name — Edit, delete, snippets and the other generated statements quote a collection name, a field name or an
_id, so crafted data cannot change what they run. - What you typed is what runs and stays — Run waits for the editor's save, and moving, closing or splitting tabs quickly keeps the typed text and every tab.
- Auto-run on open only reads — A query that runs by itself when its tab opens stops before any write and offers a Run button, even on an unprotected connection.
- Write protection closes its gaps — It covers
db.setProfilingLevel(), writes through a collection'sdbhandle and Cluster Monitor kills, and turning it on stops running queries. - Ctrl+K opens only what you picked — Enter reveals a database without loading it, never opens a row you did not pick, waits for an input method, and a huge saved query previews at once.
Import and export
- Transfers follow the connection and stop at once — Exports, imports, generated data and copies use the connection's TLS, sign-in and timeout, and Stop also ends the collection in progress.
- Database exports keep every collection — A name with
/,..orCONstays in the chosen folder, and names that differ only in case get two files on Windows and macOS. - Files are read and written only where you picked — Exports, imports, chart and map images, logs, themes and diagnostics use only the files and folders you pick in the dialog, where any path was accepted.
- Copies and transfers keep exact data — A duplicated database keeps text and geo index settings, a result export keeps a Long's digits, and toasts give the counts written and skipped.
- Generate Data fills UUID, number and image fields again — Faker choices such as UUID, Number, Float, Hexadecimal, Random Word and the image themes made an empty value or 0, and now make real data.
Sidebar
- The tree follows your changes — Lists load from an edited connection's new server, a create or drop that worked is not reported failed, and a collection named like
x:schemaopens as a collection.
AI access
- An approval runs only what you approved — While a query waits, the assistant cannot change it, Explain and export run nothing, and the approval cannot move to another connection or database.
- Waiting requests recheck what changed — A request rechecks write protection before it runs, and a narrower scope, an AI access restart or a deleted connection ends the requests waiting on it.
- AI access keeps to its scope and plan — Turning it off ends every session, its scope covers saved queries and the sidebar, and the Free limits apply to clones, saved queries and pins.
For MCP client authors
- Version 2 of the tool catalog — 77 tools with new names and strict arguments keep every 1.x ability, and a call of a 1.x name answers its 2.0 name and the migration guide.
- Runs and edits are safe to repeat —
query_executetakes anoperationIdand never runs one twice,workspace_updatetakes the tab'scodeRevision, andresult_getreads an operation.
Downloads for v2.0.0
Installers published with this release. The current version is v2.1.0.