القائمة
Maintain database quality, ensure data alignment, verify mission compliance, prepare for JusticeHub syndication.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
| name | data-integrity-guardian |
| description | Maintain database quality, ensure data alignment, verify mission compliance, prepare for JusticeHub syndication. |
Ensure database quality, cultural safety, mission alignment, and API readiness.
SELECT
'Stories' as metric, COUNT(*)::text as value FROM stories
UNION ALL
SELECT 'Published', COUNT(*)::text FROM stories WHERE status = 'published'
UNION ALL
SELECT 'Active Storytellers', COUNT(*)::text FROM storytellers WHERE is_active = true
UNION ALL
SELECT 'Avatar Coverage %',
ROUND(COUNT(*) FILTER (WHERE avatar_url IS NOT NULL) * 100.0 / COUNT(*), 1)::text
FROM storytellers;
-- Stories without storytellers (should be 0)
SELECT COUNT(*) FROM stories s
LEFT JOIN storytellers st ON s.storyteller_id = st.id
WHERE s.storyteller_id IS NOT NULL AND st.id IS NULL;
-- Public stories without elder review (should be 0)
SELECT COUNT(*) FROM stories
WHERE requires_elder_review = true AND elder_reviewed = false AND is_public = true;
-- Public stories missing consent (should be 0)
SELECT COUNT(*) FROM stories
WHERE status = 'published' AND is_public = true
AND (has_explicit_consent = false OR has_explicit_consent IS NULL);
| Topic | File |
|---|---|
| All integrity checks | refs/integrity-checks.md |
| JusticeHub readiness | refs/justicehub-readiness.md |
frontend-backend-auditor - Frontend alignmentdatabase-navigator - Schema explorationcultural-review - Cultural sensitivityThe 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.