Build queries by clicking instead of typing. On PostgreSQL, MySQL, MariaDB, SQL Server, Oracle and SQLite, pick columns, add filters, accept JOINs suggested from your foreign keys, and watch the SQL update in a live preview. On MongoDB, build find filters with operator dropdowns and AND/OR groups while the query JSON updates next to them.
Pick a field from your collection, choose an operator such as $eq, $gt, $lt, $in or $regex from a dropdown, and type a value into an input that adapts to the field type: date, number, string or boolean. Add more conditions, group them with AND/OR logic, and the builder writes the MongoDB filter for you.
Choose which fields to include or exclude in the projection builder, add sort criteria with ascending and descending toggles, and set limit and skip for paging. Every option lives in the same panel as the filter, so you never have to remember how a projection or sort document is written.
Changes in the builder update the Query field, and edits in the Query field update the builder. Switch between clicking and typing whenever you like, run the query, and browse the results in Tree, Table or BSON view. Reading the generated JSON next to your clicks is also a quick way to learn MongoDB query syntax.
The same point-and-click approach works on PostgreSQL, MySQL, MariaDB, SQL Server, Oracle and SQLite. Pick your tables, let the builder suggest joins from your foreign keys, add WHERE conditions and sorting, and watch the generated SQL update as you click.
Here is what a few clicks produce in each builder. The SQL walkthrough follows the Visual SQL Query Builder documentation; the MongoDB example uses the filter, projection and sort fields of a collection.
orders and click the Query Builder toggle in the toolbar.customers. The builder suggests orders.customer_id = customers.id from the foreign key; click Add JOIN.customers.name and switch its Group toggle on.orders.total, set its aggregate to SUM and rename it total_value.total_value descending and set Limit to 20.The live preview panel now shows:
status, equals, active.age, $gte, 18. Both conditions sit in one AND group.name and email and exclude _id.createdAt, descending.The query fields now hold:
To group and total documents the way the SQL example does, continue in the aggregation pipeline builder.
The Visual SQL Query Builder writes SELECT statements. It lives as a side panel in the SQL Table activity, so it always runs against a specific base table, and it keeps its filters, joins and aggregates when you close and reopen the panel.
Each filter is a column, an operator and a value input that adapts to the column type. Operators include =, !=, >, <, >=, <=, BETWEEN, IN, LIKE, IS NULL and IS NOT NULL.
Filters combine with AND by default. Click the AND chip to switch to OR, or drag one filter onto another to group them. Joins can be INNER, LEFT, RIGHT or FULL OUTER, with more than one condition per join, and removing a joined table cleans up every reference to it.
Wrap any output column in COUNT, COUNT(DISTINCT), SUM, AVG, MIN or MAX, and give it an alias. Columns with the Group toggle on go into GROUP BY automatically, and + Having adds a filter that applies after aggregation.
Set sort direction per column, drag rows in the Sort panel to reorder them, and cap the row count with Limit. The live SQL preview highlights the clause produced by your last click, so you can see exactly what each control does.
Each database page shows how VisuaLeaf works with that engine. The documentation covers every builder control in detail.
orders.customer_id = customers.id. You can accept it, edit it, add more conditions, and choose INNER, LEFT, RIGHT or FULL OUTER. If your schema has no declared foreign keys, you can add relationship hints in the connection settings.Take your Query Builder results further with the Aggregation Pipeline. After filtering documents with the visual query builder, seamlessly transform, group, and analyze your data using 37+ aggregation stages. Build complex data pipelines that start where your queries end.
Visualize your Query Builder results instantly with Charts & Dashboards. Turn filtered data into bar charts, line graphs, and pie charts with one click. Create live dashboards that update as your query results change, perfect for monitoring and reporting.
Check out the documentation to explore all the details about the Query Builder and discover more VisuaLeaf features.
Read the DocumentationGet started free with our Community Edition. Includes a 14-day trial of Pro features.
