migration-checker

Validate CakePHP migrations against fixtures and multi-database schema alignment.

2|Updated Oct 19, 2025

Search Tags:#database #multi-tenant #validation #schema #migration #fixtures #cakephp

Ready to run

npx skills add https://github.com/masanao-ohba/claude-manifests --skill migration-checker-masanao-ohba

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: migration-checker
Source: https://github.com/masanao-ohba/claude-manifests/tree/main/skills/php-cakephp/migration-checker
Command: npx skills add https://github.com/masanao-ohba/claude-manifests --skill migration-checker-masanao-ohba

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

CakePHP migrations, fixtures, and schemas often become out-of-sync across multi-database environments, causing runtime issues and flaky tests.

Core Features & Use Cases

Migration-Fixture consistency checks to ensure column definitions and data types match between migrations and fixtures.
Multi-tenant schema pattern validation to detect incorrect connection patterns and tenant-specific naming.
Quick diagnostics and guidance for aligning test databases and caching schema state.

Quick Start

Run the migration-checker against your application's config/Migrations directory to validate alignment with fixtures and schemas. Provide the path to your migrations directory and let the tool report inconsistencies and suggested fixes.

Frequently Asked Questions about migration-checker

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

Why do my CakePHP fixtures and migrations keep going out of sync?▼

CakePHP fixtures and migrations go out of sync in multi-tenant environments lacking automated schema alignment checks. Validating column definitions and data types between migrations and fixtures prevents these runtime issues and flaky tests.

How do I validate CakePHP migration schema against test fixtures?▼

Validate CakePHP migration schema by running a consistency check against your config/Migrations directory. This compares per-table column definitions and data types with corresponding fixtures to report structural inconsistencies and suggest fixes.

Does this validation tool support multi-tenant database schema patterns?▼

Yes, this validation supports multi-tenant database schema patterns by detecting incorrect connection patterns and validating tenant-specific naming conventions. It enforces per-table schema checks to maintain consistency across multiple databases.

What is the best way to align CakePHP test databases and maintain schema cache?▼

The best way to align test databases is to enforce fixture-structure consistency and maintain the schema cache. Clearing and regenerating the schema cache ensures your migration state matches your test database configuration reliably.

When should I run a migration-fixture consistency check in CakePHP?▼

Run a migration-fixture consistency check when updating multi-tenant schemas or adding new table columns. This catches misaligned data types between your config/Migrations and fixtures before they cause flaky tests or runtime errors.