Best MongoDB GUI for 2021
If you search for a good MongoDB GUI on Google today, you'll probably end up with a dozen tools, most of which unfortunately defunct or unmaintained.
To save you time and effort, we've compiled a list of the most modern and actively maintained MongoDB GUI out there.
We focused on the commercial tools in this article as these are usually the ones that continuously get maintained over the years. However, we'll make a separate article about the free ones too.
| Name | Most notable feature |
|---|---|
| NoSQLBooster | Shell centric GUI. Runs in a node environment and supports moment.js and lodash. |
| HumongouS.io | Online MongoDB GUI. Collaborative in nature. Supports charts and dashboards and works on mobile. |
| Studio 3T | Code generation tool to export queries in Node.js, Python, Java... |
NoSQLBooster
NoSQLBooster is a shell-centric GUI for MongoDB.
It has many interesting features, with the most notable outlined below:
- The SQL query builder lets you query your collections with the SQL query language.
- You can import Node.js modules like lodash or moment.js within the shell using the Shell extensions.
- The Log Parser allows you to filter and analyze your MongoDB logs.
- It also comes with a Visual Explain system that transforms MongoDB explain output into a hierarchical view, allowing for query tuning.
NoSQLBooster is a license-based software. Pay once, and the version you paid for is yours.
Today, the personal license (single user) costs $119 / license, the commercial license (single user) $219 / license. The corporate license includes unlimited users for $8000 / license.
Today, the personal license (single user) costs $119 / license, the commercial license (single user) $219 / license. The corporate license includes unlimited users for $8000 / license.
HumongouS.io
HumongouS.io goes beyond the classic MongoDB GUI and offers a fully-fledged online admin interface creation tool.
The most notable features of HumongouS.io are:
- The Widget system lets you customize how you want your data to be displayed. Widgets can also be used to pull data from reference collections (e.g. replacing ids with users' email addresses).
- Smart Filters can be used to create filters around your collections displayed as chips for quick access.
- The Collaboration Features let you set up the platform as an internal admin tool rather than a simple GUI. No need to share database credentials anymore. Invite colleagues directly from the app.
- Because it's an online GUI, you can access your data anywhere, even on mobile devices.
- It comes with a Charts and Dashboards creation tool to track your metrics.
HumongouS.io is subscription-based, with the base plan starting at $19 / month and the startup plan at $49 / month
Studio 3T
Studio 3T is a cross-platform GUI for MongoDB owned by the 3T Software Labs.
The major feature differentiators of Studio 3T are the following :
- Similar to NoSQLBooster, Studio 3T lets you directly write SQL to query your database.
- The Tree View displays the data into expandable hierarchies, which is suitable for large and deeply nested documents.
- The Code Generation Tool is able to export queries in Node.js, Python, Java, C#, PHP and Ruby.
- The Data importer works with SQL databases and Oracle.
Studio 3T also has a subscription-based pricing, starting at $199 / year / user for the base subscription, $399 / year / user for the Pro plan, and $699 / year / user for the enterprise plan.
Export specific fields of your MongoDB collections
The export feature in the app used to systematically include all fields in exported documents. We recently shipped an improvement to fix that. You now have the ability to include only the fields you choose. See it in action below:
Top Three MongoDB Tools in 2020 (1/3)
Our main product is a MongoDB GUI, and all of our internal tools and databases are MongoDB based. We live and breathe MongoDB, and because of that, we see all sorts of MongoDB tools and services released all year round.
This year, we’ve decided to share with you our 2020 pick of the top 3 MongoDB tools and services we use the most.
This is the part one of a three posts series.
Create custom roles for your team
In case you need finer control over your collaborators roles, you can now create and assign custom roles.
Search your collections with date presets
You can now use date presets like $date_yesterday or$date_3_weeks_ago to filter down your collections.
Raw Query Builder
Raw Query Builder lets you write MongoDB aggregation pipeline queries directly to create your charts.
Quick Filter Toolbar
Toolbar widgets are a new category of widgets. They add new features to your collections’ toolbar.
The first one we’ve released in the Quick filter toolbar. It gives you a way to have a list of predefined labeled queries in your collections.
Clone MongoDB charts on HumongouS.io
It is now possible to clone your existing charts. It’s super simple. Open the chart’s contextual menu and click on Clone and voilà!
Improved Mobile Search
We’ve made some improvements on the way we present the search bar on mobile. Only the current project title is shown on the header to create more space. The search bar will be accessible by clicking on the search button on the right hand side of the menu.
Jump to collection keyboard shortcut
Going from collection to collection very frequently can be quite tedious especially if you’re doing it across projects. You’ve asked it and we’ve listened. The next time you refresh your browser, type⌘+J and jump from collection to collection at the speed of light.
Sort your MongoDB charts in HumongouS.io
This is a long outstanding request that we just fulfilled. We couldn’t be happier. It’s now possible to re-order your charts by drag and dropping them. Yay!
Copy Json documents
We’ve added a convenient button to directly copy long JSON data from the JSON view.
Fixed Table Header
Being able to scroll and keep the table header fixed has been a paint point for many users for a long time. This issue has now been fixed (no pun intended :) ) in the latest release.
Duplicate collections documents
We recently added a new Table option to duplicate data in your collections. In order to use it, first select the documents you would like to duplicate, click on More to open the Table options dropdown and click on Duplicate documents.
Search bar auto completion
Not remembering the names of your collections fields when you’re about to write a query can be very frustrating, that’s why we’ve added a new auto-completion feature in the Search bar.
It’s only phase 1 for this feature. We’ll iterate on it as we get more feedback and expand it to other places in the app that allow you to enter MongoDB queries (i.e Charts, Collection filters...).
Tip of the week — Brighten up your collection labels with emojis 🤯
You normally have a list of collections on the left menu of HumongouS.io. They are just labels that you can change at will.
Instead of having them plain, you can prefix them with nice little emojis. Bonus is that they’re surprisingly effective at easing the quick scan process 😀.
Here’s a cool example :
