OpenSkillIndex← back to search
claude-code

Claude-skill-registry frontend-backend-auditor

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

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/frontend-backend-auditor" ~/.claude/skills/majiayu000-claude-skill-registry-frontend-backend-auditor && rm -rf "$T"
manifest: skills/data/frontend-backend-auditor/SKILL.md
source content

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

TopicFile
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