Managing Database Migrations

This skill empowers Claude to handle database migrations, including creating new migrations, applying changes, and rolling back previous modifications. It ensures that database schema changes are managed safely and efficiently.

Databases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add jeremylongshore/claude-code-plugins-plus-skills
/plugin install database-migration-manager@claude-code-plugins-plus

Run these inside Claude Code. The skill comes with its plugin.

What this skill does

This skill enables Claude to manage database schema changes through version-controlled migrations. It is activated when the user requests to create, apply, or rollback database migrations. The skill supports generating timestamped migration files with both up and down migrations for PostgreSQL, MySQL, SQLite, and MongoDB. It helps in tracking schema evolution and ensuring safe database modifications. Use this skill when the user mentions "database migration", "schema change", "add column", "rollback migration", or "create migration".

Trigger phrases

Claude loads this skill automatically when you say things like:

“database migration”“schema change”“add column”“rollback migration”“create migration”

How it works

  1. Migration File Generation: Claude generates a timestamped migration file, including both "up" (apply changes) and "down" (rollback changes) migrations.
  2. Database Support: The generated migration file is compatible with PostgreSQL, MySQL, SQLite, or MongoDB.

When to use it

  • Create a new database migration file.
  • Add a column to an existing database table.
  • Rollback a previous database migration.
  • Manage database schema changes.

Best practices

  • Transactions: Wrap migration steps within transactions to ensure atomicity; either all changes succeed, or none do.
  • Naming Conventions: Use clear and descriptive names for your migration files (e.g., `YYYYMMDDHHMMSS_add_email_to_users`).

Details

Skill name
managing-database-migrations
Plugin
database-migration-manager

FAQ

What does the Managing Database Migrations skill do?

This skill enables Claude to manage database schema changes through version-controlled migrations. It is activated when the user requests to create, apply, or rollback database migrations. The skill supports generating timestamped migration files with both up and down migrations for PostgreSQL, MySQL, SQLite, and MongoDB. It helps in tracking schema evolution and ensuring safe database modifications. Use this skill when the user mentions "database migration", "schema change", "add column", "rollback migration", or "create migration".

How do I install the Managing Database Migrations skill?

Claude Code plugin: /plugin marketplace add jeremylongshore/claude-code-plugins-plus-skills then /plugin install database-migration-manager@claude-code-plugins-plus. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Related skills

000 Jeremy Content Consistency Validator

jeremylongshore/claude-code-plugins-plus-skills

Validates messaging consistency across website, GitHub repositories, and local documentation. Generates comprehensive read-only discrepancy reports showing where messaging conflicts or inconsistencies exist. Activates when user mentions "consistency check", "validate documentation", "check for mixed messaging", "audit content consistency", or before updating internal paperwork.

Writing & Content

001 Jeremy Taskwarrior Integration

jeremylongshore/claude-code-plugins-plus-skills

Enforces complete Taskwarrior integration protocol for ALL coding tasks. Activates automatically when user mentions "taskwarrior", "task warrior", "tw", or discusses task management. Decomposes all coding work into properly tracked Taskwarrior tasks with full lifecycle: task add → task start → implementation → task done. Integrates with Timewarrior for automatic time tracking.

Productivity & Notes

Adapting Transfer Learning Models

jeremylongshore/claude-code-plugins-plus-skills

This skill automates the adaptation of pre-trained machine learning models using transfer learning techniques. It is triggered when the user requests assistance with fine-tuning a model, adapting a pre-trained model to a new dataset, or performing transfer learning. It analyzes the user's requirements, generates code for adapting the model, includes data validation and error handling, provides performance metrics, and saves artifacts with documentation. Use this skill when you need to leverage existing models for new tasks or datasets, optimizing for performance and efficiency.

Learning & Education

Managing Database Partitions

jeremylongshore/claude-code-plugins-plus-skills

This skill enables Claude to design, implement, and manage table partitioning strategies for large databases. It is triggered when the user needs to optimize query performance, manage time-series data, or reduce maintenance windows for tables exceeding 100GB. Use this skill when asked to "create database partitions", "optimize database queries with partitioning", "manage large database tables", or when the user mentions "partitioning strategy", "data archival", or uses the command `/partition`. The skill helps automate partition maintenance and data lifecycle management. It focuses on database

Databases

Implementing Database Caching

jeremylongshore/claude-code-plugins-plus-skills

This skill enables Claude to implement multi-tier database caching solutions. It is triggered when the user requests database caching, performance improvements, or reduced database load. The skill utilizes Redis, in-memory caching, and CDN layers to optimize database performance by reducing database load, improving query latency, and supporting horizontal scaling with cache-aside, write-through, and read-through patterns. Use this skill when the user mentions terms like "database caching", "improve database performance", "reduce database load", or uses the `/caching` command.

Databases

Managing Database Recovery

jeremylongshore/claude-code-plugins-plus-skills

This skill manages database recovery operations using the database-recovery-manager plugin. It enables disaster recovery, point-in-time recovery (PITR), and automated failover strategies for production database systems. Use this skill when the user requests help with "database recovery", "disaster recovery", "point-in-time recovery", "PITR", "backup validation", "recovery testing", or "multi-region failover" for databases. It automates backup verification and recovery testing.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.