NoSQL Booster for MongoDB 4.7.2 Enterprise Edtion
NoSQLBooster for MongoDB (formerly MongoBooster) is a shell-centric cross-platform GUI tool for MongoDB v2.6-4.0, which provides fluent query builder, SQL query SQL Query, update-in-place, ES2017 syntax support and true intellisense experience. NoSQLBooster for MongoDB offers true IntelliSense experience. The build-in language service knows all possible completions, methods, properties, variables, key words, even the MongoDB collection names, field names and operators. The IntelliSense suggestions will pop up as you type. You can always manually trigger it with Ctrl-Shift-Space. Out of the box, Ctrl-Space, Alt-Space are acceptable triggers.
In the script editor, parameter hints will pop up as you’re typing a method invocation.
We offer tons of build-in snippets, Handy date range snippets, SQL to MongoDB conversion snippets…
The mouse hover will show many useful information, such as types of symbols, function definition, type information and document.
Matching brackets will be highlighted as soon as the cursor is near one of them.
With NoSQLBooster for MongoDB, you can run SQL SELECT Query against MongoDB. SQL support includes functions, expressions, aggregation for collections with nested objects and arrays.
Let’s look at how to use the GROUP BY clause with the SUM function in SQL.
Instead of writing the MongoDB query which is represented as a JSON-like structure
SQL Query Features
Access data via SQL including WHERE filters, ORDER BY, GROUP BY, HAVING, DISTINCT, LIMIT
SQL Functions (COUNT, SUM, MAX, MIN, AVG)
Aggregation Pipeline Operators as SQL Functions (dateToString, toUpper, split, substr…)
Provide a programming interface (mb.runSQLQuery) that can be integrated into your script
Autocomplete for key words, MongoDB collection names, field names and SQL functions
Please note that SQL features are not natively supported by MongoDB. The SQL query is validated and translated into a MongoDB query and executed by NoSQLBooster for MongoDB. The Equivalent MongoDB Query can be viewed in console.log tab.
NoSQLBooster for MongoDB comes with visual query builder. The two-way query builder could help you construct and display complex MongoDB find statements even without the knowledge of the MongoDB shell commands syntax.
Schema Analyzer is a very useful build-in tool. Due to schema-less feature, collections in MongoDB do not have a schema document to describe field’s datatype, collection structure and validations. With our brand new Schema Analyzer Tool, you will get a document to describe the schema of certain collection from sampled(random, first, last) N or all records.
The document shows the probability of sampled objects , different types percentage, you could get a brief of certain collection’s schema. If you want more accurate result, you could sample more records or analyze whole collection, but it may took a long time to finish if the collection has millions records or thousands fields.
It also shows document validation of the collection, which is a new feature in MongoDB 3.2. There will be a validator window showing below the document. If you click the link, field will be highlighted in the window.
NoSQLBooster for MongoDB includes a few useful MongoDB shell extensions to make the life inside of the MongoDB shell a little bit easier.
NoSQLBooster for MongoDB integrates lodash, shelljs, momentjs and mathjs utility library. You can directly use lodash , shelljs, moment and mathjs in your shell script.
ShellJs ShellJS is a portable (Windows/Linux/OS X) implementation of Unix shell commands on top of the Node.js API.
Moment.js is a full featured date library for parsing, validating, manipulating, and formatting dates.
MongoDB, NoSQLBooster, query, shell, collection, Space, document, names, Query, experience, support, build, field, script, functions, language, IntelliSense, which, builder, schema, MongoDB, NoSQLBooster, query, shell, collection, Space, document, names, Query, experience, support, build, field, script, functions, language, IntelliSense, which, builder, schema