DreamCoder for MySQL is a tool for developing and managing MySQL databases. This product can increase the productivity and quality of development teams and database administrators (DBAs). In the DreamCoder for MySQL you will find different modules and utilities to manage and develop in MySQL. You won't need to buy separate tools or complex Studios which make everyday work more complex and difficult.DreamCoder for MySQL provides an intuitive interface that allows you to perform database tasks quickly and easily. With DreamCoder you can create, edit, duplicate, export and delete objects, compile and run stored procedures, export and import data, generate reports, monitor the database activity, synchronize the database, build and execute queries, format code, manipulate blob, create users and execute scripts. Moreover, this product supports all versions of the MySQL database server, from version 3.23 to version 3.60. Development and management of MySQL features never was this easy! Start working immediately with stored procedures, triggers, views, foreign keys, scheduled events, blob, etc. You don't need to be a database expert.

Some key features of "DreamCoder for MySQL Enterprise":

• SSH Tunnel connection
• SSL connection
• Administration of project
• MDI Interface - Microsoft Office Style
• User Manager
• Report Designer - build powerful reports visually
• HTML Report Generator
• Master Detail Table Browser (Enterprise Only)
• Database Reports (Enterprise Only)
• SQL Formatter (Enterprise Only)
• Database Data Synchronization (Enterprise Only)
• Database Structure Synchronization (Enterprise Only)
• Advanced Query Builder (Enterprise,Professional)
• Object Description
• List Value for foreing keys (MySQL 5.0)
• SQL History
• Powerful PHP code editor (Enterprise/Professional)
• Powerful HTML code editor (Enterprise/Professional)
• Powerful Java code editor (Enterprise/Professional)
• Powerful XML code editor (Enterprise/Professional)
• PHP Highlighter (Enterprise/Professional)
• Java Highlighter (Enterprise/Professional)
• HTML Highlighter (Enterprise/Professional)
• XML Highlighter (Enterprise/Professional)
• Procedure Evaluator ( MySQL 5.0)
• UDF Manager
• BLob Viewer
• Database Transfer (Enterprise/Professional)
• Clone Object (Enterprise/Professional)
• Export Manager
• Connection manager
• Graphical TABLE status
• Graphical databases status
• Generate Table SQL
• SQL Autocomplete
• Constraint Manager
• Index Manager
• Graphical Session Monitor
• Foreign key support for InnoDB tables
  
  Easy management of all MySQL objects
• Creating/Dropping databases
• Creating/Alter/Dropping tables
• Creating/Dropping Stored Procedures ( MySQL Server 5.0)
• Creating/Alter/Dropping/Viewing/Editing data in Tables ( MySQL Server 5.0)
• Creating/Alter/Dropping Triggers ( MySQL Server 5.0)
• Creating/Editing/Dropping index.
• Support of all MySQL TABLE types (including transaction-safe-tables)
• Creating/Editing/Dropping users
• Creating/Editing/Dropping foreing keys
• Support of all field types (including BLOBs)
  
  SQL processing and watching tools
• Multiple SQL Editors
• Parameter Manager.
• Script Executing (SQL Script Editor)
• SQL Monitor
• Templates Options
• Powerful Print Metadata Module for creating customizable metadata reports
• Extracting metadata INTO text files or SQL Script editor
• Powerful User Manager for administering users and privileges
  
  Powerful data manipulation tools
• Powerful BLOB Viewer/Editor with several types of viewing BLOB data
• Export data in to 14 popular formats like MS Access, MS Excel, MS Word , HTML, PDF.
• Import data from in 7 popular formats like MS Excel, MS Access, DBF, XML, TXT and CSV.
• Export data to SQL script as INSERT statement
• Advanced Grid Options. ( Copy and Paste records for Ms Excel)
• Grid Fileters.
• Grid Group, Sort and Summarize information.
  
  Fully customizable program interface
• Program options: windows, fonts, grid colors, etc.
• Editors: custom colors, fonts etc.
• Toolbars for all program windows
• Powerful Visual Options Module
• Possibility of saving all the program settings
• Localizable program interface