Generate and Edit MySQL Queries Visually

dbForge Query Builder for MySQL is a visual tool that allows creating any sort of MySQL queries, from simple lookups to complex JOINs. The tool provides broad compatibility options and helps constructing and editing complex MySQL queries in a few clicks. You don't need to sweat building complex code - just "draw" your query on a diagram.

Powerful visual MySQL query builder functionality
MySQL statement generator executes created queries and edits tables data
Combine a few queries to a sub-query via visual MySQL query editor
Manage databases proactively
Easily make JOINs between tables
Discover trends from mountains of data
Cut the time you spend on writing complex queries

How dbForge Query Builder helps you work with MySQL and MariaDB databases

Viewing SQL Data

dbForge Query Builder comes with an advanced Data Editor that allows viewing SQL data right in the grid. With the tool, you can retrieve data in seconds and then apply robust filtering and sorting for better data analysis.

Learn more

Editing SQL data

dbForge Query Builder for MySQL gives a perfect possibility to edit data right in the result grid, thus saving much time and effort. With MySQL Query Builder from Devart, you can update data in a table in a blink of an eye.

Learn more

Designing SQL SELECT Query

dbForge Query Builder for MySQL is bound to make your coding faster and easier. Build your SELECT query by simply dragging and dropping objects from Database Explorer and watch the JOINs created automatically!

Learn more

Designing SQL INSERT Query

Developed to speed up SQL code writing, dbForge Query Builder for MySQL allows building complex INSERT queries visually and previewing the data to be added to eliminate possible mistakes.

Learn more

Designing SQL UPDATE Query

With the dbForge Query Building tool, you get the benefits of creating complex queries quickly. The tool allows specifying conditions, creating JOINs, and building WHERE and HAVING clauses in a comprehensive and user-friendly GUI.

Learn more

Designing SQL DELETE Query

To help users improve their coding performance, dbForge Query Builder for MySQL allows constructing complex queries in a few clicks. With the tool, you can easily include or exclude columns, specify JOINS, build GROUP BY or ORDER BY clauses, and much more.

Learn more

Features

Query Builder

The state-of-art diagram with zooming and keyboard support
Diagram preview and printing
Functionality to visually add sub-queries to any part of the main query body
Query outline feature (displayed in the Document Outline window)
Visual editing of sub-queries
Visual expression builder for complex conditions
MySQL JOINs generator
Interactive building of INSERT, UPDATE, and DELETE statements
Fast conversion of SELECT queries into INSERT statements
One-click conversion of SELECT queries into UPDATE or DELETE saving the WHERE condition

SQL Editing and Execution

Automatic SQL syntax check
Context-sensitive code completion
On-the-fly code formatting in the comprehensive editor
Document Outline window for quick navigation through large scripts
Seamless execution of scripts, selected SQL fragments, and statements
Quick information about schema objects
SQL editor with syntax coloring, bookmarks, and text searching
Wizard for batch SQL formatting of the selected files
Customizable formatting profiles

Query Profiler

Compare query profiling results visually
Query plan displayed in the tree view for easy review and evaluation
Profiling history that can be saved for further data analysis
Highlighting differences in profiling results
Sessions statistics
Detailed query information that shows command types used the most

Data Editor

Asynchronous data fetch with the ability to cancel the operation
Batch table update mode
Copying data with column headers for quick paste to a spreadsheet
Advanced data filters
Data Viewer and Editor windows for browsing and editing large objects
Foreign key lookup editor
Full-text and Incremental search through data grid
Server-side sorting and filtering
Convenient Date and Time Editor
Paginated data browsing for big data sets
Visible columns picking dialog box
Editing microseconds in columns with the TIME, DATETIME, and TIMESTAMP

Exporting Data

With dbForge MySQL query software, you can export data to 14 common formats:

RTF
PDF
JSON
XML
CSV
ODBC
DBF

HTML
Text
MS Excel
MS Excel 2007
Google Sheets
MS Access
and SQL

dbForge MySQL database query tool features ability to export data from multiple tables at once.

Query Builder for MySQL also allows saving templates to facilitate recurrent operations.

Database Explorer

Support for multiple database connections
Quick script generation for an object: SELECT, INSERT, UPDATE, DELETE
Asynchronous connection to server with ability to cancel the operation
Detailed object properties and data browsing in the Object Viewer window
'Send To' command to quickly forward tables to Query Builder
Multi-selection for batch operations on numerous data objects
Database navigation history
Drag and drop functionality for easy SQL query management

Data Reports

Build visual data reports from scratch
Create simple data-aware and master-detail reports
Create reports based on a custom query
Customize report structure and content
Automate the report creation using the command-line interface
Manage and reorder bands
Export reports to supported file formats such as HTML, CSV, PDF, RTF, XLS, XLSX, TEXT, etc
Zoom in and out reports
Print or save data reports to a file for later use

Master-Detail Browser

Group and summarize data in pivot tables visually
Create custom filters
Sort data in an ascending or descending order
Set up custom conditional styles
Build pivot charts to visualize and analyze data dependencies
Arrange the appearance of pivot tables
Group data by default parameters
Apply summary functions to calculate custom totals

Pivot Table

Visualize relationships and manage objects in the Design View
Detect logical errors visually
Export diagrams to images
Export data to the supported file formats that include HTML, CSV, PDF, Google Sheets, XML, etc
View the selected database-related tables in the Data View
Filter master-detail tables by default or custom conditions
Export to file formats such as HTML, CSV, PDF, RTF, XLS, XLSX, TEXT, etc
Zoom in and out pivot tables

What people say

Leave a testimonial

I really love the product, from my point of view a bit more focus on usability to manage, document and find your product files would be really great! Now its a lot of grapping to find what You need on bigger projects.

Robert Nowothy

Chief Technology Officer, Rotek

Thank you dbForge for this software, I've been looking for something that was fairly intuitive to use and robust, and so it looks like I have found it!