Exploring MCP sessions

An MCP session is one agent run, identified by $session_id on the $mcp_tool_call event. A session is just the set of $mcp_tool_call events that share a $session_id, ordered by timestamp. Listing sessions and reading a session's tool calls are both plain HogQL over events; the full property schema and recipes are in the shared reference: products/posthog_ai/skills/querying-posthog-data/references/models-mcp.md.

The one thing SQL cannot do is summarise the agent's goal in prose — that is the typed tool posthog:mcp-analytics-sessions-generate-intent.

Tools