dbForge Query Builder

Simply draw query on the visual diagram and execute it.

dbForge Query Builder is a visual tool that allows creating any sort of SQL queries, from simple lookups to complex JOINs. The tool enables extended data management in MariaDB, MySQL, 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 connection to server with option to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Quick script generation templates 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 for indexes and columns in tables
  • Displaying the number of objects

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

  • Display of SHOW PROFILE, EXPLAIN results and STATUS variables in UI
  • Display of query plan in tree view for easy review
  • Profiling history that can be saved for further analysis
  • Profiling results comparison with highlighted differences
  • Comparison of profiling results with differences highlighting
  • Printing of profiling results

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
  • On-the-fly SQL formatting 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 at the product page

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.