|
Personal
|
Commercial
|
Basic
|
|
¡¡
|
Operating
System
|
Windows,
Mac, Linux
|
MongoDB
Community Server
|
3.6-7.0
|
3.6-7.0
|
MongoDB
Enterprise Server
|
3.6-7.0
|
3.6-7.0
|
MongoDB
Atlas
|
✔
|
✔
|
Connection
|
|
¡¡
|
Direct Connection
|
✔
|
✔
|
Replica
Set
|
✔
|
✔
|
Sharded
Cluster
|
✔
|
✔
|
SSH
Tunnel Integration
|
✔
|
✔
|
SSL
Support
|
✔
|
✔
|
Customize
Connection Colorings
|
✔
|
✔
|
Export/import
Connection Settings
|
✔
|
✔
|
Authentication
|
|
¡¡
|
SCRAM-SHA-1
Authentication
|
✔
|
✔
|
SCRAM-SHA-256
Authentication
|
✔
|
✔
|
MONGODB-CR
Authentication
|
✔
|
✔
|
X.509
Authentication
|
✔
|
✔
|
Kerberos
(GSSAPI) Authentication
|
¥¹
|
✔
|
LDAP
(PLAIN) Authentication
|
¥¹
|
✔
|
MONGODB-AWS
Authentication
|
¥¹
|
✔
|
MongoDB
Shell and Extensions
|
|
¡¡
|
Embedded
MongoDB Shell (do not require mongo shell binary)
|
✔
|
✔
|
ES2020
Syntax Support
|
✔
|
✔
|
Chaining
Fluent Find/Aggregate API
|
✔
|
✔
|
Operator
Helper($) and Pipeline Builder
|
✔
|
✔
|
Shell
Extensions (lodash, moment, shelljs, mathjs)
|
✔
|
✔
|
Using
Node/NPM modules in Your Script
|
✔
|
✔
|
Code
Editing and Script Processing
|
|
¡¡
|
Code
Completion
|
✔
|
✔
|
Code
Snippets
|
✔
|
✔
|
Query
Script History
|
✔
|
✔
|
Syntax
Highlighting
|
✔
|
✔
|
Editor
Themes
|
✔
|
✔
|
Automatic
Indent
|
✔
|
✔
|
Code
Formatter (Source Code Beautifier)
|
✔
|
✔
|
Code
Folding
|
✔
|
✔
|
On-the-fly
Error Detection
|
✔
|
✔
|
Mouse
Hover
|
✔
|
✔
|
Bracket
and Parentheses Matching
|
✔
|
✔
|
Mark
Changed Lines
|
✔
|
✔
|
Read-only
Status-Lock
|
✔
|
✔
|
Switch
Connection/RS Member/Database Within the Editor
|
✔
|
✔
|
Visual
Query Builder
|
✔
|
✔
|
Visual
Explain Plan
|
✔
|
✔
|
Query
Code (Convert MongoDB Query and SQL to Java, C#, Python, Nodejs, PHP,
Ruby, Golang)
|
¥¹
|
✔
|
Debugger
capabilities
|
|
¡¡
|
Breakpoints
|
✔
|
✔
|
Step-by-step
Execution(Step over/into/out/stop)
|
✔
|
✔
|
Call
Stack
|
✔
|
✔
|
Watch
and Edit Variables
|
✔
|
✔
|
Debug Console
REPL
|
✔
|
✔
|
Data
Viewer
|
|
¡¡
|
Tree/Table/JSON
Viewer
|
✔
|
✔
|
In-Place
Tree/Table Editing
|
✔
|
✔
|
CRUD
Operations
|
✔
|
✔
|
Mark
Types with Colors
|
✔
|
✔
|
Tooltip
for Array, Object and ObjectId Values
|
✔
|
✔
|
One-click
Filter By (Query by Example)
|
✔
|
✔
|
One-click
Group-By (COUNT, SUM, MIN, MAX, AVG)
|
✔
|
✔
|
One-click
Order By (ASC, DESC)
|
✔
|
✔
|
One-click
Project By
|
✔
|
✔
|
One-click
Save Query as MongoDB Read-only View (Exclude/Include Visible Columns)
|
✔
|
✔
|
Binary
Image Preview Tooltip
|
✔
|
✔
|
Visualize
Geo JSON Data
|
✔
|
✔
|
Object
Explorer/Management
|
|
¡¡
|
Database
Management
|
✔
|
✔
|
Collection
Management
|
✔
|
✔
|
Index
Management
|
✔
|
✔
|
User and
Role Management
|
✔
|
✔
|
GridFS
Management
|
✔
|
✔
|
Watch
Database/Collection (Change Streams)
|
✔
|
✔
|
Open
MongoDB Shell Here
|
✔
|
✔
|
Open
NoSQLBooster Command Line Here
|
✔
|
✔
|
Show/hide
System Objects
|
✔
|
✔
|
Set Comments
for Any Database Objects
|
✔
|
✔
|
Information-rich
Database Object Tooltip
|
✔
|
✔
|
Copy
& Paste MongoDB Database and Collections
|
✔
|
✔
|
Database
Object Favorites
|
✔
|
✔
|
Server
Monitoring
|
|
¡¡
|
In-progress
Operations Viewer
|
✔
|
✔
|
Kill In-progress
Operation
|
✔
|
✔
|
Database
Profiler
|
✔
|
✔
|
Log
Viewer: The Most Recent 1024 Mongod Events
|
✔
|
✔
|
Log
Viewer: Parse External MongoDB Log File
|
✔
|
✔
|
Mongo
Status Charts and Data Table (mongostat)
|
✔
|
✔
|
Mongo Top
(Track Read And Write)
|
✔
|
✔
|
Server/Replica/Sharding
Status
|
✔
|
✔
|
Import/Export
and Backup/Restore
|
|
¡¡
|
One-click
Export XSLX and View as Spreadsheet in Excel...
|
✔
|
✔
|
Export
to JSON/BSON
|
✔
|
✔
|
Export
to CSV
|
✔
|
✔
|
Export to
Excel(.xslx and .xslb)
|
✔
|
✔
|
Export
to TXT and HTML(.txt and .html)
|
✔
|
✔
|
Export
to SQL
|
✔
|
✔
|
Import
from JSON/BSON
|
✔
|
✔
|
Import
from CSV
|
✔
|
✔
|
Import
from MySql, PostgreSql and MSSQL
|
✔
|
✔
|
mongoimport
Integration
|
✔
|
✔
|
mongoexport
Integration
|
✔
|
✔
|
mongorestore
Integration
|
✔
|
✔
|
mongodump
Integration
|
✔
|
✔
|
SQL
Query
|
|
¡¡
|
SQL
Query (SELECT, WHERE, GROUP BY, HAVING, DISTINCT, ORDER BY, LIMIT)
|
✔
|
✔
|
SQL
Functions (COUNT, SUM, MAX, MIN, AVG)
|
✔
|
✔
|
Date,
String, Conversion Functions
|
✔
|
✔
|
Aggregation
Pipeline Operators in SQL Query
|
✔
|
✔
|
SQL
JOIN and Uncorrelated SubQuery
|
✔
|
✔
|
SQL
Code Completion
|
✔
|
✔
|
Command
Line Interface
|
|
¡¡
|
Run
JavaScript Script File
|
✔
|
✔
|
Run
JavaScript Statements
|
✔
|
✔
|
Run SQL
Query Statements
|
✔
|
✔
|
Run
Tasks
|
¥¹
|
✔
|
Other Useful
Features
|
|
¡¡
|
Quick
Access to My Queries (My Queries Tab)
|
✔
|
✔
|
Learn
MongoDB with Free Interactive Samples (Samples Tab)
|
✔
|
✔
|
Test
Data Generator
|
✔
|
✔
|
Tasks
|
✔
|
✔
|
Task
Schedule
|
¥¹
|
✔
|
Schema Explorer/Visualization/Documentation
|
✔
|
✔
|
Collection
re-schema tool
|
✔
|
✔
|
Command
Log Window
|
✔
|
✔
|
Auto
Self-Update
|
✔
|
✔
|