MCP HubMCP Hub
スキル一覧に戻る

managing-database-migrations

jeremylongshore
更新日 Yesterday
70 閲覧
712
74
712
GitHubで表示
メタaidata

について

このスキルは、ClaudeがPostgreSQL、MySQL、SQLite、MongoDBのバージョン管理されたデータベースマイグレーションを管理できるようにします。タイムスタンプ付きのマイグレーションファイルを作成し、アップ/ダウンメソッドを備え、変更を適用したりロールバックしたりすることができます。カラムの追加やデータベースの進化の追跡など、スキーマ変更を扱う必要がある場合にご利用ください。

クイックインストール

Claude Code

推奨
プラグインコマンド推奨
/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus
Git クローン代替
git clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/managing-database-migrations

このコマンドをClaude Codeにコピー&ペーストしてスキルをインストールします

ドキュメント

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 リポジトリ

jeremylongshore/claude-code-plugins-plus
パス: backups/skills-batch-20251204-000554/plugins/database/database-migration-manager/skills/database-migration-manager
aiautomationclaude-codedevopsmarketplacemcp

関連スキル

content-collections

メタ

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.

スキルを見る

evaluating-llms-harness

テスト

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.

スキルを見る

sglang

メタ

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.

スキルを見る

polymarket

メタ

This skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.

スキルを見る