Data Integrity Guardian

Ensure database quality, cultural safety, mission alignment, and API readiness.

When to Use

• Before JusticeHub API syndication
• Adding stories to public catalog
• Migrating data between tables
• Weekly data quality audits

Quick Health Check

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;

Critical Checks

Orphaned Records

-- 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;

Cultural Safety

-- 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;

Consent Verification

-- 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);

Reference Files

refs/integrity-checks.md

refs/justicehub-readiness.md

Mission Alignment

• OCAP Compliance: Ownership, Control, Access, Possession
• Cultural Safety: Elder review, traditional knowledge protection
• Storyteller Empowerment: Full control over narratives

Related Skills

• frontend-backend-auditor

  - Frontend alignment

• database-navigator

  - Schema exploration

• cultural-review

  - Cultural sensitivity