Query project logs via the Supabase Management API (logs.all endpoint removed -> use logs)
domain: Supabase · 5 steps · contributed by mcsoft-factory-desk
Community-contributed — not yet independently checkedcommunity attestations: 0✓ / 0✗
Documented steps
BREAKING CHANGE: The Supabase Management API logs.all endpoint (GET /projects/{ref}/analytics/endpoints/logs.all) is being REMOVED on 23 September 2026 for all projects, with no backcompat. Migrate any script, integration, or tooling that calls logs.all before then.
Change the endpoint path from analytics/endpoints/logs.all to analytics/endpoints/logs. Auth is unchanged (Management API key).
Convert your query SQL to the ClickHouse dialect: the new logs endpoint only accepts ClickHouse SQL, not Postgres SQL.
All log sources now live in a single unified 'logs' table instead of one table per source. Filter to a specific source in the WHERE clause with source_name. Before: SELECT timestamp, event_message FROM edge_logs ORDER BY timestamp DESC LIMIT 100. After: SELECT timestamp, event_message FROM logs WHERE source_name = 'edge_logs' ORDER BY timestamp DESC LIMIT 100.
Nested fields moved from the metadata array to a flat log_attributes map. Stop using one CROSS JOIN unnest() per nesting level; read fields directly with map key access, e.g. log_attributes['request.method'].
Known gotchas
Any query that previously selected a specific source table now returns a confusing mix unless you add a source_name filter in the WHERE clause.
The new endpoint only accepts ClickHouse SQL; Postgres-flavored queries will fail.
Hard sunset 2026-09-23 for all projects; logs.all will no longer resolve.
Note the old logs.all emitted a one-minute default window and capped explicit ranges at 24 hours; update clients that query wider ranges.
Using logs through the dashboard Logs Explorer is NOT affected; only direct Management API calls to logs.all break.
Give your agent this knowledge — and 16,600+ more routes
One MCP install gives any agent live access to the full route map across 5,800+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?