supabase-audit-rpc

Audit exposed Supabase PostgreSQL RPC functions for security vulnerabilities.

Updated Jan 31, 2026
One-click install
npx skills add https://github.com/marvinbiss/servicesartisans --skill supabase-audit-rpc-marvinbiss
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-audit-rpc
Source: https://github.com/marvinbiss/servicesartisans/tree/main/.cursor/skills/supabase-audit-rpc
Command: npx skills add https://github.com/marvinbiss/servicesartisans --skill supabase-audit-rpc-marvinbiss

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill identifies and tests PostgreSQL functions exposed via Supabase's RPC endpoint, helping to uncover security vulnerabilities such as RLS bypass and SQL injection.

Core Features & Use Cases

  • Discover Exposed Functions: Automatically lists all available RPC functions in your Supabase project.
  • Security Testing: Assesses functions for risks like SECURITY DEFINER without proper checks, potential SQL injection vectors, and RLS bypass.
  • Use Case: Before deploying a new feature that relies on custom database functions, use this Skill to ensure these functions do not inadvertently expose sensitive data or allow unauthorized actions.

Quick Start

Audit all RPC functions on my Supabase project for security issues.

Frequently Asked Questions about supabase-audit-rpc

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

FAQPage Schema
How do I audit Supabase RPC functions for SQL injection vulnerabilities?

To audit Supabase RPC functions for SQL injection, the Skill tests text parameters on exposed PostgreSQL functions for injection flaws and identifies functions with inadequate authorization checks. It requires your Supabase URL and anon key to access and assess your project.

What causes RLS bypass in Supabase PostgreSQL functions?

RLS bypass in Supabase PostgreSQL functions is often caused by using SECURITY DEFINER without proper authorization checks. The Skill scans exposed RPC functions to identify this configuration and detect inadequate security boundaries that could expose sensitive data.

How can I check if my Supabase SECURITY DEFINER functions are secure before deployment?

You can check SECURITY DEFINER functions by auditing all exposed RPC functions for missing authorization checks and potential RLS bypass. The Skill automates this security testing to ensure custom database functions do not inadvertently allow unauthorized actions before deployment.

Do I need database admin credentials to scan Supabase RPC endpoints for security issues?

You do not need database admin credentials to scan Supabase RPC endpoints for security issues. The Skill requires only the Supabase project URL and the anon key to list available functions and test text parameters for injection vulnerabilities.

What is the best way to discover exposed PostgreSQL functions in a Supabase project?

The best way to discover exposed PostgreSQL functions is to use an automated audit tool that lists all available RPC endpoints. The Skill connects using your Supabase URL and anon key to enumerate functions and assess them for security vulnerabilities.

Why does my Supabase RPC function bypass row level security policies?

Your Supabase RPC function likely bypasses row level security policies because it is defined with SECURITY DEFINER or lacks adequate authorization checks. The Skill identifies these specific configurations to help you pinpoint and resolve RLS bypass risks.