What’s New in MongoChef 4.5

This is one of our largest releases ever. We would like to explicitly thank you, our users, for your plentiful feedback and feature suggestions that continue to make MongoChef so much better.

MongoChef 4.5 is chock-full of new features and improvements:

Full MongoDB 3.4 Compatibility

MongoDB Export to SQL

Improved Connections Tree

Integration of mongodump and mongorestore for Easy Backups

to name but the most high-level ones.

Full MongoDB 3.4 Compatibility

MongoDB 3.4 has brought many new high-level features such as read-only views, collation documents, and new aggregation operators. MongoChef 4.5 adds full support for these features.

Read-Only Views

MongoChef makes it super-easy to create MongoDB read-only views with its industry-leading aggregation builder. Build and debug your view with ease and then store it as a read-only view with just a click of your mouse.

Collation Support

With MongoDB 3.4, you can now provide a collation document to specify language-specific rules for string comparison, such as rules for letter case and accent marks. MongoChef 4.5 allows you to specify a collation when you’re creating a collection, view, or an index and also when building an aggregation pipeline – and, naturally, wherever applicable in IntelliShell.

New Aggregation Operators

MongoDB 3.4 has also brought a number of new aggregation operators ($bucket, $bucketAuto, $facet, $graphLookup, $sortByCount). Of course, both MongoChef’s aggregation builder and IntelliShell have you covered here.

Export Your MongoDB Data to SQL

MongoChef Pro and Enterprise now let you export your MongoDB data directly to SQL and support the major SQL dialects: Oracle, MS SQL Server, MySQL, and PostgreSQL. Select your MongoDB data source and export to a SQL file that can then be safely imported into your SQL deployment.

1) Choose your SQL format options:

2) MongoChef runs schema discovery on your MongoDB data to auto-select the most appropriate SQL target data types. You can of course also manually overwrite the mapping.

Improved Connection Tree

We have introduced new meta-levels below the database level to make it even more comfortable to manage your various collections, views, system collections, and GridFS buckets.

Integration of mongodump and mongorestore for Easy Backups

MongoChef now integrates with the mongodump and mongorestore backup and restore tools. You can now directly export (and of course import) your databases, collections or your query results to BSON folders or BSON archive files directly from within MongoChef. Backing up your data with MongoChef has never been easier.

Please add better intellisense on aggregation. This would include both basic intellisense for fields and advanced intellisense for other aggregation functionality including counting, unwinding ,grouping, lookups etc.

Also could the stages on the tabs be renamed to something like $match(1) , $match(2), $unwind(3) etc.

Thank you Davit for this suggestion. Quite a few people have asked for this so we have it on our to-do list and it will be implemented in one of our next releases. Please continue to update to the latest release of MongoChef for more new features and hot fixes.

Happy to hear it, Ashkan! We did mean CouchBase, specifically their Community Edition (https://www.couchbase.com/downloads), but it's definitely worth mentioning that their other edition (Enterprise) is not open-source and isn't free for production use.

Tags list

Studio 3T

Studio 3T helps thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Happy to hear it, Ashkan! We did mean CouchBase, specifically their Community Edition (https://www.couchbase.com/downloads), but it's definitely worth mentioning that their other edition (Enterprise) is not open-source and isn't free for production use.