database-migration
Protocols for managing database schema migrations safely.
Install
mkdir -p .claude/skills/database-migration-dokhacgiakhoa && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/14211" && unzip -o skill.zip -d .claude/skills/database-migration-dokhacgiakhoa && rm skill.zipInstalls to .claude/skills/database-migration-dokhacgiakhoa
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.
MASTER DB: Zero-Downtime, Schema Design (3NF), SQL/NoSQL.Key capabilities
- →Simulate database migrations with a dry run
- →Design zero-downtime transition strategies
- →Execute migrations while monitoring database health
- →Architect database schemas using 3NF principles
How it works
The skill executes a dry run of the migration, plans a zero-downtime strategy, and then runs the migration while observing database health.
Inputs & outputs
When to use database-migration
- →Performing zero-downtime migrations
- →Simulating schema changes
- →Designing 3NF schemas
- →Observing DB health during updates
About this skill
🗄️ Database Migration Master Skill
You are a Senior Database Administrator and Schema Architect. You ensure data integrity, performance, and availability across complex database migrations and architectural changes.
🛠️ Execution Protocol
- Dry Run: Always simulate the migration before execution.
node .agent/skills/database-migration/scripts/migration_dry_run.js migrations/latest.sql - Plan Zero-Downtime: Design the transition strategy.
- Execute & Observe: Run migration and monitor DB health.
Merged and optimized from 3 legacy database migration skills.
When not to use it
- →When data integrity and availability are not critical concerns
- →When simple schema changes do not require a dry run or monitoring
- →When the database is not complex or does not require 3NF schema design
Limitations
- →The skill requires a dry run before actual execution
- →The skill focuses on zero-downtime strategies, which may add complexity
- →The skill requires monitoring database health during execution
How it compares
This skill mandates a dry run and active monitoring during migration, ensuring data integrity and performance, unlike direct execution that risks downtime or data corruption.
Compared to similar skills
database-migration side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| database-migration (this skill) | 0 | 2mo | Review | Advanced |
| drizzle-orm | 32 | 2mo | No flags | Intermediate |
| database-design | 6 | 6mo | Review | Intermediate |
| database-schema-designer | 6 | 6mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by Dokhacgiakhoa
View all by Dokhacgiakhoa →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.
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-migrations-sql-migrations
sickn33
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
postgresql-syntax-reference
pgschema
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
databases
mrgoonie
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.