MongoDB GUI Client for Mac in 2018 [duplicate]
Stackoverflow’s questions about recommended GUI clients are all closed and mostly 5 years or older.
What’s your latest GUI client for MongoDB GUI?
Please note there are existing closed questions such as 1. MongoDB GUI client (cross-platform or Linux) (2011-2014)
But they seem quite out of date
1 Answer 1
I have tried Studio 3T, Robo 3T and MongoDB Compass.
- Robo 3T(renamed from Robomongo acquired by Studio 3T) — previously voted as top option, only supports a limited feature of editing
- Studio 3T, commercial counterparts of Robo 3T
- MongoDB Compass
Robo 3T and Studio 3T
MongoDB Compass
I personally quite like MongoDB Compass as the UI looks much better, and feature-wise provides revert editing, geo query, visualizations etc.
The best MongoDB GUI for Mac OS X
open source
mongodb
workflow
I still see a lot of people asking «what’s the best MongoDB client for Mac OS X» (besides the mongo shell console), so I think it would be only fair to share my experience.
I’ve been using MongoDB a lot and for some reason I haven’t been too comfortable using the shell console. I mean, you need an integrated code editor to fiddle with those somewhat verbose JSON-formatted queries.
So I was constantly looking for alternatives; 18 months ago there was none I could find and learn to like, really, but now I really favour Robomongo. It gives you «the full power of MongoDB shell», but in the same time you can easily save, load, edit your queries, do copy/paste, view your results as JSON/trees/tables. and yes, you do get a decent autocompletion :-).
It’s also cross-platform, free and open-source (GitHub repo here).
Fotonauts’ fork of MongoHub is another interesting alternative to keep an eye on; it has a more «native» OS X feel but IMO it does lack a better query editor.
Install MongoDB Community Edition on macOS¶
Overview¶
Use this tutorial to install MongoDB 4.4 Community Edition on macOS using the third-party brew package manager.
MongoDB Version¶
This tutorial installs MongoDB 4.4 Community Edition. To install a different version of MongoDB Community, use the version drop-down menu in the upper-left corner of this page to select the documentation for that version.
Considerations¶
Platform Support¶
MongoDB 4.4 Community Edition supports macOS 10.13 or later.
See Supported Platforms for more information.
Production Notes¶
Before deploying MongoDB in a production environment, consider the Production Notes document which offers performance considerations and configuration recommendations for production MongoDB deployments.
Install MongoDB Community Edition¶
Prerequisites¶
If you have the Homebrew brew package installed on your OSX host and you have previously tapped the official MongoDB Homebrew Tap, skip the prerequisites and go to the Procedure step.
Install XCode¶
Install Homebrew¶
Tap the MongoDB Homebrew Tap¶
Issue the following from the terminal to tap the official MongoDB Homebrew Tap:
Procedure¶
Follow these steps to install MongoDB Community Edition using the third-party brew package manager.
From a terminal, issue the following:
If you have previously installed an older version of the formula, you may encounter a ChecksumMismatchError. To resolve, see Troubleshooting ChecksumMismatchError .
In addition to the binaries , the install creates:
Run MongoDB Community Edition¶
Follow these steps to run MongoDB Community Edition. These instructions assume that you are using the default settings.
You can run MongoDB as a macOS service using brew , or you can run MongoDB manually as a background process. It is recommended to run MongoDB as a macOS service, as doing so sets the correct system ulimit values automatically (see ulimit settings for more information).
To run MongoDB (i.e. the mongod process) as a macOS service, issue the following:
To stop a mongod running as a macOS service, use the following command as needed:
To run MongoDB (i.e. the mongod process) manually as a background process, issue the following:
To stop a mongod running as a background process, connect to the mongod from the mongo shell, and issue the shutdown command as needed.
Both methods use the /usr/local/etc/mongod.conf file created during the install. You can add your own MongoDB configuration options to this file as well.
macOS Prevents mongod From Opening
macOS may prevent mongod from running after installation. If you receive a security error when starting mongod indicating that the developer could not be identified or verified, do the following to grant mongod access to run:
- Open System Preferences
- Select the Security and Privacy pane.
- Under the General tab, click the button to the right of the message about mongod , labelled either Open Anyway or Allow Anyway depending on your version of macOS.
To verify that MongoDB is running, search for mongod in your running processes:
You can also view the log file to see the current status of your mongod process: /usr/local/var/log/mongodb/mongo.log .
Connect and Use MongoDB¶
To begin using MongoDB, connect a mongo shell to the running instance. From a new terminal, issue the following:
macOS Prevents mongo From Opening
macOS may prevent mongo from running after installation. If you receive a security error when starting mongo indicating that the developer could not be identified or verified, do the following to grant mongo access to run:
- Open System Preferences
- Select the Security and Privacy pane.
- Under the General tab, click the button to the right of the message about mongo , labelled either Open Anyway or Allow Anyway depending on your version of macOS.
For information on CRUD (Create,Read,Update,Delete) operations, see:
Additional Information¶
Localhost Binding by Default¶
By default, MongoDB launches with bindIp set to 127.0.0.1 , which binds to the localhost network interface. This means that the mongod can only accept connections from clients that are running on the same machine. Remote clients will not be able to connect to the mongod , and the mongod will not be able to initialize a replica set unless this value is set to a valid network interface.
This value can be configured either:
- in the MongoDB configuration file with bindIp , or
- via the command-line argument —bind_ip
Before binding to a non-localhost (e.g. publicly accessible) IP address, ensure you have secured your cluster from unauthorized access. For a complete list of security recommendations, see Security Checklist . At minimum, consider enabling authentication and hardening network infrastructure .
For more information on configuring bindIp , see IP Binding .
Troubleshooting ChecksumMismatchError¶
If you have previously installed an older version of the formula, you may encounter a ChecksumMismatchError resembling the following:
9 Best MongoDB GUI Tools in 2020
There are many MongoDB management tools available in the market. These tools can improve the productivity of your MongoDB development and admin tasks. Here is the list of most popular MongoDB tools for your business with it’s top features, use, and download link.
1) Studio 3T
Studio 3T is an integrated development environment designed especially for teams working with MongoDB:
- Autocomplete queries with IntelliShell
- Drag and drop fields to visually build queries
- Use SQL, with INNER and OUTER joins, to query MongoDB
- Generate driver-code from SQL or mongo shell into PHP, Python, Javascript and others
- Secure connections for single MongoDB instances and replica sets
- Copy and paste documents across servers and databases
- Effortlessly compare and synchronise data
- Build aggregation queries stage by stage
- Multiple ways to import & export, including SQL Migration
- Automate and schedule repetitive MongoDB tasks like imports
2) Robo 3T
Robo 3T (formerly Robomongo) is the popular free GUI for MongoDB enthusiasts. This lightweight, open-source tool has cross-platform support and also embeds the mongo shell within its interface to provide both shell and GUI-based interaction. It is developed by 3T Software, the team behind Studio 3T, the IDE for MongoDB.
Key features
- Embedded shell environment
- Asynchronous, non-blocking UI
- Supports MongoDB 4.0
3) NoSQL Manager
This MongoDB GUI tool merges friendly UI and Shell power. It offers high performance with support for all the MongoDB and MongoDB Enterprise latest features. It also saves time for database developers and administrators.
Features:
- Fully featured MongoDB GUI Shell with code autocompletion, and syntax highlighting
- It offers support for replica sets, standalone hosts and sharded clusters connections
- Editor comes with three views Tree, Table, and JSON view modes
- Easy-to-use document viewer
- File Manager Tool to work with GridFS
- Simple view and management option for all types of MongoDB objects
- Import tables from MySQL and SQL Server databases
- Multiple Mongo host database connections
- Export documents to CSV, XML, XLSX, and JSON file formats
4) MongoDB Compass:
MongoDB Compass is another effective too. It provides users with a graphical view of their MongoDB schema without the need of query language. It also analyses documents and displays rich structures inside this intuitive GUI.
Features:
- The tool allows to explore data visually
- MongoDB Compass analyzes documents and displays rich structures within one collection using Run ad-hoc queries in seconds
- Supports quick insight into server status and query performance
- Allows to view query performance
- A better approach to CRUD makes it easier to interact
- It helps users to take decisions about indexing, document validation, and more
- No need to write command line
5) Nucleon Database Master:
Nucleon Database Master is one of the most powerful and easy to use MongoDB database administration, and management tool. It simplifies managing, monitoring, querying, editing, visualizing relational NoSQL DBMS.
Features:
- Support for JSON/LINQ/SQL Query Editor
- It offers powerful and intuitive SQL, LINQ and JSON query editor
- The tool provides notable features like code highlighting, code completion and text find and replace
- The users can export data into file formats like XML, HTML, MS Office, CSV, OpenOffice, RTF, PDF, XPS, JSON, dBase, and PNG
- It provides dynamic C# Scripting query editor which supports Linq to MongoDB and Linq to Dataset
- It allows importing data from XML, CSV, and SQL Script files without any size limit.
6) Mongo Management Studio:
Mongo Management Studio is another effective tool for MongoDB management. It is possible to execute all the regular MongoDB commands without using the MongoDB shell.
Features:
- Mongo Management Studio is cross-platform, so it runs on all major systems
- It offers support for MongoDB 3.0 / 3.2 / 3.4
- The app allows connecting to remote MongoDB databases using an SSH tunnel
- With Mongo Management Studio, it is possible to read and write to GridFS collections
- It offers a complete documentation of all features by explaining MongoDB related topics
- With its inline edit feature, it is possible to do data manipulation on the fly
7) MongoJS Query Analyzer:
MongoJS Query Analyzer is MongoDB JavaScript editor. It allows users to execute JavaScript commands. The tool provides supports for auto completion and syntax highlighting.
Features:
- The JavaScript statements and queries run within a MongoDB shell command line interface. It can also be typed and executed
- The MongoJS Query Analyzer allows users to view the results in a tree hierarchy, grid and as a text result
- The MongoJS Pretty Print JSON feature allows displaying the JSON result in an easy to read format
- It displays query results in several ways; as text, text history, grid, and pivot grid.
- The contents of the Query Analyzer can be saved in different ways and formats
8) Cluster control:
ClusterControl offers fully automated security, maintaining the integrity of the database infrastructure. In this MongoDB tool, it is possible to deploy and manage various open source database technologies from a single console.
Features:
- The tool allows users to customize solutions for their own MongoDB deployments
- Easily add and remove nodes, resize instances, and clone production clusters with the help of this tool
- It provides single interface to automate mixed MongoDB and MySQL database environments
- It provides management features that repair and recover broken nodes, and test and automate upgrades