Formatted SKILL.md (raw) Package Files
Copy .md
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
supabase-connection - Database clients
supabase-deployment - Migrations
database-navigator - Schema exploration