mongodb-aggregation-pipeline

What problem does it solve?

This Skill helps you design and optimize MongoDB aggregation pipelines to turn raw documents into analysis-ready results without writing complex, error-prone custom logic.

Core Features & Use Cases

• Pipeline Construction: Build multi-stage pipelines using key operators like $match, $group, $project, $sort, $limit, $skip, $unwind, and $lookup for joining collections.
• Data Transformation & Analytics Queries: Reshape documents, compute aggregates (sum/avg/min/max), and derive new fields with expressions such as $concat, $toLower, and $cond.
• Performance-Oriented Guidance: Apply practical rules like filtering early, avoiding unnecessary $project stages, leveraging indexes for $match, and using $facet for parallel result views.

Quick Start

Use the mongodb-aggregation-pipeline skill to create an aggregation pipeline that filters active orders, groups them by category, computes total sales and order counts, and sorts categories by total sales descending.