Learn how to run Aggregation in MongoDB Compass. Our MongoDB Support team is here to help you with your questions and concerns.

Run Aggregation in MongoDB compass

MongoDB Compass offers several modes for creating aggregation pipelines. Each mode is tailored to different user preferences and pipeline complexities:

• Stage View Mode:

  This mode offers a visual pipeline editor that preloads pipeline syntax as per selected stages.
• Stage Wizard:

  It is a feature of Stage View Mode. The Stage Wizard offers templates for simple aggregation stages. It’s ideal for beginners and provides a quick way to start building pipelines.
• Focus Mode:

  This is also a part of Stage View Mode. It lets us edit one stage at a time. This makes it easier to manage complex or nested pipeline stages.
• Text View Mode:

  This mode lets us edit the pipeline using raw syntax. Hence offering more flexibility and control for advanced users.

Before building a pipeline, we have to select a collection and head to the Aggregations tab in MongoDB Compass. This tab will display a blank aggregation pipeline along with a preview of documents from the selected collection.

How to Create an Aggregation Pipeline

1. Here, we will create an aggregation pipeline in the Stage View Mode. First, select the {} Stages toggle switch in the aggregation pipeline pane.

   
2. Then, click the + Add Stage button to add an aggregation stage.
3. Next, select a stage from the Select drop-down menu and choose the aggregation pipeline stage to use for the first stage of the pipeline.
4. Then, fill in the selected stage. We can adjust the width of the pipeline stage by dragging its border to the right.

   Additionally, the toggle to the right of each pipeline stage name lets us know if the stage is included in the pipeline.
5. We can add the pipeline stage after the last aggregation stage by clicking Add Stage. We can add an aggregation stage ahead of our most recently added stage, by clicking the + icon above the stage card.
6. Repeat Steps 3 to 5 for each additional stage.
7. Finally, click Run at the top-right corner of the pipeline builder.

To create an aggregation pipeline in the Stage Wizard mode, follow the steps in Stage View Mode, but use the Stage Wizard templates for simple aggregation stages.

Similarly, to create an aggregation pipeline in the Focus Mode mode, follow the steps in Stage View Mode, but focus on editing one stage at a time to manage complexity.

Additionally, we can do this via the Text View Mode tab by manually entering our pipeline syntax. We have to click Run to execute the pipeline and view the results in the document view.

With the above steps, we can easily create and run aggregation pipelines in MongoDB Compass via the mode that best suits our needs.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In brief, our Support Experts demonstrated how to create and run an Aggregation pipeline in MongoDB Compass.