Schedule a Supabase Edge Function

Use Supabase pg_cron for SQL-only database maintenance. Use this pattern when the recurring unit is an HTTP Edge Function and an external scheduler is desired.

Prerequisites

• Deploy the function before creating its schedule.
• Make the function idempotent for one logical period.
• Protect it with a dedicated server-side cron secret.
• Never send a Supabase service-role key to Crontap.

Function security pattern

Read a dedicated header or bearer value and compare it with a server-only environment variable before doing work. If Supabase gateway JWT verification is disabled for the function, this application-layer check is mandatory.