Full support of MySQL versions from 3.23 to 6.0
- Support of all MySQL objects (Tables, Views, UDFs, Stored Procedures and Functions, Triggers and Events)
- Support of all MySQL features and extensions
- Support of UTF8 data
Rapid database management and navigation
- Multiple host/database connections
- Connection to MySQL Server through HTTP
- Connection to MySQL Server through SSH
- 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
Simple management of all MySQL objects
- 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
Advanced data manipulation tools
- 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 security management
- Powerful user manager to administer users and privileges
- Grant manager displaying all database object grants in the form of a grid
Excellent visual and text tools for query building
- 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)
Impressive data export and import capabilities
- 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
Report designer with clear in use report construction 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
Other useful tools to make your work with MySQL server as easy as it can be
- 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
Powerful Visual Database Designer
- 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
Easy-to-use wizards performing MySQL services
- Backing up database
- Restoring database
- Analyzing tables
- Checking tables
- Repairing tables
- Optimizing tables
New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- 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
- Powerful visual options module
- Localizable program interface
And other useful features
- Keyboard templates
- To-do list
- External tool manager
