www.mongobooster.com Open in urlscan Pro
34.231.250.163  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Toggle Navigation
 * Home
 * Features
   * Feature Tour
   * Unique Feature List
   * 
   * Feature Matrix
   * 
   * Code Editing and Script Processing
   * Results Tab and Data Viewer
   * Performance Monitoring Tools
   * Query MongoDB with SQL
   * Mongo Shell and Extensions
   * Use Node Modules in Your Script
   * 
   * Complete List of SQL Support
   * Chaining Fluent Query API for MongoDB
   * Command Line Interface (nbcli)
 * Downloads
 * Purchase
   * Order New licenses
   * 
   * Upgrade Existing License
   * 
   * Renew Software Assurance
 * Support
 * Blog
 * 
 * 
 * 




THE SMARTEST IDE FOR MONGODB

NoSQLBooster is a cross-platform GUI tool for MongoDB v2.6-5.0, which provides a
build-in MongoDB script debugger, comprehensive server monitoring tools,
chaining fluent query, SQL query, query code generator, task scheduling, ES2020
support, and advanced IntelliSense experience.

NEW VERSION 7.0 AVAILABLE NOW!


Download Learn more




 * EMBEDDED MONGODB SHELL
   
   NoSQLBooster embeds V8 JavaScript engine. No external MongoDB command line
   tools dependence. Support MongoDB 2.6-5.0

 * 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?


MONGODB SCRIPT DEBUGGER

Still debugging your MongoDB script with print statements? Now, you can use
NoSQLBooster's built-in debugging capabilities to set breakpoints and step
through code.

To start debugging, click the editor's text margin to set a breakpoint F9, and
run with debugger F5. When your breakpoint is hit, you can explore the call
stack, watch and edit variables, and interact directly with the debugger.







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.

Click here to learn more about code editing and script processing.





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.

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

db.employees.aggregate([{
        $group: { _id:   "$department", total: { $sum: "$salary" }}
    }])


You can query MongoDB by using old SQL, which you probably already know.

  SELECT department, SUM(salary) AS total FROM employees GROUP BY department



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.

Click here to learn how to run SQL SELECT Query against MongoDB





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

The following is a screenshot of Visual Explain, Click here to learn more about
NoSQLBooster Performance Monitoring Tools.







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.







CHAINING FLUENT MONGODB QUERY

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.

// instead of writing:
db.user.find({age:{$gte:18,$lte:65}},{name:1,age:1,_id:0}).sort({age:-1, name:1});

// we can write:
db.user.where('age').gte(18).lte(65).select('name age -_id').sort("-age name");    

// passing query conditions is permitted too
db.collection.find().where({ name: 'nosqlbooster' })

// chaining
db.collection
    .where('age').gte(18).lte(65)
    .where({ 'name': /^nosqlbooster/i })
    .where('friends').slice(10)

// aggregation
db.companies.aggregate() 
  .match(qb.where('founded_year').gte(2000).lte(2010)) //qb:querybuilder
  .group({_id:"$category_code",count:{$sum:1}})
  .sort('-count')
  .limit(100)






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. It also adds mongoose-like fluent API, provides
mb.runSQLQuery function, integrates a few utility modules (lodash, moment,
bluebird, shelljs, mathjs) to global scope to make the life inside of the
MongoDB script a little bit easier.

Here's how to install and use the npm package.

Launch NoSQLBooster for MongoDB. - Execute Main Menu -> Help -> Open User Data
Directory - New Terminal at this folder

npm i axios  # run it in NoSQLBooster for MongoDB user data directory


After successfully installing this package in the NoSQLBooster for MongoDB User
Data Directory, you can require and access it in the NoSQLBooster for MongoDB
script.

const axios=require("axios");
let rst=await (axios.get('https://api.github.com/users/github'));//await promise
console.log(rst.data);


The following figure shows the use of lodash and Moment.js directly in mongodb
shell scripts.






 * ENABLE SSH TUNNELING

 * GUI FOR MONGODB TOOLS - MONGOTOP, MONGOSTAT...

 * MONGODB ENTERPRISE AUTHENTICATION, KERBEROS & LDAP(PLAIN)

Download Learn more
Contact
Terms & conditions
Privacy policy
MongoDB Admin GUI, Copyright © 2022 AnQing Inspector Software All rights
reserved