AI topic extraction: identify trending themes & community concerns

[SaharPak]

Context

We want to know what the community is talking about — trending topics, common challenges, recurring questions — so we can create relevant content and events.

Requirements

• Periodically (daily/weekly) analyze recent messages using Claude
• Extract: top topics, common questions, sentiment, pain points
• Store results in DB with timestamp
• /topics admin command shows current trending themes
• Optional: weekly digest message posted to admin chat

Example output

📊 This week in Tech Immigrants:

Trending topics:
1. 🇩🇪 Germany Blue Card changes (42 messages)
2. 💼 Layoff strategies (38 messages)
3. 📝 CV tips for EU market (27 messages)

Top concerns:
- Visa processing delays
- Interview prep for FAANG
- Relocation costs

Acceptance Criteria

• Daily topic extraction runs automatically
• Results stored and queryable
• Admin command shows latest insights
• Weekly digest (optional, behind feature flag)