Oracle has released a new version of MySQL Workbench with a revamped user interface and more database management support.

(click in image to enlarge)

MySQL Workbench combines data modeling, SQL development, and server administration tools. You can use it to visually design, model, generate, and manage databases including ER models, forward and reverse engineering. On the developer front, it has visual tools for creating, executing, and optimizing SQL queries.

The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The editor also supports EXPLAIN plans for optimizing queries. New in this version is support for database migration, with wizard-based support for migrating Microsoft SQL Server, Sybase ASE, Sybase SQL Anywhere, PostreSQL, and other RDBMS tables, objects and data to MySQL.

The SQL Editor now has a Table Data Search Panel that lets you find data across an entire database by letting you carry out a text search on any number of tables and schemas. The new release also adds a schema inspector that shows you a grid of all the objects in your database schemas letting you view, sort, and analyze various details and statistics.

Other improvements include a Database Connections Panel and Connections Wizard that you can use to create, organize, and manage database connections. While the wizard gives a quick way to create connections, you can work more directly through a Manage Connections dialog that lets you enter connection parameters like IP address, port, username, and password.

The Community Edition of MySQL Workbench is downloadable free of charge under the GPL; the Enterprise Edition is included with the MySQL Enterprise Edition subscription.