Clickhouse skills

ClickHouse Patterns

affaan-m

Optimize your ClickHouse database for analytics.

ClickHouse Query

civitai

Run ClickHouse queries for analytics and metrics analysis.

ClickHouse Query Performance Reports

posthog

Generate structured reports for slow ClickHouse queries.

C

ClickHouse Autoresearch Campaign

posthog

Optimize ClickHouse queries efficiently on a git branch.

Seed Test Data

langfuse

Generate reproducible test data for Langfuse environments.

ClickHouse Analytics Patterns

davila7

Optimize your analytical workloads with ClickHouse best practices.

O

Optimizing ClickHouse and HogQL Queries

posthog

Streamline your ClickHouse and HogQL query performance.

A

Adding Ingestion Warnings

posthog

Integrate custom ingestion warnings into your event pipeline.

Query ClickHouse via Metabase

posthog

Analyze ClickHouse query logs with Metabase API.

Querying Tophog

posthog

Identify hot actors in your ingestion pipeline.

ClickHouse Migrations

posthog

Streamline your ClickHouse migration processes with best practices.

ClickHouse Analytics Patterns

sickn33

Optimize your ClickHouse queries and data structures.

Write, review, and migrate Supabase logs queries against the ClickHouse-backed `logs` table (the `logs.all.otel` analytics endpoint). Use this whenever a task involves Logs Explorer SQL, the `log_attributes` map, querying a log `source` (edge_logs, postgres_logs, auth_logs, etc.), translating an old BigQuery `cross join unnest(metadata)` logs query to ClickHouse, or wiring analytics log SQL in `apps/studio/data/logs` and `apps/studio/components/interfaces/Settings/Logs`. Reach for it even when the user just says "logs query", "Logs Explorer", or pastes a BigQuery logs query to convert, not only when they name ClickHouse.

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.