managing-database-migrations
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".
Install
mkdir -p .claude/skills/managing-database-migrations && curl -L -o skill.zip "https://mcp.directory/api/skills/download/1229" && unzip -o skill.zip -d .claude/skills/managing-database-migrations && rm skill.zipInstalls to .claude/skills/managing-database-migrations
About this skill
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
- Migration Request: The user requests a database migration task (e.g., "create a migration").
- Migration File Generation: Claude generates a timestamped migration file, including both "up" (apply changes) and "down" (rollback changes) migrations.
- 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:
- Generate a new migration file with timestamped name.
- Populate the 'up' migration with SQL to add the 'email' column to the 'users' table.
- 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:
- Identify the most recently applied migration.
- Execute the 'down' migration script associated with that migration.
- 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.
More by jeremylongshore
View all →You might also like
flutter-development
aj-geddes
Build beautiful cross-platform mobile apps with Flutter and Dart. Covers widgets, state management with Provider/BLoC, navigation, API integration, and material design.
drawio-diagrams-enhanced
jgtolentino
Create professional draw.io (diagrams.net) diagrams in XML format (.drawio files) with integrated PMP/PMBOK methodologies, extensive visual asset libraries, and industry-standard professional templates. Use this skill when users ask to create flowcharts, swimlane diagrams, cross-functional flowcharts, org charts, network diagrams, UML diagrams, BPMN, project management diagrams (WBS, Gantt, PERT, RACI), risk matrices, stakeholder maps, or any other visual diagram in draw.io format. This skill includes access to custom shape libraries for icons, clipart, and professional symbols.
godot
bfollington
This skill should be used when working on Godot Engine projects. It provides specialized knowledge of Godot's file formats (.gd, .tscn, .tres), architecture patterns (component-based, signal-driven, resource-based), common pitfalls, validation tools, code templates, and CLI workflows. The `godot` command is available for running the game, validating scripts, importing resources, and exporting builds. Use this skill for tasks involving Godot game development, debugging scene/resource files, implementing game systems, or creating new Godot components.
nano-banana-pro
garg-aayush
Generate and edit images using Google's Nano Banana Pro (Gemini 3 Pro Image) API. Use when the user asks to generate, create, edit, modify, change, alter, or update images. Also use when user references an existing image file and asks to modify it in any way (e.g., "modify this image", "change the background", "replace X with Y"). Supports both text-to-image generation and image-to-image editing with configurable resolution (1K default, 2K, or 4K for high resolution). DO NOT read the image file first - use this skill directly with the --input-image parameter.
ui-ux-pro-max
nextlevelbuilder
"UI/UX design intelligence. 50 styles, 21 palettes, 50 font pairings, 20 charts, 8 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, mobile app, .html, .tsx, .vue, .svelte. Elements: button, modal, navbar, sidebar, card, table, form, chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, flat design. Topics: color palette, accessibility, animation, layout, typography, font pairing, spacing, hover, shadow, gradient."
rust-coding-skill
UtakataKyosui
Guides Claude in writing idiomatic, efficient, well-structured Rust code using proper data modeling, traits, impl organization, macros, and build-speed best practices.
Stay ahead of the MCP ecosystem
Get weekly updates on new skills and servers.