> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/dbforge-query-builder-for-mysql-mariadb.md).

# 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.

![](/files/j84SF4sAaQM6DcRYdVKK)

## Database Explorer

Work with multiple database connections.

MariaDB query management with drag\&drop functionality.

Quick script generation.

![](/files/J8ezihQdPwCo18HCZ9e6)

## 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.

![](/files/lPtVSrn0SSaw4zRBRET9)

## SQL Editing and Execution

Check the syntax automatically.

Get quick information about schema objects.

Customize formatting profiles.

Execute scripts, statements and MariaDB fragments seamlessly.

![](/files/teZiImQEnnNsdcGVv3SN)

## 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.

![](/files/yNpX3FMmLcW2cswsmhRr)

## Data Editor

Advanced data filters.

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

Fetch asynchronous data.

![slider-data-editor](/files/kuYQw6s1Tcu5kP355agj)

## Data Reports

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

![](/files/B3zxT57NbmqvgBVl9QCZ)

## 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.

![](/files/TchVD8WwoK6K0qmAs6yL)

## Pivot Tables

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

![](/files/9vUOu3hFDubAelGfAvrC)

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" %}