crontap-supabase-edge-function-cron
/crontap-supabase-edge-function-cron
Schedule a protected Supabase Edge Function or HTTP-facing RPC through Crontap with an external clock and observable delivery. Use when a user needs recurring Supabase work with retries, history, or failure alerts.
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 10
No signals detected. Repository changed on 16.09.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Schedule a protected Supabase Edge Function or HTTP-facing RPC through Crontap with an external clock and observable delivery. Use when a user needs recurring Supabase work with retries, history, or failure alerts.
Original author description
Schedule a protected Supabase Edge Function or HTTP-facing RPC through Crontap with an external clock and observable delivery. Use when a user needs recurring Supabase work with retries, history, or failure alerts.
How it works
- Prerequisites
- Function security pattern
- Workflow
- MCP example
- REST fallback
- Verification
- Safety and plan limits
- Troubleshooting
- References
SKILL.md preview
---
name: crontap-supabase-edge-function-cron
description: >
Schedule a protected Supabase Edge Function or HTTP-facing RPC through
Crontap with an external clock and observable delivery. Use when a user needs
recurring Supabase work with retries, history, or failure alerts.
license: MIT
metadata:
version: "1.0.0"
group: patterns-migrations
order: 10
title: Schedule a Supabase Edge Function
summary: Call a Supabase Edge Function on a dependable cadence without exposing service credentials in logs.
bestFor: Protected Edge Functions, RPCs, and database jobs
guide: https://crontap.com/guides/supabase-cron-jobs
guideTitle: Supabase cron jobs
tools: create_schedule
---
# 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
Before using the required tools, check whether they are available. If any are
missing, stop and offer the user exactly two choices:
1. Connect Crontap MCP at `https://mcp.crontap.com/mcp`. MCP access works on
every Crontap tier.
2. Configure `$CRONTAP_CLIENT_ID` and `$CRONTAP_API_KEY` for the raw API. Raw
API access requires Ultra.
Do not silently choose a path or continue until the user selects one.
- 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.
Keep the function response bounded. For long work, durably enqueue the job and
return success only after the queue accepts it.
## Workflow
1. Deploy the Edge Function and configure its cron secret.
2. Call it manually from a controlled environment with and without the secret.
3. Confirm expected status codes and idempotency behavior.
4. Create the Crontap schedule with the deployed HTTPS URL.
5. Verify the resolved cadence and first retained run.
## MCP example
```json
{
"tool": "create_schedule",
"arguments": {
"url": "https://project-ref.supabase.co/functions/v1/nightly-cleanup",
"text": "every day at 02:00",
"timezone": "UTC",
"method": "POST",
"headers": {
"Authorization": "Bearer <cron-secret-from-secure-store>",
"Content-Type": "application/json"
},
"body": {
"source": "crontap"
},
"label": "Supabase nightly cleanup"
}
}
```
Use the real project reference from the Supabase project URL. Do not place a
secret in the function URL or JSON body.
## REST fallback
REST requires Ultra API access:
```bash
curl --fail-with-body https://api.crontap.com/v1/schedule \
-X POST \
-H "ClientId: $CRONTAP_CLIENT_ID" \
-H "ApiKey: $CRONTAP_API_KEY" \
-H "Content-Type: application/json" \
--data '{
"url": "https://project-ref.supabase.co/functions/v1/nightly-cleanup",
"interval": "0 2 * * *",
"timezone": "UTC",
"verb": "POST",
"headers": {
"Authorization": "Bearer <cron-secret-from-secure-store>",
"Content-Type": "application/json"
},
"data": {"source": "crontap"},
"label": "Supabase nightly cleanup"
}'
```
Prefer MCP when available.
## Verification
- A request without the cron secret returns 401 before side effects.
- A request with the secret returns the intended success status.
- Two requests for the same logical period create one durable side effect.
- The Crontap history outcome matches Supabase function logs at the same time.
## Safety and plan limits
- Do not use `SUPABASE_SERVICE_ROLE_KEY` as the scheduler credential.
- Scope the function to the narrow recurring operation.
- If the Supabase project can pause, remember that an external clock exposes
the failure but cannot make an unavailable project execute.
- If Crontap rejects the cadence or capacity, present the returned four-option
ladder and smallest viable option.
## Troubleshooting
- Supabase 401 means gateway or function authorization rejected the request.
- Supabase 404 usually means the project reference, function slug, or deploy
environment is wrong.
- A 2xx with missing work requires application logs and an idempotency-record
check.
- Timeouts are better fixed with durable queueing than aggressive retries.
## References
- [Crontap Agent Skills catalogue](https://crontap.com/skills)
- [Supabase cron jobs](https://crontap.com/guides/supabase-cron-jobs)
- [Supabase Edge Function cron jobs](https://crontap.com/use-cases/cron-jobs-for-supabase-edge-functions)
- [Cron troubleshooting](https://crontap.com/guides/cron-troubleshooting)
- [Live REST API reference](https://api.crontap.com/docs/)
Versions
The database has no other skills named crontap-supabase-edge-function-cron.
Database snapshot: 13.11.2026 · package version c09995287be2 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 1 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100crontap-schedule-http-job
Create, update, and verify recurring Crontap HTTP requests with cron or plain English, timezones, headers, and JSON bodies. Use when a user wants to schedule a webhook, API call, or cloud function through MCP or REST. - 100crontap-replace-github-actions-cron
Replace a GitHub Actions schedule trigger with a Crontap HTTP dispatch while keeping the workflow, runner, and logs on GitHub. Use when a user needs a timezone-aware external clock or wants to avoid scheduled-workflow drift. - 100supabase-cost-tuning
Optimize Supabase costs through plan selection, database tuning, storage cleanup, connection pooling, and Edge Function optimization. Use when analyzing Supabase billing, reducing costs, right-sizing compute, or implementing usage tracking and budget alerts. Trigger with phrases… - 90lovable-cloud-edge-functions
Supabase edge function authentication, config.toml, and Lovable Cloud deployment. TRIGGER when: adding, modifying, or reviewing an edge function in a Lovable Cloud project, or modifying a file that configures one (e.g. supabase/config.toml) or invokes one (e.g. pg_cron). DO NOT… - 100build-supabase-edge-function
Use when logic must run server-side next to Supabase — a webhook, a cron or database-triggered job, a third-party call with secrets, or an API for non-Next clients — and you must choose and build an Edge Function with caller auth, CORS, secrets and tests. - 95supabase-cli
This skill should be used when user asks to "use supabase CLI", "supabase init", "supabase start", "run migrations", "deploy edge functions", "manage Supabase project", or works with the supabase command-line tool for local development and project management.