Free, monitor and users on Pro

A MongoDB IDE that completes from the data in your collections

Monghoul is a desktop MongoDB IDE for Windows, macOS and Linux. Autocomplete suggests the field names and values in your collections, through every pipeline stage. Build an aggregation visually or as code, grade a query with Explain, and open the document an id points to.

Download Monghoul Read the MongoDB docs

The autocomplete list open on a nested field path, offering the four child fields of shipping — Fig 01 Query editor · Typing "shipping." offers only the child fields

Does it autocomplete nested fields and real values?

Typing a path such as shipping. offers only the child fields. Inside a filter, it offers the values that field holds, from a sample of your collection, and it follows the documents through $project, $group and $lookup.

Can I build an aggregation pipeline visually?

Build the pipeline stage by stage from a searchable catalog. Each stage row says what its last preview returned, so you see what $match and $group did before you add the next stage. The Builder button returns to code, formatted.

The visual aggregation builder: a $match, a $group, a $sort and a skipped $limit as rows of one reorderable outline, each with its own Run to here control, above the result pane — Fig 02 Aggregation builder · Stages as rows of one outline, each with its own Run to here

How do I find the index a slow query needs?

Explain grades the plan. A COLLSCAN is named as one, with the index that would fix it, so the next step is one action.

The explain view grading a query that runs a collection scan, with an index suggestion — Fig 03 Explain · A COLLSCAN graded, with the index that would fix it

Can I open the document an id points to?

After a scan finds the links between collections, an id in a result opens the document it names, and from there the next one. The Database Map draws those links.

An orders table whose customerId column names customers in its header. Beside the selected cell, a peek shows the referenced customer as a tree, and its referredBy link has opened a second peek with the customer who referred them, its name field open — Fig 04 Results · A reference leads to the document it names, and on to the next

Which operation is slowing the server down?

On Pro, the Cluster Monitor rates cache use, connections, replica lag and the lock queue, and names the worst one in a sentence. Live lists the running operations, marks the ones that wait for a lock or scan a whole collection, and Kill ends one after a second click. Profiler sets a database’s profiling level and lists its 200 most recent profiled operations.

The cluster monitor with live metric sparklines, connection usage, and replica set health — Fig 05 Monitoring · Live server metrics, connections, and replica set health Pro

Can I manage users and roles?

On Pro, Manage Users opens the users and roles of a connection in one tab, ordered by database. An Atlas deployment is managed the same way, with a project API key.

The user management tab listing database users and their roles — Fig 06 Administration · Users and the roles they hold, per database Pro

Connecting to MongoDB

MongoDB 4.4 or newer. An older server fails with an error rather than opening.

A connection string or individual fields, with 8 authentication methods, no auth among them.
TLS, an SSH tunnel with a host key check, replica sets and read preferences.
Write protection for the whole connection or for chosen databases and collections.

What it does not do on MongoDB

MongoDB 4.4 or newer only.
The database and collection filters hide names in the tree, and are not a security boundary.

Shared with the other engines

The same windows as on the other engines, with MongoDB's words and limits. Compare all five.

MongoDB questions

Is Monghoul a MongoDB Compass alternative?

Yes. Monghoul adds autocomplete from your data, a Database Map of the links between collections and AI access with your approval. The comparison page measures both apps on one machine.

Does it read Extended JSON and keep types exact?

Yes. A 64-bit integer keeps every digit, Copy Value of an object copies Extended JSON with its types, and Decimal128 stays exact in the table, copy and export.

Can I connect to MongoDB Atlas?

Yes. Paste the `mongodb+srv://` string from Atlas. An AWS IAM string is moved into the AWS fields for you.

Point it at your MongoDB database

43 MB installer. Free for 8 connections, and a 14-day Pro trial with no card.

Download Monghoul