JSONToTable
Loading MongoDB Query Formatter...
Please wait a moment

MongoDB Query Formatter Online — Format & Beautify MongoDB Queries

Paste your MongoDB query above and get clean, properly indented output instantly. Supports find(), aggregate(), insert, update, and delete queries — all processed in your browser.

How to Format MongoDB Queries Online — Step-by-Step

Step 1

Input Your MongoDB Query

Got a messy MongoDB query from your mongosh shell, application logs, or a code review? Three ways to load it:

•
Paste directly: Copy the query and paste it in — formatting happens instantly
•
Upload a file: Click "Upload" to select a .js or .json file
•
Load a sample: Click "Sample" to see a complex aggregation pipeline formatted

Example: Unformatted MongoDB Query

Here is what a compact MongoDB aggregation pipeline looks like before formatting:

db.orders.aggregate([{$match:{status:"completed",total:{$gte:100}}},{$group:{_id:"$customer_id",totalRevenue:{$sum:"$total"},orderCount:{$sum:1}}},{$sort:{totalRevenue:-1}},{$limit:10}])
Step 2

Automatic Formatting & Validation

No button press needed — the formatter runs the moment you paste:

•
Structured indentation: Each pipeline stage, nested object, and array element gets proper indentation
•
Syntax highlighting: MongoDB operators ($match, $group, etc.), keys, and values are color-coded
•
Error detection: Missing commas, unclosed brackets and unclosed strings are reported with their line and column

Example: Formatted Output

The same query, now properly formatted:

db.orders.aggregate([
  {
    "$match": {
      "status": "completed",
      "total": { "$gte": 100 }
    }
  },
  {
    "$group": {
      "_id": "$customer_id",
      "totalRevenue": { "$sum": "$total" }
    }
  },
  ...
])
Step 3

Copy or Download Your Formatted Query

When it looks right, grab it:

•
Copy to clipboard: One click — paste into your MongoDB shell, Compass, or code editor
•
Download as file: Save as a .js file
•
Minify: Click "Minify" to compress the query into a single line — useful for scripts
•
Convert it: Convert to SQL, DynamoDB, or try our JSON Formatter for the query body

Frequently Asked Questions — MongoDB Query Formatter

How do I format a MongoDB query online?

Paste the query into the input editor and the formatted version shows up on the right about half a second later. There is no button to press and nothing to install.

What MongoDB query syntax does it understand?

The same syntax you type into mongosh: db.collection.find(), aggregate(), insertOne(), updateMany(), deleteOne() and the rest, db.getCollection("name"), chained calls like .sort().limit(), unquoted keys, single-quoted strings, trailing commas, and helpers such as ObjectId("…"), ISODate("…"), new Date() and /regex/i. A plain JSON filter object works too. Shell commands like use mydb or show dbs are not supported.

Will formatting change any of my values?

No. Strings, numbers, regular expressions and helper calls are copied exactly as you typed them, so a long ID like 8901240544102066246 or a price written as 14.50 comes out unchanged. Keys are put in double quotes and comments are removed; nothing else is rewritten.

Does it detect syntax errors?

Yes. A missing comma, a bracket that is never closed or a string without its closing quote is reported with the line and column where the problem is. It checks syntax only, so it will not tell you whether a field or collection actually exists.

Can I minify MongoDB queries?

Yes. Click Minify to put the whole query on one line with the whitespace between keys and values removed (spaces inside strings are kept). Handy for scripts, config files or environment variables.

Is my data safe?

Your queries are formatted in your browser and are not sent to any server.

Is this MongoDB formatter free?

Yes, and there is no account to create. Format as many queries as you like.

Need to move a query between databases? Try SQL to MongoDB, MongoDB to SQL or, for SQL itself, the SQL Formatter.

Related Tools

SQL to MongoDB

Convert SQL queries to MongoDB query syntax with aggregation pipeline support

MongoDB to SQL

Convert MongoDB queries and aggregation pipelines to equivalent SQL statements

SQL to DynamoDB

Convert SQL queries to AWS DynamoDB query and scan operations with PartiQL support

DynamoDB to SQL

Convert AWS DynamoDB query and scan operations to equivalent SQL statements

MongoDB to DynamoDB

Convert MongoDB queries to AWS DynamoDB query operations and vice versa

DynamoDB to MongoDB

Convert AWS DynamoDB operations to MongoDB queries with proper operator mapping