Use Cursor's browser aria snapshots to audit a page for accessibility issues — missing labels, broken tab order, contrast, and ARIA misuse.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트
무료GitHub에 공개
querying-posthog-data
Required reading before writing any HogQL/SQL or calling execute-sql against PostHog. Use whenever the user wants to search, find, or do complex aggregations PostHog entities (insights, dashboards, cohorts, feature flags, experiments, surveys, hog flows, data warehouse, persons, etc.) and query analytics data (trends, funnels, retention, lifecycle, paths, stickiness, web analytics, error tracking, logs, sessions, LLM traces). Covers HogQL syntax differences from ClickHouse SQL, system table schemas (system.*), available functions, query examples, and the schema-discovery workflow.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
설치 방법 보기포함된 파일(57)
- SKILL.md7.3 KB
- references/available-functions.md11.6 KB
- references/example-error-tracking.md2.8 KB
- references/example-event-taxonomy.md1.8 KB
- references/example-funnel-breakdown.md2.9 KB
- references/example-funnel-trends.md2.2 KB
- references/example-lifecycle.md3.8 KB
- references/example-llm-trace.md3.3 KB
- references/example-llm-traces-list.md3.8 KB
- references/example-logs.md1.2 KB
- references/example-observability-correlation.md4.8 KB
- references/example-paths.md4.7 KB
- references/example-person-property-taxonomy.md630 B
- references/example-retention.md2.6 KB
- references/example-session-replay.md1.9 KB
- references/example-sessions.md468 B
- references/example-stickiness.md1.8 KB
- references/example-team-taxonomy.md521 B
- references/example-trends-breakdowns.md4.4 KB
- references/example-trends-unique-users.md1.3 KB
- references/example-web-overview.md1.4 KB
- references/example-web-path-stats.md3.2 KB
- references/example-web-traffic-by-device-type.md1.2 KB
- references/example-web-traffic-channels.md1.4 KB
- references/guidelines.md15.0 KB
- references/hogql-extensions.md5.7 KB
- references/models-actions.md2.8 KB
- references/models-activity-logs.md2.7 KB
- references/models-ai-observability-events.md3.3 KB
- references/models-ai-observability-reviews.md7.5 KB
- references/models-alerts.md2.1 KB
- references/models-annotations.md2.1 KB
- references/models-apm-spans.md8.3 KB
- references/models-batch-exports.md4.8 KB
- references/models-cohorts.md5.6 KB
- references/models-dashboards-insights.md3.2 KB
- references/models-data-warehouse.md8.2 KB
- references/models-early-access-features.md2.4 KB
- references/models-endpoints.md2.7 KB
- references/models-error-tracking.md5.0 KB
- references/models-flags-experiments.md3.6 KB
- references/models-heatmaps.md3.0 KB
- references/models-hog-flows.md1.9 KB
- references/models-hog-functions.md2.7 KB
- references/models-integrations.md2.5 KB
- references/models-logs.md14.4 KB
- references/models-metrics.md10.2 KB
- references/models-notebooks.md2.8 KB
- references/models-session-recording-playlists.md2.0 KB
- references/models-session-recordings.md2.3 KB
- references/models-support-tickets.md2.5 KB
- references/models-surveys.md2.8 KB
- references/models-usage-metrics.md3.1 KB
- references/models-variables.md2.7 KB
- references/person-property-modes.md2.4 KB
- references/taxonomy-dynamic-properties.md2.8 KB
- references/taxonomy-skipped-events.md1.0 KB
SKILL.md(원문)
설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.
Querying data in PostHog
The guidelines contain the same instructions as posthog:execute-sql. If you've already read posthog:execute-sql, you don't need to read them again.
When to use this skill
Finding a specific PostHog entity
When the user wants to find a specific entity created in PostHog (insights, dashboards, cohorts, feature flags, experiments, surveys, hog flows, data warehouse items, etc.), or when a list/search tool returns too many results to narrow down:
- Read the appropriate schema reference under Data Schema to understand the entity's table and columns.
- Use
posthog:execute-sqlto query the system table and find the matching entity (typically returning its ID). - Use the dedicated read tool for that entity type (e.g.
posthog:insight-get,posthog:dashboard-get) to retrieve the full entity by ID.
Don't try to reconstruct the entity from SQL — execute-sql is for discovery, the read tool is for retrieval.
Querying analytics data
When the user wants analytics data (trends, funnels, retention, paths, sessions, LLM traces, web analytics, errors, logs, etc.) and the existing insight schemas don't fit the request:
- Look for a matching example under Analytics Query Examples. The list is not exhaustive — there may not be an example for every scenario. If one is a close fit (same domain, similar aggregation), read it; otherwise skip this step.
- Adapt the example query (if one was found) to the user's request and run it via
posthog:execute-sql. If no example fit, compose the query from scratch using the Data Schema and HogQL References.
Data Schema
Schema reference for PostHog's core system models, organized by domain:
- Activity logs
- Actions
- Alerts
- Annotations
- APM / tracing (
posthog.trace_spans) - Batch exports
- Early Access Features
- Cohorts & Persons
- Dashboards, Tiles & Insights
- Data Warehouse
- Data Modeling Endpoints
- Error Tracking
- Flags & Experiments
- Heatmaps (
heatmapsdata +system.heatmaps_saved) - Hog Flows
- Hog Functions
- Integrations
- AI observability events (
posthog.ai_events) - AI observability reviews
- Logs (
logsdata plane + saved views and alerts) - Metrics (
posthog.metrics) - Notebooks
- Session Recording Playlists
- Session Recordings
- Support Tickets
- Surveys
- Usage Metrics
- 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.
- Trends (unique users, specific time range, single series)
- Trends (total count with multiple breakdowns)
- Funnel (two steps, aggregated by unique users, broken down by the person's role, sequential, 14-day conversion window)
- Conversion trends (funnel, two steps, aggregated by unique groups, 1-day conversion window)
- Retention (unique users, returned to perform an event in the next 12 weeks, recurring)
- User paths (pageviews, three steps, applied path cleaning and filters, maximum 50 paths)
- Lifecycle (unique users by pageviews)
- Stickiness (counted by pageviews from unique users, defined by at least one event for the interval, non-cumulative)
- LLM trace (generations, spans, embeddings, human feedback, captured AI metrics)
- LLM traces list (searching and listing traces with property filters, two-phase query)
- Web path stats (paths, visitors, views, bounce rate)
- Web traffic channels (direct, organic search, etc)
- Web views by devices
- Web overview
- Error tracking (search for a value in an error and filtering by custom properties)
- Logs (filtering by severity and searching for a term)
- Cross-signal correlation (metric exemplar → trace → logs)
- Sessions (listing sessions with duration, pageviews, and bounce rate)
- Session replay (listing recordings with activity filters)
- Team taxonomy (top events by count, paginated)
- Event taxonomy (properties of an event, with sample values)
- Person property taxonomy (sample values for person properties)
리뷰
아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.
댓글
로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.
아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.
같은 저장소의 스킬
Add PostHog analytics to a web application, including event tracking, page views, feature flags, and session replay.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트
Generate OpenAPI/Swagger documentation for an API, including endpoint schemas, request/response types, and interactive docs UI.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트
Add authentication to a web application using NextAuth.js (Auth.js), including OAuth providers, session management, and protected routes.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트
Dockerize an application with a production-ready Dockerfile, docker-compose setup, and .dockerignore.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트
Set up Playwright end-to-end testing in a project, including test configuration, example tests, and CI integration.
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
0xAidan/polymarket-bot-test42026년 9월 4일 업데이트