NoSQLBooster for MongoDB 9.0.6
Shell-centric cross-platform GUI tool for MongoDB
Category: | Developer Tools |
Price: | High |
Popularity: | Low |
Version String: | 9.0.6 |
Release Date: | 2024-09-30 |
Architecture: | Intel |
Minimum OS: | macOS 10.10.0 |
Vendor Name: | qinghai |
Homepage: | nosqlbooster.com |
Version History 9.0.6
#{version_history}
Description:
The Smartest IDE for MongoDB
NoSQLBooster for MongoDB (formerly MongoBooster) is a shell-centric cross-platform GUI tool for MongoDB v2.6-4.4, which provides comprehensive server monitoring tools, fluent query builder, SQL query, query code, task schedulingserver monitoring tools, ESNext support, and true IntelliSense experience.
✪ Embedded MongoDB Shell
NoSQLBooster embeds V8 JavaScript engine. No external MongoDB command line tools dependence. Support MongoDB 2.6-4.4
✪ Query Code Generator
Converts MongoDB find/aggregate and SQL into Node.js, Java, Python, C #, PHP, Ruby, Golang and mongo shell languages
✪ Tasks and Task Scheduler
Define and perform tasks to import/export, dump/restore, or run script files on a recurring schedule.
Why Choose NoSQLBooster for MongoDB?
● True IntelliSense
NoSQLBooster for MongoDB offers true IntelliSense experience. The built-in language service knows all possible completions, methods, properties, variables, keywords, even the MongoDB collection names, field names, and operators. The IntelliSense suggestions 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 pop up as you're typing a method invocation.
• We offer tons of built-in snippets, Handy date range snippets, SQL to MongoDB conversion snippets...
• The mouse hover show much useful information, such as types of symbols, function definition, type information, and document.
• Matching brackets is highlighted as soon as the cursor is near one of them.
● Query MongoDB with SQL
With NoSQLBooster for MongoDB, you can run SQL SELECT Query against MongoDB. SQL support includes SQL JOINS, functions, expressions, aggregation for collections with nested objects and arrays.
SQL Query Features
• Access data via SQL including WHERE filters, ORDER BY, GROUP BY, HAVING, DISTINCT, LIMIT
• SQL Functions (COUNT, SUM, MAX, MIN, AVG)
• Date, String, Conversion Functions (dateToString, toUpper, split, substr...)
• Aggregation Pipeline Operators as SQL Functions
• SQL Equi JOIN and uncorrelated sub-queries
• Provide a programming interface (mb.runSQLQuery) that can be integrated into your script
• Autocomplete for keywords, MongoDB collection names, field names, and SQL functions
Please note that MongoDB does not natively support SQL features. 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 the console.log tab.
● Monitor and Tune for Performance
NoSQLBooster provides rich performance monitoring and analysis tools to help you keep your MongoDB environment running smoothly.
• Visual Explain Plan, transforms explain output into a hierarchical view, allowing for query tuning to enhance query and resolve performance issues.
• Server Real-Time Status (mongostat), view MongoDB real-time performance metrics as a chart or tabular form.
• In-progress Operations Viewer, find and kill long-running MongoDB operations quickly.
• MongoDB Log Parser, easier to parse, filter, and analyze MongoDB log information.
• Database Profiler, collects detailed information about Database Commands executed against a running mongod instance.
• GUI for mongotop, tracks the time required to read and write operations thoroughly.
• Troubleshoot Replica Sets
● Learn Mongodb with Free Interactive Samples
The "My Queries" tab is used to open user-saved query scripts quickly. By default, the user-saved query script is saved as a "connection -> database -> query name" directory structure. Double-click to open a saved query script will automatically connect to the appropriate database server and switch to the proper database.
The "Samples" tab includes several NoSQLBooster-Enabled tutorials. All samples are executable in NoSQLBooster already, with detailed descriptions. You can try these queries and change them to learn better.
● Fluent MongoDB Query builder
NoSQLBooster for MongoDB supports mongoose-like fluent query builder API. A Query enables you to build up a query using chaining syntax, rather than specifying a JSON object. The aggregation framework is now fluent as well. You can use it as currently documented or via the chainable methods.
● Schema Analyzer
Schema Analyzer is a handy built-in tool. Due to schema-less features, collections in MongoDB do not have a schema document to describe the field's datatype, collection structure, and validations. With our brand new Schema Analyzer Tool, you get a document to describe the schema of a particular collection from sampled(random, first, last) N or all records.
● Shell Extensions, Using Node Modules, Lodash, Momentjs in Your Script
NoSQLBooster for MongoDB is an electron-powered desktop application that bundles Node.js and Chromium runtime. You can use any Node.js build-in global objects and modules (console, util, fs, path ...) and pure JS NPM packages in NoSQLBooster for MongoDB.