web-backend-debugger

Debugging API route failures involves running health checks to verify database connections and environment variables, then inspecting error logs from your Next.js 15.5.4 app router and Supabase PostgreSQL. This Skill provides commands to isolate whether failures stem from database migrations, Prisma connection issues, or middleware problems.

Stripe webhook testing requires local verification of webhook signatures against your Supabase backend. This Skill includes instructions to configure webhook endpoints, validate signature verification in your Next.js routes, and troubleshoot common webhook failures without deploying to production.

License validation issues typically stem from incorrect license keys in Supabase, exceeded activation counts, or bugs in the `/api/licenses/validate` endpoint. This Skill guides you through querying the database to verify license records, checking activation counts, and testing the validation endpoint directly.

Essential health checks verify database connectivity, confirm environment variables are set correctly, and validate Supabase status. This Skill provides quick commands to test Prisma connections, inspect migration status, and confirm your Next.js backend can reach PostgreSQL.

Yes. This Skill enforces migration workflows and connection diagnostics for both local and production environments, helping you identify migration failures, connection timeouts, and Prisma schema mismatches without downtime.

Familiarity with Prisma schema, Supabase PostgreSQL structure, and Stripe webhook concepts is helpful but not required. This Skill walks through debugging steps for each component, translating common errors and guiding you through fixes.