supabase-fn-logs

---
name: supabase-fn-logs
description: Query Supabase Edge Function invocations and log lines for the DFL prod project (`yoojxnggaxcqtsyjdrdx`) via the Logflare-backed Analytics API. **Use this skill instead of calling `bash /root/.claude/skills/supabase-fn-logs/run.sh` directly** or hand-rolling the Analytics API curl. Skill-tool route handles project ID, auth, time-range params, and JSON pagination. Use for edge function call counts, error rates, console output, and to verify the 7-day soak gate for retired functions (e.g. invocations of a retired function should drop to zero). Trigger phrases — "supabase fn logs", "edge function logs", "function invocations supabase", "how many times was fn X called", "show me logs for edge function X", "console output of <fn>", "errors on supabase function", "fn X call count", "verify <fn> retired (zero invocations)", "soak gate check", "supabase edge function errors", "logs da edge function X", "quantas vezes <fn> rodou", "function call rate", "is <fn> still being called". Skip for non-edge-function Supabase logs (use `supabase-helpers` SELECT against logs tables if accessible) and for DB query logs (use Supabase dashboard).
license: MIT
---

# supabase-fn-logs

Wraps the Supabase Analytics API (Logflare-backed BigQuery) to query edge function invocations and log lines for DFL prod.

## Trigger phrases

- "supabase fn logs", "edge function logs", "function invocations supabase"
- "how many times was fn X called"
- "show me logs for edge function X"
- "verify dfl-publisher-generate-title-desc has zero invocations" (7-day soak gate)
- "function_edge_logs", "function_logs"

## Auto-trigger

When claude-main needs to verify the 7-day soak gate from the drift cleanup plan:
`dfl-publisher-generate-title-desc` invocations should drop to zero after retirement.
Run: `./query.sh invocations dfl-publisher-generate-title-desc --since 7d`

## CLI usage

```bash
cd /root/.claude/skills/supabase-fn-logs

# Count invocations for a function
./query.sh invocations <fn_name> [--since 7d|24h|1h]

# Show log lines (console output, errors, shutdowns)
./query.sh logs <fn_name> [--limit 50] [--since 1h]

# Examples
./query.sh invocations transcribe-audio --since 24h
./query.sh invocations dfl-publisher-generate-title-desc --since 7d
./query.sh logs dfl-github-webhook --limit 20 --since 1h
```

## Auth

Fetches `SUPABASE_ACCESS_TOKEN` from Infisical at `/supabase/SUPABASE_ACCESS_TOKEN` via `credentials-lookup`. Never written to disk.

## API used

- **Analytics endpoint:** `GET https://api.supabase.com/v1/projects/yoojxnggaxcqtsyjdrdx/analytics/endpoints/logs.all`
  - Query params: `sql=<BigQuery SQL>`, `iso_timestamp_start`, `iso_timestamp_end`
  - **NOT** the Management API `/functions/{slug}/metrics` — that endpoint returns 404 (does not exist on this plan)
  - **NOT** POST body — GET with URL-encoded `sql=` param is the working form

## Log tables (BigQuery-backed)

- `function_edge_logs` — one row per invocation: `event_message` (method|status|url), `metadata[0].function_id`, `metadata[0].execution_time_ms`, `metadata[0].response[0].status_code`
- `function_logs` — one row per log event (console.log, console.error, shutdown, boot): `event_message`, `metadata[0].event_type`, `metadata[0].level`

Filter by function name: `WHERE event_message LIKE '%/functions/v1/<fn_name>%'`
Filter by function_id: `WHERE metadata[0].function_id = '<uuid>'` (use after resolving slug→id via Management API)

## Drift signals

- **Management API `/functions/{slug}/metrics`** — returns 404. This endpoint does not exist in the current Supabase plan or API version.
- **POST body for analytics** — returns 404. Only GET with `sql=` query param works.
- **`SELECT *` is blocked** — analytics returns `restricted wildcard (*) in a result column`. Always name columns explicitly.
- **`metadata.request.path`** — invalid BigQuery syntax (it's an ARRAY). Use `event_message LIKE '%..%'` to filter by URL.
- **Rate limits** — not encountered during initial testing (2026-05-04). The analytics API is BigQuery-backed; very wide time windows + large result sets may time out.

## Soak gate use case

To verify `dfl-publisher-generate-title-desc` retirement (drift cleanup plan):

```bash
./query.sh invocations dfl-publisher-generate-title-desc --since 7d
# Success criterion: count = 0
# If count > 0: function is still being called — retirement is blocked
```