About JSON → MongoDB Query

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.