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
All tables owned by sermon-illustrations/ and SermonWise — illustration content, scripture analysis, theological lenses, lectionary, word studies, and user subscriptions
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 ITW users browse and search sermon illustrations — free vs premium content gating, scripture/topic/lectionary filtering, and the premium upgrade prompt
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