Menü
Guides database schema changes across SQLite and PostgreSQL, including seed updates and schema push.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Implement a backlog story following the layer order (Domain, Database, API, Frontend, E2E) with TDD.
Review the backlog to determine what to work on next by checking epic and story statuses in docs/backlog/.
Automates pre-commit workflow: lint, test, review changes, then commit with conventional commit format.
Verify a story is complete by checking acceptance criteria, running all tests, and updating status.
Add end-to-end Playwright tests for a feature using data-testid selectors, with API and UI test patterns.
Add unit tests for domain logic, database adapters, API endpoints, or frontend components using Vitest patterns.
| name | add-migration |
| description | Guides database schema changes across SQLite and PostgreSQL, including seed updates and schema push. |
| disable-model-invocation | true |
packages/database/src/schema.sqlite.tspackages/database/src/schema.postgres.tspackages/database/src/seed.tse2e/seed.tspnpm --filter @acme/database db:pushpnpm --filter @acme/database db:seedsnake_case (e.g., user_id, created_at)text('id').primaryKey() with UUIDinteger('created_at', { mode: 'timestamp_ms' }).notNull() (SQLite)integer('is_active', { mode: 'boolean' }) (SQLite).references(() => parentTable.id, { onDelete: 'cascade' })// schema.sqlite.ts
export const notes = sqliteTable('notes', {
// ... existing columns
tags: text('tags'), // JSON string of tag names
});
// schema.postgres.ts
export const notes = pgTable('notes', {
// ... existing columns
tags: text('tags'),
});