How does the agent learn from your context?
An agent that ships in production does not memorize your business — it reads structured context, recalls proven examples, and writes them back as it works. Wren AI is designed around that loop.
Why this matters
A first-day analyst does not know which table is canonical. Neither does an agent. Both get better through the same path: a guided start, focused questions, and a record of what worked.
The difference is that an agent forgets between sessions unless your tooling stores the learning somewhere reviewable. Wren AI captures that learning in four explicit places — MDL, instructions, memory, and skills — so the agent picks up where the team left off, every time.
The two beats: scaffold fast, enrich deep
Wren AI runs the agent through two beats whenever you set up a new project.
Beat 1 — Scaffold fast. The wren-generate-mdl skill drives the agent through schema discovery, type normalization, and an initial MDL project. The agent can already query through that modeled layer in a few minutes. The MDL is rough but functional — it covers what the database can tell you about itself.
Beat 2 — Enrich deep. Structure is only the start. The hard business meaning lives in docs, decks, Slack threads, and analyst SQL. The wren-enrich-context workflow brings that meaning in through two modes:
- Grill mode — the agent asks one focused question at a time ("which is the canonical
orderstable?", "what doesstatus = 4mean?", "shouldactive customerexclude internal users?"). You answer; the agent patches MDL,instructions.md,queries.yml, or memory. - Auto-pilot mode — drop PDFs, glossaries, handbooks, and SQL history into
<project>/raw/. The agent reads them, proposes context changes with evidence, and waits for review.
Both modes write to reviewable, version-controlled artifacts. Nothing is silently absorbed into a black box.
What learning actually persists
Four artifacts capture different layers of learning:
| Artifact | What it stores | Updated by |
|---|---|---|
MDL (models/, views/, relationships.yml) | Structural and semantic contract — what data exists, how it relates, which calculations are reusable | wren context build, manual edits, agent-proposed changes |
instructions.md | Operational guidance — preferred terminology, default filters, table selection rules, caveats | Manual edits or agent-proposed changes |
Memory (.wren/memory/) | Retrieval index over MDL + instructions, plus a record of confirmed natural-language-to-SQL pairs | wren memory index, wren memory store |
queries.yml | Curated, committable seed of natural-language-to-SQL examples | wren memory dump from accumulated memory |
The agent reads from all four when it gathers context for a new question. The first three change rarely; memory and queries grow with use.
The query workflow in practice
The wren-usage skill orchestrates the day-to-day pattern:
User asks a business question
│
├── 1. wren memory recall → find similar accepted NL-SQL pairs
├── 2. wren memory fetch → retrieve relevant models, columns, relationships
├── 3. Write SQL against MDL objects, not raw tables
├── 4. wren dry-plan → see expanded SQL before execution
├── 5. wren --sql ... → execute
├── 6. Repair on failure → diagnose at MDL layer vs DB layer
└── 7. wren memory store → persist the confirmed pair
Each step is a deterministic primitive the agent orchestrates. The trace stays visible in the agent's reasoning, not buried in a closed product.
Why this is different from "more examples"
Sending more examples into a prompt has a ceiling. The model sees the schema and tries its best.
Wren AI lets the system compound:
- Recurring questions retrieve better examples each time.
- Recurring metrics reuse accepted SQL patterns.
- Schema retrieval narrows as the project grows.
- Corrections become future grounding instead of disappearing at session end.
- Teams can commit
queries.ymlso new environments inherit the learning.
The agent is not getting smarter. The context layer it reads from is getting richer, and it is reviewable every step of the way.
See also
- How does memory get smarter over time? — the mechanics of recall and indexing.
- What does MDL do for the agent? — the semantic contract the agent reads.
- Refine answer quality — the recipe for running the enrich loop.