Menú
AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Basado en la clasificación ocupacional 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.
Maintain database quality, ensure data alignment, verify mission compliance, prepare for JusticeHub syndication.
| name | data-analysis |
| description | AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis. |
Patterns for AI-powered analysis: themes, quotes, summaries, and story suggestions.
Transcript → AI Analysis → themes[], key_quotes[], ai_summary
Story → Connections → Related Stories, Suggested Content
| Table | Analysis Fields |
|---|---|
transcripts | themes, key_quotes, ai_summary, ai_processing_status |
stories | themes, cultural_tags, featured_quote |
storytellers | expertise_themes, connection_strength |
-- Stories with matching theme
SELECT * FROM stories WHERE themes && ARRAY['identity', 'heritage'];
-- Theme frequency
SELECT unnest(themes) as theme, count(*) FROM stories GROUP BY theme ORDER BY count DESC;
| Endpoint | Purpose |
|---|---|
POST /api/transcripts/{id}/analyze | Trigger AI analysis |
GET /api/stories/{id}/suggestions | Get related stories |
GET /api/themes | List themes with counts |
| Topic | File |
|---|---|
| Code patterns | refs/analysis-patterns.md |
| SQL queries | refs/supabase-queries.md |
| Theme hierarchy | refs/theme-taxonomy.md |
| Sync status | refs/sync-status.md |
database-navigator - Database explorationsupabase-connection - Database clientsdesign-component - UI patterns for analysis display