Block Editor

The news page currently runs on mock data. To get live news flowing, the following work is needed:

- mc.briefings — stores generated briefings (id, date, headline, kicker, lede, takeaway, reading_time_min, created_at)

- mc.briefing_stories — individual stories (id, briefing_id, title, summary, url, severity, sentiment, topic, score, source_id, published_at)

- mc.news_sources — connects to the Sources page (id, name, url, category, status, last_fetch, article_count)

Scheduled daily (or twice daily). Pulls from RSS feeds configured in the Sources page, deduplicates against stored stories, passes new articles through LLM for summaries/severity/sentiment/topic/score, stores results in mc.briefing_stories.

Takes the day's fetched stories, groups by topic into sections, generates headline / kicker / lede / What the Week Brings, stores finished briefing in mc.briefings.

Replace mock data in page.tsx with fetch from /api/briefing/latest. API route reads from mc.briefings.

Replace mock archive with fetch from /api/briefing/archive. Returns historical briefing summaries by date.

Persist add/toggle/delete to mc.news_sources table. Fetcher reads from this table instead of mock data.

1. DB schema (tables + migrations)

2. mc.news_sources — fetcher needs this to know what to pull

3. Fetches + LLM enrichment

4. Briefing generator

5. Wire UI pages to API routes