Query Builder for MySQL Feature List

This visual tool is designed for quick creation of queries and extended data management. In this page you will find a comprehensive listing of features available in Query Builder for MySQL. For a list of new features see What's New in 4.0

Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Copying data with column headers for quick paste to spreadsheet
  • 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
  • Full-text search (Ctrl+F) through data grid
  • Graphical card view
  • Incremental search (Ctrl+I) through data grid
  • Multi-table query result set editing
  • Paginal data browsing for large result sets
  • 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
  • Editing microseconds in columns with TIME, DATETIME and TIMESTAMP

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

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

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

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

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

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