How much should a data agent learn upfront? A team's discovery-layer design

prous5tmaker · reddit · 2026-10-19

A team building a proactive data agent (surfacing growth/revenue issues and posting to Slack) shares its design trade-off between upfront 'discovery' and on-the-fly lookups. V1 used an LLM agent to inspect schemas and write a catalog of tables, columns, and joins. Their new path moves schema collection into code — reading names, columns, types, and key constraints from metadata, grouping shard tables/partitions, and matching layouts — while the model only decides which tables matter, whether matching layouts are copies, and what tables mean; code validates outputs against the source catalog. Open questions: whether to sample categorical values during discovery or defer to each investigation, and how to keep descriptions and join suggestions checked against live findings.

Original post →

More from coding & agent

coding & agent channel →