Name: database-migration
Author: xiangteng007

Imported from xiangteng007/light-keepers (.agent/skills/database-migration/SKILL.md). Install upstream with npx skills add xiangteng007/light-keepers --skill database-migration. Copyright stays with the author.

Database Migration Skill

管理 TypeORM 資料庫遷移。

創建遷移

自動生成（從 Entity 變更）

cd backend
npm run migration:generate -- src/migrations/DescriptiveName

手動創建空白遷移

cd backend
npm run migration:create -- src/migrations/DescriptiveName

執行遷移

運行所有待執行遷移

npm run migration:run

回滾上一次遷移

npm run migration:revert

查看遷移狀態

npm run migration:show

遷移檔案結構

import { MigrationInterface, QueryRunner } from 'typeorm';

export class DescriptiveName1234567890 implements MigrationInterface {
    name = 'DescriptiveName1234567890';

    public async up(queryRunner: QueryRunner): Promise<void> {
        // 升級操作
        await queryRunner.query(`ALTER TABLE ...`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        // 回滾操作
        await queryRunner.query(`ALTER TABLE ...`);
    }
}

最佳實踐

命名規範: 使用描述性名稱，如 AddUserEmailIndex
原子性: 每個遷移只做一件事
可回滾: 確保 down() 方法正確實作
測試: 在開發環境先測試遷移
備份: 生產環境執行前先備份資料庫

Install database-migration and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

{ "ocm": "1", "id": "xiangteng007-light-keepers-database-migration", "kind": "skill", "name": "database-migration", "description": "創建和執行 TypeORM 資料庫遷移，管理 schema 變更", "publisher": "xiangteng007", "version": "1.0.0", "capabilities": { "domains": [ "general" ], "tags": [ "skill-md", "github" ], "languages": [ "en" ] }, "quality_prior": 0.6, "examples": [ "創建和執行 TypeORM 資料庫遷移，管理 schema 變更" ], "primary": false, "metadata": { "source": { "provider": "github", "repository": "https://github.com/xiangteng007/light-keepers", "path": ".agent/skills/database-migration/SKILL.md", "ref": "af2c288c137cc497f9e1c7d4b05d7a5df00654ae", "url": "https://github.com/xiangteng007/light-keepers/blob/af2c288c137cc497f9e1c7d4b05d7a5df00654ae/.agent/skills/database-migration/SKILL.md", "key": "xiangteng007/light-keepers/.agent/skills/database-migration/SKILL.md" } }, "instructions": "# Database Migration Skill\n\n管理 TypeORM 資料庫遷移。\n\n## 創建遷移\n\n### 自動生成（從 Entity 變更）\n\n```bash\ncd backend\nnpm run migration:generate -- src/migrations/DescriptiveName\n```\n\n### 手動創建空白遷移\n\n```bash\ncd backend\nnpm run migration:create -- src/migrations/DescriptiveName\n```\n\n## 執行遷移\n\n### 運行所有待執行遷移\n\n```bash\nnpm run migration:run\n```\n\n### 回滾上一次遷移\n\n```bash\nnpm run migration:revert\n```\n\n### 查看遷移狀態\n\n```bash\nnpm run migration:show\n```\n\n## 遷移檔案結構\n\n```typescript\nimport { MigrationInterface, QueryRunner } from 'typeorm';\n\nexport class DescriptiveName1234567890 implements MigrationInterface {\n name = 'DescriptiveNa", "cost": { "context_tokens": 262 } }

database-migration

About