SQL query on MongoDB

Query MongoDB with SQL

Write SELECT with joins, GROUP BY and HAVING. MotionQL translates it into a MongoDB find or aggregation, shows you the translation, and runs it.

Get MotionQL free All features

MotionQL SQL Query with a SELECT statement and its MongoDB translation

SQL on the left, the generated MongoDB query next to it.

Capabilities

What you can do with it

Real SELECT

DISTINCT and expressions, WHERE with AND / OR / NOT, IN, LIKE / ILIKE, BETWEEN and IS NULL.

Joins

INNER and LEFT JOIN, translated to $lookup.

Grouping

GROUP BY with aggregate functions, COUNT(DISTINCT …) and HAVING; ORDER BY, LIMIT and OFFSET.

See the translation

The generated MongoDB query is shown, and opens in IntelliShell or the aggregation editor.

Read-only by design

Only SELECT runs. INSERT, UPDATE and DELETE are refused.

.sql files

Save and open SQL scripts, and turn any query into code in nine languages.

Related features

SQL to MongoDB migration

Import tables from PostgreSQL, MySQL, MariaDB, SQL Server and Oracle, choose whether each relationship is a reference or an embedded document, preview the result, and run it.

Learn more

Visual query builder

Drag fields from the schema, combine conditions in nested AND / OR groups, and pick projection and sort. MotionQL writes the filter for you, and reads any filter you type back into the builder.

Learn more

Aggregation pipeline builder

Add, reorder and disable stages and see the documents after every one. The operator library covers $lookup, $facet, $setWindowFields, $search and $vectorSearch.

Learn more

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.

Get MotionQL free Explore every feature