# dbForge Query Builder

[dbForge Query Builder](https://www.devart.com/dbforge/mysql/querybuilder/) is a visual tool that helps create any sort of MariaDB queries. Queries can be drawn on a diagram.

Features are described in the following.

## Exporting Data

Export data to many popular formats.

Export data from several tables simultaneously.

Create templates for repeated operations.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-2c9db81f00f7811ba5a00f31755780c3bd172c6f%2Fslider-export-data.png?alt=media)

## Database Explorer

Work with multiple database connections.

MariaDB query management with drag\&drop functionality.

Quick script generation.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-2abcf717a9f009ed133e891b9993895fa84a2ec7%2Fslider-database-explorer.png?alt=media)

## Visual Drag and Drop Query Builder

Zooming and keyboard support in a sophisticated diagram.

Preview and print diagrams.

Add and edit sub-queries visually.

MariaDB JOINs generator.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-169b49d66fd2415b0062ff752610bc6d591d7c58%2Fslider-query-builder.png?alt=media)

## SQL Editing and Execution

Check the syntax automatically.

Get quick information about schema objects.

Customize formatting profiles.

Execute scripts, statements and MariaDB fragments seamlessly.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-27bf5890bb8ed33ec948d90e070d560dce6e7291%2Fslider-sql-editing-and-execution.png?alt=media)

## Query Profiler

Compare the results of the query visually.

Review and evaluate a query plan shown in the tree view.

Get the detailed query information.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-db84a9a36e677bb8c724a01d87e00b16d3d83a73%2Fslider-query-profiler.png?alt=media)

## Data Editor

Advanced data filters.

Browse and edit large objects in Data Viewer and Editor windows.

Fetch asynchronous data.

![slider-data-editor](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-d239006bb9bfd84f401ef3f0e169702aa650e587%2Fslider-data-editor.png?alt=media)

## Data Reports

Data Report wizard supports building Data Reports and customizing them with a rich set of controls.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-7ceac944a942a2cc39b80b6070a350db3203fa09%2Fmysql-data-reports.png?alt=media)

## Master-Detail Browser

Allows users to view and analyze the data of several related database objects in a master-detail structured document. Edit data, build relationships, filter data based on specific criteria, sort data, etc. in the Design and Data views.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-c86016439a5badb02ccd18f0bc1447a525a53420%2Fmysql-master-detail.png?alt=media)

## Pivot Tables

Let users manipulate data visually, including sorting, grouping, or filtering fields, building charts, and calculating totals.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-da19a8157f8326ec27e609b73f0e7a201b5e5d60%2Fmysql-pivot-table.png?alt=media)

Download a free 30-day trial of dbForge Query Builder for MariaDB [here](https://www.devart.com/dbforge/mysql/querybuilder/download.html).

[Documentation](https://docs.devart.com/querybuilder-for-mysql) is available, too.

| Version                    | Introduced                                                                                                                                                             |
| -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| dbForge Query Builder 10.1 | Support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on AWS and enhanced cloud compatibility features, new automation capabilities. |
| dbForge Query Builder 10.0 | MariaDB 11.4, Implemented support for the `JSON_TABLE()` table function in MariaDB.                                                                                    |
| dbForge Query Builder 5.2  | MariaDB 11.3.                                                                                                                                                          |
| dbForge Query Builder 5.1  | MariaDB 10.9, MariaDB 10.10.                                                                                                                                           |
| dbForge Query Builder 4.5  | MariaDB 10.5.                                                                                                                                                          |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}