# DungeonSettlersDB

> Unofficial, locally-hosted database for the game Dungeon Settlers (Steam AppID 4021950), build DS_B.0.3.26 / Steam buildid 23739108. All 36 game data tables parsed byte-exact from the game's Unity assets on 2026-07-13, cross-referenced into a paldb.cc-style browsable site plus clean JSON for machines.

Everything an AI agent needs is under /dbdata/ as plain JSON. Read /AGENTS.md first: it documents every table, all join conventions (TEXTKEY name resolution, `_<amount>` ref suffixes, `Stat_value` effect strings, nested DROP_ pool expansion, parallel arrays, enum `<Field>Name` siblings, sentinel values) and common query recipes.

## Machine-readable data

- [Data guide / schema docs](/AGENTS.md): Read this first - schemas, conventions, join graph
- [Manifest](/dbdata/index.json): every table with row counts and key prefixes
- [Full bundle](/dbdata/db.json): all tables + English text keys + curated notes in one JSON
- [ItemTable](/dbdata/ItemTable.json): 372 items with stats, effects, rarity
- [UnitTable](/dbdata/UnitTable.json): 108 units/monsters with combat stats and drops
- [SkillTable](/dbdata/SkillTable.json): 234 skills; [SkillTreeTable](/dbdata/SkillTreeTable.json): tree grids
- [AffecterTable](/dbdata/AffecterTable.json): 653 buffs/traits/inscriptions; [TraitTable](/dbdata/TraitTable.json): recruitment traits with authoritative rarity
- [RecipeTable](/dbdata/RecipeTable.json), [BuildingTable](/dbdata/BuildingTable.json), [ResearchTable](/dbdata/ResearchTable.json): crafting/economy
- [DropTable](/dbdata/DropTable.json), [TradePoolTable](/dbdata/TradePoolTable.json): loot and merchants
- [EventTable](/dbdata/EventTable.json) + [EventNodeTable](/dbdata/EventNodeTable.json) + [EventChoiceTable](/dbdata/EventChoiceTable.json): dungeon event dialog graphs
- [QuestTable](/dbdata/QuestTable.json), [DungeonRoomTable](/dbdata/DungeonRoomTable.json), [SpawnGroupTable](/dbdata/SpawnGroupTable.json): progression and world
- [GameSystemTable](/dbdata/GameSystemTable.json): 448 global tuning constants
- [TextKeyTable_en](/dbdata/TextKeyTable_en.json): English display strings (TEXTKEY_<Key>_NAME/_DESC)
- [Curated notes](/dbdata/curated/): regions, races, mechanics articles, gated content, glossary
- [Korean-to-English dev-string translations](/dbdata/translations_ko_en.json): 3920 entries keyed by source string
- Entity-name localization maps for 29 languages at /lang/<Language>.json

## Browsable pages

- [Home](/index.html): overview and counts
- [Items](/items/index.html), [Units](/units/index.html), [Skills](/skills/index.html), [Buildings](/buildings/index.html): main databases with per-entity detail pages
- [Inscriptions](/inscriptions/index.html), [Traits](/traits/index.html), [Statuses](/statuses/index.html): character systems
- [Loot](/loot/index.html), [Merchants](/merchants/index.html), [Events](/events/index.html), [Quests](/quests/index.html): world content
- [Mechanics](/mechanics/index.html), [Gated content](/gated/index.html), [Game constants](/constants/index.html): reference

## Notes

- Sentinel strings "NULL"/"NOT_USED"/"Dev_NotUsed" mean empty; filter them
- Item refs may carry amounts as suffix: ITEM_CopperIngot_3 = 3x Copper Ingot
- Display names: look up TEXTKEY_<EntityKey>_NAME in TextKeyTable_en.json
- Icons at /icons/<group>/<KEY>.png (pixel art)