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 仓库查看创作者相关仓库

下载

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