FreeSkills
Analyse your ClickHouse data in conversation
- 477477 downloads
- 180180 likes
- 112112 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Warehouse data model foundations v1.0.0
Use this resource to lay the foundations of a reusable data model in the warehouse
New
- 522 downloads
- 149 likes
- 139 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install warehouse-data-model-foundationsWith no option, the skill goes to ~/.agents/skills/; add --agent claude-code (or codex, cursor…) to target an agent.
First time: connect the CLI with
npx --yes palatekit@latest loginThe agent helps choose between PostHog-native views and a dbt project, then follows the view-create, view-materialize and sync_frequency workflow. It also covers joins, currency conversion and registering the model in the catalog.
Mostly picked by
Updated November 2, 2026
Previews
Details
- Install guides
- Generates with
- Your agent's model
- Licence
- MIT
Similar resources
View all- Free
FreeSkills
Google Workspace CLI admin
- 465465 downloads
- 222222 likes
- 193193 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Project management agent
- 519519 downloads
- 155155 likes
- 220220 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Financial analyst agent
- 399399 downloads
- 103103 likes
- 176176 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Quality and regulatory agent
- 347347 downloads
- 222222 likes
- 109109 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Git work log (deprecated reference)
- 537537 downloads
- 176176 likes
- 203203 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Persistent task tracking and day planning
- 384384 downloads
- 224224 likes
- 134134 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
OKR design that drives decisions
- 454454 downloads
- 101101 likes
- 165165 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
What you get
- SKILL.md: choosing PostHog-native or dbt, and the rules to follow
- references/: dbt skeleton project, governance, joins and PostHog views
Good fit for
- You want one business metric defined once for every dashboard
- You move from an ad hoc calculation to a dbt model
Not for
Tags
- modelling
- warehouse
- dbt
- views
About
You say
“Build a revenue model in converted currencies that insights can reuse.”
Skill published by posthog under the MIT license, delivered in its original version.
Show moreShow less
How to use it
- Install the skill in your agent's skills folder
- Ask your agent to lay the foundations of a reusable data model in the warehouse
- Review and adjust the result
Content preview
Files
- LICENSE1.5 KB
- NOTICE-PALATEKIT.md0.5 KB
- references/dbt-project.md4.4 KB
- references/dbt-skeleton/dbt_project.yml0.7 KB
- references/dbt-skeleton/models/marts/fct_daily_active_users.sql0.4 KB
- references/dbt-skeleton/models/marts/schema.yml1 KB
- references/dbt-skeleton/models/staging/_sources.yml1.2 KB
- references/dbt-skeleton/models/staging/stg_events.sql0.6 KB
- references/governance.md2.9 KB
- references/joins-and-dimensions.md3 KB
- references/posthog-views.md6.2 KB
- SKILL.md8.3 KB
Origin and licence
Listed unmodified
- Author
- posthog
- Source
- github.com/posthog/posthog/tree/fcb362bb439b15171da4dfba401bff03ea98bd2b/products/data_modeling/skills/modeling-warehouse-foundations
- Licence
- MIT
Notice
« modeling-warehouse-foundations » (posthog, MIT) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…