dbForge Query Builder for MySQL is a visual tool for quick quick queries creation and extended data management. With the help of this tool developers can effortlessly create and edit any complex queries in just several clicks. The main component of Query Builder is a visual diagram where one can "draw" a query instead of writing code manually. The tool now works with any MariaDB database servers and supports all MariaDB objects types.
* Includes support for MySQL server versions 3.23-5.x
* Includes support for MariaDB server versions 5.5, 10.0
* Data editor with in-place filtering, grouping, and sorting options
* Visual editing of sub-queries
* Enhanced SQL Editor with syntax coloring, bookmarks, and text searching
* Automatic SQL syntax check in SQL editor
* SQL editor with syntax coloring, bookmarks, and text searching
* Convenient and flexible user interface
* Undo/Redo support in query diagram
* Expression builder for creating complex conditions
* Query Diagram and data printing
* Customizable data export to SQL, CSV, HTML, DBF, MS Access, MS Excel and other formats
* Data editor with filtering, grouping, and sorting options
* Code completion and SQL Code Formatter. These features offer developers the extended list of suggestions during the typing of SQL code and object information on different database objects. Profile formatting capabilities allow users to create new profiles and edit the existing ones easier than ever.