api-db-maplisted
Install: claude install-skill qqzhangyanhua/api-db-map
# API → DB Map
Analyze a backend codebase and answer, with evidence, which HTTP APIs read or write which database tables and fields. Then render three diagrams.
If the code does not prove an access, mark it `uncertain` and keep going.
Load [references/ir-schema.md](references/ir-schema.md) before step 3 and emit that shape from then on.
## Output contract
Always produce artifacts under the project root or a path the user named (default `./api-db-map-out/`). Incremental: a new run adds timestamped files and does not replace earlier ones.
```
api-db-map-out/
├── registry.json
├── index.html ← entry page (search by path or table)
├── GET__api__orders__-id-/
│ ├── 2026-09-13.json
│ ├── 2026-09-13.html
│ └── 2026-09-13.md
└── _project_overview/ ← when more than one endpoint is deep-traced
└── 2026-09-13.html
```
Directory name: `METHOD` + path with `/` → `__` and `{id}` → `-id-` (`GET /api/orders/{id}` → `GET__api__orders__-id-`).
Stamp: `YYYY-MM-DD`; if that `.html` already exists, `YYYY-MM-DDTHH-MM`.
`index.html` is what you open first. Render HTML with `scripts/render_html.py`. Never hand-write the HTML.
Reply in the user's language. If they wrote Chinese, diagram chrome is Chinese (影响架构图 / 表与字段关系 / 接口时序图).
## Running the scripts
The scripts ship next to this file, **not** in the project you are analyzing, and your working directory is normally the project. So resolve the skill root once, before step 2, and use abso