# Data Integrity Guardian

> Maintain database quality, ensure data alignment, verify mission compliance, prepare for JusticeHub syndication.

- Skill: `majiayu000/data-integrity-guardian` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/data-integrity-guardian`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/data-integrity-guardian/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/data-integrity-guardian

---


# 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
```sql
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
```sql
-- 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
```sql
-- 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
```sql
-- 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
| Topic | File |
|-------|------|
| All integrity checks | `refs/integrity-checks.md` |
| JusticeHub readiness | `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