ワンクリックで
database-navigator
Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
メニュー
Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
The 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.
| 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 patterns