migration-create-sql

Generates Up/Down SQL migration scripts for schema changes.

Updated Mar 14, 2026
One-click install
npx skills add https://github.com/CaptainPhantasy/floyd-v5 --skill migration-create-sql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migration-create-sql
Source: https://github.com/CaptainPhantasy/floyd-v5/tree/main/extensibility/skills/data/migration-create-sql
Command: npx skills add https://github.com/CaptainPhantasy/floyd-v5 --skill migration-create-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Generate Up/Down SQL migration scripts that ensure deterministic, repeatable changes to your database schema across environments.

Core Features & Use Cases

  • Deterministic Up/Down migration script generation for safe schema changes.
  • Versioned migrations that track changes across environments and rollback paths.
  • Use Case: apply a refactor or feature deployment with confidence, then rollback if needed.

Quick Start

Provide your desired Up/Down migration changes and this tool will output deterministic SQL migrations.

Frequently Asked Questions about migration-create-sql

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

FAQPage Schema
How do I generate idempotent SQL migration scripts for database schema changes?

You generate idempotent SQL migration scripts by automating deterministic Up/Down script creation for database schema changes. This ensures repeatable, reliable versioned migrations across environments during feature deployments and rollbacks.

What is the best way to create reversible database migrations for safe rollbacks?

The best way to create reversible database migrations is to generate deterministic Up/Down SQL scripts. This approach ensures reliable reversibility for each migration, allowing you to apply a refactor confidently and rollback if needed.

How do I manage versioned database schema changes across multiple environments?

You manage versioned database schema changes across environments by applying deterministic Up/Down SQL migration scripts. This tracks changes across environments and rollback paths, ensuring repeatable deployments during refactors.

Does this SQL migration approach work without external database dependencies?

Yes, this SQL migration approach works without external dependencies. It independently automates Up/Down migration script generation to ensure deterministic naming and idempotent operations for your project database.

Why do my database migrations fail to rollback cleanly during feature deployments?

Database migrations fail to rollback cleanly without deterministic Up/Down scripts. Generating reliable, reversible SQL migrations ensures that schema changes track properly across environments and rollback paths for safe feature deployments.

Can I use this to automate SQL migrations for project database refactors?

Yes, you can automate SQL migrations for project database refactors. By providing your desired Up/Down migration changes, the tool outputs deterministic SQL migrations that ensure repeatable schema changes.