This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

dbForge Query Builder for MySQL & MariaDB

dbforge_query_builder_for_mysqldbForge Query Builder is a powerful visual tool that helps create any sort of MariaDB queries. Building a code has never been so easy – the query can be drawn on a diagram.

dbForge Query Builder Key features:

1. Exporting Data

Export your data to 14 popular formats

Export data from several tables simultaneously

Create templates for repeated operations

slider-export-data

2. Database Explorer

Work with multiple database connections

Easy MariaDB query management with drag&drop functionality

Quick script generation

slider-database-explorer

3. Visual Drag and Drop Query Builder

Enjoy zooming and keyboard support in a sophisticated diagram

Preview and print diagrams

Add and edit sub-queries visually

MariaDB JOINs generator

slider-query-builder

4. SQL Editing and Execution

Check the syntax automatically

Get quick information about schema objects

Customize formatting profiles

Execute scripts, statements and MariaDB fragments seamlessly

slider-sql-editing-and-execution

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

slider-query-profiler

6. Data Editor

Enjoy advanced data filters

Browse and edit large objects in Data Viewer and Editor windows

Fetch asynchronous data

slider-data-editor

7. Data Reports

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

mysql-data-reports

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

mysql-master-detail

9. Pivot Tables

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

mysql-pivot-table

Download a free 30-day trial of dbForge Query Builder for MariaDB and MySQL here.

Documentation

VersionIntroduced
dbForge Query Builder 10.1Support 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.0MariaDB 11.4, Implemented support for the JSON_TABLE() table function in MariaDB
dbForge Query Builder 5.2MariaDB 11.3
dbForge Query Builder 5.1MariaDB 10.9, MariaDB 10.10
dbForge Query Builder 4.5MariaDB 10.5
dbForge Query Builder 4.4MariaDB 10.4
dbForge Query Builder 4.3MariaDB 10.3
dbForge Query Builder 4.2MariaDB 10.2, MariaDB 10.1
dbForge Query Builder 3.1MariaDB 10.0, MariaDB 5.5
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.