Docs

Reference material for consumers of the Items Hub data lake. If you're writing code that reads from items.*, start here.

Data Dictionary

Every source, its payload shape, what gets extracted, and its scope / retention / PII envelope.

Use when: You're building a consumer and need to know what's in each source.

Three access patterns (direct SQL, REST, Brickston proxy) with working examples.

Use when: You want to read from items.* and need to pick the right door.

Source registry: items.source_config in Neon. Dashboard + dictionary read from this.
Table shapes: app/lib/db/schema.ts (Drizzle).
Source definitions: app/lib/sources.ts (used by npm run bootstrap:sources).
Operational plan + status snapshot: docs/operational-plan.md.
Cron / trigger changelog: docs/CRON_HISTORY.md.