---

name: data-analysis description: AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.

Data Analysis

Patterns for AI-powered analysis: themes, quotes, summaries, and story suggestions.

When to Use

• Adding quotes to story cards
• Implementing story suggestions/related content
• Building theme-based filtering or search
• Creating analytics dashboards
• Integrating AI analysis results

Quick Reference

Analysis Pipeline

CopyTranscript → AI Analysis → themes[], key_quotes[], ai_summary
Story → Connections → Related Stories, Suggested Content

Key Tables

Theme Categories

• cultural: identity, heritage, tradition, language, ceremony
• family: kinship, elders, children, ancestors, community
• land: country, connection, seasons, wildlife, sacred-sites
• resilience: survival, adaptation, strength, healing, hope
• knowledge: wisdom, teaching, learning, stories, dreams

Common Queries

Copy-- 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

Reference Files

Related Skills

• database-navigator - Database exploration
• supabase-connection - Database clients
• design-component - UI patterns for analysis display