QBS Slogan
QBS Slogan
You are not currently logged in

dbForge Query Builder for MySQL  by Devart

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. You don't need to type any code at all - just "draw" your query on a diagram. When you need to type some SQL code manually, comprehensive suggestions will simplify the task.

Key Features:

  • Visual query diagram: Simply draw your query on an 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 sub-queries: Manage complex sub-queries with visual query building tool for MySQL and MariaDB. Use the tabbed window to edit sub-queries 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 specified on the label of the diagram. Use this label to choose a table to work with.
  • Expression editor: Automate your work with query criteria. See and visually edit them on separate tabs under the diagram. You don't need to type column names or remember complex rules. Just select the required data from the lists and enjoy results.
  • SQL code beautifier: Query building tool for MySQL will help you write SQL code yourself or modify the existing code. The tool suggests possible variants for completing words, shows information on database objects and provides customisable 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 print or export query results.
  • Foreign key lookup editor: Edit foreign keys directly in the data grid via Foreign key lookup editor. If you edit a table with foreign keys, just click the needed cell - and data of the parent table will be shown.
  • Export to 10+ formats: Visual and accurate data export to widely-used formats: HTML, Text, MS Excel, MS Excel, MS Access, RTF, PDF, XML, CSV, DBF, ODBC, SQL. The export is customisable and allows using templates.

Devart products are sold on a subscription basis, i.e. during a year after a purchase you can download new versions released within this period.

But the license itself is permanent in the sense that a particular version can be used without any time limitations. Subscription will need to be renewed only if you want to keep having access to version updates.

Code Description Excl VAT Incl VAT
338313 Standard Licence + 1 Year Subscription v4.x (ESD) (300280582) Delivery within 5 days. information button
Version: 4.x. Publisher's code: 300280582. Electronic Software Delivery: We manually process this order and then email you download instructions. There is no delivery charge for this item. Normally delivered within 5 working day(s). Service is provided for 1 year.
£55.53 £66.64

Code Description Excl VAT Incl VAT
269838 Standard 1 Year Subscription Renewal (300479359) information button
Publisher's code: 300479359. This is a Renewal. Product serial or licence number required. Service is provided for 1 year.
£24.28 £29.14