SQL to MongoDB Query Converter
NewConvert SQL SELECT queries to MongoDB find() syntax. Supports WHERE, AND, OR, LIKE, IN, ORDER BY, LIMIT, and DISTINCT. Instant browser-based conversion.
Share:
Supported SQL Syntax
| SQL | MongoDB |
|---|---|
| WHERE a = 1 | { a: 1 } |
| WHERE a != 1 | { a: { $ne: 1 } } |
| WHERE a > 1 | { a: { $gt: 1 } } |
| WHERE a IN (1,2) | { a: { $in: [1,2] } } |
| WHERE a LIKE '%x%' | { a: { $regex: ".*x.*" } } |
| ORDER BY a DESC | .sort({ a: -1 }) |
| LIMIT 10 | .limit(10) |
| SELECT DISTINCT a | .distinct("a") |
How to Use SQL to MongoDB Query Converter
- Enter a SQL SELECT query in the left text area.
- The MongoDB equivalent is generated automatically.
- Use the example buttons to try common patterns.
- Copy the MongoDB query with the copy button.
- Refer to the syntax table for supported operators.
SQL vs MongoDB Query Syntax
SQL databases use a declarative query language while MongoDB uses a document-based query API. This tool helps developers transitioning from SQL to MongoDB by automatically converting familiar SELECT statements into MongoDB's find() syntax.
Key differences: SQL WHERE becomes MongoDB's filter object, SELECT columns become projection, ORDER BY becomes .sort(), and LIMIT maps directly. SQL operators like =, >, < map to MongoDB's $eq, $gt, $lt. LIKE becomes $regex, and IN becomes $in. Understanding these mappings is essential when working with both SQL and NoSQL databases.
Frequently Asked Questions
Related Tools
Was this tool helpful?