Home / kanfu-panda / pdlc-skills · GitHub

pdlc-db-design SKILL.md skillA

pdlc-db-design 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-design@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-design/SKILL.md
Versions recorded: 5
Latest version: git:20261012.035af0d, committed Oct 12, 2026
First version recorded: May 7, 2026
Size: 6,437 bytes
Repository stars: 18
License: MIT

按 PRD 设计数据库表结构、索引与 ER 图，产出 docs/02_design/database/ 设计文档；生成迁移脚本用 /pdlc-db-migrate.

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 -->

根据需求和 API 设计文档，创建数据库设计方案。

## PDLC 前置检查（必须执行，不可跳过）

1. 从用户输入中提取功能名称关键词
2. 在 `docs/01_requirements/prd/` 目录下搜索包含该关键词的 PRD 文档
   - 匹配新格式：`F<日期>-<编号>-*<关键词>*-prd.md`
   - 匹配旧格式：`YYYYMMDD-*<关键词>*-prd.md`
   - 同时检查文件内容中是否包含该关键词
3. **未找到** → 输出以下信息后**立即停止，不继续执行**：
   ```
   ⛔ PDLC 守卫：未找到与「<功能名>」相关的 PRD 文档。
   数据库设计必须基于已有的 PRD。请先运行：
   👉 /pdlc-prd <需求描述>
   ```
4. **找到** → 提取功能ID（如 `F20260326-090000`），读取该 PRD 内容，继续执行

## 工作流程

1. **阅读需求**: 阅读找到的 PRD 文档
2. **阅读 API 设计**: 阅读 `docs/02_design/api/` 下同功能ID的 API 设计文档（如有）
3. **梳理数据模型**: 识别实体、属性、关系
4. **ER 图**: 用文本方式描绘实体关系图
5. **表结构定义**: 逐表定义字段、类型、约束
6. **索引设计**: 根据查询场景设计索引
7. **输出设计文档**: 在 `docs/02_design/database/` 下创建数据库设计文档

## 文档内容
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint

mdr add kanfu-panda/pdlc-skills/pdlc-db-design@sha256:4f8357af24e955a8

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](https://markdownregistry.com/badge/art_4k3aap6zwn7cie7d.svg)](https://markdownregistry.com/a/art_4k3aap6zwn7cie7d)

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

Versions

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

version	committed	commit	size	audit
git:20261012.035af0d latest	2026-10-12	035af0d	6,437 B	A	view · diff
git:20261008.f546207	2026-10-08	f546207	6,435 B	A	view · diff
git:20260923.6b87696	2026-09-23	6b87696	6,758 B	A	view · diff
git:20260718.42454d5	2026-07-18	42454d5	3,035 B	A	view · diff
git:20260507.ba956b7	2026-05-07	ba956b7	3,015 B	A	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 (6437 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_4k3aap6zwn7cie7d
GET https://markdownregistry.com/api/v1/resolve?ref=kanfu-panda/pdlc-skills/pdlc-db-design
GET https://markdownregistry.com/api/v1/blob/4f8357af24e955a8cf989d4521724c4ae5f4095d7e832a39d867f42cc74fd74f

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