What is the MongoDB Aggregation Beautifier?

It is a browser tool that takes a compacted or single-line MongoDB aggregation pipeline and reformats it with clean indentation so each stage and expression is easy to read and review.

Does it work with a full aggregate() call or just the stage array?

Both. You can paste a complete db.collection.aggregate([...]) statement or just the bare array of pipeline stages — the beautifier formats either one.

Will it run or execute my aggregation against a database?

No. It only formats the text of your pipeline. It does not connect to MongoDB, run the aggregation, or return any query results.

Does my pipeline get uploaded anywhere?

No. This is a local tool that runs entirely in your browser, so the pipeline you paste never leaves your device and nothing is uploaded to ArrayKit or any server.

Is it safe to paste a pipeline that contains sensitive field names or values?

Yes. Because all parsing and formatting happens locally on your machine, sensitive collection, field, and value details stay on your device.

How is this different from the MongoDB Query Beautifier?

The Query Beautifier targets find() and shell-style queries, while this tool is tuned for aggregation pipelines — arrays of stages like $match, $group and $sort.

MongoDB Aggregation Beautifier Online

Name: MongoDB Aggregation Beautifier
Author: ArrayKit

Beautify and indent MongoDB aggregation pipelines in your browser. Your pipelines never leave your device.

This is a local tool: it runs entirely in your browser, the aggregation pipeline you paste never leaves your device, and nothing is uploaded to ArrayKit or any server.

Built and maintained by Udit Agarwal

Open MongoDB Query Beautifier

About MongoDB Aggregation Beautifier

The MongoDB Aggregation Beautifier formats and indents messy, single-line aggregation pipelines into clean, readable code right in your browser. Paste a `db.collection.aggregate([...])` call or a bare array of stages like `$match`, `$group`, `$sort` and `$lookup`, and it pretty-prints the whole pipeline with consistent two-space indentation so you can actually read what each stage does. It is built for backend and data engineers debugging slow aggregations, reviewers checking a pull request, and anyone copying a compacted pipeline out of logs, a driver, or the Mongo shell. Because everything runs locally as a browser tool, there is no request building or upload involved — the formatter parses and reflows your pipeline on your own machine. Use it to clean up exported queries, document pipelines, or spot a misplaced bracket before running an aggregate against production data.

Features

Beautifies full `db.collection.aggregate([...])` calls and bare stage arrays alike
Consistent two-space indentation across every stage and nested expression
Handles common stages — $match, $group, $sort, $project, $lookup, $unwind, $facet and more
Preserves MongoDB-specific values such as ISODate(), ObjectId() and operator keys
Live formatting as you type, with no run or submit step
Clear error message when brackets are unbalanced or syntax is invalid
Copy the beautified pipeline or download it as a .js file
Runs entirely in your browser — nothing is uploaded

How to use the MongoDB Aggregation Beautifier

Paste your aggregation pipeline or full aggregate() call into the input box
Read the beautified, indented pipeline that appears in the output panel
Fix any reported error if brackets or syntax look off
Copy the formatted result or download it as pipeline.js

Example

Input

db.orders.aggregate([{$match:{status:"paid"}},{$group:{_id:"$userId",total:{$sum:"$amount"}}},{$sort:{total:-1}}])

Output

db.orders.aggregate([
  {
    $match: {
      status: "paid"
    }
  },
  {
    $group: {
      _id: "$userId",
      total: {
        $sum: "$amount"
      }
    }
  },
  {
    $sort: {
      total: -1
    }
  }
])

A compact one-line pipeline reflowed into readable, indented stages.

Common errors & troubleshooting

Could not format — unbalanced brackets reported. — Check that every [ , { and ( has a matching close; a single dropped bracket breaks parsing of the whole pipeline.
Pasted only part of the pipeline and got a syntax error. — Copy the complete aggregate([...]) call or the entire stage array, including the outer brackets.
Trailing commas from a code editor cause a parse failure. — Remove any trailing comma after the last stage or the last field in an object before formatting.
Smart quotes from a document break the input. — Replace curly quotes with straight " or ' quotes so string values parse correctly.

Frequently asked questions

What is the MongoDB Aggregation Beautifier?: It is a browser tool that takes a compacted or single-line MongoDB aggregation pipeline and reformats it with clean indentation so each stage and expression is easy to read and review.
Does it work with a full aggregate() call or just the stage array?: Both. You can paste a complete db.collection.aggregate([...]) statement or just the bare array of pipeline stages — the beautifier formats either one.
Will it run or execute my aggregation against a database?: No. It only formats the text of your pipeline. It does not connect to MongoDB, run the aggregation, or return any query results.
Does my pipeline get uploaded anywhere?: No. This is a local tool that runs entirely in your browser, so the pipeline you paste never leaves your device and nothing is uploaded to ArrayKit or any server.
Is it safe to paste a pipeline that contains sensitive field names or values?: Yes. Because all parsing and formatting happens locally on your machine, sensitive collection, field, and value details stay on your device.
How is this different from the MongoDB Query Beautifier?: The Query Beautifier targets find() and shell-style queries, while this tool is tuned for aggregation pipelines — arrays of stages like $match, $group and $sort.

Related tools

MongoDB Query Beautifier — Beautify and indent MongoDB queries and find() statements in your browser.
MongoDB Query Formatter — Format MongoDB shell queries and aggregation pipelines.
MongoDB Explorer — Explore a MongoDB document or collection sample and infer its field schema and types.
SQL Formatter — Format SQL for MySQL, PostgreSQL, SQL Server, SQLite, BigQuery and Oracle.
JSON Formatter — Beautify, minify and validate JSON with error locations.
GraphQL Formatter — Format or minify GraphQL queries and schemas, validate syntax and extract operations.
YAML ↔ JSON — Convert YAML to JSON and back.

Guides

More Code Formatters tools

MongoDB Explorer — Explore a MongoDB document or collection sample and infer its field schema and types.
OpenAPI / Swagger Formatter — Format and validate OpenAPI / Swagger specs (JSON or YAML) and count paths and operations.
CSS Unit Converter — Convert between px, rem, em, pt and % live with a configurable root font size.
Glob to Regex — Convert a glob or wildcard pattern into an equivalent JavaScript regex.
HTML to Markdown — Paste HTML and convert it to clean Markdown live, with GFM tables, lists and code blocks.
TOML Formatter & Converter — Format and validate TOML, and convert TOML ↔ JSON.
logfmt to JSON — Convert logfmt key=value logs to JSON and back.
dotenv to JSON — Convert a .env file to JSON and JSON back to .env, with quoting and comments handled.
CSV to Markdown Table — Convert CSV or TSV data into a Markdown table, with alignment and header options.
INI to JSON — Convert INI config files to JSON and JSON back to INI, with sections and comments.
Markdown Table Generator — Build a table in an editable grid and export Markdown, HTML, AsciiDoc and LaTeX.
Data Size Converter — Convert between bits, bytes, KB, MB, GB and KiB, MiB, GiB, with decimal and binary units.

See all Code Formatters tools (32) · All tools