Query MongoDB using familiar SQL syntax
Write familiar SQL SELECT statements to query MongoDB. Use WHERE clauses, ORDER BY, LIMIT, and aggregate functions like COUNT, SUM, and AVG. Results display in grid view with full spreadsheet functionality including sorting, filtering, and editing.
See exactly how your SQL translates to MongoDB aggregation pipelines. Switch between SQL editor and MongoDB Query tabs to understand the conversion. Learn MongoDB by comparing familiar SQL to native MongoDB syntax side-by-side.
Access a library of SQL examples with one-click insertion. See how to write JOINs, GROUP BY, subqueries, and complex conditions. Each example shows both SQL and the MongoDB translation, helping you learn through practical examples.
Choose your preferred query style: SQL Mode for familiar SELECT syntax or the Visual Query Builder for MongoDB-native queries. Both produce the same results - pick what feels natural. Great for teams transitioning from SQL databases to MongoDB.
SQL Mode supports GROUP BY and aggregate functions, but for advanced transformations use the Aggregation Pipeline. Start with SQL for simple aggregates, then graduate to the pipeline builder for $unwind, $lookup, and complex multi-stage operations.
Check out the documentation to explore all the details about SQL Mode and discover more VisuaLeaf features.
Read the DocumentationGet started free with our Community Edition. Includes a 14-day trial of Pro features.
