Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

writing-clickhouse-queries

Write new ClickHouse queries in PostHog product code, including picking a Workload and designing tables.

When to use it

You're adding a QueryRunner or ClickHouse call site and need to decide which Workload tag it should pass.

For example

You say

Use writing-clickhouse-queries to add a QueryRunner for a new product's events table and pick its Workload.

You get
  • QueryRunner subclass
  • Workload choice with rationale
  • Table design notes

How it works

  • Explains how to choose between ONLINE, OFFLINE, LOGS, and ENDPOINTS for each call site.
  • Covers materialized columns, skip indexes, and row ID format for new tables.