Skip to main content
lab.golamrabbani.org

MongoDB Query Builder

Generate db.collection.find / insert / update / delete shell commands from JSON inputs.

Written by Golam Rabbani, Founder & Lead Engineer

e.g. {"active": true}

e.g. {"name": 1, "email": 1}

e.g. {"createdAt": -1}

How to use this mongodb query builder

  1. Pick the operation: find, findOne, insertOne, updateMany, or deleteMany.
  2. Enter the collection name (letters, digits, or underscores only).
  3. For reads/writes, paste a JSON filter object — for example {"active": true}.
  4. For insertOne add a document, for updateMany add an operator update (must start with $set, $inc, …).
  5. Press Generate to emit a db.collection.X(...) shell command; Copy puts it on your clipboard.

About this mongodb query builder

The MongoDB query builder produces shell-style commands without ever connecting to a database. Each filter, projection, document, and update is parsed as JSON before output so syntactic errors surface immediately. find chains optional .sort({...}) and .limit(N) when those fields are filled. updateMany checks that the update document uses MongoDB update operators ($set, $inc, $unset, $push, …) at the top level — a common pitfall when developers accidentally pass a replacement document instead of an operator update.

Worked example: pick find, set collection to "users", filter to {"active": true, "role": "admin"}, projection to {"name": 1, "email": 1, "_id": 0}, sort to {"createdAt": -1}, and limit to 25. The tool emits: db.users.find({ "active": true, "role": "admin" }, { "name": 1, "email": 1, "_id": 0 }).sort({ "createdAt": -1 }).limit(25)

Paste that straight into mongosh or any MongoDB shell tab. Everything is processed locally, so secrets and PII never leave your browser.

FAQ

Does it connect to MongoDB?
No. The builder only emits the shell command string. Run it yourself in mongosh, Studio 3T, MongoDB Compass, or via any driver that accepts a query document.
Why must update documents start with a $ operator?
updateMany applied with a plain document like {"name": "Ada"} would replace the entire document instead of patching a field — a common production bug. The builder rejects that shape to push you toward the operator form ({"$set": {"name": "Ada"}}).
How are JSON parse errors reported?
The native JSON parser runs first; if it fails, the underlying error message is shown next to the offending field so you can locate the bad comma or unbalanced bracket.
Can I use MongoDB shell helpers like ObjectId() or ISODate()?
Those are not valid JSON, so they cannot be entered as input. Use the placeholder string ("ObjectId(\"…\")") and then edit the output before running. The builder targets the strict-JSON subset to stay deterministic.
Does it support aggregation pipelines?
Not in this version — the builder targets the five most-used CRUD operations. For complex pipelines, write the pipeline by hand and use our JSON Formatter to keep it tidy.
Is my data safe?
Yes. The tool is purely client-side. Nothing is uploaded, logged, or persisted between sessions.