DataGrip is a powerful database IDE for advanced data manipulation, with full MongoDB support
Get free 30-day trialJetBrains DataGrip is a cross-platform tool for working with a wide variety of SQL and NoSQL databases. It is available for Windows, macOS, and Linux.
DataGrip includes a database console built on top of the MongoDB Shell, and provides a variety of benefits for database developers. It automates routine tasks, detects and fixes errors, and improves the overall efficiency of MongoDB development.
DataGrip provides a smart collection editor that allows you to add, delete, and change fields and documents. All of the queries DataGrip runs during collection updates can later be found in a log, allowing you to easily perform the same changes against another database. DataGrip’s data extractor supports many formats, including CSV, JSON, XML, and others. The mechanism is customizable so you can create your own formats, such as Markdown or just plain text.
Most developers spend the bulk of their time in IDEs coding. DataGrip’s smart features like auto-completion, code snippets, the formatter, refactorings, and various intention actions help you code faster. Concentrate on your logic, not on what you need to type!
If you work with MongoDB scripts stored on your computer, then you might already have a working directory with tons of scripts. DataGrip provides a handy interface for that. Attach folders from your computer, associate them with data sources, run scripts against several databases, or even use the built-in Git integration!
DataGrip provides many ways to customize the interface. You can choose from any of the default color schemes or create your own, mark data sources with different colors, and even set up your own keyboard shortcut layout.
You can use SQL to query MongoDB databases. We've created our own JS-SQL translator that makes this possible.
Only SELECT queries work, and the working сlauses are JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET.
A complete post on what is supported is available here.
There are two options in the context menu for each SQL query in Mongo: Copy JS Script to clipboard and Show JS Script. You can edit the query and run it in the JS Script Preview window.
Most of the commands that you can run in the MongoDB shell are available in DataGrip, and they work in exactly the same way as they do in MongoDB. This is the result of close collaboration between engineering teams at MongoDB and JetBrains.
A detailed description of what is supported can be found in this blog post.
To connect to your MongoDB database, DataGrip uses a JDBC driver, which will be downloaded automatically when testing the connection. In addition to the main credentials you’ll need in order to connect (such as URL, user name, and password), there are several configurable options for your new MongoDB data source:
Once you’re connected to one of your MongoDB databases, you’ll see a list of objects in the left pane, called the database explorer. Here you can filter objects and choose which databases should be shown.
DataGrip can help you detect bugs and problems that are likely to arise in the code of your MongoDB queries before you compile and run it. Here are just a few examples of ways DataGrip can come to the rescue by catching mistakes and bringing them to your attention.
To work with data in MongoDB, you write scripts for the mongo shell in JavaScript. In some cases, it might be helpful to use SQL for MongoDB collections as well. DataGrip can translate your SQL queries to JavaScript. You can find the details here.
You can modify data, add and delete columns, and more. You can find more information about editing data here.
For instructions, check out this MongoDB connection tutorial.
DataGrip fetches the first 10 documents from each collection to get information about the fields. This behavior is customizable, and you can find more information about it here.