🔄
SQL to MongoDB Converter
Convert SQL queries to MongoDB query syntax
SQL Query
Examples
Supported Syntax
✓ Supported
- • SELECT, INSERT, UPDATE, DELETE
- • WHERE with AND/OR
- • Comparison operators (=, !=, >, <, >=, <=)
- • IN, LIKE, IS NULL, IS NOT NULL
- • ORDER BY, LIMIT
- • COUNT(*), GROUP BY
✗ Not Yet Supported
- • JOINs (use $lookup in aggregation)
- • Subqueries
- • HAVING
- • DISTINCT
MongoDB Quick Reference
| SQL | MongoDB |
|---|---|
| = | { field: value } |
| >, <, >=, <= | $gt, $lt, $gte, $lte |
| != / <> | $ne |
| IN | $in |
| LIKE | $regex |
| AND | implicit (multiple fields) |
| OR | $or |
| ORDER BY | .sort() |
| LIMIT | .limit() |