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
bash
# 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
typescript
// ❌ OLD: profiles table
supabase.from('profiles').select('*').eq('is_storyteller', true)
// ✅ NEW: storytellers table
supabase.from('storytellers').select('*').eq('is_active', true)
AI Analysis
typescript
// ❌ 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