dbForge Query Builder for MySQL

You are viewing an old version of this article. View the current version here.

MySQL and MariaDB Query Builder tool for building and executing queries visually

dbForge Query Builder for MySQL is a visual tool that allows to create any sort of MySQL queries, from simple lookups to complex JOINs. The tool enables extended data management in MySQL, MariaDB, and Percona server databases. Create and edit any complex queries in just a few clicks. There is no need to type any code - just "draw" your query on a diagram. When you need to type some SQL code manually, comprehensive suggestions will simplify the task.

Key features:

1. Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Custom data filters of any complexity
  • Large objects (LOB) viewer
  • Date time editor with visual interface
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Graphical card view
  • Multi-table query result set editing
  • Quick filter feature available for each data cell
  • Read-only state indication
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box

2. Database Explorer

  • Multiple database connections allowed
  • Asynchronous connect to server with ability to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc
  • 'Send To' command for quick sending of tables to Query Builder
  • Multi-selection for batch operations on objects
  • Database navigation history
  • Expanded support of indexes and columns in tables
  • Displaying the objects number

3. Exporting Data

  • Data export to: CSV, DBF, HTML, MDB (Access), ODBC, PDF, RTF, SQL, Text, XML, XLS, and XLSX
  • Export data from multiple tables at once
  • Templates for export operations

4. Query Builder

  • The state-of-art diagram with zooming and keyboard support
  • Diagram preview and printing
  • Visual addition of sub-queries to any part of the main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creation of complex conditions
  • Copy/Paste for tables on a diagram
  • Undo/Redo support
  • Saving queries to a file
  • Visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition

5. Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Query plan is displayed in tree view for easy review
  • Profiling history that can be saved for further analysis
  • Profiling results comparison with highlighted differences
  • Compare profiling results feature with differences highlight
  • Profiling results printing

6. SQL Editing and Execution

  • Automatic SQL syntax check
  • Context-sensitive code completion
  • Document Outline window for quick navigation through large scripts
  • Execution of scripts, selected SQL fragments, and statements
  • Quick information about schema objects
  • SQL editor with syntax coloring, bookmarks, and text searching
  • SQL formatting on-the-fly in the editor
  • Executed SQL history window for the document
  • Wizard for batch SQL formatting of files on the disk
  • Query execution pane

7. User Interface

  • Rich user settings
  • UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Windows connection coloring
  • Restoring document tabs from the last session
  • Switching between wizard window and primary window

Learn more about dbForge Query Builder for MySQL at the product page

Comments

Comments loading...
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.