database-migrations
Outlines patterns for executing database schema and data migrations while maintaining zero downtime and rollback safety.
Install
mkdir -p .claude/skills/database-migrations && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/2812" && unzip -o skill.zip -d .claude/skills/database-migrations && rm skill.zipInstalls to .claude/skills/database-migrations
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.Key capabilities
- →Execute backward-compatible schema changes
- →Perform zero-downtime data migrations
- →Implement rollback procedures
- →Batch large data transformations
How it works
It uses a migration runner to apply SQL changes atomically within transactions while ensuring backward compatibility with existing code.
Inputs & outputs
When to use database-migrations
- →Plan a zero-downtime schema change
- →Execute backward-compatible migrations
- →Design database rollback procedures
- →Refactor existing table structures
About database-migrations
Provides best practices and patterns for database migrations, ensuring zero downtime. Covers safe handling of schema updates, data migrations, and rollback safety.
Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.
When not to use it
- →Non-database schema changes
- →Environments where downtime is acceptable and simplicity is preferred
Prerequisites
Limitations
- →Requires careful planning for complex renames
- →Large data migrations must be batched to avoid performance issues
How it compares
It enforces a strict zero-downtime strategy with mandatory rollback scripts instead of simple, destructive schema updates.
Compared to similar skills
database-migrations side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| database-migrations (this skill) | 3 | 6mo | No flags | Advanced |
| drizzle-orm | 32 | 2mo | No flags | Intermediate |
| database-design | 6 | 6mo | Review | Intermediate |
| prisma-expert | 12 | 6mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by dadbodgeoff
View all by dadbodgeoff →You might also like
drizzle-orm
EpicenterHQ
Drizzle ORM patterns for type branding and custom types. Use when working with Drizzle column definitions, branded types, or custom type conversions.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
prisma-expert
davila7
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
database-migration
wshobson
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
database-migrations-sql-migrations
sickn33
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server