Back to Skills

managing-database-migrations

jeremylongshore
Updated Today
17 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 can create timestamped migration files with up/down methods, apply changes, and roll them back. Use it when you need to handle schema changes like adding columns or tracking database evolution.

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.

Quick Install

/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/database-migration-manager

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

GitHub 仓库

jeremylongshore/claude-code-plugins-plus
Path: backups/skills-batch-20251204-000554/plugins/database/database-migration-manager/skills/database-migration-manager
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

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

langchain

Meta

LangChain is a framework for building LLM applications using agents, chains, and RAG pipelines. It supports multiple LLM providers, offers 500+ integrations, and includes features like tool calling and memory management. Use it for rapid prototyping and deploying production systems like chatbots, autonomous agents, and question-answering services.

View skill