数据库 Schema Migra

数据社区

作者仓库星标 0
作者仓库 skills-registry

解读按原文结构重写，命令、链接、术语均保留；右侧可核对作者原始 SKILL.md

原文结构

Key Responsibilities：Design and version schema changes. Write migration scripts. Ensure database compatibility.
Migration Pattern：原文以此为独立章节。
Naming Convention：Migration files: YYYYMMDDdescription.sql Tables: snakecase, plural (e.g., resources, permissions) Columns: snakecase (e.g., resourceid, createdat)

适用与边界

当前原文没有单列适用场景。
当前原文没有单列不适用场景或限制。

原文中的明确线索

要点：「Manage schema design, migrations, and database operations.」
文件与命令：YYYYMMDDdescription.sql、resources、permissions、resourceid、createdat、IF NOT EXISTS、references/migration-patterns.md、references/rollback-strategies.md

流狐整理：以上内容来自当前 SKILL.md 的章节与原词；未补写作者没有声明的工具、兼容性或能力。

Database Schema Migrations

Manage schema design, migrations, and database operations.

Key Responsibilities

Design and version schema changes.
Write migration scripts.
Ensure database compatibility.
Provide rollback-safe migration steps.

Migration Pattern

-- Good: Idempotent migration
CREATE TABLE IF NOT EXISTS resources (
  id TEXT PRIMARY KEY,
  title TEXT NOT NULL,
  owner_id TEXT NOT NULL,
  created_at INTEGER DEFAULT (unixepoch())
);

-- Good: Safe index addition
CREATE INDEX IF NOT EXISTS idx_resources_owner ON resources(owner_id);

Naming Convention

Migration files: YYYYMMDD_description.sql
Tables: snake_case, plural (e.g., resources, permissions)
Columns: snake_case (e.g., resource_id, created_at)

Constraints

Migrations must be idempotent and reversible.
Indexes must be added in a way that doesn't break existing queries.
Use timestamp-prefixed filenames.
Always provide rollback scripts.

Checklist

Migration is idempotent (can run multiple times safely).
Rollback migration tested.
Indexes use IF NOT EXISTS.
Foreign keys defined where applicable.
Migration logged in migration history table.

References

references/migration-patterns.md - Common migration patterns by database type
references/rollback-strategies.md - Safe rollback strategies

Source: d-o-hub/github-template-ai-agents — distributed by TomeVault.

流狐档案作者与许可取自来源；运行、权限和网络为流狐检测或估算

流狐分类: 数据
作者声明 Agent: 未找到明确声明；不据此推断已兼容或已测试
静态检查: 88 / 100 · 启发式扫描，不代表运行安全
作者 / 版本 / 许可: @tomevault-io · 未声明 license
流狐 Token 估算: 低消耗
流狐接入估算: 即装即用
是否需要外部 API Key: 未发现要求
检测到的系统要求: 未声明
底层运行要求: 未声明
检测到的文件与系统行为: 只读
允许写入 / 修改
检测到的网络行为: 仅限本地
安装命令数: 无（仅作为资料）

档案由构建时根据 SKILL.md 与安装命令自动衍生，可能与作者实际意图存在差异。

需要注意： 未限定 allowed-tools，默认拥有全部工具权限。

输出预览 database-schema-migrations.preview

作者没有在当前 SKILL.md 中定义固定输出样例。

SKILL.md SKILL.md

# Database Schema Migrations

Manage schema design, migrations, and database operations.

## Key Responsibilities
- Design and version schema changes.
- Write migration scripts.
- Ensure database compatibility.
- Provide rollback-safe migration steps.

## Migration Pattern

```sql
-- Good: Idempotent migration
CREATE TABLE IF NOT EXISTS resources (
  id TEXT PRIMARY KEY,
  title TEXT NOT NULL,
  owner_id TEXT NOT NULL,
  created_at INTEGER DEFAULT (unixepoch())
);

-- Good: Safe index addition
CREATE INDEX IF NOT EXISTS idx_resources_owner ON resources(owner_id);
```

## Naming Convention
- Migration files: `YYYYMMDD_description.sql`
- Tables: snake_case, plural (e.g., `resources`, `permissions`)
- Columns: snake_case (e.g., `resource_id`, `created_at`)

## Constraints
- Migrations must be idempotent and reversible.
- Indexes must be added in a way that doesn't break existing queries.
- Use timestamp-prefixed filenames.
- Always provide rollback scripts.

## Checklist
- [ ] Migration is idempotent (can run multiple times safely).
- [ ] Rollback migration tested.
- [ ] Indexes use `IF NOT EXISTS`.
- [ ] Foreign keys defined where applicable.
- [ ] Migration logged in migration history table.

## References
- `references/migration-patterns.md` - Common migration patterns by database type
- `references/rollback-strategies.md` - Safe rollback strategies

---
> Source: [d-o-hub/github-template-ai-agents](https://github.com/d-o-hub/github-template-ai-agents) — distributed by [TomeVault](https://tomevault.io).
<!-- tomevault:4.0:skill_md:2026-05-22 -->

证据边界与执行链路

作者原文负责流程事实；流狐只索引当前章节、要点、文件与命令。

章节    -> Key Responsibilities → Migration Pattern → Naming Convention → Constraints → Checklist → References
要点    -> Manage schema design, migrations, and database operations.
文件/命令 -> YYYYMMDDdescription.sql · resources · permissions · resourceid · createdat · IF NOT EXISTS · references/migration-patterns.md · references/rollback-strategies.md
内容 SHA-256 -> 06d19f972789