菜单
Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | database-navigator |
| description | Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships. |
Navigate the complex database architecture - tables, functions, views, indexes, and policies.
| Group | Tables |
|---|---|
| Users | profiles, organizations, organization_members |
| Content | stories, storytellers, transcripts |
| Media | media_assets, media_usage |
| Cultural | cultural_backgrounds, protocols |
supabase/migrations/ - SQL files with timestamps
-- List all tables
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'public';
-- Find table columns
SELECT column_name, data_type FROM information_schema.columns
WHERE table_name = 'your_table';
-- Check RLS policies
SELECT * FROM pg_policies WHERE tablename = 'your_table';
| Topic | File |
|---|---|
| Query examples | refs/queries.md |
| Connection setup | refs/connection.md |
| Full documentation | docs/04-database/SUPABASE_COMPLETE_OVERVIEW.md |
supabase-connection - Database clients and migrationssupabase-sql-manager - SQL operationsdata-analysis - Analysis patternsThe brand constitution for Empathy Ledger — what it is, why it exists, who it serves, and how it sounds. Load BEFORE writing any Empathy Ledger public-facing copy (storyteller, organisation, or funder-facing), before naming or positioning anything, and before designing any storyteller-facing surface. Also load when reviewing whether existing copy or a feature is on-brand.
Run one cycle of the Empathy Ledger wiki research loop. Lints the wiki, surfaces the highest-priority gap, drafts fill content, queues the result for elder review.
Build world-class data visualizations for the Empathy Ledger platform — force-directed graphs, network maps, geographic overlays, temporal flows, and interactive dashboards using d3, recharts, leaflet, and framer-motion.
Local dev server management — start, stop, clean restart, fix cache corruption, port conflicts. Use this skill whenever the dev server needs launching or is misbehaving.
Explore EL projects, organizations, and all related content - storytellers, stories, transcripts, media, galleries, analysis. Core function for syndication API and ACT ecosystem.
AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.