migration-validator

Community

Ensure Supabase migration integrity.

AuthorBruceTyndall
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses the critical need for maintaining the integrity and order of Supabase database migrations, preventing data loss and deployment failures caused by incorrect schema changes.

Core Features & Use Cases

  • Migration Inventory: Lists and counts SQL migration files.
  • Sequential Ordering Check: Verifies that migration files are chronologically ordered and detects duplicate timestamps.
  • ADD-ONLY Compliance: Scans for and reports destructive operations like DROP TABLE, DROP COLUMN, TRUNCATE, and DELETE FROM.
  • Naming Convention Check: Ensures migration files adhere to the YYYYMMDDHHMMSS naming pattern.
  • Conflict Detection: Identifies tables that are modified across multiple migrations, highlighting potential conflicts.
  • Use Case: Before merging a new set of database changes, run this skill to automatically audit all migration files, ensuring they are correctly ordered, do not contain accidental data-deleting commands, and follow established naming conventions.

Quick Start

Run the migration validator skill to check the integrity of Supabase migrations in the SOCELLE-WEB project.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: migration-validator
Download link: https://github.com/BruceTyndall/socelle-global/archive/main.zip#migration-validator

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.