Architecture
The pipeline behind every Ask Oracle answer — classification, grounding, generation, then a typed renderer. Built so the knowledge layer can grow independently of the LLM.
User | v Next.js UI (app/ask) | v Question Classifier lib/ai/classify.ts | v Intent + Product + Module Detection | v Retrieval Layer lib/oracle/retrieval.ts |-- Curated Oracle Metadata data/oracle/* |-- Verified SQL Patterns data/oracle/sql-patterns.ts `-- (future) Oracle Documentation via pgvector | v LLM lib/ai/provider.ts (Gemini, provider-agnostic) | v Structured JSON lib/ai/schemas.ts (zod-validated) | v Answer Renderer components/oracle/answer-renderer.tsx
“The LLM explains. The Oracle knowledge layer establishes the facts.”