Laravel Migrations

laravel-migrations

Laravel 12 database migrations - Schema Builder, columns, indexes, foreign keys, seeders. Use when designing database schema or managing migrations.

majiayu000/claude-skill-registry·0installs663starsDevOps & CI/CD

SKILL.md

Full skill instructions

Laravel Migrations

Agent Workflow (MANDATORY)

Before ANY implementation, launch in parallel:

fuse-ai-pilot:explore-codebase - Check existing migrations
fuse-ai-pilot:research-expert - Verify Laravel 12 patterns via Context7
mcp__context7__query-docs - Check specific Schema Builder features

After implementation, run fuse-ai-pilot:sniper for validation.

Overview

Feature	Description
Schema Builder	Create, modify, drop tables
Columns	50+ column types with modifiers
Indexes	Primary, unique, fulltext, spatial
Foreign Keys	Constraints with cascade options
Seeders	Populate tables with data

Critical Rules

Always define down() - Reversible migrations
Use foreignId()->constrained() - Not raw unsignedBigInteger
Add indexes on foreign keys - Performance critical
Test rollback before deploy - Validate down() works
Never modify deployed migrations - Create new ones

Decision Guide

Migration Type

Need schema change?
├── New table → make:migration create_X_table
├── Add column → make:migration add_X_to_Y_table
├── Modify column → make:migration modify_X_in_Y_table
├── Add index → make:migration add_index_to_Y_table
└── Seed data → make:seeder XSeeder

Column Type Selection

Use Case	Type	Example
Primary Key	`id()`	Auto-increment BIGINT
Foreign Key	`foreignId()->constrained()`	References parent
UUID Primary	`uuid()->primary()`	UUIDs
Boolean	`boolean()`	is_active
Enum	`enum('status', [...])`	order_status
JSON	`json()`	preferences
Money	`decimal('price', 10, 2)`	99999999.99
Timestamps	`timestamps()`	created_at, updated_at
Soft Delete	`softDeletes()`	deleted_at

Foreign Key Cascade

Scenario	onDelete	Use Case
Strict integrity	`restrictOnDelete()`	Financial records
Auto-cleanup	`cascadeOnDelete()`	Post → Comments
Preserve with null	`nullOnDelete()`	Optional relations
No action	`noActionOnDelete()`	Audit logs

Reference Guide

Core Concepts

Topic	Reference	When to Consult
Schema	schema.md	Table operations
Columns	columns.md	Column types
Indexes	indexes.md	Performance indexes
Foreign Keys	foreign-keys.md	Constraints
Commands	commands.md	Artisan commands
Seeding	seeding.md	Populate data

Advanced Topics

Topic	Reference	When to Consult
Testing	testing.md	Test migrations
Production	production.md	Deploy safely
Troubleshooting	troubleshooting.md	Fix errors

Templates

Template	When to Use
CreateTableMigration.php.md	New table
ModifyTableMigration.php.md	Alter table
PivotTableMigration.php.md	Many-to-many
Seeder.php.md	Seed patterns
MigrationTest.php.md	Test migrations

Quick Reference

Create Table

Schema::create('posts', function (Blueprint $table) {
    $table->id();
    $table->foreignId('user_id')->constrained()->cascadeOnDelete();
    $table->string('title');
    $table->text('content');
    $table->enum('status', ['draft', 'published'])->default('draft');
    $table->timestamps();
    $table->softDeletes();

    $table->index(['user_id', 'status']);
});

Modify Table

Schema::table('posts', function (Blueprint $table) {
    $table->string('slug')->after('title')->unique();
    $table->boolean('featured')->default(false);
});

Commands

php artisan make:migration create_posts_table
php artisan migrate
php artisan migrate:rollback --step=1
php artisan migrate:fresh --seed

Best Practices

DO

Use foreignId()->constrained() for foreign keys
Add composite indexes for common queries
Test down() method before deploying
Use --pretend to preview SQL

DON'T

Modify already-deployed migrations
Forget down() method
Use raw SQL without Schema Builder
Skip indexes on foreign keys

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/majiayu000/claude-skill-registry --skill laravel-migrations

View on GitHub

skills/data/laravel-migrations/SKILL.md

More DevOps & CI/CD skills

View all

DevOps & CI/CD

google-agents-cli-scaffold

Project scaffolding, deployment configuration, and CI/CD setup for Google ADK agents.

6K 472.6K

View

DevOps & CI/CD

google-agents-cli-observability

Set up tracing, logging, and monitoring for deployed ADK agents across Cloud Trace, BigQuery, and third-party platforms.

6K 472.6K

View

DevOps & CI/CD

azure-enterprise-infra-planner

Enterprise Azure infrastructure architect generating Bicep or Terraform from workload descriptions.

1.5K 454.3K

View

DevOps & CI/CD

azure-kubernetes

Plan and configure production-ready Azure Kubernetes Service clusters with Day-0 and Day-1 best practices.

1.5K 447.1K

View

DevOps & CI/CD

Raw mechanical interfaces fusing Swiss typographic print with military terminal aesthetics. Rigid grids, extreme type scale contrast, utilitarian color, analog degradation effects. For data-heavy dashboards, portfolios, or editorial sites that need to feel like declassified blueprints.

92.7K 354.9K

View

DevOps & CI/CD

just-scrape

Web search, scraping, extraction, crawling, and monitoring via ScrapeGraph AI CLI.

69 245K

View

DevOps & CI/CD

firebase-hosting-basics

Skill for working with Firebase Hosting (Classic). Use this when you want to deploy static web apps, Single Page Apps (SPAs), or simple microservices. Do NOT use for Firebase App Hosting.

462 159.7K

View

DevOps & CI/CD

firebase-app-hosting-basics

Deploy and manage web apps with Firebase App Hosting. Use this skill when deploying Next.js/Angular apps with backends.

462 159.1K

View

DevOps & CI/CD

deploy-to-vercel

Deploy applications and websites to Vercel. Use when the user requests deployment actions like "deploy my app", "deploy and give me the link", "push this live", or "create a preview deployment".

31.9K 146.6K

View

DevOps & CI/CD

programmatic-seo

Build SEO-optimized pages at scale using templates, data, and proven playbook patterns.

53.3K 140.1K

View

DevOps & CI/CD

convex-create-component

Design and build isolated, reusable Convex backend components with clear boundaries and app-facing wrappers.

63 123.5K

View

DevOps & CI/CD

vercel-cli-with-tokens

Deploy and manage projects on Vercel using token-based authentication. Use when working with Vercel CLI using access tokens rather than interactive login — e.g. "deploy to vercel", "set up vercel", "add environment variables to vercel".

31.9K 116.1K

View