pdlc-db-migrate SKILL.md skillA

pdlc-db-migrate from kanfu-panda/pdlc-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add kanfu-panda/pdlc-skills/pdlc-db-migrate@git:20261012.035af0d

Pins git:20261012.035af0d in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
kanfu-panda/pdlc-skills
Path
skills/pdlc-db-migrate/SKILL.md
Versions recorded
7
Latest version
git:20261012.035af0d, committed Oct 12, 2026
First version recorded
May 7, 2026
Size
12,868 bytes
Repository stars
18
License
MIT

按数据库设计生成与管理迁移脚本(先沿用项目已有的迁移工具),不直接连库执行 SQL.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# 数据库迁移管理

<!-- @include templates/prompts/iron-law-tool.md(已内联于下方,无需另读) -->
⛔ **IRON LAW · 不可违反的硬门禁(工具型命令)**

本命令不是主链路上的阶段:**不追加 `history`,不改 `current_stage` / `next_step` / `last_phase_result`**,也不为此分配功能ID。以下规则不可协商:

1. **文件必须落盘**:正文要求创建的文件必须作为实际文件写入磁盘,不可仅在对话中输出(只要求在对话里输出的,照正文办)。
2. **自检必须执行**:产出后按本命令的自检项逐项核对,不得以"已经很好了"为由跳过。
3. **防循环**:修复只做一次,不递归。修不了的问题记进报告,继续往下走。

**违反任一条 = 立即中止当前命令,输出违规详情,等待人工介入。**
<!-- @include-end templates/prompts/iron-law-tool.md -->

根据 db-design 文档管理数据库迁移脚本,支持生成、执行、回滚和状态查看。

## 子命令解析

从本命令的参数中解析子命令和选项:

| 子命令 | 格式 | 说明 |
|--------|------|------|
| `generate <描述>` | 根据 db-design 文档生成版本化迁移脚本(up + down) |
| `status` | 查看迁移状态,列出已执行/待执行的迁移 |
| `up` | 执行所有待执行的迁移 |
| `down [N]` | 回滚最近 N 个迁移(默认 1) |
| `diff <功能名>` | 对比 db-design 文档与现有迁移脚本,生成增量迁移 |

如果未提供子命令或子命令无法识别,输出以上帮助信息后停止。

---

## PDLC 前置检查(仅 generate 和 diff 子命令)

当子命令为 `generate` 或 `diff` 时执行:

1. 从用户输入中提取功能名称关键词
2. 在 `docs/02_design/database/` 目录下搜索包含该关键词的数据库设计文档
   - 匹配新格式:`F<日期>-<编号>-*<关键词>*-db.md`
   - 匹配旧格式:`YYYYMMDD-*<关键词>*-db.md`
   - 同时检查文件内容中是否包含该关键词
3. **未找到** → 输出以下信息后**立即停止,不继续执行**:
   ```
   ⛔ PDLC 守卫:未找到与「<功能名>」相关的数据库设计文档。
   迁移脚本必须基于已有的数据库设计。请先运行:
   👉 /pdlc-db-design <设计目标>
   ```
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add kanfu-panda/pdlc-skills/pdlc-db-migrate@sha256:d6da0ce3c4b19be6

The line at the top of this page pins the label git:20261012.035af0d, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_4bmo4idmyj6log7n.svg)](https://markdownregistry.com/a/art_4bmo4idmyj6log7n)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 7 versions of this file, between May 7, 2026 and Oct 12, 2026, about one every 26 days.

versioncommittedcommitsizeaudit
git:20261012.035af0d latest2026-10-12 035af0d 12,868 BA view · diff
git:20261008.f5462072026-10-08 f546207 12,866 BA view · diff
git:20261008.72fb7f72026-10-08 72fb7f7 13,219 BA view · diff
git:20261007.7eb3b9d2026-10-07 7eb3b9d 10,544 BA view · diff
git:20260923.6b876962026-09-23 6b87696 10,359 BA view · diff
git:20260718.42454d52026-07-18 42454d5 6,625 BA view · diff
git:20260507.ba956b72026-05-07 ba956b7 6,597 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (12868 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

kanfu-panda/pdlc-skills · 18 stars · license MIT · pushed 2026-10-13 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_4bmo4idmyj6log7n
GET https://markdownregistry.com/api/v1/resolve?ref=kanfu-panda/pdlc-skills/pdlc-db-migrate
GET https://markdownregistry.com/api/v1/blob/d6da0ce3c4b19be655b50ed1c890a54708a7e1c0c21d86104899caa6f5aa3d2e

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from kanfu-panda/pdlc-skills

CLAUDE.md CLAUDE.md file
kanfu-panda/pdlc-skills · CLAUDE.md
git:20261013.ef05bf2 · audit A · 18 stars
pdlc-add-app SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-add-app/SKILL.md · 在已有项目里加一个前端应用(先探测布局,跟随现有目录与技术栈);新项目一次性初始化用 /pdlc-bootstrap
git:20261012.035af0d · audit A · 18 stars
pdlc-add-service SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-add-service/SKILL.md · 在已有项目里加一个后端服务(先探测布局,跟随现有目录与技术栈);新项目一次性初始化用 /pdlc-bootstrap
git:20261012.035af0d · audit A · 18 stars
pdlc-adopt SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-adopt/SKILL.md · 已有代码、还没有 PDLC 文档的老项目接入——只读扫描后逆向生成基线文档并做健康检查,不改代码;空目录新项目用 /pdlc-bootstrap
git:20261012.035af0d · audit A · 18 stars
pdlc-api-mock SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-api-mock/SKILL.md · 按 API 设计文档生成 Mock 数据与 Mock 服务配置,供前端联调
git:20261012.035af0d · audit A · 18 stars
pdlc-arch SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-arch/SKILL.md · 架构分析(生成/更新 docs/ARCHITECTURE.md 系统架构总览 · surface 型)
git:20261012.035af0d · audit A · 18 stars
pdlc-bootstrap SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-bootstrap/SKILL.md · 空目录从一句话描述初始化新项目(服务 / 应用拆分、技术栈、目录骨架与 PDLC 文档目录);已有代码的项目用 /pdlc-adopt
git:20261012.035af0d · audit A · 18 stars
pdlc-changelog SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-changelog/SKILL.md · 未发版时按 git 记录手动刷新 CHANGELOG 的 [未发布] 段;正式发版由 /pdlc-ship 一并处理
git:20261012.035af0d · audit A · 18 stars
pdlc-code-gen SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-code-gen/SKILL.md · 在已有服务 / 应用里按设计文档生成模块代码骨架(分层、接口、模型);加新服务用 /pdlc-add-service
git:20261012.035af0d · audit A · 18 stars
pdlc-db-design SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-db-design/SKILL.md · 按 PRD 设计数据库表结构、索引与 ER 图,产出 docs/02_design/database/ 设计文档;生成迁移脚本用 /pdlc-db-migrate
git:20261012.035af0d · audit A · 18 stars
pdlc-deploy SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-deploy/SKILL.md · 按已评审的功能或发布版本写部署手册(docs/05_deployment/guides/),不执行真实部署;要发布版本先用 /pdlc-ship
git:20261012.48d119f · audit A · 18 stars
pdlc-design SKILL.md skill
kanfu-panda/pdlc-skills · skills/pdlc-design/SKILL.md · 创建技术设计文档(自动生成 + 自检 + handoff)
git:20261012.18be267 · audit A · 18 stars

Every file in kanfu-panda/pdlc-skills

Browse by kind, by grade A, or by owner.