Export from MySQL Workbench to a Laravel Migration

Export from MySQL Workbench to a Laravel Migration

MySQL Workbench is a cross-platform GPL app that allows you to fully design and document your databases through the app.

Brandon Eckenrode, created a plugin that allows you to export a MySQL Workbench model to Laravel 5 migrations that follow PSR-2 coding standards. When exported, each migration is generated and saved in its own, properly named, migration file.

This works by downloading the plugin from GitHub, then open MySQL Workbench and go to the Scripting menu, Install Plugin/Module. Next select the export-laravel-5-migrations.py file and restart the app.

When you open it back up navigate to File -> New Model and add a basic structure for a table.

mysql-workbench-model

Next, navigate to Tools -> Catalog -> Export Laravel 5 Migration, and a window will open with the migration ready for you to download:

laravel-mysql-workbench-migration

You can download this from GitHub and learn about Workbench Modeling on the MySQL site.

If you are a Sequel Pro user be sure and check out a similar style plugin, Export from Sequel Pro to a Laravel Migration


Filed in: Development Tools / Migrations / MySQL


Newsletter

Join the weekly newsletter and never miss out on new tips, tutorials, and more.

Laravel News Partners

Laravel Jobs

Software Engineer Lead (PHP)
Remote
CivicPlus, LLC
Full-time Senior Web Developer
Detroit, MI
Wayne State University
Senior Software Engineer
Sydney, Australia
FoodByUs
Full Stack Engineer
Remote or Medford, Oregon
Empire Medical
Laravel Developer (fulltime - Dutch only)
Netherlands
Qbixx | Webservices
Full Stack or Back-End Developer
Alexandria, VA; Tallahassee, FL; Orlando, FL
Marketing for Change
Senior Quality Assurance Engineer
Remote
Bisnow Media