migration-requirements

Analyze schema changes and generate database migration plans with rollback steps.

3|2|Updated Jun 25, 2024
One-click install
npx skills add https://github.com/Hopin-inc/civicship-api --skill migration-requirements
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migration-requirements
Source: https://github.com/Hopin-inc/civicship-api/tree/main/.claude/skills/migration-requirements
Command: npx skills add https://github.com/Hopin-inc/civicship-api --skill migration-requirements

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps teams design safe, auditable data migration plans for evolving database schemas, ensuring minimal downtime and clear rollback procedures.

Core Features & Use Cases

  • Migration planning workflow including risk assessment, backup strategy, and rollback options.
  • Support for Prisma and SQL-based migrations.
  • Step-by-step execution plan with readiness checks and rollback tests.

Quick Start

Describe a complete migration plan by supplying a migration overview, a requirements document, or a Prisma/SQL migration file.

Frequently Asked Questions about migration-requirements

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

FAQPage Schema
How do I plan a safe database migration with rollback steps?

To plan a safe database migration, you must analyze schema changes, assess risks, and define explicit rollback requirements. This process generates a detailed migration plan featuring pre-checks, backup strategies, and staged rollout guidance to ensure minimal downtime.

How does a Prisma migration plan handle data transformation and validation?

A Prisma migration plan handles data transformation by analyzing schema changes and integrating validation checks into the workflow. It generates step-by-step execution guidance, ensuring data integrity through readiness checks before and after the transformation.

What's the best way to execute staged rollouts for SQL database migrations?

The best way to execute staged rollouts for SQL database migrations is to follow a generated plan that includes readiness checks, backup strategies, and rollback tests. This approach ensures minimal downtime and provides clear rollback procedures if issues arise.

Can I use raw SQL migration files to generate a risk assessment report?

Yes, you can supply raw SQL migration files to generate a risk assessment report. The system analyzes the provided SQL to identify data transformation needs, evaluate rollback requirements, and output a detailed migration plan with risk assessments.

When do I need a database backup strategy for schema evolution?

You need a database backup strategy for schema evolution whenever you execute database migrations that involve data transformation or structural changes. A proper backup strategy is automatically included in the generated migration plan to ensure safe and auditable rollbacks.

Why does my database migration plan need pre-checks and rollback tests?

Database migration plans need pre-checks and rollback tests to prevent data loss and ensure minimal downtime during schema evolution. These validation steps confirm readiness before execution and verify that backup procedures function correctly if a rollback is required.