supabase-db-rpc-auditor

What problem does it solve?

This Skill ensures your Supabase database schema, Remote Procedure Calls (RPCs), views, and Row Level Security (RLS) policies are consistent, secure, and performant, aligning perfectly with your application code.

Core Features & Use Cases

• Schema Validation: Detects mismatches between your application's database interactions and the actual Supabase schema.
• RPC & View Auditing: Verifies RPC signatures, parameter handling, and return shapes, and ensures views are correctly defined.
• RLS Policy Review: Assesses RLS policies for correctness, security gaps, and adherence to your application's access control logic.
• Performance Analysis: Identifies potential performance bottlenecks like missing indexes or inefficient query patterns.
• Use Case: When you deploy new SQL migrations or update your application's Supabase interaction code, use this Skill to automatically audit for any inconsistencies, security vulnerabilities, or performance regressions before they impact production.

Quick Start

Use the supabase-db-rpc-auditor skill to review the provided SQL migration file and the attached TypeScript code for any Supabase schema or RPC correctness issues.