SQL to MongoDB Query

Convert basic SQL SELECT queries to MongoDB find() syntax.

SQL Query

Try an example:

MongoDB Query

db.users.find(
  {
    "age": {
      "$gt": 25
    }
  }
)

Supported SQL Features

SELECT with column projection or *
WHERE with =, !=, >, >=, <, <= operators
AND / OR logical operators
BETWEEN, IN, LIKE, IS NULL, IS NOT NULL
ORDER BY with ASC/DESC
LIMIT

Was this page helpful?

Related tools

JSON to TypeScript JSON to Go Struct JSON to Python Dataclass JSON to Java POJO JSON to Rust Struct JSON to C# Classes