Download the PHP package devsite/claude-skill-laravel-migration-searcher without Composer

Laravel Migration Searcher

Intelligent Laravel migration indexer with Claude AI integration. Automatically analyzes and indexes all migrations for instant search and debugging.

Why This Package?

Problem: You have hundreds or thousands of migrations. Finding specific migrations is time-consuming and error-prone.

Solution: This package automatically analyzes all migrations and creates searchable markdown indexes that Claude AI (or you) can query instantly.

Features

• Deep Analysis - Analyzes DDL, DML, Raw SQL, Eloquent operations, loops
• Multiple Views - Chronological, by-type, by-table, by-operation indexes
• Claude AI Integration - Ships with SKILL.md template for Claude AI workflow
• Complexity Scoring - Each migration gets a 1-10 complexity score
• Multiple Formats - Markdown and JSON output formats
• Configurable - Support for custom migration paths and types
• Team-Friendly - Commit indexes to git, whole team benefits
• Zero Dependencies - Only Laravel required

What It Analyzes

The package performs comprehensive static analysis of each migration file:

DDL Operations (Structure)

• CREATE/ALTER/DROP/RENAME tables
• Column definitions with types and modifiers (nullable, default, unique, etc.)
• Indexes (index, unique, primary)
• Foreign keys with dependency tracking

DML Operations (Data)

• INSERT/UPDATE/DELETE via DB::table()
• WHERE conditions - where, whereIn, whereNotIn, whereNull, whereNotNull, whereBetween, whereHas, whereDoesntHave, orWhere
• Columns modified in UPDATE operations
• DB::raw expressions (CASE WHEN, subqueries, etc.)
• Eloquent operations - Model::create(), ->save(), ->delete()
• Relationship operations - ->relation()->create(), ->relation()->createMany()
• Operations inside loops (foreach with save/create/delete/update)

Raw SQL

• DB::statement() - complete SQL queries
• DB::unprepared() - full SQL code
• DB::raw() expressions
• Heredoc/Nowdoc SQL blocks
• Auto-detected operation type (SELECT/INSERT/UPDATE/DELETE/CREATE/ALTER/DROP/TRUNCATE)

Installation

Publish configuration:

Publish skill template (optional - auto-copied on first run):

Configuration

Edit config/migration-searcher.php:

Usage

Generate Index

Generated Output

Default (markdown):

With --format=json:

Using with Claude AI

1. Generate index:

2. Upload to Claude:

   • Upload files from .claude/skills/laravel-migration-searcher/ to claude.ai
   • Or use Claude Code with local file access
3. Ask Claude:

Configuration Examples

Multi-Tenant Application

Modular Application

Data Import Workflow

Team Workflow

Initial Setup

Other Team Members

After Adding/Modifying Migrations

Index Entry Example

Each migration in the full index contains:

Architecture

The package follows SOLID principles with a clean separation of concerns:

Data flows through a clean pipeline: raw migrations → MigrationAnalyzer (returns MigrationAnalysisResult DTO) → toArray() → IndexDataBuilder (sort, group, stats) → Renderer (format to markdown/JSON) → file output. Adding a new format requires only a new class implementing Renderer and registering it in the formats config key.

All constructor dependencies are required (non-nullable) — no fallbacks to concrete implementations. All contracts are bound in the service provider, making it easy to swap implementations or mock in tests.

Requirements

• PHP 8.3+
• Laravel 11.x or 12.x

Testing

Code Coverage

Generate an HTML coverage report (requires PCOV, included in the Docker image):

The report will be available in the ./coverage/ directory. Open coverage/index.html in a browser to inspect line-by-line coverage.

Code Style

This project uses Laravel Pint with the PSR-12 preset.

Check formatting:

Fix formatting locally:

Static Analysis

This project uses PHPStan at level 0.

Run analysis:

License

MIT License. See LICENSE for details.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Support

• Issues: GitHub Issues
• Questions: Open a discussion on GitHub

Author

Adrian Kuriata - GitHub