Build MongoDB Aggregation Pipelines Visually
Drag stages, configure fields, and see results in real time. No more debugging nested JSON in a terminal.
Download MongoPilotAggregation pipelines are powerful but painful to write
MongoDB’s aggregation framework can do almost anything. Grouping, lookups, reshaping, statistical analysis. But building pipelines means writing deeply nested JSON by hand, switching between documentation tabs, and running the pipeline over and over to check each stage. A missing bracket or a wrong field name sends you back to the start. For complex pipelines with five or more stages, this process can take hours.
See every stage, build with confidence
MongoPilot gives you a visual canvas where each pipeline stage is a draggable card. Pick a stage from the sidebar, configure it with your collection’s actual field names, and run the pipeline to see results at each step. Switch between the visual editor and raw JSON at any time. When your pipeline is ready, copy the code and paste it into your application — or export the results directly.
What you can do
Drag-and-Drop Stages
Pick from match, match,group, lookup, lookup,unwind, project, project,sort, addFields, addFields, count, merge, $indexStats, and more. Drag them onto the canvas and reorder freely.
Live Execution
Run your pipeline at any point and see the output immediately. The results panel shows document count, execution stats, and formatted JSON for every run.
Visual + Code Editing
Configure stages through form fields or switch to the JSON code view to edit directly. Changes sync both ways — use whichever mode fits the task.
Copy & Export
Copy the full pipeline as JSON to paste into your application code. Export results to JSON or CSV for analysis in other tools.
Pipeline Search
Search across all stages to find specific fields, operators, or values. Navigate between matches with keyboard shortcuts — essential for large pipelines.
Detachable Results Window
Pop the results panel into a separate window. Compare outputs side by side or keep results visible while editing stages on your main screen.
From blank canvas to working pipeline in minutes
1. Pick your stages
Open the pipeline builder from any collection. The sidebar lists every aggregation stage organized by category — filtering, reshaping, grouping, joining, and analysis. Click or drag a stage to add it.
2. Configure with real fields
Each stage knows your collection’s schema. Select fields from a dropdown instead of typing them manually. Set conditions, grouping keys, and projections through a structured form — or edit the raw JSON directly.
3. Run, refine, export
Hit Execute to see results instantly. Check document counts and stage-by-stage statistics. Reorder stages, adjust configurations, and re-run until the output is exactly what you need. Copy the pipeline code or export the results.
Related Features
Index Performance Experiments
Test index impact on cloned collections before touching production.
Index Management
View, create, and drop indexes. Check which ones are used and which are wasting resources
AI Query Assistant
Describe what you need in plain English and get a pipeline suggestion instantly
Stop writing MongoDB pipelines in the dark
Free trial of the most intuitive MongoDB GUI. Mac, Windows, and Linux.
Download MongoPilot