# Hr Data Custody

> HR ERP database migrations and packaging: Prisma/SQL surfaces, expand-migrate-contract, RLS-safe seeds, db:verify, distroless/GHCR supply chain. Use for DDL, backfills, dual-write cutovers, Dockerfile, or publish-ghcr workflows.

- Skill: `safetymp/hr-data-custody` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add safetymp/hr-data-custody`
- Raw SKILL.md: https://api.skillmd.com/api/skills/safetymp/hr-data-custody/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: SafetyMP (https://skillmd.com/u/safetymp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/safetymp/hr-data-custody

---


# HR data custody

**Collaboration plane:** Specialized skill — invoke only after phase 6 / `revalidationConfirmed`. Record DDL tradeoffs in [collaboration-plan.md](../../../specs/templates/collaboration-plan.md).

## Use this skill when

- Editing `prisma/schema.prisma`, `prisma/migrations/**`, `services/*/db/migrations/**`
- Backfills, RLS migrations, or `scripts/db-verify-migration.ts`
- Dockerfile, GHCR publish, SBOM/Cosign (ADR 0003)

## Do not use this skill when

- Read-only schema questions with no migration intent
- Application code with no DDL/infra change

## Instructions

1. Read [references/migration-runbook.md](references/migration-runbook.md).
2. Apply expand → migrate → contract; CONCURRENTLY discipline for indexes.
3. Run `npm run db:verify` after migrate deploy in CI/local evidence.
4. Co-load `@hr-domain-boundaries` when bounded-context SQL changes.

## Resources

- [references/migration-runbook.md](references/migration-runbook.md)
- [specs/alignment/decisions/0003-container-supply-chain.md](../../../specs/alignment/decisions/0003-container-supply-chain.md)

## Limitations

- Zero-downtime posture required for production paths