What It Is For
Some bugs in a Supabase or PostgREST app never throw, never log and never show a red box. The request works. The page loads. The number looks sure of itself. And nothing happened.
This skill teaches an AI agent to find those bugs. Its main rule is to check by calling the system, not by reading the code. The skill says most of these bugs were hidden in the source and plain on the first real call.
Who Should Use It
Developers with a Supabase or PostgREST app. Load it when:
- a save does not save, but shows no error
- a scheduled job looks healthy but does no work
- a column shows up as undefined or as a fallback value
- you debug a 400 or a 300 from PostgREST
- you write a loop over customer or job records
- you review supabase-js queries
How Clickflame Built It
Clickflame wrote this skill from production outages on a Supabase app with many tenants. The skill says each one ran for days or weeks while every dashboard said fine.
A few examples from its text. A quotes list showed all fifty quotes as closed, because the page never asked for the expiry column. A stored timestamp with a plus sign broke a URL, and no inbound lead was answered for three days. A task ran 146 times and never once worked, while the board showed it running on schedule.
The skill sums up the cause in one line. The error path gave back a value that looked just like a normal quiet result.
What It Checks
- Updates that match zero rows and still return 200
- Columns a page uses but never selects, so a fallback takes over
- Stored timestamps that turn into a 400 when put in a URL
- HTTP 300 answers, which mean an unclear embed, not a redirect
- Column defaults that turn into null on the service key
- Scheduled tasks with many runs and zero wins
- One bad record that fails on every retry of every tick
- Routes that 404 after a rebuild, and CORS checks that fail the same way
- Two entry points that run the same handler twice
Each section ends with a way to prove it, like adding a select to a write and checking how many rows came back.
How to Install It
Run this in your terminal. It adds this skill for your AI coding agent:
npx skills add halltony85-source/clickflame-agent-skills@postgrest-silent-failures -g -yOr add all four Clickflame skills at once:
npx skills add halltony85-source/clickflame-agent-skills -g -yThen start a new session. The agent loads the skill when a task matches it. New to skills? Start with what an agent skill is.
See It on GitHub
The full skill is free to read before you install it. Read PostgREST Silent Failures on GitHub. It is part of Clickflame's agent skills repo, under the MIT license.