跳到正文
cccskills
免费在 GitHub 公开

database-erd

Regenerate docs/database-erd.md from MySQL information_schema (Mermaid ERD: foreign keys and key columns). Use after Flyway schema changes, new migrations, or when the diagram is stale. Triggers on: database ERD, database-erd.md, export_database_erd, schema diagram, ER diagram after migration.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut星标 50(GitHub 50 + cccskills 0)
集成工具MySQL

实测评分 未实测

查看安装方法

包含的文件(1)

  • SKILL.md2.9 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

<objective> Regenerate `docs/database-erd.md` from the live MySQL catalog so the Mermaid ERD matches the current migrated schema.

Purpose: Keep the schema diagram accurate after Flyway migrations — never hand-edit the Mermaid block.

Output: Updated docs/database-erd.md + summary ending with ## ERD EXPORTED. </objective>

<context> `docs/database-erd.md` is generated from MySQL `information_schema` (foreign keys and PK/UK/FK columns). **Do not hand-edit the Mermaid block**; re-run the exporter after schema changes.

Run when:

  • A new or changed Flyway migration alters tables, columns, or constraints
  • The ERD needs to match the current migrated schema

Git does not use the Nix prefix. All other repo tooling does: CURSOR_DEV=true nix develop -c …

Implementation:

  • Script: scripts/export_database_erd.py
  • Output: docs/database-erd.md
  • Omits flyway_schema_history from the diagram

Overrides (optional):

VariableDefault
DONUT_ERD_SCHEMA(auto: development → test → e2e)
DONUT_ERD_MYSQL_HOST127.0.0.1
DONUT_ERD_MYSQL_PORT3309
DONUT_ERD_MYSQL_USERdoughnut
DONUT_ERD_MYSQL_PASSWORDdoughnut
</context> <process> <step name="ensure_mysql"> Ensure MySQL is reachable on **127.0.0.1:3309** with user **`doughnut`** (local dev defaults from `scripts/shell_setup.sh` / `process-compose`). </step> <step name="ensure_migrated_schema"> Ensure at least one migrated schema exists (Flyway has run). The script picks, in order: **`doughnut_development`**, then **`doughnut_test`**, then **`doughnut_e2e_test`**, unless **`DONUT_ERD_SCHEMA`** is set to a specific catalog. </step> <step name="export"> From the repo root:
CURSOR_DEV=true nix develop -c python3 scripts/export_database_erd.py

Or:

CURSOR_DEV=true nix develop -c pnpm export:database-erd
</step> <step name="commit_with_migration"> Commit the updated `docs/database-erd.md` with the migration (or immediately after). </step> </process>

<success_criteria>

  • MySQL reachable on 127.0.0.1:3309 with user doughnut
  • At least one migrated schema available (or DONUT_ERD_SCHEMA set)
  • Exporter run with Nix prefix
  • docs/database-erd.md updated and ready to commit
  • Final output includes ## ERD EXPORTED </success_criteria>
<output> Report a short summary to the caller, then the completion marker:
  1. Schema catalog used (auto-selected or DONUT_ERD_SCHEMA override).
  2. Whether docs/database-erd.md changed.
## ERD EXPORTED
</output>

<out_of_scope>

  • Do not hand-edit the Mermaid block in docs/database-erd.md. </out_of_scope>

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

backend

免费

Backend Java — Spring Boot controllers/services, JUnit controller tests, MakeMe. Read this first for any backend work. Use when working on the Java Spring backend.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

Backend Java production code, Spring Boot controllers/services/repositories, controller return values, imports, schema ERD pointer. Use when editing backend production Java.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

Backend Java tests, controller-level stable-boundary tests, JUnit, @Nested, MakeMe builders, @Transactional, parameterized tests. Use when writing or changing backend JUnit tests.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

cli

免费

related to donut CLI. Use when working on donut-cli.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

Set up and run the Donut dev environment on Cursor Cloud VM (no Nix). Use when working on Cloud VM, running tests on Cloud VM, or encountering command errors related to missing nix. Triggers on: cloud VM, cloud agent, no nix available, /workspace path.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

Database migration, Flyway, SQL migrations, schema changes, database versioning, migration files, squashing historical migrations. Use when adding or changing Flyway migrations or schema.

中文简介正在准备中。当前显示原文说明。

nerds-odd-e/doughnut502026年10月26日 更新

查看 nerds-odd-e 的全部技能

报告此技能的问题