All skills
writing-clickhouse-queries
Write new ClickHouse queries in PostHog product code, including picking a Workload and designing tables.
- Part of PostHog/posthog
- 146 installs
- Developer Tools · Backend
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.
More Backend skills
See all- lark-shared497kHandles Lark CLI login, identity, permissions and authorization status.
- lark-event489kStreams Lark real-time events like messages, approvals and meetings for bots and subscribers.
- golang-pro19.8kWrites concurrent Go services with goroutines, channels, gRPC or REST, and profiles performance.
- php-pro16.4kBuilds modern PHP applications with strict typing, Laravel or Symfony, tests and REST or GraphQL APIs.
Also in this pack
- react-doctor511Diagnoses and fixes React codebase health issues, including performance problems, security gaps and code quality.
- hogli267Explains the PostHog developer CLI and repo tooling for running, building, testing, and linting.
- clickhouse-migrations266Writes and modifies ClickHouse database migrations following project rules.
- survey-sdk-audit255Audits survey SDK features and version requirements, then implements survey changes across backend, UI, and SDKs.