adding-warehouse-perso…
Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties…
Explore PostHog MCP intent clusters — agent goals grouped by semantic similarity, with each cluster's tool distribution and error rates, plus the tool-centric pivot (capture rate per intent, discovery rate against the advertised catalog, description fit, tool overlaps). Use when
$ npx -y skills add PostHog/ai-plugin --skill exploring-mcp-intent-clusters --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/exploring-mcp-intent-clustersContext preview
The summary Claude sees to decide when to auto-load this skill.
Explore PostHog MCP intent clusters — agent goals grouped by semantic similarity, with each cluster's tool distribution and error rates, plus the tool-centric pivot (capture rate per intent, discovery rate against the advertised catalog, description fit, tool overlaps). Use when
name: exploring-mcp-intent-clusters description: > Explore PostHog MCP intent clusters — agent goals grouped by semantic similarity, with each cluster's tool distribution and error rates, plus the tool-centric pivot (capture rate per intent, discovery rate against the advertised catalog, description fit, tool overlaps). Use when the user asks "what are agents trying to do with the MCP?", "group the intents", "which goals fail most?", "what does each cluster route to?", "when agents have this intent do they find my tool?", "which tools get mixed up?", wants to recompute the clustering, or pastes an MCP analytics intent-clustering URL.
Intent clustering takes the free-text `$mcp_intent` values agents attach to their tool calls, embeds them, and groups semantically similar goals into clusters. Attribution is per call: each call is credited to its own intent (calls without one inherit the most recent prior intent in the same session), so a tool's counts reflect the intent it actually served. Each cluster carries its tool distribution, call counts, and error rates — answering "what are people _trying_ to do, and does it work?" rather than "which tool was called". The snapshot also carries a tool-centric pivot answering the reverse question: for a given tool, which intents drive its usage, how often do agents find it, and who does it compete with.
Unlike tool quality and sessions (which ultimately aggregate `$mcp_tool_call`), clustering needs embeddings and is **not expressible in SQL**. It is served by two typed tools backed by a stored snapshot.
| Tool | Purpose | | ------------------------------------------------- | ------------------------------------------------- | | `posthog:mcp-analytics-intent-clusters-retrieve` | Fetch the latest cluster snapshot for the project | | `posthog:mcp-analytics-intent-clusters-recompute` | Trigger an async recompute of the snapshot |
posthog:mcp-analytics-intent-clusters-retrieve
{}Returns a snapshot with `status`, `last_computed_at`, `computed_with` (the embedding model, clustering parameters, and sample-coverage percentages), a `clusters` array, a `tools` array (the tool pivot), and `tool_overlaps`. Each cluster has a `label`, `intent_count`, `call_count`, `error_count`, `error_rate_pct`, `routing_entropy`, a `tool_distribution` (which tools that goal routes to, with per-tool error rates), `sample_intents`, plus `switches` (errored call immediately followed by a different tool for the same intent — the strongest "agents mix these tools up" evidence) and `self_retries` (errored call immediately retried with the same tool — a sign the tool's error messages aren't helping agents self-correct).
Read clusters by `call_count` for "what are agents mostly doing", or by `error_rate_pct` for "which goals are failing" — a high error rate on a cluster points at a class of agent goals the tools serve badly.
`routing_entropy` is how spread-out a cluster's tool usage is: low entropy means one goal reliably maps to one tool; high entropy means agents are casting around for the right tool for that goal (often a missing-capability signal).
Each entry in `tools` carries:
(its share of the cluster's calls), `rank`, `top_competitor` (the strongest other tool and its share), and `description_fit` (cosine similarity between the tool's description and the cluster centroid; null until descriptions are captured). Entries carry only `cluster_id`, not the cluster's own label or totals — join them against the top-level `clusters` array on that id
list above is capped, so compare the two before saying "this tool serves N intents"
catalog advertised the tool, the share that actually called it; null when the tool was advertised in fewer than 5 sampled sessions
intents are split with other tools
High `description_fit` with low `capture_pct` is the discoverability failure: agents should find the tool for that intent but pick something else. Low fit with high capture means the description undersells what the tool actually does. `tool_overlaps` lists pairs competing for the same intents; use `sessions_with_both` vs `sessions_with_either` to separate workflows (used together) from confusion (one or the other).
Read coverage before quoting numbers: `computed_with.sampled_sessions` / `session_coverage_pct` say how much of the window the corpus represents, and `advertisement_coverage_pct` bounds what discovery rates can see. Only sessions with an observed tools-list catalog enter discovery denominators, and sessions in exec-wrapper mode advertise only the wrapper, so per-tool discovery is measured on full-catalog sessions.
`computed_with` is not a completeness check for everything, though. Only the top-level tool and overlap-pair caps report what they dropped, via `dropped_tools` and `dropped_overlap_pairs`. The per-cluster lists are capped silently, so treat a cluster showing 10 switches or 5 self-retries as "at least that many", not "exactly". A tool's cluster entries are capped too, but there `n_clusters_served` gives you the real count.
Clustering reads events only. The on-demand session summaries (`MCPSession.intent`, what "generate intent" writes) are deliberately left out: a summary describes a whole session, and spreading it across that session's calls is the mis-attribution the per-call corpus exists to remove. So a session whose intent was only ever summarised is not in any
Official PostHog plugin for AI clients. Access PostHog products directly from your AI coding tool.
Repo: PostHog/ai-plugin
Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties…
Analyze the most expensive users in AI observability and explain why they cost so much. Use when the user asks about top spenders, expensive users, per-user…
Analyze session replay patterns across experiment variants to understand user behavior differences. Use when the user wants to see how users interact with…
Split a completed PostHog task run into activity records — what the agent tried, whether it worked, what blocked it — and record each one through the…
Assesses what a page's heatmap is telling you and recommends concrete changes. Pulls click / rageclick / scroll-depth data for a URL, names the hot elements by…
Audit every endpoint in a PostHog project for staleness, failed materialisations, and unused materialised versions. Use when the user asks "what endpoints can…