| name | endfield-source-graph |
| description | Quickly look up Endfield repo evidence with tools/endfield_source_graph.py. Use when Codex needs to answer questions about story keys, dialog lines, options, option routes/branch evidence, actors, audio ids, narrative videos, assets, materials, map/level rows, structured table references, or "why do we think X links to Y?" from the local SQLite source graph. |
Endfield Source Graph
Use this skill for fast evidence lookup, not for changing WebUI recovery logic.
If the task is primarily about WebUI refresh, frontend behavior, inline SNS
images, or browser packaging/serving, open
.codex/skills/endfield-webui-workflow/SKILL.md first and use this graph skill
only as supporting evidence.
The graph is a local SQLite database built from WebUI data, source links,
selected tables, assets, materials, character manifests, and optional
AnimeStudio maps.
Quick Lookup
Prefer the graph before wide text search when the user asks to look up a known
story key, option id, actor, asset, audio id, map/level id, or evidence link.
python tools\endfield_source_graph.py query dlg_c28m3_23
python tools\endfield_source_graph.py query option_dlg_c28m3_23_2_001
python tools\endfield_source_graph.py query au_dlg_e1m1_5_001
python tools\endfield_source_graph.py story dlg_e1m1_5 --limit-lines 8
The query command returns matching nodes/aliases plus neighbors of the first
match. Exact aliases and typed node ids are preferred over fuzzy matches, and
--kind story, --kind option, or --kind line can narrow a noisy query.
The story command returns a compact per-story arrangement: recovered line order,
option groups, anchors, option first/path/merge lines, and the evidence source
for each branch edge. Use it when a WebUI recovery issue needs a quick
line-order or option-route explanation.
Build Or Refresh
If reports/source_graph/endfield_source_graph.sqlite is missing or clearly
stale, first verify that its exported inputs are current:
python scripts\verify_export_freshness.py
If the guard reports stale installed-game sources, refresh with
export.bat --export-from-game before rebuilding the graph. Then use the
WebUI-relevant build first for story/option/audio and Presentation/Combat work:
python tools\endfield_source_graph.py build --relevant-asset-maps --skip-reference-rows --skip-followups
This still scans original AssetMaps but inserts only exact material, shader,
texture, and FMV source/PathID consumers. Use the full build only when generic
Unity-object/PathID lookup or generated follow-up reports matter:
python tools\endfield_source_graph.py build
Generated graph outputs live under reports/source_graph/ and are ignored by
git. Do not confuse them with WebUI data; they are investigation artifacts.
The graph also reads canonical generated evidence from
reports/story/build/, reports/story/recovery/options/, and
reports/mission_order/. Treat those files as report-to-report inputs: do not
remove them during cleanup unless their consumer is retired or they will be
regenerated before the next graph build. Keep graph outputs inside the existing
reports/source_graph/ topic root, never loose at reports/.
Put revisitable graph experiments under scratch/source_graph/<task>/ and
disposable databases or query exports under tmp/source_graph/<task-or-run>/.
Do not create loose SQLite files at the root of scratch/ or tmp/, and delete
temporary graph copies after the result is validated.
Exact Evidence Queries
When the built-in query is too broad, query SQLite directly. Useful tables:
nodes(id, kind, name, source, path, data), edges(src, dst, kind, source, evidence, data), aliases(alias, node_id, kind, source), files(...).
Examples:
python -c "import sqlite3; c=sqlite3.connect('reports/source_graph/endfield_source_graph.sqlite'); print(c.execute(\"SELECT dst,kind,source,evidence FROM edges WHERE src=? ORDER BY kind,dst\", ('option:option_dlg_c28m3_23_2_001',)).fetchall())"
python -c "import sqlite3; c=sqlite3.connect('reports/source_graph/endfield_source_graph.sqlite'); print(c.execute(\"SELECT src,dst,kind,source,evidence FROM edges WHERE source='timeline_route_branch' AND (src LIKE '%c28m3_23%' OR dst LIKE '%c28m3_23%') ORDER BY src,dst\").fetchall())"
Interpreting Sources
webui/story: generated story, line, actor, audio, option, video data.scene_graph: direct dialog-tree or sceneGraphLinks branch evidence.option_branch_risk: inferred option branch hints from WebUI recovery.timeline_route_branch: Runtime Jump Track recovered option routes.story_source_links: mission/runtime source references to story keys.AnimeStudio/maps: Unity AssetMap entries; exact WebUI consumers in relevant
mode and all entries in exhaustive mode.
For user answers, report both the resolved relationship and its evidence source
when the distinction matters.
