database-migration
Guides idempotent database migrations and schema evolution.
Install
mkdir -p .claude/skills/database-migration-berntpopp && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/13266" && unzip -o skill.zip -d .claude/skills/database-migration-berntpopp && rm skill.zipInstalls to .claude/skills/database-migration-berntpopp
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.
Use when changing review re-RAG schema, repositories, migrations, or PostgreSQL integration behavior.Key capabilities
- →Inspect existing database schemas and migrations
- →Make database migrations idempotent
- →Keep bootstrap schema and migrations consistent
- →Add or update unit tests for schema and mappers
- →Add PostgreSQL integration coverage
- →Run focused database tests
How it works
The skill guides the user through inspecting existing database components, ensuring migrations are idempotent and consistent, and adding tests for schema, mappers, and PostgreSQL integration.
Inputs & outputs
When to use database-migration
- →Applying schema changes
- →Writing database migrations
- →Integrating postgresql
About this skill
Database Migration
Follow AGENTS.md first.
Workflow
- Inspect
pubtator_link/db/review_schema.sql, existing migrations, and repository tests before editing schema code. - Make migrations idempotent and keep bootstrap schema and migrations consistent.
- Keep SQL mapping logic in repository/mappers, not API or MCP layers.
- Add or update unit tests for schema text, migration ordering, mapper behavior, and repository edge cases.
- Add PostgreSQL integration coverage when the behavior depends on database semantics that unit tests cannot prove.
- Run focused database tests, then
make ci-localbefore handoff.
How it compares
This skill provides a specific workflow for database migrations, ensuring idempotency and consistency, unlike manual schema changes.
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 | 3mo | No flags | Intermediate |
| 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.
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