Create and Edit MySQL 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 complex MySQL 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.

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