Dreamcoder for MySQL (FREE MySQL Tool)

Overview



DreamCoder for MySQL
News | Requirements | View demo | Screenshots | FAQ | Testimonials


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.

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 5.4.

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.


Feature List



Supports all versions of MySQL database server (3.23,4.0,5.0,5.1,5.4)
  • Tables
  • Views
  • UDFs
  • Stored procedures
  • Triggers
  • Events
  • InnoDB tables
  • Foreign Keys
  • UTF-8 Data
Types of connection to the database
  • SSH Tunnel Support
  • SSL Support
  • Standard Connection to MySQL database API
  • Direct connection to the database via TCP-IP
Comprehensive object management
  • Create and delete databases/li>
  • Manage tables, fields, indexes, foreign keys
  • Manage views, stored procedures, triggers, UDF and scheduled events
  • Duplicate database objects
Data Handling
  • Add, view, edit, search, group, sort and filter data
  • Ability to copy and paste data directly from Excel
  • Ability to delete selected records
  • Able to export data into SQL inserts
  • Able to create master detail relationships between unlimited number of tables
  • Utility to handle LOV
  • Advanced filter data builder
Advanced visual SQL query builder and text
  • SQL Editor with autocomplete, syntax highlighting, code folding, description of objects, code proposal and parameters manager/li>
  • Query builder to build SQL's without previous knowledge required
  • SQL Code Formatter
  • Running scripts
  • Parameters auto-replace/li>
Options for exporting and importing data
  • Utility to export data and structure from database like MySQL dump
  • Utility to transfer data from the database
  • Utility to export in multiple formats (MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF)
  • Utility to import in multiple formats (MS Excel, MS Access, DBF, XML, ODF, TXT and CSV)
  • Advanced options for export and import at the level of the data grid
  • Utility to import data directly from Excel
  • Simple export of data into a table
Options for monitoring the database
  • Monitor sessions
  • Graphical utility for database status
  • Graphical utility for tables status
Advanced options for synchronizing the database
  • Utility to synchronize schemas of two databases
  • Utility to synchronize data of two databases
Reports module
  • Multiple database reports
Options for customizing the IDE
  • Options to modify the behavior of the IDE
  • Options to modify the behavior of the SQL editor
  • Options to change the behavior of the data grid
 

Why DreamCoder

DreamCoder is downloaded over 1 millions time and has accumulated over 10.000 happy customers from over 100 countries in the last 8 years.
Now we are the best database tools availabe 100% free in the world for Oracle , MySQL and PostgreSQL.
Home Products DreamCoder for MySQL