supabase-functions

What problem does it solve?

This Skill helps generate PostgreSQL functions for Supabase with security-focused patterns, including SECURITY INVOKER defaults and safe search_path usage, to ensure secure, production-ready database logic.

Core Features & Use Cases

• Function Templates: Basic function, parameterized functions, error handling
• Security Patterns: SECURITY INVOKER, set search_path, fully qualified names
• Triggers & Helpers: Trigger functions and helper patterns for RLS
• Use case: Implement server-side calculations or data transformations in the database.

Quick Start

Example: create a function my_schema.calculate_total_price(order_id bigint) with SECURITY INVOKER and set search_path to ''.