How does the skill prevent accidental data loss?

It classifies all migration steps and halts the process if a 'DESTRUCTIVE' operation is detected, requiring an explicit flag in the user story configuration before proceeding.

Does this skill support specific ORMs?

Yes, it is designed to work with major ORMs including Prisma, TypeORM, SQLAlchemy, and Drizzle by monitoring their respective model and schema files.

What is the purpose of the shadow database?

The shadow database is a temporary Docker container used to apply and test the migration in isolation, ensuring the SQL is valid and passes integrity checks before affecting dev or prod.

Can I roll back migrations created by this skill?

Yes, the skill is built on the principle of reversibility and automatically generates 'down' migration SQL for every change it plans.

Schema Migration Governor

Name: Schema Migration Governor
Author: kimhons

bykimhons

•

Database Management

Manages database schema migrations autonomously while preventing data loss through automated safety checks and reversible planning.

The Schema Migration Governor is a specialized skill for Claude Code designed to automate the end-to-end lifecycle of database schema changes. It monitors model and entity files for modifications, delegates migration planning to a dedicated sub-agent to generate reversible SQL scripts, and strictly identifies potentially destructive operations. By utilizing a Docker-based shadow database for pre-deployment validation and requiring explicit configuration-level confirmation for data-dropping actions, it provides a robust safety net for autonomous, production-level development.

Key Features

011 GitHub stars

02Pre-deployment validation using temporary shadow database testing

03Automated schema change detection via git file monitoring

04Generation of reversible 'up' and 'down' migration scripts

05Destructive operation detection with mandatory confirmation safeguards

06Automated schema snapshot management and state tracking

Use Cases

01Automating SQL migration generation for ORMs like Prisma or SQLAlchemy

02Safely modifying database entities in production-grade applications

03Preventing accidental data loss during autonomous development cycles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kimhons/ralph-loop-ultra schema-migration-governor

For use in Claude.ai and ChatGPT

Download Skill