# Postgres Schema Migration

> Design PostgreSQL schemas and migrations.

- Skill: `jajabong/postgres-schema-migration` (Agent Skill)
- Install (CLI): `npx skillmds@latest add jajabong/postgres-schema-migration`
- Raw SKILL.md: https://api.skillmd.com/api/skills/jajabong/postgres-schema-migration/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: jajabong (https://skillmd.com/u/jajabong)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/jajabong/postgres-schema-migration

---


See `/Users/henry/hermes-wiki/concepts/postgres-schema-migration.md` for full content.

## Trigger

Queen is designing a PG schema, picking a migration tool (golang-migrate / goose / Atlas), or writing a zero-downtime migration.

See `/Users/henry/hermes-wiki/concepts/postgres-schema-migration.md` for the full wiki concept.

## Full description

Design PostgreSQL schemas, write zero-downtime migrations, choose migration tools (golang-migrate/goose/Atlas), or tune indexes/queries/PgBouncer.

## Pointer

Wiki: `/Users/henry/hermes-wiki/concepts/postgres-schema-migration.md`
Sourced from: golang-migrate/migrate; pressly/goose; ariga/atlas

## Promotion criteria

Per skill-write-policy: this stub stays until the same workflow succeeds in 2+ real tasks. Then expand stub to full SKILL.md with numbered steps, copy-paste commands, and verification.