supabase / mcp / 29496062367

96%

push

github

feat: support edge function runtime logs in get_logs (#326)

## Problem

The `get_logs` MCP tool only exposes edge function **invocation** logs
(`function_edge_logs`). Edge function **runtime** logs — `console.log`
output, the dashboard's per-function "Logs" view (`function_logs`) — are
unreachable via MCP. Reported independently by two users in April;
confirmed as a gap in `logs.ts` (Linear: AI-651).

The tool also still queries the deprecated BigQuery `logs.all` endpoint
(Linear: AI-890 / platform PR supabase/platform#35096 context).

## Changes

- **New `edge-function-runtime` service** on `get_logs`, returning edge
function console output. `edge-function` keeps meaning invocation logs
(backward compatible).
- **ClickHouse migration (cloud):** `getLogs` now calls
`/v1/projects/{ref}/analytics/endpoints/logs` with ClickHouse SQL
against the unified `logs` table (new `getClickHouseLogQuery` builder).
The endpoint already exists in the generated management API types — no
type regen.
- **BigQuery builder removed.** The legacy `getLogQuery` had no
production callers (only `getClickHouseLogQuery` is wired into
`getLogs`), and self-hosted routes through Studio's own copy of these
queries, not this package. Dropped the builder, its tests, and the stale
`logs.all` MSW handler (thanks @mattrossman for the catch).
- **Prompt-injection guardrails:** all `get_logs` output is now wrapped
in the same UUID-salted `<untrusted-data>` boundary as `execute_sql`,
extracted into a shared `wrapWithUntrustedDataBoundary` helper (log
content is arbitrary user text).
- **Tool description** now names both edge function log kinds, states
the 24h default window, and advises correlate-don't-poll.
- **Tests:** MSW handler for the new endpoint, service iteration
extended, untrusted-data boundary asserted, new `logs.test.ts` covering
the ClickHouse builder for every service.

## Notes for reviewers

- `branch-action` maps to `source = 'workflow_run_logs'` with
`log_attributes['wor... (continued)

325 of 359 branches covered (90.53%)

Branch coverage included in aggregate %.

2794 of 2879 relevant lines covered (97.05%)

42.62 hits per line