PROJ-005

RAG + SQL Hybrid Analytics Assistant

Not StartedP0IdeaAdvancedAI & AutomationCV Ready

Natural-language assistant that routes between unstructured-knowledge (RAG) and structured-data (SQL) answers

progress

12 weeks

Quick Update

Changes save directly to Excel

Status

Progress — 0%

0%50%100%

Where I Stopped

Next Action

Start after PROJ-004 semantic layer is stable

Business Context

Decision Supported

Who can ask the business questions without SQL knowledge; analyst leverage

Business Impact

Democratize analytics; reduce ad-hoc request backlog; capture tribal knowledge

Data Needed

PostgreSQL MVs, internal docs, past analysis artifacts

Tools

Anthropic API, Python, pgvector or similar, n8n orchestration

Deliverables

Assistant UI, evaluation harness, query log

Execution Context

Learning Goals

Tool use; retrieval; query routing; evaluation

Dependencies

Stable semantic layer (PROJ-004); guardrails

Milestones

No milestones yet. Add them to the milestones sheet in Excel.

Claude Support

0 modes configured

No Claude support modes configured yet

Add rows to the claude_support sheet in Excel for PROJ-005

Notes & Documentation

0 notes

No notes yet

Add rows to the notes sheet in Excel to document your progress.