Mongo Query Formatter

How to use it

1. Pick a mode: Format pretty-prints the query; Minify collapses it to one line and strips comments.
2. Paste anything mongosh accepts as a single expression — a filter document, a pipeline array, or a db.collection.method(…) chain, up to 1 MB.
3. For Format, choose the indent unit: 2 spaces, 4 spaces or tabs.
4. Set the Keys policy — keep them as typed, quote every key (the $-operators included), or unquote the ones that are valid identifiers — and pick a quote style for strings.
5. Read the result as you type: the strip under the output counts every constructor that rode through untouched, and a syntax error shows the parser's own message with a caret frame plus a Jump-to-line button.

Paste a mongosh query or aggregation pipeline and get it back cleanly indented — with ISODate, ObjectId, NumberLong and the other shell constructors kept intact, byte for byte. Plain JSON formatters choke on that syntax; this page's relaxed lexer reads unquoted keys, single quotes, trailing commas and comments the way the shell does. Nothing is executed and nothing leaves this tab.

Examples

db.orders.aggregate([{ $match: { created: { $gte: ISODate("2026-01-01") }, userId: ObjectId("65a1f30e9d2c4b7a8c3d1e2f") } }, { $group: { _id: "$status", total: { $sum: "$amount" }, big: { $max: NumberLong("9007199254740993") } } }])

db.orders.aggregate([
  {
    $match: {
      created: {
        $gte: ISODate("2026-01-01")
      },
      userId: ObjectId("65a1f30e9d2c4b7a8c3d1e2f")
    }
  },
  {
    $group: {
      _id: "$status",
      total: {
        $sum: "$amount"
      },
      big: {
        $max: NumberLong("9007199254740993")
      }
    }
  }
])

db.orders.find({
  created: {
    $gte: ISODate('2026-01-01')
  },
  status: 'paid'
})

db.orders.find({created:{$gte:ISODate('2026-01-01')},status:'paid'})

{ user_id: 42, 'active': true, $or: [ { role: 'admin' }, { role: "editor" } ] }

{
  "user_id": 42,
  "active": true,
  "$or": [
    {
      "role": "admin"
    },
    {
      "role": "editor"
    }
  ]
}

Every example on this page is executed against the same engine that powers the tool, on every build.

Common errors

Unbalanced parentheses — '(' opened at line 1, column 15 was never closed.

The classic truncated paste: db.orders.find({ status: 'paid' } closes the document but not the call. The position names the opener that never found its partner, and the caret frame marks the same spot in your input.

Unterminated string — the closing ' for the string opened at line 1, column 9 was never found.

A quote opened and the line ended first, as in { name: 'ada }. Shell strings cannot span a raw line break, so the fix is on the line the position points at: close the quote or escape what sits inside it.

'use' is out of scope here — variables, loops and multi-statement scripts do not format; paste a single query or db.collection call.

Session commands like use shop are shell statements, not query expressions — they carry no document to format. Drop the use line and paste the query beneath it on its own.