migrate

Generate ORM-aware database migrations with rollback steps and risk assessment.

1|Updated Dec 1, 2025
One-click install
npx skills add https://github.com/hypeJunction/ai-assistant-starter --skill migrate-hypejunction
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migrate
Source: https://github.com/hypeJunction/ai-assistant-starter/tree/main/skills/migrate
Command: npx skills add https://github.com/hypeJunction/ai-assistant-starter --skill migrate-hypejunction

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of making database schema changes, ensuring safety, clarity, and a robust rollback plan to prevent data loss or corruption.

Core Features & Use Cases

  • Automated Schema Changes: Handles adding/removing columns, creating tables, and adding indexes.
  • Risk Assessment & Planning: Classifies migration risk and outlines a clear plan, including rollback strategies.
  • ORM Integration: Supports popular ORMs like Prisma, Drizzle, Knex, and TypeORM.
  • Use Case: When adding a new email_verified boolean column to your users table, this Skill will guide you through assessing the risk, planning the steps (especially for NOT NULL constraints on existing data), generating the migration file, reviewing the SQL, applying it, and documenting the rollback procedure.

Quick Start

Use the migrate skill to add a nullable phone column to the users table using Prisma.

Frequently Asked Questions about migrate

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

FAQPage Schema
How do I safely add a NOT NULL column to an existing database schema without losing data?

To safely add a NOT NULL database schema column, you need a migration workflow that assesses risk and plans data backfills. This Skill generates the migration steps, handles existing data constraints, and documents rollback procedures to prevent data loss.

Can I generate database migrations using Prisma and other ORMs?

Yes, you can generate database migrations using Prisma, as well as Drizzle, Knex, and TypeORM. The Skill provides ORM-aware migration file generation, allowing you to review the underlying SQL before applying schema changes to your database.

What is the safest way to plan a database schema rollback for risky operations like adding indexes?

The safest way to plan a database schema rollback is to use a migration workflow that classifies operational risk and documents rollback steps. This Skill generates rollback procedures for adding indexes or creating tables to ensure safe schema reversal.

How do I handle database schema changes and data backfills in a production environment?

Handling production database schema changes and data backfills requires a structured migration process with risk assessment. This Skill manages the workflow by generating reviewable SQL, planning backfill steps, and outlining a clear rollback strategy.

Does this database migration workflow support risk assessment for schema changes?

Yes, this database migration workflow includes risk assessment for schema changes. It classifies the risk level of operations like adding or removing columns and provides a clear execution plan with documented rollback steps before applying changes.