Does this tool connect to my MongoDB database?

No. It only generates query JSON or shell syntax in your browser. Nothing is sent to any server or database.

What is the difference between find and aggregate mode?

Find mode outputs a filter document with optional projection, sort, and limit. Aggregate mode builds a pipeline starting with $match.

How do I combine filters with OR logic?

Add a second filter row and set its logic selector to OR. The builder nests conditions in $or or $and arrays.

MongoDB Query Builder

Build find filters or aggregate pipelines from visual rows — field, operator, value

Query Builder

Quick samples

Collection

Output mode

Filters

MATCH

Matches values equal to the specified value. Shorthand: { field: value }.

Projection

Sort

Limit

Generated query
Shell

{
  "filter": {
    "status": "active"
  },
  "projection": {
    "name": 1,
    "email": 1
  },
  "sort": {
    "name": 1
  },
  "limit": 100
}

Matches values equal to the specified value. Shorthand: { field: value }.

About this tool

This tool assembles MongoDB queries from a form: pick a collection, add filter rows with comparison operators ($eq, $gt, $in, $regex, $exists, and more), combine them with AND/OR logic, then output either a find document (filter, projection, sort, limit) or an aggregate pipeline ($match, optional $group, $sort, $limit). Switch to shell format for db.collection.find() or aggregate() syntax. Nothing executes against a database — generation is client-side only.

Examples

Find active users

{
  "filter": { "status": "active" },
  "projection": { "name": 1, "email": 1 },
  "sort": { "name": 1 },
  "limit": 100
}

Equality filter on status with a projection list, ascending sort, and limit.

Aggregate by department

[
  { "$match": { "status": "active" } },
  { "$group": { "_id": "$department", "count": { "$sum": 1 } } },
  { "$sort": { "count": -1 } },
  { "$limit": 10 }
]

Match active documents, group by department with a count, sort descending, limit ten.

About this tool

Build MongoDB find filters and aggregate pipelines visually. Add field/operator/value rows, copy JSON or shell — free, no signup, runs in your browser. MongoDB Query Builder runs in the browser on DevTools. There is no signup, and your input stays on this device unless the tool explicitly performs a live network lookup.

What this tool does not do

MongoDB Query Builder is a free in-browser utility, not a hosted API. It does not keep server-side history and is not a substitute for production verification in your own stack.

How do I use this tool?

How do I use MongoDB Query Builder?
Open MongoDB Query Builder, enter or paste your input, and copy the result. The page works without an account.

MongoDB Query Builder

Query Builder

Generated query
Shell

About this tool

Examples

Find active users

Aggregate by department

About this tool

What this tool does not do

How do I use this tool?

How do I use MongoDB Query Builder?

Build MongoDB Queries Without Memorizing Operators

Base64 Toolbox

C# to VB.NET Converter

CSV Data Viewer

CSV to Chart

CSV to JSON Converter

CSV to Markdown Converter

Query Builder

Generated queryShell

About this tool

Examples

Find active users

Aggregate by department

About this tool

What this tool does not do

How do I use this tool?

How do I use MongoDB Query Builder?

Related guides

Build MongoDB Queries Without Memorizing Operators

Related tools

Base64 Toolbox

C# to VB.NET Converter

CSV Data Viewer

CSV to Chart

CSV to JSON Converter

CSV to Markdown Converter

Generated query
Shell