skills.rest
seb1n
seb1nCOMMUNITY
Explore all skills by this author →
GitHub

database-migration

Generate, execute, and roll back versioned database schema migrations across Alembic, Prisma, Flyway, and Knex.

147|32|Updated Feb 11, 2026
Search Tags:#database#schema#migration#prisma#alembic#flyway#knex
One-click install
npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-migration-seb1n
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/seb1n/awesome-ai-agent-skills/tree/main/database/database-migration
Command: npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-migration-seb1n

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the complex and error-prone process of managing database schema evolution, ensuring data integrity and application stability during updates.

Core Features & Use Cases

  • Automated Schema Changes: Generates and applies forward and rollback scripts for database schema modifications.
  • Tool Agnostic: Supports popular migration frameworks like Alembic, Prisma Migrate, Flyway, and Knex.
  • Zero-Downtime Deployments: Implements safe, phased migration strategies to prevent service interruptions.
  • Use Case: Safely add a new is_active boolean column to your users table, backfill existing users with a default value, and ensure the application can handle the change without downtime.

Quick Start

Use the database-migration skill to add a nullable email_verified_at timestamp column to the users table using Alembic.

Frequently Asked Questions about database-migration

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

FAQPage Schema
How do I manage database schema migrations across different frameworks?▼

Database schema migrations are managed by generating, executing, and rolling back versioned scripts across frameworks like Alembic, Prisma Migrate, Flyway, and Knex to ensure data integrity during application updates.

What is a zero-downtime database migration strategy?▼

A zero-downtime database migration strategy implements safe, phased schema changes to prevent service interruptions during production deployments while ensuring application stability throughout the update process.

Can I backfill existing data when adding a new column to a database table?▼

Yes, data backfills are supported during schema migrations, allowing you to safely add new columns like a boolean flag to a table and update existing records with default values without causing downtime.

Does this database migration approach work with both Prisma and Alembic?▼

Yes, the tool-agnostic database migration approach works with Prisma Migrate, Alembic, Flyway, and Knex, supporting automated forward and rollback script generation for various frameworks.

How do I roll back a database schema change if an update fails?▼

You can roll back a database schema change by executing generated rollback scripts that reverse the applied modifications, ensuring robust database evolution and data integrity in production environments.

Related Skills

Explore More Software Engineering Skills→
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
AndyAnh174AndyAnh174

database-migration

A JAX and NumPy based library for writing, and executing portable GPU/TPU programs.

Community
Advanced
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced