BysonDB v1.1.9 - Aggregation Pipeline Builder 🧱
A new visual way to build, preview, and tune MongoDB aggregation pipelines, right inside BysonDB.
✨ New: Aggregation Pipeline Builder
Open it from the collection menu in the sidebar (Aggregate...).
- Build visually. Drag stages from a searchable palette (or click to add), reorder by the drag handle, enable/disable, and duplicate stages. Every stage gets its own editor.
- Form or Code per stage. Simple stages ($match, $project, $sort, $limit, $skip, $sample, $unwind) offer a structured form; anything more advanced falls back to a code editor.
- Live preview. See results up to any stage as you build, in Tree / Table / JSON views. Write stages ($out / $merge) are skipped in preview.
- Explain plan. One click shows the execution plan (index usage, COLLSCAN warnings, docs examined vs returned) plus static hints (move $match earlier, suggest indexes for $match / $sort).
- Collection autocomplete for $lookup, $graphLookup, $unionWith, $out, and $merge.
- Save and reuse pipelines, export results to JSON, copy the generated code, or open it in a Query tab.
- Pipelines and view preferences are remembered across tab switches and restarts.
🔒 Safe by design
Aggregation results are read-only, so you cannot accidentally edit or delete documents from the results view, and the source collection is never modified.