DA
database-migration
Use when changing review re-RAG schema, repositories, migrations, or PostgreSQL integration behavior.
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.101 chars✓ has a “when” trigger
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.