MySQL Workbench is a complete visual database design tool that integrates SQL development, administration, database design, visual data modeling, change management, creation and maintenance into a single, seamless environment for the MySQL database system.
MySQL Workbench enables a database administrator, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases.
Whilst MySQL Workbench is the successor application of the DBDesigner4 project, it is a complete rewrite.
The software is available in two editions, the Community Open Source edition, and the commercial standard edition. The feature set below relates to the open source edition.
Key Features
- General:
- Database Connection & Instance Management.
- Unlimited Undo/Redo.
- Advanced Find.
- Wizard driven action items.
- Fully scriptable with Python and Lua.
- Export Model Diagrams (PNG, SVG, PDF, PS).
- Print Model Diagrams.
- Support for user plugins.
- SQL Editor:
- Schema Object browsing.
- SQL Syntax Highlighter and Statement Parser.
- Multiple-, editable Result Sets.
- SQL Snippets Collections.
- SSH Connection Tunneling.
- Unicode Support.
- Data Modeling:
- ER Diagramming.
- Drag’n’Drop visual modeling.
- Reverse Engineering from SQL Scripts and Live Database.
- Forward Engineering to SQL Scripts and Live Database.
- Schema Synchronization:
- Schema Diff.
- Schema Synchronization to SQL Scripts.
- Schema Synchronization to Live Database.
- Printing of Models.
- Import from fabFORCE.net DBDesigner4.
- Database Administration:
- Start & Stop of Database Instances.
- Instance Configuration.
- Database Account Management.
- Instance Variables Browsing.
- Log File Browsing.
- Data Dump Export/Import.
Website: www.mysql.com/products/workbench
Support:
Developer: MySQL Workbench Developer Tools Team (Oracle Corporation)
License: GNU GPL or proprietary
MySQL Workbench is written in C++, C#, and Objective-C. Learn C++ with our recommended free books and free tutorials. Learn C# with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.