Claude Code Skills·Claude Skills·The open SKILL.md registry for Claude
ClaudSkills / Science & Research / science-misc

Querying Posthog Data

Category: Science & Research  ·  Sub-category: science-misc  ·  Last updated:
Explains how to choose typed queries or SQL for PostHog data. 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 calculate a governed business or telemetry measure, check system.information_schema.metrics for an approved definition. Examples include MRR, activation, billable usage, active organizations, and failure rates. Use the approved definition before you derive a measure from raw events or use a typed domain tool. It also covers HogQL differences, system table schemas, functions, query examples, and schema discovery.
Security AStatic scan found no risk patternsHow grading works ›

From the source SKILL.md

The [guidelines](./references/guidelines.md) explain SQL syntax and schema discovery. Read them when you choose posthog:execute-sql. You do not need them for typed queries.

What this skill does

Querying Posthog Data is a community-contributed Claude Code skill in the science-misc sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/querying-posthog-data/ and loads when your prompt matches the skill's trigger.

Who uses this skill

The Querying Posthog Data Claude Code skill is built for researchers, data scientists, academics, and analysts working with complex data and scientific literature. It's part of ClaudSkills (also referred to as Claude Skills or Claude Code Skills) — the open community-curated registry of 196,000+ SKILL.md files for Anthropic's Claude Code agent and the wider Claude ecosystem (Claude API, Claude Agent SDK).

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/querying-posthog-data
curl -L https://claudskills.com/skills/querying-posthog-data/SKILL.md \
  -o ~/.claude/skills/querying-posthog-data/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/querying-posthog-data/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/querying-posthog-data/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\querying-posthog-data\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Telegram

📱 Install from your phone or desktop Telegram

Open @claudskills_bot on Telegram, tap Open Desktop App, and the desktop app installs this skill for you. Or share the bot link with a colleague — they get the same one-tap install. Learn more →

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

Pro

For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.

See pricing → Download desktop app

Frequently asked questions

How do I install the Querying Posthog Data Claude Code skill?
Install via the ClaudSkills desktop app (one click) or copy SKILL.md from the source repository to ~/.claude/skills/querying-posthog-data/SKILL.md and restart Claude Code. Both flows are detailed at claudskills.com/install/.
What does the Querying Posthog Data skill do?
Explains how to choose typed queries or SQL for PostHog data. 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 calculate a governed business or telemetry measure, check system.information_schema.metrics for an approved definition. Examples include MRR, activation, billable usage, active organizations, and failure rates. Use the approved definition before you derive a measure from raw events or use a typed domain tool. It also covers HogQL differences, system table schemas, functions, query examples, and schema discovery.
Is this skill free to install?
Yes. ClaudSkills is an open registry — every skill keeps its source repository's license, and manual install via copy is free. ClaudSkills Pro ($9/mo, $79/yr, or $149 one-time) adds one-click install via the desktop app and a multi-signal Quality Score.
When should I use the Querying Posthog Data skill?
Use Querying Posthog Data when your Claude Code task falls under the Science & Research category — specifically in the science misc area. Claude Code auto-discovers installed skills and invokes the right one based on the task description, so you can also ask Claude directly (e.g. "use Querying Posthog Data" or describe the task and let Claude pick). Browse related skills at /category/science/.
What is a Claude Code skill and how does the Querying Posthog Data skill fit in?
A Claude Code skill is a SKILL.md file that lives under ~/.claude/skills/<name>/ and tells the Claude Code CLI agent how to perform a specific task (instructions, prompts, allowed tools). Skills are auto-discovered at session start. Querying Posthog Data is one of 67,000+ skills indexed in the open ClaudSkills catalog, classified under the Science & Research category. Learn more at /learn/what-is-a-claude-skill/.

Attribution & license

Cite this skill

If you reference this skill in a blog post, paper, or documentation, you can cite it as:

APA
PostHog. (2026). Querying Posthog Data [Claude Code skill]. ClaudSkills. https://claudskills.com/skills/querying-posthog-data/
BibTeX
@misc{querying-posthog-data-2026,
  author    = {PostHog},
  title     = {Querying Posthog Data [Claude Code skill]},
  year      = {2026},
  publisher = {ClaudSkills},
  url       = {https://claudskills.com/skills/querying-posthog-data/}
}

Embed this skill

Promote, attribute, or link this skill from your own README, blog post, or documentation. All three snippets are free to use — no sign-up, no API key. More distribution surfaces →

Badge
[![ClaudSkills](https://claudskills.com/badge/querying-posthog-data.svg)](https://claudskills.com/skills/querying-posthog-data/?utm_source=badge&utm_medium=readme&utm_campaign=skill_badge)
<script>
<script src="https://claudskills.com/embed/querying-posthog-data.js" async></script>
<iframe>
<iframe src="https://claudskills.com/embed/querying-posthog-data.html" width="100%" height="160" frameborder="0" loading="lazy" title="ClaudSkills: Querying Posthog Data"></iframe>

Security scan

Grade A · scanned 2026-09-28 — free static scan against the OWASP Agentic Skills Top 10.

No risk patterns were found in any of the ten OWASP-aligned categories. How grading works ›

Show this grade on your repo (click to copy):

[![Security: A](https://img.shields.io/badge/Security-A-2e7d32)](https://claudskills.com/skills/querying-posthog-data/#security)

Free. No spam. Unsubscribe in one click.

More Science & Research skills

Browse all Science & Research skills in the ClaudSkills registry, or explore these other picks from the same category:

Browse all Science & Research skills → Top 100 skills
Part of ClaudSkills — the open registry for Claude Skills & Claude Code Skills.  ·  What's New  ·  Install guide  ·  About  ·  llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: PerfectStudio · Ucaption · UTagger · AutoXPoster · TestYourSkills · AutomationFlows · Au Naturel · Telegram @acreatorstore

Categories

Use cases

Popular tags

Learn

Site