Runs HogQL queries against this project's PostHog data from the terminal using posthog-cli, with bundled scripts for dashboard metadata the CLI itself has no command for.
$ npx skills add debugtheworldbot/keyStats --skill posthog-cli-queries -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install debugtheworldbot/keyStats posthog-cli-queries --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/debugtheworldbot/keyStats.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .claude/skills/posthog-cli-queries && 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 "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .claude/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queriesType 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 debugtheworldbot/keyStats --skill posthog-cli-queries -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install debugtheworldbot/keyStats posthog-cli-queries --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/debugtheworldbot/keyStats.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .agents/skills/posthog-cli-queries && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .agents/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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 debugtheworldbot/keyStats --skill posthog-cli-queries -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install debugtheworldbot/keyStats posthog-cli-queries --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/debugtheworldbot/keyStats.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .cursor/skills/posthog-cli-queries && 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 "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .cursor/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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/debugtheworldbot/keyStats.git --path .agents/skills/posthog-cli-queries--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 debugtheworldbot/keyStats --skill posthog-cli-queries -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install debugtheworldbot/keyStats posthog-cli-queries --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/debugtheworldbot/keyStats.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .gemini/skills/posthog-cli-queries && 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 "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .gemini/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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 debugtheworldbot/keyStats posthog-cli-queriesInstalls 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 debugtheworldbot/keyStats --skill posthog-cli-queries -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/debugtheworldbot/keyStats.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .github/skills/posthog-cli-queries && 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 "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .github/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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 debugtheworldbot/keyStats --skill posthog-cli-queries -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install debugtheworldbot/keyStats posthog-cli-queries --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/debugtheworldbot/keyStats.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/posthog-cli-queries .opencode/skills/posthog-cli-queries && 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 "posthog-cli-queries" agent skill from https://github.com/debugtheworldbot/keyStats/tree/main/.agents/skills/posthog-cli-queries into .opencode/skills/posthog-cli-queries/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "posthog-cli-queries", 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.
posthog-cli-queriesRuns HogQL queries against this project's PostHog data from the terminal using posthog-cli, with bundled scripts for dashboard metadata the CLI itself has no command for.
Before querying, the skill verifies authentication with a trivial query and notes that dashboard API helpers read credentials from a local JSON file rather than any hardcoded project id, even though it names the project's current PostHog environment and region for reference. Event-level queries run directly through posthog-cli's experimental query command with a HogQL string, while dashboard metadata or cached insight results go through two bundled shell scripts because the CLI has no dedicated dashboard command.
A shell-quoting rule calls for wrapping HogQL in single quotes whenever it references a property like $app_version or $os, since double quotes let the shell expand the dollar sign before the CLI sees it. A set of ready-made HogQL queries covers recent events, top events and pageview pages over the last 7 days, click targets, app versions and an OS breakdown, and the skill expects every answer to report the exact command used, the key rows or aggregates, and any caveats such as partial-day data or test-account filtering.
4 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 0bb183d. It shows what the files ask for, not the result of running them.
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.
Ships 2 files in scripts/ (Shell), which the agent can run.
Shell commands in SKILL.md call:
bashjqFrom the folder's file list and the shell code blocks in SKILL.md.
Hosts in commands or code, which the agent is likely to contact:
us.posthog.comFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
PostHog CLI Queries loads about 1.2k tokens when it runs. Until then it costs about 50 tokens; SKILL.md has 375 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.
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); the scripts in this folder are not scanned.
The full file from debugtheworldbot/keyStats at commit 0bb183d, republished under its MIT licence (© debugtheworldbot). 375 words, ~1,193 tokens.
.claude/skills/posthog-cli-queries/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.Query this project's PostHog data from the terminal without guessing command syntax.
posthog-cli must be installed and authenticatedquery:read~/.posthog/credentials.json292804 on https://us.posthog.com, but scripts read the active local credentials instead of hardcoding valuesposthog-cli exp query run 'SELECT 1 AS ok'posthog-cli exp query run '<hogql>'Shell quoting rule:
$app_version or $os, otherwise the shell may expand them before the CLI sees the queryRecent events:
posthog-cli exp query run 'SELECT event, timestamp FROM events ORDER BY timestamp DESC LIMIT 20'Top events in the last 7 days:
posthog-cli exp query run 'SELECT event, count() AS c FROM events WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY event ORDER BY c DESC LIMIT 15'Top pageview pages in the last 7 days:
posthog-cli exp query run "SELECT properties.page_name AS page_name, count() AS c FROM events WHERE event = 'pageview' AND timestamp > now() - INTERVAL 7 DAY GROUP BY page_name ORDER BY c DESC LIMIT 15"Top click targets in the last 7 days:
posthog-cli exp query run "SELECT properties.element_name AS element_name, count() AS c FROM events WHERE event = 'click' AND timestamp > now() - INTERVAL 7 DAY GROUP BY element_name ORDER BY c DESC LIMIT 15"Recent app versions from events:
posthog-cli exp query run 'SELECT properties.$app_version AS app_version, count() AS c FROM events WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY app_version ORDER BY c DESC LIMIT 20'Recent OS breakdown:
posthog-cli exp query run 'SELECT properties.$os AS os, count(DISTINCT person_id) AS users FROM events WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY os ORDER BY users DESC LIMIT 20'Hourly volume in the last 24 hours:
posthog-cli exp query run 'SELECT toStartOfHour(timestamp) AS hour, count() AS c FROM events WHERE timestamp > now() - INTERVAL 24 HOUR GROUP BY hour ORDER BY hour DESC LIMIT 24'List dashboards:
bash .agents/skills/posthog-cli-queries/scripts/dashboard_list.shFetch a dashboard as JSON:
bash .agents/skills/posthog-cli-queries/scripts/dashboard_fetch.sh 1075953Fetch a dashboard summary:
bash .agents/skills/posthog-cli-queries/scripts/dashboard_fetch.sh 1075953 --summaryCurrent known dashboard:
bash .agents/skills/posthog-cli-queries/scripts/dashboard_fetch.sh 1075953 --summarylast_refresh mattersfilterTestAccounts before comparing tiles with each other$os or $app_version has a large null bucket, call out that the property coverage is incompleteapp_open and Application Opened, mention that the taxonomy is splitExtract tile names from a fetched dashboard JSON:
jq -r '.tiles[] | select(.insight != null) | [.id, .insight.id, .insight.name] | @tsv'Show top breakdown rows from one insight result:
jq -r '.tiles[] | select(.insight.id==6334935) | .insight.result[] | [.label, .count, (.data[-1] // 0)] | @tsv'posthog-cli exp query run says missing required scope 'query:read', fix the personal API key scopes first~/.posthog/credentials.json exists and contains host, token, and env_id© debugtheworldbot, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 2 other files (scripts) in .agents/skills/posthog-cli-queries of debugtheworldbot/keyStats.
Open the folder on GitHubat commit 0bb183d
PostHog CLI Queries 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 |
|---|---|---|---|---|---|---|
| PostHog CLI Queries this skilldebugtheworldbot/keyStats | 1.5k | — | ~1.2k | Automated safety check: Pass | MIT | |
| Retentioneering Contributingretentioneering/retentioneering-tools | 920 | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | |
| Retentioneering Product Analyticsretentioneering/retentioneering-tools | 920 | — | ~1.6k | Automated safety check: Pass | Apache-2.0 | |
| Retention Analysisliangdabiao/claude-data-analysis-ultra-main | 290 | 1 repos | ~1.3k | Automated safety check: Notes | None | |
| Feature Analytics Instrumentation Plannermistralai/mistral-vibe | 5.1k | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | |
| Funnel Analysisliangdabiao/claude-data-analysis-ultra-main | 290 | 2 repos | ~781 | Automated safety check: Notes | None |
retentioneering/retentioneering-tools
Help the user turn their Retentioneering ideas, friction reports, bug findings, or feature needs into high-quality upstream contributions: from capturing and validating the idea, through minimal…
retentioneering/retentioneering-tools
Analyze event logs, clickstreams, user paths, product funnels, retention, behavioral segments, transition graphs, step matrices, sequence patterns, and customer journeys using Retentioneering.
liangdabiao/claude-data-analysis-ultra-main
Analyze user retention and churn using survival analysis, cohort analysis, and machine learning.
mistralai/mistral-vibe
Plans which analytics events and properties a new feature needs, checks them against the existing event registry, and verifies them per environment.
liangdabiao/claude-data-analysis-ultra-main
Analyze user conversion funnels, calculate step-by-step conversion rates, create interactive visualizations, and identify optimization opportunities.
linuxfoundation/insights
Add event tracking calls to Vue/Nuxt components in the Insights app using the useTrackEvent composable.
debugtheworldbot/keyStats
Writes a short changelog or release notes by comparing two git tags, defaulting to the latest two version-like tags, from the real commits and changed files.
Categories
Runs HogQL queries against this project's PostHog data from the terminal using posthog-cli, with bundled scripts for dashboard metadata the CLI itself has no command for. Before querying, the skill verifies authentication with a trivial query and notes that dashboard API helpers read credentials from a local JSON file rather than any hardcoded project id, even though it names the project's current PostHog environment and region for reference. Event-level queries run directly through posthog-cli's experimental query command with a HogQL string, while dashboard metadata or cached insight results go through two bundled shell scripts because the CLI has no dedicated dashboard command.
PostHog CLI Queries fits situations like: querying recent PostHog events from the terminal instead of the web UI; getting a breakdown of top pages, click targets or app versions; fetching PostHog dashboard metadata or cached insight results via script.
Run `npx skills add debugtheworldbot/keyStats --skill posthog-cli-queries -a claude-code`. Or copy the skill folder (.agents/skills/posthog-cli-queries in debugtheworldbot/keyStats) into .claude/skills/posthog-cli-queries in your project. Claude Code loads it when a task matches its description.
Run `npx skills add debugtheworldbot/keyStats --skill posthog-cli-queries -a codex`. Or copy the skill folder (.agents/skills/posthog-cli-queries in debugtheworldbot/keyStats) into .agents/skills/posthog-cli-queries in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add debugtheworldbot/keyStats --skill posthog-cli-queries -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/posthog-cli-queries, .gemini/skills/posthog-cli-queries, .github/skills/posthog-cli-queries and .opencode/skills/posthog-cli-queries in your project.
Going by SKILL.md and its folder, PostHog CLI Queries needs a shell for the scripts in its folder and the command-line tools its instructions call (bash and jq). Our summary lists: posthog-cli, installed and authenticated; A personal API key with query:read.
SKILL.md names 1 domain. In commands or code: us.posthog.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.
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. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
PostHog CLI Queries is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 1.2k tokens (SKILL.md is roughly 4.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with PostHog CLI Queries: Retentioneering Contributing (retentioneering/retentioneering-tools, 920 stars), Retentioneering Product Analytics (retentioneering/retentioneering-tools, 920 stars), Retention Analysis (liangdabiao/claude-data-analysis-ultra-main, 290 stars) and Feature Analytics Instrumentation Planner (mistralai/mistral-vibe, 5.1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
debugtheworldbot (a GitHub user) maintains it in debugtheworldbot/keyStats, which has 1,465 GitHub stars. The repository holds 2 skills in this directory. The repository was last updated on October 3, 2026.
Source: debugtheworldbot/keyStats on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.
