Add New Sermon Illustrations
Add individual or batch sermon illustrations to unified_rag_content — single inserts via SQL, batch generation via claude -p CLI scripts, with required fields and lens IDs
Add individual or batch sermon illustrations to unified_rag_content — single inserts via SQL, batch generation via claude -p CLI scripts, with required fields and lens IDs
Systematic audit of unified_rag_content for quality gaps — too-short illustrations, missing embeddings, missing images, low theological lens coverage, and stub content
How ITW sermon illustrations are generated in bulk using Claude CLI (claude -p) — scripture-based, topic-based, and theological-lens scripts, plus stub regeneration
How RAG queries work — embedding the user query, pgvector cosine search against unified_rag_content, theological lens filtering, and injecting results into LLM context
Regenerate OpenAI text-embedding-3-small vectors for unified_rag_content rows — identify rows with null embeddings, run the embedding script, and verify RAG search improves
Add or update FAQ and knowledge base entries in unified_rag_content for a specific church — SQL inserts, embedding generation, and verifying the chatbot answers correctly