database-erd SKILL.md skillA

database-erd from nerds-odd-e/doughnut is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add nerds-odd-e/doughnut/database-erd@git:20260826.0b913a6

Pins git:20260826.0b913a6 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
nerds-odd-e/doughnut
Path
.agents/skills/database-erd/SKILL.md
Versions recorded
2
Latest version
git:20260826.0b913a6, committed Aug 26, 2026
First version recorded
Jul 26, 2026
Size
3,016 bytes
Repository stars
50
License
MIT

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.

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

<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):**

| Variable | Default |
|----------|---------|
| `DONUT_ERD_SCHEMA` | (auto: development → test → e2e) |
| `DONUT_ERD_MYSQL_HOST` | `127.0.0.1` |
| `DONUT_ERD_MYSQL_PORT` | `3309` |
| `DONUT_ERD_MYSQL_USER` | `doughnut` |
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add nerds-odd-e/doughnut/database-erd@sha256:1a4d0a10aee3699d

The line at the top of this page pins the label git:20260826.0b913a6, 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_6ahi2m3nxn7n6hnw.svg)](https://markdownregistry.com/a/art_6ahi2m3nxn7n6hnw)

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

Versions

The registry has recorded 2 versions of this file, between Jul 26, 2026 and Aug 26, 2026, about one every 31 days.

versioncommittedcommitsizeaudit
git:20260826.0b913a6 latest2026-08-26 0b913a6 3,016 BA view · diff
git:20260726.72e37c12026-07-26 72e37c1 3,040 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 (3016 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

nerds-odd-e/doughnut · 50 stars · license MIT · pushed 2026-11-01 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_6ahi2m3nxn7n6hnw
GET https://markdownregistry.com/api/v1/resolve?ref=nerds-odd-e/doughnut/database-erd
GET https://markdownregistry.com/api/v1/blob/1a4d0a10aee3699d2313966f443642643b6c07da02b5502ae6885480b27cce93

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 nerds-odd-e/doughnut

backend-code SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/backend-code/SKILL.md · Backend Java production code, Spring Boot controllers/services/repositories, controller return values, imports, schema…
git:20260928.32163ae · audit A · 50 stars
backend-testing SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/backend-testing/SKILL.md · Backend Java tests, controller-level stable-boundary tests, JUnit, @Nested, MakeMe builders, @Transactional…
git:20261003.8204a88 · audit A · 50 stars
backend SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/backend/SKILL.md · Backend Java — Spring Boot controllers/services, JUnit controller tests, MakeMe. Read this first for any backend work…
git:20260918.3a97b0e · audit A · 50 stars
cli SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/cli/SKILL.md · related to donut CLI. Use when working on donut-cli.
git:20260916.b334104 · audit A · 50 stars
cloud-vm-setup SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/cloud-vm-setup/SKILL.md · Set up and run the Donut dev environment on Cursor Cloud VM (no Nix). Use when working on Cloud VM, running tests on…
git:20261101.6bb5c5b · audit B · 50 stars
db-migration SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/db-migration/SKILL.md · Database migration, Flyway, SQL migrations, schema changes, database versioning, migration files, squashing historical…
git:20260928.428ed03 · audit A · 50 stars
dough-adr-awareness SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-adr-awareness/SKILL.md · Use and cite this project's current Accepted Architectural Decision Records for architecture-shaped work, follow…
git:20260909.3784459 · audit A · 50 stars
dough-bug-fixing SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-bug-fixing/SKILL.md · Resolves a reported discrepancy, defect, or regression by gathering expected versus actual behavior and passing the…
git:20261011.8ac439b · audit A · 50 stars
dough-execute-plan SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-execute-plan/SKILL.md · Executes one selected story or bounded retrospective correction through an executable plan, or one authorized planless…
git:20261031.b173027 · audit A · 50 stars
dough-execution-retrospective SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-execution-retrospective/SKILL.md · Reviews planned, completed planless quick, or quick-to-planned execution against original intent, aggregate commits…
git:20261031.b173027 · audit A · 50 stars
dough-land SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-land/SKILL.md · Dough Land lands everything in one reviewed checkout on the authorized remote trunk: commits all of its changes…
git:20261028.db35405 · audit A · 50 stars
dough-maintain-findings SKILL.md skill
nerds-odd-e/doughnut · .agents/skills/dough-maintain-findings/SKILL.md · Adopts supplied, approved DD-NNN to ODF-NNN finding-name mappings in this project's DearDough.md while preserving…
git:20260912.fc98c0d · audit A · 50 stars

Every file in nerds-odd-e/doughnut

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