Sustainability Summary

Core Goal

• Read only relevant (is_relevant=1) records from shared SQLite.
• Build compact RAG context from DOI-keyed entries.
• Include optional enriched content from 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 table: entry_content (from sustainability-fulltext-fetch).
• Use the same absolute DB path in all sustainability skills.

Workflow

1. Build retrieval context by time window.

export SUSTAIN_RSS_DB_PATH="/absolute/path/to/workspace-rss-bot/sustainability_rss.db"

python3 scripts/time_report.py \
  --db "$SUSTAIN_RSS_DB_PATH" \
  --period weekly \
  --date 2026-02-10 \
  --max-records 120 \
  --max-per-feed 20 \
  --summary-chars 8192 \
  --fulltext-chars 8192 \
  --pretty \
  --output /tmp/sustainability-weekly-context.json

2. Generate final summary from returned records + aggregates.

3. Cite evidence using DOI + URL for key claims.

Time Window Modes

• --period daily --date YYYY-MM-DD
• --period weekly --date YYYY-MM-DD
• --period monthly --date YYYY-MM-DD
• --period custom --start ... --end ...

Default Fields

• doi,timestamp_utc,timestamp_source,feed_title,feed_url,title,url,summary,fulltext_status,fulltext_length,fulltext_excerpt

Configurable Parameters

• --db
• SUSTAIN_RSS_DB_PATH
• --period
• --date
• --start
• --end
• --max-records
• --max-per-feed
• --summary-chars
• --fulltext-chars
• --top-feeds
• --top-keywords
• --fields
• --output
• --pretty
• --fail-on-empty

Error Handling

• Missing required DOI-based tables: fail fast with setup guidance.
• Invalid date/time/field list: return parse errors.
• Missing entry_content: continue in metadata-only mode.
• Empty relevant set: return empty context; optional failure with --fail-on-empty.

References

• references/time-window-rules.md
• references/report-format.md

Assets

• assets/config.example.json

Scripts

• scripts/time_report.py