Automate Goose SQL migration lifecycle for the Hominem monorepo.
npx skills add https://github.com/hackefeller/hominem --skill goose-migrations
Please help me install this Agent Skill. Skill: goose-migrations Source: https://github.com/hackefeller/hominem/tree/main/.codex/skills/goose-migrations Command: npx skills add https://github.com/hackefeller/hominem --skill goose-migrations
Hominem Goose migrations require careful lifecycle management to avoid drift in database schemas, ensure safe application of changes, and maintain reproducibility across environments.
Scaffold a new migration with make db-new-migration NAME=descriptive_change and apply it with make db-migrate-sync
High-intent search queries and answers about installing and using this skill.
To create a SQL database migration, scaffold a new file using the standard naming convention with make db-new-migration NAME=descriptive_change. This generates a migration file for authoring Up and Down blocks.
Applying SQL schema changes safely requires coordinating the Goose migration lifecycle to avoid schema drift. Use make db-migrate-sync to apply changes and maintain reproducibility across environments.
A Goose migration validates database schema types by running the make db-verify-types workflow. This synchronization step ensures type safety and checks for drift after schema changes.
Yes, you can automate database rollback workflows by authoring and validating Down blocks within your migration files. This ensures safe reversal of schema changes during development cycles.
Database schemas drift during manual SQL migrations due to uncoordinated application of changes across environments. Automating the migration lifecycle with standardized workflows prevents this drift and maintains consistency.
FindMalekConfigure Prisma for multiple database providers and set up the client.
alinaqiEnforce database schema adherence during AI-driven code generation.
imkdwAutomate Prisma migrations for PostgreSQL schema changes.
y1feng200156Manage database schema migrations with Flyway and Atlas.
