drizzle-migrations

スター14

フォーク0

更新日2026年3月15日 05:13

Enforces correct Drizzle migration workflow. Use when adding/changing tables, columns, indexes, or any schema changes. NEVER manually create migration SQL — always run pnpm run db:generate.

インストール

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

ソース

ctxpipe-ai

ctxpipe-ai/ctxpipe

GitHub リポジトリを開く Creator のリポジトリを見る

ダウンロード

Drizzle Migrations

BLOCKER: Never Manually Create Migration SQL

Do NOT write or create migration.sql files yourself. Drizzle Kit generates them from schema diffs. Manual SQL will:

Break snapshot consistency
Cause migration conflicts
Omit metadata drizzle-kit expects

Correct Workflow

Edit schema files in apps/backend/src/db/schema/
Run: pnpm run db:generate from apps/backend (or pnpm --filter @ctxpipe/backend db:generate from repo root)
Review the generated migration in apps/backend/migrations/
If generation fails, fix the schema — do not fall back to manual SQL

Command Reference

Action	Command	CWD
Generate migration	`pnpm run db:generate`	apps/backend
Apply migrations	`pnpm run db:migrate`	apps/backend
Studio	`pnpm run db:studio`	apps/backend

Schema Locations

Main schema index: apps/backend/src/db/schema/index.ts
Table definitions: apps/backend/src/db/schema/*.ts
Drizzle config: apps/backend/drizzle.config.ts

このリポジトリの他の Skills

同じリポジトリ

storybook

ctxpipe-ai/ctxpipe

Work with Storybook in apps/ui (colocated stories, MSW, TanStack Start, Storybook MCP). Use when writing or updating stories, using the ctxpipe-storybook MCP, previewing components in Storybook, or when adding new UI components or pages in apps/ui.

2026-05-1114

react

ctxpipe-ai/ctxpipe

React UI patterns for apps/ui—Effects vs rendering, TanStack Query for all server data, useMemo, keys, event handlers. Start here when creating or editing React components.

2026-05-0314

memory-init

ctxpipe-ai/ctxpipe

Initialize the ConKeeper memory system for the current project. Creates the directory structure and starter files for persistent AI context.

2026-03-2214

memory-insights

ctxpipe-ai/ctxpipe

Track recurring session friction and success patterns across memory (sessions/, patterns). Use periodically or when improving agent instructions—not every turn.

2026-03-2214

memory-reflect

ctxpipe-ai/ctxpipe

Lightweight session retrospective: summarize what worked, what confused the agent, and propose a sessions/ note or pattern bullet. Use after substantial tasks or before handoff.

2026-03-2214

memory-search

ctxpipe-ai/ctxpipe

Search .ai/memory for keywords, topics, or ADR numbers before loading large files. Use when you need relevant memory without reading patterns.md or all ADRs whole.

2026-03-2214

name	drizzle-migrations
description	Enforces correct Drizzle migration workflow. Use when adding/changing tables, columns, indexes, or any schema changes. NEVER manually create migration SQL — always run pnpm run db:generate.

Drizzle Migrations

BLOCKER: Never Manually Create Migration SQL

Do NOT write or create migration.sql files yourself. Drizzle Kit generates them from schema diffs. Manual SQL will:

Break snapshot consistency
Cause migration conflicts
Omit metadata drizzle-kit expects

Correct Workflow

Edit schema files in apps/backend/src/db/schema/
Run: pnpm run db:generate from apps/backend (or pnpm --filter @ctxpipe/backend db:generate from repo root)
Review the generated migration in apps/backend/migrations/
If generation fails, fix the schema — do not fall back to manual SQL

Command Reference

Action	Command	CWD
Generate migration	`pnpm run db:generate`	apps/backend
Apply migrations	`pnpm run db:migrate`	apps/backend
Studio	`pnpm run db:studio`	apps/backend

Schema Locations

Main schema index: apps/backend/src/db/schema/index.ts
Table definitions: apps/backend/src/db/schema/*.ts
Drizzle config: apps/backend/drizzle.config.ts