Skills migration-generator
📦

migration-generator

Content revision r1 Safe ⚙️ External commands

產生安全的資料庫遷移

當遷移不完整或不可逆時，資料庫變更可能會破壞生產環境資料。此技能會為常見 SQL 和 ORM 技術堆疊草擬遷移步驟、回滾方案與審查清單。

Supports: Claude Codex Code(CC)
Maintain this Skill? Claim it 🥉 77 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "migration-generator" from https://skillstore.io/skills/curiouslearner-migration-generator.md and its manifest at https://skillstore.io/api/skills/curiouslearner-migration-generator/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/curiouslearner-migration-generator.md Signed manifest GET /api/skills/curiouslearner-migration-generator/manifest Signed lockfile GET /api/skills/curiouslearner-migration-generator/lockfile

Test it

Using "migration-generator". 為 users 新增電子郵件驗證。

Expected outcome:

  • 以分階段方式新增 email_verified 欄位。
  • 在要求值之前先回填既有資料列。
  • 為未來資料列套用預設值。
  • 包含移除該欄位的回滾備註。

Using "migration-generator". 建立與 users 連結的 user profiles。

Expected outcome:

  • 建立與 users 連結的 user profiles。
  • 回填既有資料列，再要求必填值。
  • 為未來資料列套用預設值。
  • 包含移除該欄位的回滾備註。

Security Audit

Safe
v9 • 7/5/2026 Open versioned report

All 84 static findings were adjudicated as false positives. The external-command hits are Markdown fences, inline SQL, or documented ORM CLI examples; the sensitive and reconnaissance hits are migration-domain text, SQL identifiers, Django imports, and checklist items. No prompt injection, data exfiltration, unauthorized network access, or executable helper script was found in SKILL.md or output.json.

2
Files scanned
1,037
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (62)
SKILL.md:49-55 SKILL.md:55-60 SKILL.md:60-83 SKILL.md:83-86 SKILL.md:86-102 SKILL.md:102-105 SKILL.md:105-113 SKILL.md:113-116 SKILL.md:116-142 SKILL.md:142-145 SKILL.md:145-169 SKILL.md:169-174 SKILL.md:174-204 SKILL.md:204-206 SKILL.md:206-215 SKILL.md:215-218 SKILL.md:218-235 SKILL.md:235-238 SKILL.md:238-320 SKILL.md:320-322 SKILL.md:322-389 SKILL.md:389-391 SKILL.md:391-400 SKILL.md:400-403 SKILL.md:403-450 SKILL.md:450-452 SKILL.md:452-481 SKILL.md:481-483 SKILL.md:483-495 SKILL.md:495-498 SKILL.md:498-531 SKILL.md:531-533 SKILL.md:533-561 SKILL.md:561-563 SKILL.md:563-575 SKILL.md:575-580 SKILL.md:580-598 SKILL.md:598-601 SKILL.md:601-632 SKILL.md:632-640 SKILL.md:640-643 SKILL.md:643-690 SKILL.md:690-695 SKILL.md:695-707 SKILL.md:707-710 SKILL.md:710-726 SKILL.md:726-729 SKILL.md:729-739 SKILL.md:739-744 SKILL.md:744-754 SKILL.md:754-757 SKILL.md:757-764 SKILL.md:764-767 SKILL.md:767-783 SKILL.md:783-788 SKILL.md:788-793 SKILL.md:793-810 SKILL.md:810-832 SKILL.md:832-837 SKILL.md:837-848 SKILL.md:848-851 SKILL.md:851-878
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/curiouslearner-migration-generator/audits/9?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/curiouslearner-migration-generator/security.svg)](https://skillstore.io/skills/curiouslearner-migration-generator?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/curiouslearner-migration-generator?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/curiouslearner-migration-generator/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/curiouslearner-migration-generator.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

CuriousLearner. (2026). migration-generator security audit report (audit version 9) [Author version unspecified]. Skillstore. https://skillstore.io/skills/curiouslearner-migration-generator/audits/9

BibTeX citation

@techreport{curiouslearner-curiouslearner-migration-generator-2026, author = {CuriousLearner}, title = {migration-generator security audit report (audit version 9)}, institution = {Skillstore}, year = {2026}, number = {9}, url = {https://skillstore.io/skills/curiouslearner-migration-generator/audits/9}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "migration-generator security audit report (audit version 9)" version: "unspecified" type: report authors: - name: "CuriousLearner" date-released: "2026-07-05" url: "https://skillstore.io/skills/curiouslearner-migration-generator/audits/9" identifiers: - type: other value: "skillstore:curiouslearner-migration-generator:audit:9" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
70
Community
74
Spec Compliance

What You Can Build

新增應用程式功能

在新增產品功能之前，規劃新的資料表、欄位、索引和回滾步驟。

審查高風險 Schema 變更

檢查破壞性變更的可逆性、鎖定風險、預備環境測試和備份需求。

協調發布遷移

建立分階段遷移計畫，使資料庫變更與應用程式部署一致。

Try These Prompts

產生基本遷移 
Use migration-generator to add a nullable phone column to users. Include forward steps, rollback steps, and review notes.
建立 ORM 遷移 
Use migration-generator for a Prisma migration that adds user_profiles linked to users. Include constraints, indexes, and rollback guidance.
規劃零停機變更 
Use migration-generator to rename users.email to users.email_address with zero downtime. Include deployment phases and validation checks.
設計大型資料遷移 
Use migration-generator to convert product prices from decimal dollars to integer cents in PostgreSQL. Include batching, validation, rollback limits, and monitoring.

Best Practices

  • Provide current schema, desired schema, database engine, ORM, and production constraints.
  • Ask for rollback steps and data validation checks before applying any generated migration.
  • Test generated migrations on a copied database or staging environment before production.

Avoid

  • 不要在未經審查的情況下，直接對生產環境執行產生的遷移。
  • 不要將無關的 schema 變更合併到同一個大型遷移中。
  • 不要對破壞性變更略過備份、鎖定分析或回滾規劃。

Frequently Asked Questions

它會幫我執行遷移嗎？
不會。它會草擬遷移程式碼和步驟。你決定何時以及在哪裡執行它們。
它可以協助哪些框架？
它涵蓋 raw SQL、Prisma、TypeORM、Sequelize、Knex.js、Alembic、Django、Rails、Go tools、Laravel 和 Doctrine。
它可以建立零停機計畫嗎？
可以。當你提供部署限制時，它會建議分階段新增、回填、雙寫和延後刪除。
它可以安全地遷移生產環境資料嗎？
它可以提出更安全的模式，但生產環境資料變更仍需要備份、測試、監控和核准。
我應該提供哪些輸入？
請提供目前 schema、期望變更、資料庫引擎、ORM、資料表大小、限制條件和回滾需求。
它支援 Claude、Codex 和 Claude Code 嗎？
可以。技能中繼資料宣告支援 Claude、Codex 和 Claude Code。

Developer Details

License

MIT

Skillstore revision

r1

Version notice

The author did not declare a version.

Repository

https://github.com/CuriousLearner/devkit/tree/main/skills/migration-generator

Ref

02f077c174c5335e2f5d02ca15e77b70d9543e58

Maintenance freshness

7/20/2026

Usage

6 downloads · 195 views

File structure

📄 output.json

📄 SKILL.md

More from CuriousLearner

View all

Related Skills

View all