SQL to Laravel Migration

About this SQL to Laravel migration converter

Paste the structure of a MySQL or MariaDB database and get the Laravel migrations that create it: one file per table, ordered so that every foreign key points at a table that already exists. It reads the SQL itself (nothing is executed and nothing leaves your browser). This page is the SQL entry point of the Database Schema Studio: once imported, the schema is fully editable, and you can add models, factories and seeders or download a ZIP.

How to use it

1. Paste CREATE TABLE statements or a structure-only dump, or open a .sql file, then Import.
2. Pick the Laravel version and the database (MySQL is preselected).
3. Read the diagnostics first: they list what was skipped or approximated.
4. Adjust tables, columns and keys if you like: the migrations update as you edit.
5. Copy or download each migration, or download them all as one ZIP.

A worked example

This SQL:

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `title` varchar(200) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `posts_user_id_foreign` (`user_id`),
  CONSTRAINT `posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

becomes two migrations. The second one (the first has id(), the two timestamp columns and unique() on email) is:

Schema::create('posts', function (Blueprint $table) {
    $table->id();
    $table->foreignId('user_id')->constrained()->cascadeOnDelete();
    $table->string('title', 200);
    $table->boolean('published')->default(false);
});

Note what changed: bigint unsigned NOT NULL AUTO_INCREMENT named id is id(); the foreign key on user_id becomes foreignId()->constrained(); tinyint(1) with DEFAULT '0' is a boolean defaulting to false; and the separate KEY that only supported the foreign key is gone because MySQL creates it from the foreign key. ENGINE and CHARSET are connection and server configuration in Laravel, so they are not repeated in migrations.

Type mapping

tinytext, tinyblob and the larger blob types are approximated (text and binary) and year, set, bit and spatial types cannot be created by a Blueprint call: they become a // TODO line and a warning.

What it does not read

• Views, triggers, stored procedures, functions and events (listed, not imported).
• CHECK constraints, expression indexes and partitioning (warned about, dropped).
• Data: INSERT statements are counted and skipped.
• SQL for other databases than MySQL and MariaDB.