MongoDB aggregation made easy.
Studio 3T is the tops for me.
In only 30 minutes, I can gain one whole day of work when building aggregation queries.
Pierre Yves Folens
DevOps Engineer at Orange
What is aggregation in MongoDB?
Go beyond find() queries with MongoDB’s powerful aggregation pipeline
Get new data from existing data
Aggregation is gathering existing data from multiple sources and expressing it in a new, summarized form – whether that’s a sum or count. In MongoDB, you have many aggregate pipeline stage operators at your disposal.
Build aggregations faster
Say goodbye to writing complex db.collection.aggregate queries
Add operators one stage at a time
Aggregation Editor, Studio 3T’s aggregation pipeline builder, makes it easy to build queries one stage at a time, and add, move, edit and delete them as needed.
Duplicate stages in one click
Find yourself writing similar queries throughout the aggregation pipeline? Save time and clone stages instead.
Generate code in six languages
Make debugging easy
Handy functionalities to help you get straight to the problem
View inputs and outputs of each stage
Check the inputs and outputs of each aggregation stage, so that you’re sure that your MongoDB aggregation query is on track.
Enable and disable stages in the pipeline
You can, of course, execute the full pipeline at any time, but you can also enable or disable stages to help you debug.
Get the full picture – never sample sets
Whether you’re checking individual stage inputs or outputs or running the full pipeline, Aggregation Editor always uses the full data set.
We use the Aggregation Editor to debug our stages. To check the pipeline and make sure that we’re getting the correct results that we’re looking for. It then shows us the results visually in a nice way, we don’t have to do things manually, stats and all that.
Backend Lead Engineer at Speero
Share your work with the whole team
Skip the duplicate work to save you and your colleagues time
Share aggregation queries as JS files
Create views from aggregation queries
Views are a handy way to access your data, and you can create them from aggregation queries and see them directly in the Connection Tree.
Why use Aggregation Editor?
Work with MongoDB aggregation queries with minimal hassle
Get the data you need from MongoDB collections
The data is right in your MongoDB collection(s). Aggregation Editor lets you do accurate aggregations minus the complication.
Multiple export options for reporting
Easily export aggregation query results to JSON, CSV, SQL, or another MongoDB collection to complement reporting needs within your business.
Why choose Studio 3T’s MongoDB aggregation pipeline builder?
Kind words from happy customers
Studio 3T is a fantastic all round tool. It makes my life really easy and has all I need in one place. My best feature is the Aggregation Editor tool which helps me write and manipulate aggregation code with so much ease it’s painless.
Backend Manager at Softcom Ltd.
I love working on Studio 3T and I have no doubts to say that this tool has helped me scale up in writing aggregate queries at ease for some complex data mining needs at my work.
IT Quality Control Advisor at Anthem
I have tried Compass, dbKoda and the mongo shell before. I will say Studio 3T was so handy and an easy to use tool which solved many of my problems. Aggregation works like a charm.
Data Consultant at Allied Technical Services
How to Build MongoDB Aggregate Queries
MongoDB $lookup Example