What Do Agents Do When They Hit a Raw Table Nobody Has Mapped? No Shared Keys
No-Plant-5234 · reddit · 2026-08-27
A real production question for agentic systems: what happens when an agent hits a raw table mid-task that nobody has预先 mapped?
The author notes both common approaches break: dumping raw rows into context re-derives structure on every call once tables grow; Text-to-SQL against stale schema docs fails silently when columns are renamed or new tables lack foreign keys. The hardest case is no shared keys — two tables with entirely different ID schemes, where matching must be inferred from actual values, not regex.
The poster (disclosing they work at Schema Labs) shares a run where Schema-2 profiled two files and inferred their relationship without any declared keys — a single run, so limited evidence — and asks the community what's actually working: strict onboarding conventions, enforced foreign keys, or something else?
More from coding & agent
- Shared Agent Skill Libraries Propagate Malware, 41.8% Self-Poisoning Rate Found — omarsar0 · 2026-08-27
- Tip: Use STRONG_GO keyword to stop agents from seeking constant confirmation — GabGarrett · 2026-08-27
- Integrating Warp Factory run costs into Slack for model routing optimization — vikvang1 · 2026-08-27
- Weaviate 1.39 ships Boost API and MMR to GA, adds 4-bit RQ quantization — CShorten30 · 2026-08-27
- Apodex 1.1 released: New model family and FrontierAgent framework — wuqiao · 2026-08-27
- Vercel open-sources vgpu, a WebGPU library designed for agents — evilrabbit_ · 2026-08-27