MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and backup. MySQL Workbench is available on Windows, Linux and Mac OS X. It is available free through its Community edition, and an Enterprise edition is available for a commercial license as well, supported by Oracle.
- SQL Editor - Write run and debug SQL statements.
- SQL Code Completion - Context-sensitive list of SQL keywords and objects, for more efficient coding.
- SQL Code Formatter - Automatically formats SQL code to make code more readable.
- SQL Code Generation - One-Click SQL code generation.
- Visual Database Administration - server stop/start, status & health diagnostics, MySQL setting and replication configuration.
- Performance Tuning - Performance reporting and dashboards.
- User and Session Management.
- Connection Management - Connection Wizard, and define multiple, simultaneous connections to different servers.
- Schema Inspector - Detailed views on meta-data for all schema objects with access to maintenance operations.
- Object Browser & Editor - Navigate, explore, and perform actions on database objects (tables, views, triggers, etc.), or edit, create, and delete database objects.
- Data Management - Import/Export, visual data editor
- Visual Data Modeler - Diagramming, Auto layout, Model tables, indexes, etc.
- Schema Model & Validation - Enforces data modeling best practice standards and eliminates common modeling errors, as well as MySQL specific standards.
