AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

querying-posthog-data

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

Original source
posthog
License
MIT
Pinned revision
cac7c80a9e5b73484d18eda1bffb47297c938e0c

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

Ask your assistant

Use Agentic Memory skills to read posthog--querying-posthog-data at revision cac7c80a9e5b73484d18eda1bffb47297c938e0c, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 65

references/models-dashboards-insights.md

Dashboards, Tiles & Insights

Dashboard (system.dashboards)

Dashboards are collections of insights that provide a unified view of analytics data.

Columns

Column | Type | Nullable | Description --- | --- | --- | --- id | Integer | NOT NULL | Dashboard id. team_id | Integer | NOT NULL | name | String | NOT NULL | Dashboard name. description | String | NOT NULL | Dashboard description. created_by_id | Integer | NULL | User who created the dashboard. created_at | DateTime | NOT NULL | When the dashboard was created. deleted | Integer | NOT NULL | 1 if the dashboard has been deleted, 0 otherwise. filters | JSON | NOT NULL | JSON dashboard-level filters applied to all tiles. variables | JSON | NOT NULL | JSON dashboard-level template variables.

Important Notes

  • Soft-deleted dashboards are excluded by default; filter with NOT deleted
  • Use filters to store dashboard-level date ranges and property filters

Insight (system.insights)

Insights are saved analytics queries that visualize data.

Columns

Column | Type | Nullable | Description --- | --- | --- | --- id | Integer | NOT NULL | Insight id. short_id | String | NOT NULL | Short URL-safe id used in insight links. team_id | Integer | NOT NULL | name | String | NOT NULL | Insight name. description | String | NOT NULL | Insight description. filters | JSON | NOT NULL | Legacy JSON filter-based insight definition. query | JSON | NOT NULL | JSON query (HogQL query schema) defining the insight. query_metadata | JSON | NOT NULL | JSON metadata derived from the query. deleted | Integer | NOT NULL | 1 if the insight has been deleted, 0 otherwise. saved | Integer | NOT NULL | 1 if explicitly saved by a user, 0 if a transient/auto-created insight. favorited | Integer | NOT NULL | 1 if the insight is marked as a favorite, 0 otherwise. created_at | DateTime | NOT NULL | When the insight was created. created_by_id | Integer | NULL | User who created the insight. last_modified_at | DateTime | NOT NULL | When the insight definition was last changed. last_modified_by_id | Integer | NULL | User who last modified the insight. updated_at | DateTime | NOT NULL | When the row was last updated (any field).

Important Notes

  • short_id is unique per team and used in URLs: /insights/{short_id}
  • Only saved insights appear in the insights list; filter with saved
  • Soft-deleted insights are excluded by default; filter with NOT deleted