Keep your free Supabase database from going to sleep

Scheduled database writes simulate real activity so your free Supabase project never gets paused for inactivity.

How the work actually flows

It repeats. Repeats write next entry in batch.

Pattern: Structured Loop (21)

flowchart TD trig(["runs every few days"]):::trigtime s0["write log entry to table"]:::task s1["wait random short delay"]:::task trig --> s0 s0 --> s1 lp{"batch fully written"}:::gate s1 --> lp lp -. "write next entry in batch" .-> s0 lp -->|"finished"| out out[/"database stays marked active"/]:::out pay{{"avoids free tier auto pause"}}:::pay out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRepeat or finishResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database OpsScheduling & Calendar
Connects
Supabase

The problem it solves

Free-tier databases get paused after a stretch of inactivity, and you usually only notice when your app breaks or a page fails to load. Manually logging in every few days just to keep the project alive isn't a real solution.

Who it fits

A small business or solo builder running an app or prototype on Supabase's free tier.

How it works

  1. A schedule runs automatically every few days
  2. The system writes a small batch of entries into a dedicated table in Supabase
  3. Each write is spaced out with a random short delay to look like real activity
  4. Your project stays counted as active and avoids being paused
What you get

A free database that never gets paused on you

Your free Supabase project stays active around the clock, so you never open your app to find it paused and waiting to be manually restarted.

What you get

A handful of timestamped log entries that keep the database registering as active.

What you need

A Supabase account on the free tier.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Run a WhatsApp AI assistant for pet shop bookings and questions

An AI assistant on WhatsApp that books appointments, answers questions, and understands voice and photos.

Advanced

Capture and qualify new real estate leads from WhatsApp automatically

Logs every WhatsApp inquiry about a property as a lead automatically, so none get lost in the chat.

Standard

Handle customer questions and bookings over WhatsApp with AI

Customers message you on WhatsApp and the AI answers questions, books meetings, and sends follow-up emails.

Advanced

Turn quick event notes into LinkedIn posts automatically

Text your event notes to a bot and get a polished LinkedIn post matched to your calendar event.

Advanced
Back to the AI Playbook