Sustainability Summary

Core Goal

• Read only relevant (is_relevant=1) records from RSS DB.
• Build compact RAG context from DOI-keyed entries.
• Include optional enriched content from separate fulltext DB entry_content when available.
• Let the agent synthesize final summary text with evidence anchors.

Triggering Conditions

• Receive requests for daily/weekly/monthly sustainability digests.
• Receive requests for custom date-range summaries.
• Need evidence-grounded output from labeled RSS entries and enriched content.

Input Requirements

• Required tables: feeds, entries (from sustainability-rss-fetch).
• entries must be DOI-keyed and relevance-labeled.
• Optional fulltext DB table: entry_content (from sustainability-fulltext-fetch).
• RSS DB and fulltext DB must be different files.