Agent Skills › NicholasFlemmer/styx-app › db-migration

db-migration

GitHub

管理主进程 SQLite 数据库的 Drizzle 架构变更工作流，涵盖编辑 Schema、生成迁移文件、手动添加约束与触发器、更新种子数据及测试前向/回滚迁移。

.claude/skills/db-migration/SKILL.md NicholasFlemmer/styx-app

Trigger Scenarios

需要修改数据库表结构执行数据库迁移脚本验证数据迁移兼容性

Install

npx skills add NicholasFlemmer/styx-app --skill db-migration -g -y

More Options

Non-standard path

npx skills add https://github.com/NicholasFlemmer/styx-app/tree/main/.claude/skills/db-migration -g -y

Use without installing

npx skills use NicholasFlemmer/styx-app@db-migration

指定 Agent (Claude Code)

npx skills add NicholasFlemmer/styx-app --skill db-migration -a claude-code -g -y

安装 repo 全部 skill

npx skills add NicholasFlemmer/styx-app --all -g -y

预览 repo 内 skill

npx skills add NicholasFlemmer/styx-app --list

SKILL.md

Frontmatter

{
    "name": "db-migration",
    "description": "Drizzle schema change workflow for the main-process SQLite - edit schema, generate migration, hand-add CHECK\/triggers, update seed\/fixtures, test forward + rollback, keep audit table append-only.",
    "allowed-tools": "Read, Edit, Write, Bash(pnpm:*), Bash(sqlite3:*)",
    "argument-hint": "<change summary>"
}

DB migration: $ARGUMENTS

Edit apps/desktop/src/main/db/schema.ts.
pnpm db:generate → review SQL in apps/desktop/src/main/db/migrations/; add CHECK constraints and triggers by hand (drizzle-kit does not emit them for SQLite).
audit_entries: additive changes only; the RAISE(ABORT) triggers stay.
Update zod row schemas / mappers in core, packages/core/src/fixtures/demo.ts, and scripts/seed.ts.
Test: migrate a fresh DB; migrate a DB seeded at the previous version; verify data. Reversible changes get a down migration + test.
Column-name review: any token|secret|password|key column that could hold a secret is rejected (only credential_ref).
pnpm test -F @styx/desktop.