Back to Skills

Managing Database Migrations

jeremylongshore
Updated Today
23 views
712
74
712
View on GitHub
Metaaidata

About

This skill enables Claude to manage version-controlled database migrations for PostgreSQL, MySQL, SQLite, and MongoDB. It handles creating timestamped migration files with up/down methods, applying changes, and rolling back modifications. Use it for schema changes like adding columns or when users mention "database migration" or "rollback migration."

Quick Install

Claude Code

Recommended
Plugin CommandRecommended
/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus
Git CloneAlternative
git clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/Managing Database Migrations

Copy and paste this command in Claude Code to install this skill

Documentation

Overview

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.

How It Works

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

When to Use This Skill

This skill activates when you need to:

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

Examples

Example 1: Adding a Column

User request: "Create a migration to add an 'email' column to the 'users' table."

The skill will:

  1. Generate a new migration file with timestamped name.
  2. Populate the 'up' migration with SQL to add the 'email' column to the 'users' table.
  3. Populate the 'down' migration with SQL to remove the 'email' column from the 'users' table.

Example 2: Rolling Back a Migration

User request: "Rollback the last database migration."

The skill will:

  1. Identify the most recently applied migration.
  2. Execute the 'down' migration script associated with that migration.
  3. Confirm the successful rollback.

Best Practices

  • Idempotency: Ensure your migrations are idempotent, meaning they can be applied multiple times without unintended side effects.
  • 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).

Integration

This skill can be used independently or in conjunction with other plugins for database management, ORM integration, and deployment automation.

GitHub Repository

jeremylongshore/claude-code-plugins-plus
Path: backups/plugin-enhancements/plugin-backups/database-migration-manager_20251020_054521/skills/skill-adapter
aiautomationclaude-codedevopsmarketplacemcp

Related Skills

sglang

Meta

SGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.

View skill

evaluating-llms-harness

Testing

This Claude Skill runs the lm-evaluation-harness to benchmark LLMs across 60+ standardized academic tasks like MMLU and GSM8K. It's designed for developers to compare model quality, track training progress, or report academic results. The tool supports various backends including HuggingFace and vLLM models.

View skill

content-collections

Meta

This skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.

View skill

llamaguard

Other

LlamaGuard is Meta's 7-8B parameter model for moderating LLM inputs and outputs across six safety categories like violence and hate speech. It offers 94-95% accuracy and can be deployed using vLLM, Hugging Face, or Amazon SageMaker. Use this skill to easily integrate content filtering and safety guardrails into your AI applications.

View skill