My Supabase keepalive was working. The project paused anyway.

Description and use

A daily keep‑alive workflow with retries and alerts keeps a free Supabase project from pausing.

Problem

Supabase free projects pause when activity is low; a keep‑alive workflow was insufficient and silent failures caused the project to pause.

Outcome

The updated workflow keeps the Supabase project awake, provides audible failure alerts, and ensures daily traffic to satisfy Supabase’s activity threshold.

Workflow

• Schedule cron at 09:17 UTC daily
• Run three SELECT queries to _keepalive table with curl retries
• If any query fails, exit and trigger alert job
• Alert job opens or comments on a GitHub issue labeled supabase-keepalive

Evidence

Supabase pauses free projects that look inactive.

Source

The run history had five runs in total: 14 Sep success, 16 Sep success, 21 Sep success, 26 Sep failed: curl: (6) Could not resolve host, 1 Oct failed: same error.

Source