Keeper Stress Analysis
ClickHouse/ClickHouse
Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.
ClickHouse migration patterns and rules. An agent skill from PostHog/posthog.
Install Clickhouse Migrations
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install PostHog/posthog clickhouse-migrations --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .claude/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .claude/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrationsType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install PostHog/posthog clickhouse-migrations --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .agents/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .agents/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install PostHog/posthog clickhouse-migrations --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .cursor/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .cursor/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/PostHog/posthog.git --path .agents/skills/clickhouse-migrations--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install PostHog/posthog clickhouse-migrations --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .gemini/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .gemini/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install PostHog/posthog clickhouse-migrationsInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .github/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .github/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add PostHog/posthog --skill clickhouse-migrations -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install PostHog/posthog clickhouse-migrations --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/clickhouse-migrations .opencode/skills/clickhouse-migrations && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "clickhouse-migrations" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/clickhouse-migrations into .opencode/skills/clickhouse-migrations/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clickhouse-migrations", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
clickhouse-migrations- GitHub stars
- 40k
- Token cost
- ~3k tokens
- SKILL.md length
- 1,382 words
- Files
- 1
- Skills in repo
- 252
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
ClickHouse migration patterns and rules. An agent skill from PostHog/posthog.
- Works in 3 steps: Use the ClickHouse MCP to check each of… → When precedents disagree, follow the… → State in the PR description which…
- Modifying ClickHouse migrations
- Calls bash
- Tasks that involve Data warehousing
What it does
Clickhouse Migrations is an agent skill from PostHog/posthog, published by the product's own GitHub organization. ClickHouse migration patterns and rules. Use when creating or modifying ClickHouse migrations.
Its SKILL.md is about 3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering Data warehousing. It works with ClickHouse and PostHog. The repository describes itself as: :hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error…
When your agent uses it
- Modifying ClickHouse migrations
- Tasks that involve Data warehousing
Example prompts
- “/clickhouse-migrations”
Requirements
- Python 3
Workflow steps
3 steps, taken from the first numbered list in SKILL.md.
- Use the ClickHouse MCP to check each of dev, prod-us and prod-eu: where comparable tables live,
- When precedents disagree, follow the newest migration for that table family and confirm it matches
- State in the PR description which cluster each new object lands on, and name the reference migration
What it can do on your machine
Read from SKILL.md and the folder at commit 10f9ad7. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
bash
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
runbooks.posthog.com
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Clickhouse Migrations loads about 3k tokens when it runs. Until then it costs about 29 tokens; SKILL.md has 1,382 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,382 words (~2,977 tokens).
“Read posthog/clickhouse/migrations/AGENTS.md for comprehensive patterns, cluster setup, examples, and ingestion layer details.”
- name
- clickhouse-migrations
Files
Just SKILL.md in .agents/skills/clickhouse-migrations of PostHog/posthog.
Open the folder on GitHubat commit 10f9ad7
Used in 1 other repository
We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders. This page covers the copy in PostHog/posthog, which our catalogue first saw on October 7, 2026.
Compare with similar skills
Clickhouse Migrations next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Clickhouse Migrations this skillPostHog/posthog | 40k | — | ~3k | Automated safety check: Pass | Custom licence | |
| Keeper Stress AnalysisClickHouse/ClickHouse | 50k | — | ~4.7k | Automated safety check: Pass | Apache-2.0 | |
| Perf ComparisonClickHouse/ClickHouse | 50k | — | ~3.9k | Automated safety check: Notes | Apache-2.0 | |
| Patch Release CheckClickHouse/ClickHouse | 50k | — | ~4k | Automated safety check: Notes | Apache-2.0 | |
| Clickhouse Architecture Advisorvemetric/vemetric | 394 | 2 repos | ~791 | Automated safety check: Pass | Apache-2.0 | |
| Decompress BinaryClickHouse/ClickHouse | 50k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 |
Similar skills
Perf Comparison
ClickHouse/ClickHouse
Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.
Patch Release Check
ClickHouse/ClickHouse
Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…
Clickhouse Architecture Advisor
vemetric/vemetric
MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.
Decompress Binary
ClickHouse/ClickHouse
Extract the inner ELF from a ClickHouse self-extracting clickhouse binary, including when its architecture differs from the host (e.g.
Good PRs
ClickHouse/ClickHouse
Show a report of open ClickHouse PRs whose only non-green CI check is "CH Inc sync" (or that are fully green) — i.e.
More from PostHog/posthog
All 252 skills in this repo- Official
Authoring Log Alerts
PostHog/posthog
Author useful, low-noise log alerts on services in a PostHog project.
- Official
Autoresolving PR Conflicts
PostHog/posthog
Operating procedure for the conflict-autoresolver agent: sweep open PostHog/posthog PRs that conflict with master, resolve the trivial conflicts (generated artifacts deterministically, source…
- Official
Diagnosing Stacktrace Symbolication
PostHog/posthog
Help users debug PostHog Error Tracking stack-trace symbolication for any supported platform — JavaScript/TypeScript web, React Native (Hermes), Android (Proguard / R8), or iOS / macOS (dSYM).
- Official
Exploring Apm Traces
PostHog/posthog
Investigates distributed application performance using PostHog APM (OpenTelemetry span) data via MCP.
- Official
Exploring LLM Traces
PostHog/posthog
Debug and inspect LLM/AI agent traces using PostHog's MCP tools.
- Official
Investigate Metric
PostHog/posthog
Diagnose why a product metric changed (dropped, spiked, or plateaued) by orchestrating breakdowns, actors, paths, lifecycle, retention, and annotations queries.
Related
Works with
Categories
Questions about Clickhouse Migrations
What does Clickhouse Migrations do?
ClickHouse migration patterns and rules. An agent skill from PostHog/posthog. Clickhouse Migrations is an agent skill from PostHog/posthog, published by the product's own GitHub organization. ClickHouse migration patterns and rules.
When should I use Clickhouse Migrations?
Clickhouse Migrations fits situations like: modifying ClickHouse migrations; tasks that involve Data warehousing.
How do I install Clickhouse Migrations in Claude Code?
Run `npx skills add PostHog/posthog --skill clickhouse-migrations -a claude-code`. Or copy the skill folder (.agents/skills/clickhouse-migrations in PostHog/posthog) into .claude/skills/clickhouse-migrations in your project. Claude Code loads it when a task matches its description.
How do I install Clickhouse Migrations in Codex?
Run `npx skills add PostHog/posthog --skill clickhouse-migrations -a codex`. Or copy the skill folder (.agents/skills/clickhouse-migrations in PostHog/posthog) into .agents/skills/clickhouse-migrations in your project. Codex loads it when a task matches its description.
Can I use Clickhouse Migrations in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add PostHog/posthog --skill clickhouse-migrations -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/clickhouse-migrations, .gemini/skills/clickhouse-migrations, .github/skills/clickhouse-migrations and .opencode/skills/clickhouse-migrations in your project.
What does Clickhouse Migrations need to run?
Going by SKILL.md and its folder, Clickhouse Migrations needs the command-line tools its instructions call (bash). Our summary lists: Python 3.
Does Clickhouse Migrations access the network?
SKILL.md names 1 domain. As links in the text: runbooks.posthog.com. This is read from the text; nothing was executed.
Is Clickhouse Migrations safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Clickhouse Migrations use?
Clickhouse Migrations has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does Clickhouse Migrations use?
About 3k tokens (SKILL.md is roughly 12k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Clickhouse Migrations?
Skills that share tags, products or a category with Clickhouse Migrations: Keeper Stress Analysis (ClickHouse/ClickHouse, 50k stars), Perf Comparison (ClickHouse/ClickHouse, 50k stars), Patch Release Check (ClickHouse/ClickHouse, 50k stars) and Clickhouse Architecture Advisor (vemetric/vemetric, 394 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Clickhouse Migrations?
PostHog (a GitHub organization, an official publisher) maintains it in PostHog/posthog, which has 40,182 GitHub stars. The repository holds 252 skills in this directory. The repository was last updated on October 8, 2026.
Source: PostHog/posthog on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.