SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute…
Install Analyzing Experiment Query Performance
$ npx skills add PostHog/posthog --skill analyzing-experiment-query-performance -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install PostHog/posthog analyzing-experiment-query-performance --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/analyzing-experiment-query-performance .claude/skills/analyzing-experiment-query-performance && 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 "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .claude/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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/analyzing-experiment-query-performanceType 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 analyzing-experiment-query-performance -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install PostHog/posthog analyzing-experiment-query-performance --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/analyzing-experiment-query-performance .agents/skills/analyzing-experiment-query-performance && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .agents/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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 analyzing-experiment-query-performance -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install PostHog/posthog analyzing-experiment-query-performance --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/analyzing-experiment-query-performance .cursor/skills/analyzing-experiment-query-performance && 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 "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .cursor/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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/analyzing-experiment-query-performance--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 analyzing-experiment-query-performance -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install PostHog/posthog analyzing-experiment-query-performance --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/analyzing-experiment-query-performance .gemini/skills/analyzing-experiment-query-performance && 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 "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .gemini/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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 analyzing-experiment-query-performanceInstalls 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 analyzing-experiment-query-performance -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/analyzing-experiment-query-performance .github/skills/analyzing-experiment-query-performance && 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 "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .github/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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 analyzing-experiment-query-performance -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 analyzing-experiment-query-performance --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/analyzing-experiment-query-performance .opencode/skills/analyzing-experiment-query-performance && 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 "analyzing-experiment-query-performance" agent skill from https://github.com/PostHog/posthog/tree/master/.agents/skills/analyzing-experiment-query-performance into .opencode/skills/analyzing-experiment-query-performance/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analyzing-experiment-query-performance", 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
analyzing-experiment-query-performance- GitHub stars
- 40k
- Token cost
- ~3.7k tokens
- SKILL.md length
- 1,384 words
- Files
- 1
- Skills in repo
- 252
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute…
- Works in 5 steps: Headline first: precompute_overview at… → Localize: anything off → slowest_queries… → Drill to ground truth: for a specific… → …
- Investigating slow
- SKILL.md covers Environment, Authentication, Untrusted data and Endpoints, plus 5 more sections
- Calls curl and jq; reaches us.posthog.com and eu.posthog.com
What it does
Analyzing Experiment Query Performance is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute read/build health, and preaggregation cache footprint. Covers prod-US and prod-EU via a queryperformance:read personal API key, all query params, and response field semantics (exception codes, exposure paths, precompute skip reasons, job states). Use when investigating slow or failing experiment queries, precompute…
Its SKILL.md is about 3.7k 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 Query optimization. It works with 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
- Investigating slow
- Failing experiment queries
- Precompute regressions
- 307/159/241 errors
Example prompts
- “/analyzing-experiment-query-performance”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- Headline first: precompute_overview at 24h in both regions.
- Localize: anything off → slowest_queries with a targeted filter
- Drill to ground truth: for a specific query_id, the full query_log row
- Result-consistency questions (precomputed vs direct results diverging) are out of scope here —
- In any writeup, cite query_id, team_id, and experiment_id so others can reproduce.
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:
curljq
From the folder's file list and the shell code blocks in SKILL.md.
Network
Hosts in commands or code, which the agent is likely to contact:
us.posthog.comeu.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
Analyzing Experiment Query Performance loads about 3.7k tokens when it runs. Until then it costs about 179 tokens; SKILL.md has 1,384 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,384 words (~3,730 tokens).
“The /experiments/staff scene (staff-only UI, "Experiments staff tools") is backed by a set of GET endpoints that are also callable directly with a personal API key. They return the exact data the UI renders, sourced from ClickHouse query_log_archive (experiment queries…”
- name
- analyzing-experiment-query-performance
Files
Just SKILL.md in .agents/skills/analyzing-experiment-query-performance 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
Analyzing Experiment Query Performance 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 |
|---|---|---|---|---|---|---|
| Analyzing Experiment Query Performance this skillPostHog/posthog | 40k | — | ~3.7k | Automated safety check: Pass | Custom licence | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 11 repos | ~3.3k | Automated safety check: Pass | None | |
| Cloud Trace Queryinggoogle/skills | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | |
| Query Engine Designrevfactory/claude-code-harness | 120 | — | ~474 | Automated safety check: Pass | None | |
| Query Plan Snapshot CLIeclipse-rdf4j/rdf4j | 420 | — | ~1.5k | Automated safety check: Pass | BSD-3-Clause | |
| Wp Acf And Content Modelingjorgerosal/wordpress-skills | 101 | — | ~3.2k | Automated safety check: Pass | MIT |
Similar skills
- Official
Cloud Trace Querying
google/skills
Query Cloud Trace spans, filter by latency thresholds or error status, correlate distributed traces with Cloud Logging, and diagnose latency bottlenecks across Google Cloud services.
Query Engine Design
revfactory/claude-code-harness
SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.
Query Plan Snapshot CLI
eclipse-rdf4j/rdf4j
Use QueryPlanSnapshotCli to capture and compare RDF4J query plans, then assess likely performance improvements/regressions from execution verification and semantic plan diffs.
Wp Acf And Content Modeling
jorgerosal/wordpress-skills
WordPress ACF and content modeling review. An agent skill from jorgerosal/wordpress-skills.
Jpa Patterns
affaan-m/ECC
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
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 Analyzing Experiment Query Performance
What does Analyzing Experiment Query Performance do?
Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute…. Analyzing Experiment Query Performance is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute read/build health, and preaggregation cache footprint.
When should I use Analyzing Experiment Query Performance?
Analyzing Experiment Query Performance fits situations like: investigating slow; failing experiment queries; precompute regressions; 307/159/241 errors.
How do I install Analyzing Experiment Query Performance in Claude Code?
Run `npx skills add PostHog/posthog --skill analyzing-experiment-query-performance -a claude-code`. Or copy the skill folder (.agents/skills/analyzing-experiment-query-performance in PostHog/posthog) into .claude/skills/analyzing-experiment-query-performance in your project. Claude Code loads it when a task matches its description.
How do I install Analyzing Experiment Query Performance in Codex?
Run `npx skills add PostHog/posthog --skill analyzing-experiment-query-performance -a codex`. Or copy the skill folder (.agents/skills/analyzing-experiment-query-performance in PostHog/posthog) into .agents/skills/analyzing-experiment-query-performance in your project. Codex loads it when a task matches its description.
Can I use Analyzing Experiment Query Performance 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 analyzing-experiment-query-performance -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/analyzing-experiment-query-performance, .gemini/skills/analyzing-experiment-query-performance, .github/skills/analyzing-experiment-query-performance and .opencode/skills/analyzing-experiment-query-performance in your project.
What does Analyzing Experiment Query Performance need to run?
Going by SKILL.md and its folder, Analyzing Experiment Query Performance needs the command-line tools its instructions call (curl and jq).
Does Analyzing Experiment Query Performance access the network?
SKILL.md names 2 domains. In commands or code: us.posthog.com and eu.posthog.com; the agent is likely to contact these when it follows the instructions. This is read from the text; nothing was executed.
Is Analyzing Experiment Query Performance 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 Analyzing Experiment Query Performance use?
Analyzing Experiment Query Performance 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 Analyzing Experiment Query Performance use?
About 3.7k tokens (SKILL.md is roughly 15k 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 Analyzing Experiment Query Performance?
Skills that share tags, products or a category with Analyzing Experiment Query Performance: SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), Cloud Trace Querying (google/skills, 21k stars), Query Engine Design (revfactory/claude-code-harness, 120 stars) and Query Plan Snapshot CLI (eclipse-rdf4j/rdf4j, 420 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Analyzing Experiment Query Performance?
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.