Frontend-Backend Auditor

Audit frontend-database alignment. Identify deprecated AI analysis, wrong table usage, type mismatches.

When to Use

• After database migrations/consolidation
• Reviewing component database access
• Identifying deprecated data patterns
• Ensuring TypeScript types match schema

Quick Audit Commands

# Find deprecated table usage
grep -r "from('profiles')" src/ --include="*.tsx" --include="*.ts"
grep -r "from('analysis_jobs')" src/ --include="*.tsx" --include="*.ts"

# Find deprecated columns
grep -r "legacy_" src/ --include="*.tsx" --include="*.ts"

# Check type sync
npm run types:generate
git diff src/types/database/

Common Migrations

Storyteller Data

// ❌ OLD: profiles table
supabase.from('profiles').select('*').eq('is_storyteller', true)

// ✅ NEW: storytellers table
supabase.from('storytellers').select('*').eq('is_active', true)

AI Analysis

// ❌ OLD: analysis_jobs
supabase.from('analysis_jobs').select('*')

// ✅ NEW: versioned results
supabase.from('transcript_analysis_results')
  .select('*')
  .eq('analysis_version', 'v2')

Current AI Systems

• transcript_analysis_results - Versioned analysis
• narrative_themes - AI-extracted themes
• story_themes - Junction table
• knowledge_chunks - RAG embeddings

Reference Files

| Topic | File | |-------|------| | Deprecated patterns | refs/deprecated-patterns.md | | Audit process | refs/audit-process.md |

Related Skills

• data-integrity-guardian - Data quality checks
• supabase-deployment - Schema management
• database-navigator - Schema exploration