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
Source, optimize, and attach cover images to ITW illustrations — Unsplash API for free images, Supabase Storage for hosting, and the batch script for bulk image attachment
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
Index of content ops runbooks — add illustrations, regenerate stubs, generate by scripture/topic/lens, update images, audit quality, and update product_knowledge for AI agents
Generate ITW illustrations for a topic, theme, or liturgical season using generate-by-topic.mjs — identify thin topic pages, run claude -p batch generation, and verify results
Generate new ITW illustrations for a specific scripture passage using generate-by-scripture.mjs — gap identification, claude -p batch generation, and DB insertion with embeddings
Generate illustrations tailored to a specific theological tradition using generate-lens-content.mjs — check lens coverage gaps, run claude -p generation, and insert with correct lens_id
Product overview for IllustrateTheWord (ITW) — sermon illustration library with 327K content records, free tier browse, and $9.95/mo Premium subscription for pastors
How 327K illustration records are sourced, generated, enriched with embeddings, assigned visibility tiers, and served via the dir_illustrations SQL view
All UnifiedTemplate sections (hero, service times, staff, ministries, events, giving, contact, chatbot) — render conditions, data sources, and progressive disclosure behavior
Find and replace stub/incomplete illustrations in unified_rag_content — identify records under 200 words or missing key fields, regenerate with claude -p CLI, and update embeddings
Update the product_knowledge table that is injected into chatbot and voice agent prompts at runtime — when pricing, features, or flows change, update here for immediate effect