query-examples

Name: query-examples
Author: posthog

github.com/posthogData & databases9542 installsUpdated today

About query-examples

query-examples is a reference skill for querying PostHog data. It combines core data-schema guidance, HogQL references, and example analytics queries across product, web, session, and error data.

Key features

01PostHog core data-schema reference
02HogQL functions and syntax guidance
03Analytics query examples across domains
04LLM trace and session analysis examples

Use cases

01Build trends, funnels, and retention queries
02Inspect web traffic and user paths
03Query errors, logs, and session recordings

MCP support

The skill provides guidance for querying PostHog when an MCP server does not supply its own instructions.

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/posthog/ai-plugin --skill query-examples

After installing, type/query-examplesin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/

available-functions.md

example-error-tracking.md

example-event-taxonomy.md

example-funnel-breakdown.md

example-funnel-trends.md

example-lifecycle.md

example-llm-trace.md

example-llm-traces-list.md

example-logs.md

example-paths.md

example-person-property-taxonomy.md

example-retention.md

example-session-replay.md

example-sessions.md

example-stickiness.md

example-team-taxonomy.md

example-trends-breakdowns.md

example-trends-unique-users.md

example-web-overview.md

example-web-path-stats.md

example-web-traffic-by-device-type.md

example-web-traffic-channels.md

guidelines.md

hogql-extensions.md

models-actions.md

models-activity-logs.md

models-alerts.md

models-annotations.md

models-batch-exports.md

models-cohorts.md

Details

From the project README

Querying data in PostHog

If the MCP server haven't provided instructions on querying data in PostHog, read the guidelines.

Data Schema

Schema reference for PostHog's core system models, organized by domain:

Activity logs
Actions
Alerts
Annotations
Batch exports
Early Access Features
Cohorts & Persons
Dashboards, Tiles & Insights
Data Warehouse
Data Modeling Endpoints
Error Tracking
Flags & Experiments
Hog Flows
Hog Functions
Integrations
Logs
Notebooks
Session Recording Playlists
Session Recordings
Support Tickets
Surveys
SQL Variables
Skipped events in the read-data-schema tool
Dynamic person and event properties — patterns like $survey_dismissed/{id}, $feature/{key} that don't appear in tool results

HogQL References

Person property modes (event-time vs query-time). Read when working with person.properties.* to understand if values are historical or current.
Sparkline, SemVer, Session replays, Actions, Translation, HTML tags and links, Text effects, and more
SQL variables.
Available functions in HogQL. IMPORTANT: the list is long, so read data using bash commands like grep.

Analytics Query Examples

Use the examples below to create optimized analytical queries.

Comments

Markdown supported

Details

Author: posthog
Repository: posthog/ai-plugin
Category: Data & databases
Installs: 42
GitHub stars: 95

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).