database-migration

name	database-migration
description	Use when changing review re-RAG schema, repositories, migrations, or PostgreSQL integration behavior.

Database Migration

Follow AGENTS.md first.

Workflow

1. Inspect pubtator_link/db/review_schema.sql, existing migrations, and repository tests before editing schema code.
2. Make migrations idempotent and keep bootstrap schema and migrations consistent.
3. Keep SQL mapping logic in repository/mappers, not API or MCP layers.
4. Add or update unit tests for schema text, migration ordering, mapper behavior, and repository edge cases.
5. Add PostgreSQL integration coverage when the behavior depends on database semantics that unit tests cannot prove.
6. Run focused database tests, then make ci-local before handoff.