dbForge Query Builder for MySQL

dbForge Query Builder for MySQL Overview

dbForge Query Builder for MySQL is a visual tool for quick creation of queries and extended data management. It allows you to effortlessly create and edit any complex queries in just several clicks.

You don't need to type any code at all - you can just "draw" your query on the diagram. In case you need to type some SQL code manually, comprehensive suggestions will simplify your task.

Key Features
• Foreign key lookup data editor for easy editing of fields referencing other tables
• Visual query creation and profiling
• Query schema window for complex queries
• Extended SQL beautifier to format SQL queries
• Automatic SQL syntax check in SQL editor
• SQL editor with syntax coloring, bookmarks, and text search
• Advanced management of query results
• Undo/Redo support in query diagram
• Convenient expression builder for queries
• Query Diagram and data printing
• Customizable data export to CSV, HTML, DBF, MS Access, MS Excel and other formats
• Data editor with filtering, grouping, and sorting options

Visual query diagram
Simply draw your query on the elaborated diagram instead of writing code manually. Drag’n’drop required tables to the diagram, join them, and select columns visually. For better view, use zooming options.

Creation of subqueries
Work with complex subqueries and manage them as simple queries with visual query building tool for MySQL. Using the tabbed window, you can edit subqueries in separate windows and easily access the main query.

Designing DML queries
INSERT, DELETE, and UPDATE queries can be designed using dbForge Query Builder for MySQL. The query type is stated on the label on the diagram. You can use this label to choose a table to work with.

Expression editor
• Automate your work with query criteria. See and visually edit them on the separate tabs under the diagram where you're drawing your query.
• You don't need to type the columns' names or remember complex rules. Just select required data from the lists and enjoy the results.

SQL code beautifier
• Query building tool for MySQL will help when you are writing SQL code yourself or modifying existing code by suggesting possible variants for completing words and showing information on database objects.
• Make your code formatting standard-driven using customizable profiles.

Visual query profiling
• Leave behind challenging query profiling from the command line. Get EXPLAIN, SHOW PROFILE, and SHOW STATUS results in a convenient UI.
• Select results for two query executions and get the differences highlighted.

Data management
• Data management has become more convenient.
• Group, sort, and filter data in the grid. For better data view and editing, use various modes. Benefit from cached updates and manage your data based on your needs. Moreover, you can print or export query results.

Foreign key lookup editor
Edit foreign keys directly in the data grid with the help of the Foreign key lookup editor. If the table you want to edit has foreign keys, just click the needed cell - and data of the parent table will be shown.

Data Export to 10 formats
Experience visual and accurate data export to 10 widely-used data formats: HTML, Text, MS Excel, MS Access, RTF, PDF, XML, CSV, DBF, ODBC. The export process is highly customizable and it is possible to use templates.

dbForge Query Builder for MySQL requires the following:
• Microsoft Windows XP/7/8, and Windows Server 2008/2012
• .NET Framework 3.5 SP1, or 4.0 installed*
• 2 GHz or higher processor
• 1024 MB RAM
• 150 MB of free hard disk space