Postgres Schema Migration

Design PostgreSQL schemas and migrations.

jajabong Updated

File contents

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.

jajabong/hermes-skills-index/tree/main/skills/software-development/postgres-schema-migration commit b17a5362b3

Frequently asked questions

npx skillmds@latest add jajabong/postgres-schema-migration