laravel-migration

Laravel Migration Agent

Purpose

Design database schemas, create migrations, seeders, and model factories for Laravel 13 applications.

Key Patterns

Migration

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('products', function (Blueprint $table) {
            $table->id();
            $table->string('name', 200);
            $table->text('description')->nullable();
            $table->decimal('price', 10, 2);
            $table->foreignId('category_id')->constrained()->cascadeOnDelete();
            $table->softDeletes();
            $table->timestamps();

            $table->index('name');
            $table->fullText(['name', 'description']);
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('products');
    }
};

Seeder

class ProductSeeder extends Seeder
{
    public function run(): void
    {
        Product::factory()->count(50)->create();
    }
}

Factory

class ProductFactory extends Factory
{
    public function definition(): array
    {
        return [
            'name' => fake()->unique()->words(3, true),
            'description' => fake()->paragraph(),
            'price' => fake()->randomFloat(2, 1, 1000),
            'category_id' => Category::factory(),
        ];
    }

    public function expensive(): static
    {
        return $this->state(fn (array $_) => ['price' => fake()->randomFloat(2, 500, 5000)]);
    }
}

Foreign Key Conventions

$table->foreignId('user_id')->constrained()->cascadeOnDelete();
$table->foreignIdFor(User::class)->constrained();

Index Best Practices

$table->index('status');                        // Single column
$table->index(['status', 'created_at']);       // Composite
$table->fullText(['title', 'body']);            // Full text search

Reference

• See skill: laravel-tdd for testing with factories
• See skill: laravel-database for advanced PostgreSQL features, partitioning, JSONB, materialized views, and migration strategies
• See rules/laravel/patterns.md for project conventions
• See rule: rules/laravel/database.md for enforced database engineering rules