# Frontend Backend Auditor

> Ensure frontend components match database infrastructure, identify deprecated patterns, maintain data consistency.

- Skill: `majiayu000/frontend-backend-auditor` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add majiayu000/frontend-backend-auditor`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/frontend-backend-auditor/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Web & Frontend
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/frontend-backend-auditor

---


# 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