Connections Manager 
Import Wizard 
Collections Tab 
Visual Query Builder 
SQL Query 
SQL Connection Manager 
Team Sharing 
LDAP/ Kerberos
Export Wizard .svg){kind=icon}
SQL to MongoDB.svg){kind=icon}
MongoDB to SQL
Data Compare & Sync 
Task Scheduler 
Intellishell 
Schema Explorer 
AI Helper 
Aggregration Editor 
Query Code 
Query Profiler 
Index Manager 
Visual Explain 
Reschema 
Users and Roles Manager 
Data Masking 
MongoDB Aggregation Framework
Aggregation Editor
Take a look at how to build aggregation queries stage-by-stage with the Aggregation Editor, starting with this example that uses $match, $group and $sort.
Posted on: 02/06/2020 (last updated: 27/02/2025) • Kirsty Burgess • 10 minutesMongoDB $out Example | The MongoDB Aggregation Pipeline
We show you how to use the MongoDB $out stage to output documents of an aggregation query to a new collection.
Posted on: 26/11/2019 (last updated: 03/11/2023) • Kathryn Vargas • 2 minutesMongoDB $project Example | The MongoDB Aggregation Pipeline
The $project stage is extremely useful for showing only the fields you need. In this article, we walk through an example of the $project stage in tandem with $lookup.
Posted on: 26/11/2019 (last updated: 03/11/2023) • Kathryn Vargas • 3 minutesMongoDB $lookup Example | The MongoDB Aggregation Pipeline
In this article, we show you two ways to run a MongoDB $lookup using Studio 3T. $lookup lets you join data from two collections, as long as they are on the same database.
Posted on: 26/11/2019 (last updated: 16/10/2023) • Kathryn Vargas • 4 minutesSupported MongoDB Aggregation Operators and Stages
The full list of MongoDB aggregation operators and stages supported by the Aggregation Editor, Studio 3T’s MongoDB aggregation query builder.
Posted on: 30/10/2018 (last updated: 08/12/2022) • Kathryn Vargas • 5 minutesExtending MongoDB Aggregation with the Bucket and Facet Stages
Learn how to query the MongoDB aggregation pipeline more efficiently with the $bucket and $facet stages.
Posted on: 03/09/2018 (last updated: 04/08/2021) • Phil Factor • 6 minutesUsing Aggregation and Regex in MongoDB to Reduce Data in a Collection
Learn how to use regex to transform an external data set to JSON or export it to CSV for later import, and run aggregation queries to reduce the data before creating a MongoDB collection.
Posted on: 19/06/2018 (last updated: 04/08/2021) • Phil Factor • 9 minutes
