Generates Laravel Migrations from an existing database

v4.5.0 2021-07-06 16:05 UTC

This package is auto-updated.

Last update: 2021-07-11 03:15:45 UTC


Build Status Latest Stable Version Total Downloads License

Generate Laravel Migrations from an existing database, including indexes and foreign keys!

V4 Changes

  1. Major rewrite on FieldGenerator and IndexGenerator.
  2. Fixed miscellaneous bugs.
  3. Added spatial data type support such as geometry, point, etc.
  4. Support more Laravel migration types such as json, uuid, longText, year, etc
  5. Added spatialIndex support.
  6. timestamp and datetime support precision.
  7. Fixed MySQL tinyInteger and boolean issue.
  8. Able generate softDeletes, rememberToken, timestamps types.
  9. Support set for MySQL.
  10. It is now possible to generate nullable timestamp
  11. Removed unused classes.
  12. Added UT!
  13. More UT will be added to increase coverage.

This package is clone from and updated to support Laravel 6 and above.

Version Compatibility

Laravel Version
8.x 4.x
7.x 4.x
6.x 4.x
5.8.x 4.x
5.7.x 4.x
5.6.x 4.x
5.5 and below


The recommended way to install this is through composer:

composer require --dev "kitloong/laravel-migrations-generator"

Laravel Setup

Laravel will automatically register service provider for you.

Lumen Setup

Auto discovery is not available in Lumen, you need some modification on bootstrap/app.php

Enable facade

Uncomment the following line


Register provider

Add following line



To generate migrations from a database, you need to have your database setup in Laravel's Config.

Run php artisan migrate:generate to create migrations for all the tables, or you can specify the tables you wish to generate using php artisan migrate:generate table1,table2,table3,table4,table5. You can also ignore tables with --ignore="table3,table4,table5"

Laravel Migrations Generator will first generate all the tables, columns and indexes, and afterwards setup all the foreign key constraints. So make sure you include all the tables listed in the foreign keys so that they are present when the foreign keys are created.

You can also specify the connection name if you are not using your default connection with --connection="connection_name"

Run php artisan help migrate:generate for a list of options.

Options Description
-c, --connection[=CONNECTION] The database connection to use
-t, --tables[=TABLES] A list of Tables you wish to Generate Migrations for separated by a comma: users,posts,comments
-i, --ignore[=IGNORE] A list of Tables you wish to ignore, separated by a comma: users,posts,comments
-p, --path[=PATH] Where should the file be created?
--useDBCollation Follow db collations for migrations
--defaultIndexNames Don't use db index names for migrations
--defaultFKNames Don't use db foreign key names for migrations
-tp, --templatePath[=TEMPLATEPATH] The location of the template for this generator

Thank You

Thanks to Bernhard Breytenbach for his great work. This package is cloned from

Thanks to Jeffrey Way for his amazing Laravel-4-Generators package. This package depends greatly on his work.


Kit Loong

Bernhard Breytenbach (@BBreyten)


The Laravel Migrations Generator is open-sourced software licensed under the MIT license