llms.txt
Compare with other sites' llms.txt files →# Monghoul
> Monghoul is a fast MongoDB GUI and IDE for developers, built with Tauri. 38 MB installer, schema-aware autocomplete, visual aggregation builder, live cluster metrics, custom themes, and 80+ MCP tools for AI assistants. Free tier included, 14-day Pro trial with no card.
Monghoul is a desktop application (Windows, macOS, Linux) for working with MongoDB databases. The product website at https://monghoul.com markets the desktop app and also hosts a set of free, in-browser developer tools (explain visualizer, EJSON converter, ObjectId decoder, connection string parser, BSON size calculator, SQL to MongoDB converter, MongoDB to SQL converter) and a comprehensive MongoDB aggregation reference.
Key facts:
- Built with Tauri (Rust + web tech), 38 MB installer.
- Cross-platform: Windows 10+, macOS 11+ (Big Sur), Linux (Ubuntu 22.04+, Fedora 36+, glibc 2.35 or newer).
- Schema-aware autocomplete pulled from real collection schemas, folding a pipeline stage by stage through $project, $group, $count, $facet, $bucket, $unset, $addFields, $set and $lookup.
- Visual drag-and-drop aggregation pipeline builder with live preview and code/visual sync.
- Live cluster metrics, slow query analysis, database profiler.
- Result views: virtualized table, hierarchical tree, six chart types with stacking, explain plan graded as collection scan, indexed, optimal, or ungraded.
- Data generation up to 100,000 documents using 17 Faker categories.
- 8 authentication methods including SCRAM, x509, LDAP, Kerberos, AWS IAM.
- SSH tunneling plus SSL/TLS with custom certificates.
- 80+ MCP (Model Context Protocol) tools for use with AI assistants.
- Free tier and paid plans (Monthly, Annual, Lifetime). Lifetime includes all future updates.
- Source: https://github.com/Kontsedal/monghoul-public
## Core pages
- [Home](https://monghoul.com/): Product overview, feature highlights, pricing summary.
- [Product](https://monghoul.com/product/): What the app does, grouped into seven workflows: querying, reading results, moving data, operations, workspace, AI access, and connection safety. Each has its own page at https://monghoul.com/product/<slug>/.
- [Documentation](https://monghoul.com/docs/): The manual. Getting started, a reference page per feature area, concepts, and troubleshooting. Every page names the FEATURES.md sections it covers.
- [Free tools](https://monghoul.com/tools/): Eight MongoDB tools that run in the browser with no signup and no upload.
- [Support](https://monghoul.com/support/): Licences, payments and refunds, bug reports, feature requests.
- [System requirements](https://monghoul.com/system-requirements/): MongoDB 4.4 or newer, and the supported operating systems.
- [Pricing](https://monghoul.com/pricing/): Monthly, Annual, and Lifetime plans. Free tier limits, Pro features, 14-day trial details.
- [Download](https://monghoul.com/download/): Installers for Windows (.exe, .msi), macOS (.dmg for Apple silicon and Intel), Linux (.AppImage, .deb, .rpm). Pulled from the latest GitHub release. Per-platform install notes at https://monghoul.com/download/windows/, https://monghoul.com/download/mac/ and https://monghoul.com/download/linux/, covering which file to take, what the installer asks for, and how updates reach that platform.
- [Changelog](https://monghoul.com/releases/): Paginated release archive. Every version gets its own page at https://monghoul.com/releases/vX.Y.Z/ with the full notes and that version's installers. RSS at https://monghoul.com/releases/rss.xml.
## Free developer tools
- [MongoDB Aggregation Cheat Sheet](https://monghoul.com/aggregation-cheat-sheet/): Complete reference for MongoDB 3.2 through 8.3. 47 pipeline stages, 207 expression operators and accumulators, system variables, aggregate options, and 16 copy-paste patterns for real-world pipelines.
- [MongoDB Explain Visualizer](https://monghoul.com/explain-visualizer/): Paste explain("executionStats") output and see the winning plan, stage pipeline, compound index suggestions, and performance insights. Free, in-browser.
- [MongoDB Extended JSON Converter](https://monghoul.com/ejson-converter/): Convert between Extended JSON, plain JSON, canonical EJSON, and relaxed EJSON. Handles $oid, $date, $numberLong, $numberDecimal, $binary, $regex, $timestamp.
- [MongoDB ObjectId Decoder](https://monghoul.com/objectid-decoder/): Decode any ObjectId into its embedded timestamp, process random bytes, and counter. Also generates ObjectIds for range queries on _id.
- [MongoDB Connection String Parser](https://monghoul.com/connection-string-parser/): Parse mongodb:// or mongodb+srv:// URIs into username, hosts, database, options, with warnings about missing TLS, deprecated ssl, and other common mistakes.
- [SQL to MongoDB Query Converter](https://monghoul.com/sql-to-mongodb/): Convert SQL to a MongoDB query and back. SELECT with JOIN, GROUP BY and HAVING, plus INSERT, UPDATE, DELETE and CREATE INDEX. The output is Node driver code, which is what Monghoul runs, with a mongosh tab beside it.
- [MongoDB to SQL Converter](https://monghoul.com/mongodb-to-sql/): Paste a MongoDB find, aggregation pipeline or write and read it back as SQL. $match becomes WHERE, $group becomes GROUP BY, $lookup with $unwind becomes a JOIN. Driver and shell syntax both read.
- [BSON Size Calculator](https://monghoul.com/bson-size-calculator/): Paste any MongoDB document to get its exact BSON size, its share of the 16 MB per-document limit, and a field-by-field byte breakdown.
## Blog
Writing about MongoDB itself rather than about the app: query plans, schema cost, and what the
server does on a given version. Everything with a number in it comes from a run with a published
script. RSS at https://monghoul.com/blog/rss.xml.
- [Projection and large documents: what MongoDB still reads, measured](https://monghoul.com/blog/projection-and-document-size-measured/): With every document in the cache, a two-field projection cost 3 ms on 1 KB and on 64 KB documents. With a 256 MB cache, the 64 KB one read 61 MB per query.
- [A page and its total count: $facet against two queries, measured](https://monghoul.com/blog/facet-pagination-measured/): The $facet recipe returns a page and its total in one round trip. At 100,000 matches it took 191 ms, against 8.3 ms for the two queries it replaces.
- [What a MongoDB MCP server can reach, before you point one at production](https://monghoul.com/blog/mongodb-mcp-server-scope/): The official server writes unless you pass --readOnly, its confirmations depend on the client supporting elicitation, and its Atlas tools create users.
- [What each MongoDB release added to the aggregation language, from 5.0 on](https://monghoul.com/blog/aggregation-stages-by-version/): The answer to "why does $percentile not work" is almost always the server version. Here is what arrived in each release from 5.0 to 8.3.
- [The 100 MB aggregation limit stopped failing your query in MongoDB 6.0](https://monghoul.com/blog/allow-disk-use-by-default/): Most guides say a stage over 100 MB errors unless you pass allowDiskUse. That has been wrong since MongoDB 6.0, and the new failure is quiet.
- [BSONObjectTooLarge, and the field that is actually costing you the space](https://monghoul.com/blog/bsonobjecttoolarge/): The 16 MB limit is on the encoded document, not on what you think you stored. The usual culprit is an array nobody bounded.
- [Extended JSON, and where $date and $oid quietly change your data](https://monghoul.com/blog/extended-json-pitfalls/): JSON has no date type and no 64-bit integer. Extended JSON has both, in two modes, and relaxed mode loses less than people think and more than they check.
- [A compound index in the wrong order is a sort you did not ask for](https://monghoul.com/blog/index-field-order/): The same three fields in a different order decides whether the index serves your sort or the server does it in memory. The plan says which you have.
- [Your query uses an index and is still slow](https://monghoul.com/blog/indexed-and-still-slow/): An IXSCAN in the plan is not the finish line. The number that matters is how many documents the server had to read to return the ones you asked for.
- [$lookup against embedding, measured on 10 million documents](https://monghoul.com/blog/lookup-vs-embedding-measured/): A $lookup on an indexed key cost nothing here. Sorting on the joined field cost nine seconds. The gap between those two is the whole decision.
- [Read-only MongoDB access for an AI agent, and what still gets through](https://monghoul.com/blog/mongodb-mcp-read-only/): A read-only flag that works by reading the query text can be walked past in four lines. Where the check runs matters more than what it is called.
## Comparisons
Seven MongoDB clients compared on editions, free tiers, trials and minimum OS versions, each row
read from the vendor's own page on a stated date and linked. One of them, MongoDB Compass, was also
installed and measured against Monghoul for disk, startup and memory. There is no feature-by-feature
capability table, because settling that means installing all seven, and the page says so.
- [MongoDB clients compared](https://monghoul.com/compare/): the matrix, and the index of the head to head pages.
- [Monghoul against DataGrip](https://monghoul.com/compare/datagrip/): DataGrip measured against Monghoul on one machine: 2,766.6 MB against 106 MB on disk, 3.53 s against 0.07 s to a window, 1,194 MB before a project is open.
- [Monghoul against NoSQLBooster](https://monghoul.com/compare/nosqlbooster/): NoSQLBooster measured against Monghoul on one machine: 455 MB against 106 MB on disk, 0.71 s against 0.07 s to a window, 585 MB against 398 MB of memory.
- [Monghoul against Studio 3T](https://monghoul.com/compare/studio-3t/): Studio 3T measured against Monghoul on one machine: 415 MB against 106 MB on disk, 5.23 s against 0.07 s to a window, 626 MB against 398 MB of memory.
- [Monghoul against TablePlus](https://monghoul.com/compare/tableplus/): TablePlus measured against Monghoul on one machine: 422 MB against 106 MB on disk, 0.78 s against 0.07 s to a window, and 59 MB of memory against our 398.
- [Monghoul against MongoDB Compass](https://monghoul.com/compare/mongodb-compass/): MongoDB Compass measured against Monghoul on one machine: 651 MB against 106 MB on disk, 1.26 s against 0.07 s to a window, 321 MB against 398 MB of memory.
## Legal
- [Privacy Policy](https://monghoul.com/privacy/): How user data is handled.
- [Terms of Service](https://monghoul.com/terms/): Licensing and usage terms.
- [EULA](https://monghoul.com/eula/): End user license agreement for the desktop app.
## Optional
- [Sitemap](https://monghoul.com/sitemap-index.xml): Full XML sitemap.
- [GitHub repository](https://github.com/Kontsedal/monghoul-public): Public repository for release downloads and issue tracking.