-- 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;
API Endpoints
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
Reference Files
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
Related Skills
database-navigator - Database exploration
supabase-connection - Database clients
design-component - UI patterns for analysis display