Visual Query Builder for MySQL is a comprehensive tool for database developers who work with MySQL and MariaDB databases. With this tool, you can generate and edit MySQL queries visually, needing less time and effort. 

Key features: 

Database Explorer. This feature provides support for multiple database connections, ensures quick script generation for SELECT, INSERT, UPDATE, and DELETE SQL queries. With Database Explorer, you  can set up and close the connection to the server, obtain detailed information about database objects in Object Properties window, and forward tables to Query Builder in the blink of an eye with the Send To command. This feature also offers multi-selection option for several database objects, and drag-and-drop functionality. 

Data Reports. This feature allows you to build reports from scratch, create detailed reports based on custom queries, manage and reorder the report structure, export reports to popular file formats, preview them and print and save them. Also, with Data Reports functionality, you  can automate report creation only with command-line interface. 

Master-Detail Browser. This tool lets you work with parent-child data structures and navigate hierarchical data relationships across tables effortlessly. It includes a visual diagram where you can define relationships, specify which table will act as the master, and designate child tables. 

Pivot Table. This tool transforms flat, raw data into grouped and summarized views, allowing you to organize and analyze your data effectively. With the Pivot Table feature, you can easily group, aggregate, and rearrange your data to uncover meaningful insights. Additionally, you can visualize the results using built-in charts, making it easier to identify patterns and trends.  

Query Builder. This feature provides the state-of-art diagram, options to add and visually edit sub-queries, and query outline. Query Builder also has an option for building complex conditions, generating MySQL JOINs, building INSERT, UPDATE, and DELETE statements. 

SQL Editing and Execution. This tool helps developers reduce the number of human-made errors while writing SQL queries. It provides the following features: automatic SQL syntax check, context-sensitive code completion, instant code formatting, quick navigation through Document Outline window, seamless execution of scripts.  

Query Profiler. With Query Profiler, you can identify bottlenecks and improve the performance of your queries. The tool has the following options: visual query profiling results comparison, query plan displayed in a tree view, profiling history, highlighted differences in profiling results, session statistics, and detailed query information. 

Data Editor. Data Editor helps you quickly and easily edit data with advanced data filters, offers convenient date and time editor, server-side sorting and filtering, and many other functions. 

Exporting Data. In Query Builder for MySQL, you can export data in the following formats: RTF, PDF, JSON, XML, CSV, ODBC, DBF, HTML, Text, MS Excel, MS Excel 2007, Google Sheets, MS Access, and SQL. It is also possible to export data from multiple tables at once.