Skip to content

ai-unified-process/aiup-drizzle

v3.1.1

AI Unified Process migration and persistence layers - Drizzle ORM schema, generated PostgreSQL migrations, repositories, and their tests

drizzle-schema

Builds the migration layer of a use case (UC-XXX) with Drizzle over PostgreSQL: edits the pg-core schema file that drizzle.config.ts names and generates the SQL migration with drizzle-kit, never by hand: a complete table, with every attribute and constraint of the entity model, for each entity the use case needs that has no table yet, and a change only where an existing table lags behind the entity model. Marks a CHECK or unique index that enforces a business rule with // UC-XXX BR-YYY in the schema file. Normally run by /use-case-implement as the first layer; can be run directly, with a use case or for the whole entity model. Use when the user asks to "create a migration", "generate SQL", "update the schema", "add a column", "create the tables for UC-001", or mentions Drizzle, drizzle-kit, pg-core, schema.ts, or database versioning in a project that combines layer plugins. Test data belongs to the test skills.

Read SKILL.md at the source

Pinned to revision 648476b42261, so it is the text this page describes rather than whatever the author pushed since.

Files

Every link opens the file at its source, pinned to the revision this page describes.