Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870
Brazil: +55 11 5189-1097

More Countries »

Contact Us Online »

MySQL Enterprise Edition Trial - Try Now

MySQL Workbench Features

MySQL Workbench is offered in the following Editions:

MySQL Workbench Community Edition — Open Source (GPL License).
MySQL Workbench Standard Edition — Commercial. Includes additional modules to improve DBA productivity.

		MySQL Workbench Community	MySQL Workbench Standard
Software License		GPL	Commercial ²
Visual SQL Development
SQL Editor	Write, run and debug SQL statements	Yes	Yes
SQL Code Completion	Context-sensitive list of SQL keywords and objects, for more efficient coding	Yes	Yes
SQL Code Formatter	Automatically formats SQL code to make code more readable	Yes	Yes
SQL Syntax Highlighting	Color syntax highlighting	Yes	Yes
SQL Code Generation	One-Click SQL code generation	Yes	Yes
SQL Snippets	Reuse your favorite SQL snippets	Yes	Yes
SQL History	Running history of all executed SQL	Yes	Yes
Visual Explain	Visually analyze query execution plans	Yes	Yes
Visual Database Administration
Server Stop/Start	Stop/Start servers locally and remotely	Yes	Yes
Server Status & Health	View key server diagnostic information (Status, CPU, Memory, Hit rate, Network Traffic)	Yes	Yes
Server Logs	View and parse slow and error logs (if table based)	Yes	Yes
Server Configuration	View and edit MySQL Server settings	Yes	Yes
Replication Configuration	View and edit MySQL Replication settings	Yes	Yes
User and Session Management
Application Roles	Convenient grouping of privileges for users	Yes	Yes
User Management	View, edit, create, delete and clone MySQL users and privileges	Yes	Yes
Session Management	View status of connections and kill	Yes	Yes
Connection Management
Connection Wizard	Configure connections to MySQL Servers	Yes	Yes
Multiple Connections	Define multiple, simultaneous connections to different servers	Yes	Yes
SSH-Tunneling	Configure SSH connections to local and remote servers	Yes	Yes
Object Management
Object Browser	Easily navigate, explore, and perform actions on database objects (tables, views, triggers, etc.)	Yes	Yes
Object Editor	Easily edit, create or delete database objects (tables, views, triggers, etc.)	Yes	Yes
Data Management
Import/Export	Import and export mysqldump files	Yes	Yes
Export Result Sets	Export result sets as CSV, XML, HTML	Yes	Yes
Visual Data Editor	View and edit result sets in grid	Yes	Yes
Multi-Pane Result Sets	View multiple result sets in the same visual data window	Yes	Yes
Quick Find	Quickly locate hard to find rows or cells	Yes	Yes
Large Result Set Limits	Limit number of rows returned for large result sets	Yes	Yes
Visual Data Modeling
ER Diagramming	Complete entity-relationship diagramming	Yes	Yes
Choice of Diagramming Notation	Choose from popular modeling notations	Yes	Yes
Auto Layout	Automatically arrange large models	Yes	Yes
Model Tables, Indexes, Views	Manage all MySQL data-related objects	Yes	Yes
Model Stored Procedures, Triggers, Functions	Manage all MySQL code-related objects	Yes	Yes
Model User Security	Manage MySQL security privileges in model	Yes	Yes
Reverse Enginnering
Reverse Engineer from SQL Script	Create models from SQL text scripts	Yes	Yes
Reverse Engineer from Live Database	Create models from live databases	Yes	Yes
Forward Enginnering
Forward Engineer to SQL Script	Generate DDL that runs right the first time to a SQL script	Yes	Yes
Forward Engineer to Live Database	Generate a complete physical database from a model	Yes	Yes
Schema Synchronization
Schema Diff	Understand the differences between a model and a live database or SQL script	Yes	Yes
Schema Synch to SQL Script	Automatically update a model or SQL script in either direction	Yes	Yes
Schema Synch to Live Database	Automatically update a model or live database in either direction	Yes	Yes
Schema & Model Validation ¹
General Schema Validation	Enforces data modeling best practice standards and eliminates common modeling errors		Yes
MySQL-specific Schema Validation	Enforces MySQL-specific design standards and ensures physical schemas are built correctly the first time		Yes
Model Validation	Ensure model is free from errors		Yes
DBDoc ¹
Document database schemata	Automate documentation of databases		Yes
Document all SQL object types	Include information about all aspects of a database or model		Yes
Document output in multiple formats	Publish in HMTL or text		Yes
Utilities
Import from DBDesigner4	Easily import models from DBDesigner4	Yes	Yes
Export Model Diagrams	Easily export as PNG, SVG, PDF, Postscript	Yes	Yes
Scripting & Plugins
Python Plugins	Customize with Python plugins	Yes	Yes
Lua Plugins	Customize with Lua plugins	Yes	Yes
Database Migration
Database Migration Wizard	Migration from Microsoft SQL Server, Sybase ASE and PostgreSQL	Yes	Yes

¹ Features only available to commercial customers

² MySQL Workbench SE is available with Commercial MySQL Editions