What does the output look like?

A `find()` query in MongoDB shell syntax. Flat JSON becomes equality matches: `{status: "active"}` → `db.collection.find({status: "active"})`.

How does it handle arrays?

Arrays in the input become `$in` queries: `{status: ["active", "pending"]}` → `{status: {$in: ["active", "pending"]}}`. Toggle off for literal array matches.

Does it generate operators like $gt, $regex?

Not from flat JSON — requires annotated input. For complex queries, write MongoDB syntax directly or use a query builder library.

What about ObjectId values?

Strings that look like 24-char hex ObjectIds are wrapped in `ObjectId("...")`. Toggle off to keep them as strings if your schema doesn't use ObjectId.

JSON → MongoDB Query | DevTools Surf

DevTools Surf

Example: JSON → MongoDB Query

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

{"name":"Ada","age":">30","roles":["admin","editor"],"city":"~london","inactive":null}

Output

db.collection.find({
  "name": "Ada",
  "age": {
    "$gt": 30
  },
  "roles": {
    "$in": [
      "admin",
      "editor"
    ]
  },
  "city": {
    "$regex": "london",
    "$options": "i"
  },
  "inactive": {
    "$exists": false
  }
})

About JSON → MongoDB Query

JSON → MongoDB Query preview - Converters tool

Convert flat key-value JSON into a MongoDB find() query object. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

Use Cases

Backend developers quickly building MongoDB filters from sample documents
Database admins converting JSON exports into diagnostic queries
Full-stack engineers debugging document lookups in MongoDB Compass
Data analysts constructing ad-hoc queries from JSON-formatted requirements

Tips

Paste flat key-value JSON to instantly get a valid find() filter object
Use the generated query directly in MongoDB Compass or the mongo shell
Combine multiple key-value pairs to build compound AND query filters

Fun Facts

MongoDB's name comes from 'humongous' — the database was designed from day one to handle massive, document-oriented datasets at scale.
MongoDB's query language supports over 30 comparison and logical operators, but the simple equality filter {key: value} handles roughly 60% of real-world queries.
MongoDB was first released in 2009 by 10gen (now MongoDB Inc.) and reached a $4 billion IPO valuation when it went public on NASDAQ in October 2017.

FAQ

What does the output look like?: A `find()` query in MongoDB shell syntax. Flat JSON becomes equality matches: `{status: "active"}` → `db.collection.find({status: "active"})`.
How does it handle arrays?: Arrays in the input become `$in` queries: `{status: ["active", "pending"]}` → `{status: {$in: ["active", "pending"]}}`. Toggle off for literal array matches.
Does it generate operators like $gt, $regex?: Not from flat JSON — requires annotated input. For complex queries, write MongoDB syntax directly or use a query builder library.
What about ObjectId values?: Strings that look like 24-char hex ObjectIds are wrapped in `ObjectId("...")`. Toggle off to keep them as strings if your schema doesn't use ObjectId.

Related Converters Tools

JSON to XML JSON to CSV JSON to YAML JSON to TSV JSON to String XML to JSON XML to CSV XML to String