Database Migration Management

This handles the mechanics of database schema evolution with version tracking, rollback capabilities, and migration logging built in. You get reference guides for common operations like adding columns safely, creating indexes without blocking production traffic, and managing data transformations. The approach centers on maintaining a migrations tracking table with checksums and execution metadata, which is pretty much the standard pattern but implemented thoroughly. Most useful when you need to coordinate schema changes across multiple environments or need a clear audit trail of what changed and when. The rollback planning is the standout piece here, since that's what most teams skip until they desperately need it.

skills.sh installs: 504
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill database-migration-management --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Implement robust database migration systems with version control, rollback capabilities, and data transformation strategies. Includes migration frameworks and production deployment patterns.

When to Use

Schema versioning and evolution
Data transformations and cleanup
Adding/removing tables and columns
Index creation and optimization
Migration testing and validation
Rollback planning and execution
Multi-environment deployments

Quick Start

Minimal working example:

-- Create migrations tracking table
CREATE TABLE schema_migrations (
  version BIGINT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  executed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  duration_ms INTEGER,
  checksum VARCHAR(64)
);

SKILL.md on GitHub