AI-powered data analysis for Empathy Ledger. Use when working with themes, quotes, story suggestions, transcript analysis, storyteller connections, or any feature requiring extracted insights. Ensures consistent analysis patterns across the platform.
Patterns for AI-powered analysis: themes, quotes, summaries, and story suggestions.
Transcript → AI Analysis → themes[], key_quotes[], ai_summary
Story → Connections → Related Stories, Suggested Content
| Table | Analysis Fields |
|-------|-----------------|
| transcripts | themes, key_quotes, ai_summary, ai_processing_status |
| stories | themes, cultural_tags, featured_quote |
| storytellers | expertise_themes, connection_strength |
-- Stories with matching theme
SELECT * FROM stories WHERE themes && ARRAY['identity', 'heritage'];
-- Theme frequency
SELECT unnest(themes) as theme, count(*) FROM stories GROUP BY theme ORDER BY count DESC;
| Endpoint | Purpose |
|----------|---------|
| POST /api/transcripts/{id}/analyze | Trigger AI analysis |
| GET /api/stories/{id}/suggestions | Get related stories |
| GET /api/themes | List themes with counts |
| Topic | File |
|-------|------|
| Code patterns | refs/analysis-patterns.md |
| SQL queries | refs/supabase-queries.md |
| Theme hierarchy | refs/theme-taxonomy.md |
| Sync status | refs/sync-status.md |
database-navigator - Database explorationsupabase-connection - Database clientsdesign-component - UI patterns for analysis displayEdit PDFs with natural-language instructions using the nano-pdf CLI.
Control Sonos speakers (discover/status/play/volume/group).
Terminal Spotify playback/search via spogo (preferred) or spotify_player.
Capture frames or clips from RTSP/ONVIF cameras.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).
Monitor blogs and RSS/Atom feeds for updates using the blogwatcher CLI.
Category:tools