frontend-backend-auditor

Audit React/TypeScript frontend data access against the current database schema.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/Acurioustractor/empathy-ledger-v2 --skill frontend-backend-auditor
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: frontend-backend-auditor
Source: https://github.com/Acurioustractor/empathy-ledger-v2/tree/main/.claude/skills/local/frontend-backend-auditor
Command: npx skills add https://github.com/Acurioustractor/empathy-ledger-v2 --skill frontend-backend-auditor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This skill identifies and reports misaligned frontend data access relative to the current database schema.

Core Features & Use Cases

  • Scans React/TypeScript source files and API routes to detect deprecated table usage and outdated AI analysis patterns
  • Generates structured audit reports with actionable migration guidance
  • Verifies type-safety alignment between code and schema to prevent runtime errors after migrations

Quick Start

Use this skill to run an audit on a project by navigating to the repository root and executing the audit script:

  • Command: bash .claude/skills/local/frontend-backend-auditor/scripts/audit.sh
  • Review the generated Markdown report for issues and recommended fixes

Frequently Asked Questions about frontend-backend-auditor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect deprecated database table usage in React after a schema migration?

To detect deprecated database table usage after a schema migration, scan your React and TypeScript source files alongside API routes. This identifies outdated table references and generates a structured audit report with actionable fixes to align with the current schema.

How do I check type-safety alignment between frontend code and database schema?

Checking type-safety alignment between frontend code and database schema involves analyzing TypeScript projects to find type mismatches. This process verifies that your data access patterns match the current schema, preventing runtime errors after migrations.

Can I scan API routes to find outdated AI analysis patterns in TypeScript projects?

Yes, you can scan API routes to find outdated AI analysis patterns in TypeScript projects. The audit identifies old data access logic and provides migration guidance to align with current tables like transcript_analysis_results.

What's the best way to audit frontend data access for misaligned database queries?

The best way to audit frontend data access for misaligned database queries is to run an automated script from your repository root. It analyzes your source files and produces a Markdown report detailing misaligned data access and recommended fixes.

Does this frontend database alignment audit work without external dependencies?

Yes, this frontend database alignment audit works without external dependencies. It operates as a standalone local script within your repository to analyze source files and generate a structured report of deprecated table usage and type mismatches.

When should I run a frontend backend database schema alignment audit?

You should run a frontend backend database schema alignment audit immediately after completing database migrations. This ensures your React and TypeScript data access patterns match the updated schema and prevents type mismatch runtime errors.