Not available yet.
To detect if mongo server is compliant with aggregation framework, db.version() expression is sent to the server for evaluation. This information is used for fitting the UI of the query panel. In some case, even if authentication is successfull, this operation is not permitted.
This instruction has been removed and now the user can switch to aggregation/find query with a button located on the toolbar of the query. It is more convenient and removes the issue mentionned above.
See CHANGELOG.txt
This plugin integrates MongoDB Servers with database/collections tree, Query Runner and Shell console.
This plugin was built with JDK 1.6 and ideaIU-11.1.5 version.
Download this plugin from your IDE (Mongo Plugin)
When you open the Mongo explorer, you will see an panel:
- To manager your Mongo servers, click on the Mongo Settings button located on the upper toolbar of the Mongo explorer Right Panel
- You can edit your mongo shell path with a test button
- To add a server, click on the [+] button and a dialog will appear
- Set a label for your server, this will be more convenient to distinguish each of them in the Mongo explorer
- Set the server info as the example in the above screenshot*
- If your access is restricted to a specific database, just type it in the corresponding field
- Put your credentials if your server requires authentication
- You can let the plugin connect to the server on the IDE startup by clicking on the corresponding checkbox
- If you want to hide some collections, you can put them in the Collections to ignore field.
- You can click on the Test Connection button to check your server configuration
The tree displays for each server all databases with its collections. Just double-click on a collection and the results will be displayed in the Mongo Runner panel. If you double-click on another collection, a new tab will appears side of the previous.
The panel is divided into 2 parts.
- Right part displays the results of the query in a tree (max. 300 records).
You can copy the result and paste in a text editor.
- Left part allows to specify a query (in json format).
When you type CTRL+SPACE key shortcut a popup is displayed in which you can select query operator.
Either you click on the run query button or else type CTRL+ENTER shortcut to run the query
If your server version is at least 2.2, you can use the aggregation framework. You can add a pipeline operation by clicking on the [+] button. You can also copy/paste the query you wrote.
NEW By default, Aggregation query is enable. you can switch to find query by clicking on the tooggle button:
If you have an error during query execution, a feedback panel is displayed below:
- In case of bad JSON syntax
- In case of general error
Note: If you use Ultimate Edition, JSON syntax highlighting is enabled.
If you set the mongo client path (e.g. /usr/bin/mongo), you can run the console by clicking the menu item Tools -> Mongo Shell.
I would like to thank:
- MongoDB team
- Mongo Java Driver team
- Jetbrains Team for the great sources of IntelliJ Community Edition which help me to improve this plugin
- Mark James author of the famfamfam web site who provides beautiful icons.
- Jean Baptiste Potonnier for the suggestion to create this plugin
- Neko team, my first beta testers ;)
- All users of this plugin who sent me valuable suggestions.
- My wife and my daughter who support me to have fun in software development and also remind me my husband/father duty ;).