supabase

浏览 Supabase 数据库表、关系和查询模式。当您需要了解表如何连接、编写查询或查找正确的数据源时使用。

📖 中文导读:浏览 Supabase 数据库表、关系和查询模式。当您需要了解表如何连接、编写查询或查找正确的数据源时使用。 以下正文为该技能的原始 SKILL.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