New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Official agent skill

Querying Posthog Data

by PostHog in PostHog/posthog

Explains how to query PostHog data, defaulting to typed runners for supported product analytics.

OfficialCustom licenceAuto-check passedData & Analytics

Install Querying Posthog Data

skills CLI
$ npx skills add PostHog/posthog --skill querying-posthog-data -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install PostHog/posthog querying-posthog-data --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .claude/skills && cp -r skills-src/products/posthog_ai/skills/querying-posthog-data .claude/skills/querying-posthog-data && rm -rf skills-src

Use ~/.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/

Facts

Skill name
querying-posthog-data
GitHub stars
40k
Token cost
~4.1k tokens
SKILL.md length
1,814 words
Files
67 (incl. references)
Skills in repo
252
Repo updated
First seen
Licence
Custom licence

At a glance

Explains how to query PostHog data, defaulting to typed runners for supported product analytics.

  • Works in 3 steps: Read the appropriate schema reference… → Use posthog:execute-sql to query the… → Use the dedicated read tool for that…
  • Aggregate PostHog entities
  • SKILL.md covers Choose the query path, Render query results, When to use this skill and Data Schema, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Querying Posthog Data is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Explains how to query PostHog data, defaulting to typed runners for supported product analytics. Read it before you write HogQL/SQL. Also read it before you call execute-sql against PostHog. Use it to find or aggregate PostHog entities. These entities include insights, dashboards, cohorts, feature flags, experiments, surveys, hog flows, warehouse data, and persons. Use it for trends, funnels, retention, lifecycle, paths, stickiness, web analytics, error tracking, logs, sessions, and LLM traces. Before you…

Its SKILL.md is about 4.1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 67 other files, including reference files (for example `references/example-llm-traces-list.md` and `references/example-observability-correlation.md`).

It sits in Data & Analytics, covering SQL and Product analytics. It works with PostHog and SQL. 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

  • Aggregate PostHog entities
  • Tasks that involve SQL
  • Tasks that involve Product analytics

Example prompts

  • “Use the querying-posthog-data skill to explain how to query PostHog data, defaulting to typed runners for supported product analytics”
  • “/querying-posthog-data”

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. Read the appropriate schema reference under Data Schema to understand the entity's table and columns.
  2. Use posthog:execute-sql to query the system table and find the matching entity (typically returning its ID).
  3. Use the dedicated read tool for that entity type (e.g. posthog:insight-get, posthog:dashboard-get) to retrieve the full entity by ID.

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

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    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

Querying Posthog Data loads about 4.1k tokens when it runs, and up to ~61k if it reads all its reference files. Until then it costs about 237 tokens; SKILL.md has 1,814 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~237
When it runs · the whole SKILL.md, loaded when a task matches
~4.1k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~61k

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,814 words (~4,107 tokens).

“The guidelines explain SQL syntax and schema discovery. Read them when you choose posthog:execute-sql. You do not need them for typed queries.”

— opening of SKILL.md by PostHog, Custom licence
name
querying-posthog-data

Read the full SKILL.md on GitHub

Files

SKILL.md and 66 other files (references) in products/posthog_ai/skills/querying-posthog-data of PostHog/posthog.

  • SKILL.md
  • references/available-functions.md.j2
  • references/example-error-tracking.md.j2
  • references/example-event-taxonomy.md.j2
  • references/example-funnel-breakdown.md.j2
  • references/example-funnel-trends.md.j2
  • references/example-lifecycle.md.j2
  • references/example-llm-trace.md.j2
  • references/example-llm-traces-list.md
  • references/example-logs.md.j2
  • references/example-observability-correlation.md
  • references/example-paths.md.j2
  • references/example-person-property-taxonomy.md.j2
  • references/example-retention.md.j2
  • references/example-session-replay.md.j2
  • references/example-sessions.md.j2
  • references/example-stickiness.md.j2
  • references/example-team-taxonomy.md.j2
  • references/example-trends-breakdowns.md.j2
  • references/example-trends-unique-users.md.j2
  • … and 47 more

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

Querying Posthog Data 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.

Querying Posthog Data compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Querying Posthog Data this skillPostHog/posthog40k—~4.1kAutomated safety check: PassCustom licence
Almost Paidnestyme/awesome-prompts151—~3.9kAutomated safety check: PassNone
Data Analystborghei/Claude-Skills881—~3.1kAutomated safety check: PassMIT
Lens Metricsjeremylongshore/tons-of-skills-marketplace2.8k—~2.8kAutomated safety check: NotesMIT
Find Hypertable Candidatestimescale/pg-aiguide1.9k1 repos~2.6kAutomated safety check: PassApache-2.0
SlKaelio/ktx1.6k—~2.7kAutomated safety check: PassApache-2.0

Similar skills

  • Almost Paid

    nestyme/awesome-prompts

    Find the users who almost paid — saw the paywall, started checkout, ran out of free credits, let a trial lapse — size what they are worth, and turn them into a one-screen dashboard with a…

    151 GitHub stars~3.9k tokensUpdated 8 days ago
    Data & AnalyticsAuto-check passed

  • Data Analyst

    borghei/Claude-Skills

    Data analysis across SQL, visualization, statistics, and reporting.

    881 GitHub stars~3.1k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • Lens Metrics

    jeremylongshore/tons-of-skills-marketplace

    Produce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like.

    2.8k GitHub stars~2.8k tokensUpdated today
    Product & Project ManagementAuto-check: notes

  • Find Hypertable Candidates

    timescale/pg-aiguide

    A skill your agent uses to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.

    1.9k GitHub starsUsed in 1 repo~2.6k tokens
    Data & AnalyticsAuto-check passed

  • Sl

    Kaelio/ktx

    ktx's semantic layer - a structured catalog of sources (tables/views), measures, joins, and segments expressed as YAML.

    1.6k GitHub stars~2.7k tokensUpdated 27 days ago
    Data & AnalyticsAuto-check passed

  • Telemetry Standards

    supabase/supabase

    Official

    PostHog event tracking standards for Supabase Studio. An agent skill from supabase/supabase.

    111k GitHub stars~2k tokensUpdated today
    Data & AnalyticsAuto-check passed

More from PostHog/posthog

All 252 skills in this repo

  • Authoring Log Alerts

    PostHog/posthog

    Official

    Author useful, low-noise log alerts on services in a PostHog project.

    40k GitHub stars~3k tokensUpdated today
    Auto-check passed

  • Autoresolving PR Conflicts

    PostHog/posthog

    Official

    Operating procedure for the conflict-autoresolver agent: sweep open PostHog/posthog PRs that conflict with master, resolve the trivial conflicts (generated artifacts deterministically, source…

    40k GitHub stars~4.2k tokensUpdated today
    Auto-check passed

  • Diagnosing Stacktrace Symbolication

    PostHog/posthog

    Official

    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).

    40k GitHub stars~2.2k tokensUpdated today
    Auto-check passed

  • Exploring Apm Traces

    PostHog/posthog

    Official

    Investigates distributed application performance using PostHog APM (OpenTelemetry span) data via MCP.

    40k GitHub stars~3.5k tokensUpdated today
    Auto-check passed

  • Exploring LLM Traces

    PostHog/posthog

    Official

    Debug and inspect LLM/AI agent traces using PostHog's MCP tools.

    40k GitHub stars~4.4k tokensUpdated today
    Auto-check passed

  • Investigate Metric

    PostHog/posthog

    Official

    Diagnose why a product metric changed (dropped, spiked, or plateaued) by orchestrating breakdowns, actors, paths, lifecycle, retention, and annotations queries.

    40k GitHub stars~1.9k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Querying Posthog Data

What does Querying Posthog Data do?

Explains how to query PostHog data, defaulting to typed runners for supported product analytics. Querying Posthog Data is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Explains how to query PostHog data, defaulting to typed runners for supported product analytics.

When should I use Querying Posthog Data?

Querying Posthog Data fits situations like: aggregate PostHog entities; tasks that involve SQL; tasks that involve Product analytics.

How do I install Querying Posthog Data in Claude Code?

Run `npx skills add PostHog/posthog --skill querying-posthog-data -a claude-code`. Or copy the skill folder (products/posthog_ai/skills/querying-posthog-data in PostHog/posthog) into .claude/skills/querying-posthog-data in your project. Claude Code loads it when a task matches its description.

How do I install Querying Posthog Data in Codex?

Run `npx skills add PostHog/posthog --skill querying-posthog-data -a codex`. Or copy the skill folder (products/posthog_ai/skills/querying-posthog-data in PostHog/posthog) into .agents/skills/querying-posthog-data in your project. Codex loads it when a task matches its description.

Can I use Querying Posthog Data 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 querying-posthog-data -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/querying-posthog-data, .gemini/skills/querying-posthog-data, .github/skills/querying-posthog-data and .opencode/skills/querying-posthog-data in your project.

What does Querying Posthog Data need to run?

SKILL.md names no scripts, command-line tools or credentials: Querying Posthog Data is instructions for the agent only.

Does Querying Posthog Data access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Querying Posthog Data 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 Querying Posthog Data use?

Querying Posthog Data 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 Querying Posthog Data use?

About 4.1k tokens (SKILL.md is roughly 16k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 57k tokens, read only when the agent opens those files.

What are the alternatives to Querying Posthog Data?

Skills that share tags, products or a category with Querying Posthog Data: Almost Paid (nestyme/awesome-prompts, 151 stars), Data Analyst (borghei/Claude-Skills, 881 stars), Lens Metrics (jeremylongshore/tons-of-skills-marketplace, 2.8k stars) and Find Hypertable Candidates (timescale/pg-aiguide, 1.9k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Querying Posthog Data?

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.