ReddRadar
Agent skill
frontend-backend-auditor
Ensure frontend components match database infrastructure, identify deprecated patterns, maintain data consistency.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/frontend-backend-auditor
SKILL.md
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 analysisnarrative_themes- AI-extracted themesstory_themes- Junction tableknowledge_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 checkssupabase-deployment- Schema managementdatabase-navigator- Schema exploration
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?