modeling-warehouse-foundations
modeling-warehouse-foundations is the official agent skill of PostHog published by posthog, listed under analytics & experiments. It lives in the PostHog/skills repository, which has 75 GitHub stars and is licensed under MIT; we last read it on 2026-09-16.
Provides shared foundations for building reusable data models in PostHog, supporting either PostHog-native data-warehouse views or an external dbt project. Requires no specific credentials.
Install
skills is a generic installer for any repository of Claude agent skills -- it reads PostHog/skills’s own structure rather than assuming one, the same way this page reads the skill’s own SKILL.md rather than assuming a format.
npx skills add PostHog/skills
What it connects to
Unverified means a mention in the skill’s own description, not a citation. A wrong claim here costs nothing to correct and nothing to trust yet.
Maintenance
Shared foundations for building reusable data models in PostHog, on either of two stacks: PostHog-native data-warehouse views / materialized views (HogQL, via the view-* MCP tools), or an external dbt project (sources.yml + staging/marts + schema tests) run against your own or PostHog's managed warehouse. Read before authoring any specific business model — covers the PostHog-vs-dbt decision, the view-create → view-materialize → sync_frequency workflow and the HogQL column-aliasing rule, the dbt project skeleton and the honest "no native dbt integration" picture, warehouse joins and star-schema dimensions, currency conversion with convertCurrency(), and checking/registering models in the data catalog for reuse. Companion to the domain skills modeling-revenue-metrics, modeling-conversion-metrics, modeling-activation-metrics, modeling-product-usage-metrics, and modeling-dimension-tables. Use when the user asks how to build a view, materialized view, or dbt model in PostHog, or which of the two stacks to use.
modeling-warehouse-foundations compared with similar skills
| Skill | Publisher | What it does | Repo stars | Last update |
|---|---|---|---|---|
| modeling-warehouse-foundations (this page) | posthog | Shared foundations for building reusable data models in PostHog, on either of two stacks: PostHog-native data… | 75 | 2026-10-25 |
| account-handover(same repository) | posthog | Draft structured handover notes for transitioning a PostHog account from one TAM or CSM to another. Use this… | 75 | 2026-10-25 |
| adding-warehouse-person-properties(same repository) | posthog | Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data be… | 75 | 2026-10-25 |
| analyzing-experiment-session-replays(same repository) | posthog | Analyze session replay patterns across experiment variants to understand user behavior differences. Use when… | 75 | 2026-10-25 |
| analyzing-task-runs(same repository) | posthog | Split a completed PostHog task run into activity records — what the agent tried, whether it worked, what bloc… | 75 | 2026-10-25 |
| assessing-heatmaps(same repository) | posthog | Assesses what a page's heatmap is telling you and recommends concrete changes. Pulls click / rageclick / scro… | 75 | 2026-10-25 |
| auditing-endpoints(same repository) | posthog | Audit every endpoint in a PostHog project for staleness, failed materialisations, and unused materialised ver… | 75 | 2026-10-25 |
Skills from the same repository first, then others for this job by repository stars. Figures are from each repository when we last read it.
Common questions about modeling-warehouse-foundations
- What does modeling-warehouse-foundations do?
- Provides shared foundations for building reusable data models in PostHog, supporting either PostHog-native data-warehouse views or an external dbt project. Requires no specific credentials.
- How do I install modeling-warehouse-foundations?
- Run npx skills add PostHog/skills. The skills installer reads the repository’s own structure, so it works for any repository of agent skills.
- Who publishes modeling-warehouse-foundations?
- posthog. It is named as the official skill of PostHog.
- Is modeling-warehouse-foundations maintained, and what licence does it use?
- Its repository has 75 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-25. The repository declares the MIT licence.
More agent skills for analytics & experiments
- youtube-thumbnail-designby 101-skills
- incremental-implementationby addyosmani
- agent-observability-replay-traceby datadog-labs
- dd-browser-sdkby datadog-labs
- dd-instrument-rumby datadog-labs
- omni-ai-evalby exploreomni