All skills
clickhouse-migrations
Write a ClickHouse migration that places tables on the correct cluster and passes schema checks.
- Part of PostHog/posthog
- 266 installs
- Developer Tools · Backend
When to use it
You have a new table or schema change to ship and need to pick the right node role and keep HCL in sync.
For example
You say
Use clickhouse-migrations to add a migration for a new sharded events rollup table, and tell me which cluster it belongs on.
You get
- Migration file
- Node role choice
- HCL layer update
How it works
- Migration PRs must contain only migration files, SQL definitions, and related tests.
- Cloud-only tables still need a local schema entry in schema.py.
- Dropping a column is a two-step process started by the ClickHouse team.
Before installing
Checking live dev, prod-us and prod-eu clusters requires the ClickHouse MCP (Housekeeper) setup.
More Backend skills
See all- 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.
- cuopt-routing-api-python2.3kBuilds and solves vehicle routing, traveling salesman, and pickup-delivery problems in Python with cuOpt.
- cuopt-server-api-python2.2kStarts the cuOpt REST server and calls its endpoints from Python or curl.
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.
- survey-sdk-audit255Audits survey SDK features and version requirements, then implements survey changes across backend, UI, and SDKs.
- django-migrations252Guides safe Django and Postgres migration work, including non-blocking schema changes, backfills and model deletions.