Dry running Laravel migrations before actually migrating them

Amit Merchant · March 11, 2021 ·

Sometimes, you might run into a situation where you want to see what all database queries will run upon running your Laravel migrations, and that too without actually running the migrations.

You can do just this by appending the --pretend option/flag to the artisan migrate command like so.

$ php artisan migrate --pretend

For instance, let’s say, I created a migration to create a flights table using the artisan make:migrate command with the following content.

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateFlightsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('flights', function (Blueprint $table) {
            $table->id();
            $table->timestamps();
            $table->string('name')->index();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('flights');
    }
}

Now, when I run the artisan migrate command with the --pretend option, it will list down all the database queries that will get executed during an actual migration like so.

Pretty handy, right?

👋 Hi there! I'm Amit. I write articles about all things web development. If you like what I write and want me to continue doing the same, I would like you buy me some coffees. I'd highly appreciate that. Cheers!

Comments?