|
| Support of all MySQL objects (Tables, Views, UDFs, Stored Procedures and Functions, Triggers and Events) | | |
| Support of all MySQL features and extensions | | |
| Support of Unicode data and metadata | | |
|
| Multiple host/database connections | | up to 5 |
| Connection to MySQL Server through HTTP | | |
| Connection to MySQL Server through SSH | | |
| Connection to MySQL Server using SSL | | |
| Registering selected databases to work with | | |
| Projects to work with the selected database objects only | | |
| Multiple user-defined tabs for any tree node to access it in one-click | | |
| Working with multiple selected objects at a time | | |
| Grouping/Ungrouping registered databases by host name | | |
|
| Ability to create/drop databases | | |
| Managing tables and all their subobjects: fields, indices, foreign keys and triggers | | |
| Managing views, stored functions and procedures, user-defined functions (UDF), scheduled events | | |
| Duplicating all database objects | | |
| Debugging of procedures, functions, triggers and events | | |
| Renaming all database objects | | |
| Viewing dependencies between database objects | | |
|
| View, edit, search, group, sort, filter any data stored in registered database | | |
| Powerful BLOB viewer/editor with several types of viewing BLOB data | | |
| Master-detail view to work with two linked tables at the same time | | |
| Table and card views to see data the way you like | | |
| Support of queries returning Multiple Result sets | | |
| Ability to copy and paste selected records | | |
| Exporting data to SQL script as INSERT statement | | |
|
| Powerful user manager to administer users and privileges | | |
| Grant manager displaying all database object grants in the form of a grid | | |
|
| Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax | | |
| Multiple SQL editors with code completion, syntax highlight and code folding | | |
| Large script execution (SQL script editor) | | |
| SQL Formatter (Available from SQL Editor context menu) | | |
| Favorite Queries (Save and use your frequently used queries easily) | | |
|
| Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc. | | |
| Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV | | |
| Copying metadata and data from one database to another as a whole or partially | | |
| Export as PHP page wizard | | |
|
| Create Report Wizard allows you to create simple reports in a few clicks | | |
| Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree | | |
|
| Extracting metadata into text files or SQL script editor | | |
| Powerful print metadata module for creating customizable metadata reports | | |
| HTML report generator to create a detailed HTML report about your database quickly | | |
| SQL Monitor | | |
| Server Properties tool to view and change system variables, to view server status information | | |
| Comparison and synchronization of database structure | | |
|
| Two diagram notations (IDEF1x and IE) | | |
| Useful diagram navigation tool | | |
| Reverse engineering | | |
| Several pages in one diagram to divide diagram into different subject areas | | |
| Ability to create/edit/drop database objects, visually set links between them | | |
| Virtual objects such as comments and virtual relationship | | |
| Saving as image or printing database diagram | | |
| A lot of visual customization options | | |
|
| Analyzing tables | | |
| Checking tables | | |
| Repairing tables | | |
| Optimizing tables | | |
| Changing tables' engine | | |
| Dumping Database | | |
| Backing up tables | | |
| Restoring tables | | |
|
| The possibility to choose different visual schemes | | |
| Well-described Wizard System | | |
| Improved database explorer for easy management of all MySQL objects | | |
| Windows Toolbar to switch between windows easily, like in Windows Task Bar | | |
| Navigation bars with hot actions in most of the windows | | |
| Ability to save all program settings | | |
| Customizable toolbars for all program windows | | |
| Fully customizable program interface | | |
| Support of dark theme | | |
| Localizable program interface | | |
|
| Keyboard templates | | |
| To-do list | | |
| External tool manager | | |