supabase

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

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

Core Tables

Storytelling

Table	Purpose
storytellers	Storyteller personas (canonical)
stories	Core content
transcripts	Audio/text transcriptions

Analysis

Table	Purpose
transcript_analysis_results	Versioned AI analysis
narrative_themes	AI-extracted themes
knowledge_chunks	RAG embeddings (22k+)

Multi-Tenant

Table	Purpose
tenants	Top-level isolation
profiles	User accounts
organisations	Community groups

Common Queries

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

Topic	File
Full table list	refs/tables.md
Relationship diagram	refs/relationship-diagram.md

Related Skills

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