---

name: supabase description: Navigate Supabase database tables, relationships, and query patterns. Schema reference for Empathy Ledger.

Supabase Database

Navigate and query the Empathy Ledger Supabase database.

When to Use

• Understanding table relationships
• Writing database queries
• Finding the right data source
• Checking schema structure

Quick Relationship Map

Copytenants
   └── profiles → storytellers → stories → transcripts
                                    ↓
                        transcript_analysis_results
                                    ↓
                        narrative_themes + extracted_quotes

Core Tables

Storytelling

Analysis

Multi-Tenant

Common Queries

Copy-- Storyteller with story count
SELECT st.*, COUNT(s.id) as story_count
FROM storytellers st
LEFT JOIN stories s ON s.storyteller_id = st.id
GROUP BY st.id;

-- Stories by theme
SELECT * FROM stories
WHERE 'healing' = ANY(cultural_themes);

-- Theme frequency
SELECT unnest(cultural_themes) as theme, COUNT(*)
FROM stories WHERE status = 'published'
GROUP BY theme ORDER BY count DESC;

Reference Files

Related Skills

• supabase-connection - Database clients
• supabase-deployment - Migrations
• database-navigator - Schema exploration