Data & Databases skills

Adding Warehouse Person Properties

Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties already work: feature flag targeting, cohorts, insight filters and breakdowns…

Analyzing Expensive Users

Analyze the most expensive users in AI observability and explain why they cost so much.

Analyzing Experiment Session Replays

Analyze session replay patterns across experiment variants to understand user behavior differences.

Analyzing Task Runs

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

Assessing Heatmaps

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 cross-referencing autocapture events on the same page, and can create a saved…

Auditing Endpoints

Audit every endpoint in a PostHog project for staleness, failed materialisations, and unused materialised versions.

Auditing Experiments Flags

Audit PostHog experiments and feature flags for configuration issues, staleness, and best-practice violations. Read when the user asks to audit, health-check, or review experiments or feature flags, check flag hygiene, or verify…

Auditing Warehouse Source Health

Audit the health of a PostHog project's data warehouse sources and syncs — find every broken or degraded source connection, sync schema, and webhook channel.

Auditing Warehouse View Health

Audit the health of a PostHog project's materialized views (saved queries) — find every failed materialization and flag unused or stale materialized views that cost storage and compute.

Authoring Data Quality Checks

Adds and runs data quality checks (dbt-test style assertions) on a project's warehouse tables and saved-query views, and HogQL catalog metrics: not-null, uniqueness, accepted values, referential integrity, row-count bounds, freshness, and…

Authoring Error Tracking Alerts

Author error tracking alerts that fire when an issue is created, reopened, or starts spiking.

Authoring Log Alerts

Author useful, low-noise log alerts on services in a PostHog project.

Authoring Scouts

Write, edit, and adapt PostHog Signals scouts: scheduled agents that scan a project and report findings. Use to change a canonical scout's scope, thresholds, schedule, or dry-run settings; add a scout for an uncovered surface; record…

Azure Cosmos DB for Python

Azure Cosmos DB SDK for Python (NoSQL API). Use for document CRUD, queries, containers, and globally distributed data.

Building A Dashboard

Build a new dashboard, or update an existing one, from a set of insights — the same job the in-app assistant does with its upsert-dashboard tool, but over MCP.

Building Canvases

Create or edit a PostHog freeform canvas — a sandboxed browser application (data board, document, form, small tool, graphics experiment) stored in PostHog and rendered by the desktop/web app.

Building HTML Canvases

Author a PostHog canvas with semantic HTML, CSS, and direct browser APIs — documents, articles, generative graphics, 2D canvas and WebGL experiences, and focused experiments where React components add no useful structure. Use after…

Building Loops

Build a Loop for PostHog Desktop: a workflow that creates an AI task each time its trigger fires, optionally followed by a Slack or email notification with the task's result.

Building React Quill Canvases

Author the React + Quill implementation of a PostHog canvas: the single-component contract, the allowed imports, Quill (PostHog's design system) component and composition rules, theme-aware design tokens, loading skeletons, and the…

Building Workflows

Build, edit, test, enable, and monitor PostHog workflows over MCP. Author the action/edge graph so it runs and opens cleanly in the visual editor, then change drafts surgically with patch operations.