~ system architecture · 01 / 03
Recall
airtable as operational database
airtable audacity sensible · doing its actual job
01
▚source of recordAIRTABLE
operational database — live records
the team's day-to-day workspace: what's in flight, who owns it, where it stands.
02
$ingestion
agentic OCR + change capture
a multi-decade scanned proposal archive → clean text; Airtable edits streamed in.
03
$retrieval store
managed Postgres · pgvector (HNSW)
one vector store for the corpus; dual embeddings power multi-dimensional comparables.
04
~llm tool-use router
route the question to the right lane
current proposalsin flight now
historical archivethe OCR'd past
comparablesdual-embedding + numeric
live tracker →reads Airtable directly
05
~answer
retrieve → rerank → synthesize
cross-encoder reranking + numeric filtering, then grounded synthesis with sources.
06
$serve
FastAPI · Azure Container Apps → SharePoint
a containerized service, embedded in the tools the team already uses.
airtable's role: the operational source of truth