Agent Skills › NangoHQ/nango › creating-database-migrations

creating-database-migrations

GitHub

指导创建数据库迁移文件，包括定位目录、命名规范、风格对齐及外键策略。

.agents/skills/creating-database-migrations/SKILL.md NangoHQ/nango

Trigger Scenarios

需要创建新的数据库迁移文件编辑现有的数据库迁移

Install

npx skills add NangoHQ/nango --skill creating-database-migrations -g -y

More Options

Non-standard path

npx skills add https://github.com/NangoHQ/nango/tree/master/.agents/skills/creating-database-migrations -g -y

Use without installing

npx skills use NangoHQ/nango@creating-database-migrations

指定 Agent (Claude Code)

npx skills add NangoHQ/nango --skill creating-database-migrations -a claude-code -g -y

安装 repo 全部 skill

npx skills add NangoHQ/nango --all -g -y

预览 repo 内 skill

npx skills add NangoHQ/nango --list

SKILL.md

Frontmatter

{
    "name": "creating-database-migrations",
    "description": "Use when adding or editing Nango database migrations - covers migration directory selection, timestamped .cjs naming, matching recent migration style, down migration decisions, and foreign key ON DELETE conventions."
}

Creating Database Migrations

Workflow

Identify the right migration directory.
- Main database migrations live in packages/database/lib/migrations/.
- Other services may have their own migration directories; use the directory for the service being changed.
Before writing a migration, read 2-3 recent migrations in the same directory and follow their style.
Name new main database migrations with the timestamped CommonJS format:
```
<YYYYMMDDHHMMSS>_<description>.cjs
```
Example:
```
20260420120000_create_customer_keys.cjs
```
Decide exports.down explicitly.
- Ask the user whether rollback logic should be included or exports.down should be left empty.
- If the user already specified rollback behavior, follow that direction.
Choose foreign key delete behavior from the relationship:
- Use ON DELETE CASCADE for ownership relationships where the child cannot exist without the parent.
- Use ON DELETE SET NULL for optional references where the child should survive parent deletion.
- Check existing migrations for the closest matching relationship before choosing.

Review Checklist

Migration is in the correct service migration directory.
Filename uses the timestamped .cjs migration format.
Style matches recent migrations in the same directory.
exports.down behavior was confirmed or explicitly requested.
Foreign keys use CASCADE for ownership and SET NULL for optional references.