Skip to content
Kitbay

clickhouse-logs-queries

Apache-2.0Updated on Nov 11, 2026114,826GitHub stars

A skill from Supabase for writing, reviewing and migrating SQL queries against the ClickHouse-backed logs table behind Supabase's log analytics.

What the skill teaches

A skill from Supabase for writing, reviewing and migrating SQL queries against the ClickHouse-backed logs table behind Supabase's log analytics. It separates two jobs: writing or checking a query for the Logs Explorer, which needs no access to Supabase's code, and wiring a query into the Studio dashboard code, which it hands to a separate reference file for Supabase engineers. For one-off conversions of older BigQuery-style log queries it points to the dashboard's Rewrite to ClickHouse action. It lives in Supabase's own repository, and part of it applies only to work inside that repository.

Capabilities

  • Write and review SQL against Supabase's ClickHouse logs table
  • Migrate older log queries to ClickHouse syntax
  • Wire log queries into the Studio dashboard code