Q: Should I use find() or aggregate() output?

find() is the natural fit for simple filtering, sorting and pagination. Choose aggregate() when you want an explicit pipeline of $match, $project, $sort, $skip and $limit stages, which is easier to extend later.

Q: How is LIKE converted?

LIKE patterns become anchored $regex expressions: % becomes .* and _ becomes a single character, with regex metacharacters escaped. NOT LIKE becomes $not with the same pattern.

Q: What is not supported?

JOINs, subqueries, GROUP BY aggregations, DISTINCT in output, expressions and function calls in the SELECT list, and UNION. These raise a clear error message rather than guessing.

Q: Is my query sent to a server?

No. The SQL parser and MongoDB code generation run entirely in your browser. Your schema and query text never leave your device.

Q: Can I trust the output in production?

Review it first. The converter is accurate within its documented subset, but field types, indexes and collation differ between SQL and MongoDB, so test the generated query against your actual data.

Question 1

What SQL is supported?

Accepted Answer

SELECT column lists, FROM, WHERE with AND/OR/NOT and parentheses, =, !=, <>, >, <, >=, <=, LIKE, NOT LIKE, IN, NOT IN, BETWEEN, IS NULL and IS NOT NULL, ORDER BY with ASC/DESC, LIMIT and OFFSET. Column aliases are accepted.

Question 2

Should I use find() or aggregate() output?

Accepted Answer

find() is the natural fit for simple filtering, sorting and pagination. Choose aggregate() when you want an explicit pipeline of $match, $project, $sort, $skip and $limit stages, which is easier to extend later.

Question 3

How is LIKE converted?

Accepted Answer

LIKE patterns become anchored $regex expressions: % becomes .* and _ becomes a single character, with regex metacharacters escaped. NOT LIKE becomes $not with the same pattern.

Question 4

What is not supported?

Accepted Answer

JOINs, subqueries, GROUP BY aggregations, DISTINCT in output, expressions and function calls in the SELECT list, and UNION. These raise a clear error message rather than guessing.

Question 5

Is my query sent to a server?

Accepted Answer

No. The SQL parser and MongoDB code generation run entirely in your browser. Your schema and query text never leave your device.

Question 6

Can I trust the output in production?

Accepted Answer

Review it first. The converter is accurate within its documented subset, but field types, indexes and collation differ between SQL and MongoDB, so test the generated query against your actual data.

SQL to MongoDB - Free Online SQL to Mongo Query Converter Tool | IconVault

SQL to MongoDB

About this tool

Frequently asked questions

Popular searches

More tools

Code Playground

JSON Formatter

Base64 Encoder

JWT Decoder

Coming soon