القائمة
AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.
التثبيت باستخدام 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.
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