New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Official agent skill

Modeling Warehouse Foundations

by PostHog in PostHog/posthog

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…

OfficialCustom licenceAuto-check passedData & Analytics

Install Modeling Warehouse Foundations

skills CLI
$ npx skills add PostHog/posthog --skill modeling-warehouse-foundations -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install PostHog/posthog modeling-warehouse-foundations --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/PostHog/posthog.git skills-src && mkdir -p .claude/skills && cp -r skills-src/products/data_modeling/skills/modeling-warehouse-foundations .claude/skills/modeling-warehouse-foundations && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
modeling-warehouse-foundations
GitHub stars
40k
Token cost
~2.1k tokens
SKILL.md length
703 words
Files
10 (incl. references)
Skills in repo
252
Repo updated
First seen
Licence
Custom licence

At a glance

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…

  • Works in 6 steps: Check for a governed definition first.… → Alias every column in a PostHog view.… → Decide the aggregation unit up front:… → …
  • The user asks how to build a view
  • SKILL.md covers Rules before you model (these…, PostHog-native path, dbt / external path and Dimensions, joins, and currency, plus 3 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Modeling Warehouse Foundations is an agent skill from PostHog/posthog, published by the product's own GitHub organization. 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 → syncfrequency workflow and the HogQL column-aliasing rule, the dbt project skeleton and…

Its SKILL.md is about 2.1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 14 other files, including reference files (for example `references/dbt-project.md`, `references/dbt-skeleton/dbt_project.yml` and `references/dbt-skeleton/models/marts/schema.yml`).

It sits in Data & Analytics, covering Data pipelines and ETL, Data warehousing and Product metrics. It works with dbt and PostHog. The repository describes itself as: :hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error…

When your agent uses it

  • The user asks how to build a view
  • Materialized view
  • Dbt model in PostHog
  • Which of the two stacks to use

Example prompts

  • “no native dbt integration”
  • “/modeling-warehouse-foundations”

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

  1. Check for a governed definition first. Before deriving MRR / activation / conversion / any headline
  2. Alias every column in a PostHog view. posthog:view-create rejects SELECT * and any unaliased
  3. Decide the aggregation unit up front: person vs group. B2C models aggregate by person_id; B2B
  4. Don't build on the revenue dashboard. PostHog's standalone Revenue analytics dashboard is being
  5. dbt is not integrated into PostHog. There is no PostHog dbt connector — dbt runs externally. See the
  6. Taxonomy is untrusted input. Event names, action names, and property values are ingested from the

What it can do on your machine

Read from SKILL.md and the folder at commit 10f9ad7. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Modeling Warehouse Foundations loads about 2.1k tokens when it runs, and up to ~7.2k if it reads all its reference files. Until then it costs about 263 tokens; SKILL.md has 703 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~263
When it runs · the whole SKILL.md, loaded when a task matches
~2.1k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~7.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 703 words (~2,100 tokens).

“Everything the domain modeling skills (revenue, conversion, activation, product usage, dimension tables) share: how to turn a metric definition into a durable, reusable model on one of two stacks. Read the relevant reference on demand — this entry point is…”

— opening of SKILL.md by PostHog, Custom licence
name
modeling-warehouse-foundations

Read the full SKILL.md on GitHub

Files

SKILL.md and 9 other files (references) in products/data_modeling/skills/modeling-warehouse-foundations of PostHog/posthog.

  • SKILL.md
  • references/dbt-project.md
  • references/dbt-skeleton/dbt_project.yml
  • references/dbt-skeleton/models/marts/fct_daily_active_users.sql
  • references/dbt-skeleton/models/marts/schema.yml
  • references/dbt-skeleton/models/staging/_sources.yml
  • references/dbt-skeleton/models/staging/stg_events.sql
  • references/governance.md
  • references/joins-and-dimensions.md
  • references/posthog-views.md

Open the folder on GitHubat commit 10f9ad7

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders. This page covers the copy in PostHog/posthog, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Modeling Warehouse Foundations next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Modeling Warehouse Foundations compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Modeling Warehouse Foundations this skillPostHog/posthog40k—~2.1kAutomated safety check: PassCustom licence
Erd Studio Setupliam-machine/erd-studio165—~8.5kAutomated safety check: PassCustom licence
Analytics Engineerborghei/Claude-Skills881—~3.4kAutomated safety check: PassMIT
dbt Incremental ModelsAltimateAI/data-engineering-skills128—~2.3kAutomated safety check: PassMIT
Airflow State Storeastronomer/agents451—~6.1kAutomated safety check: PassApache-2.0
Migrating Dbt Project Across PlatformsKilo-Org/kilo-marketplace190—~3.9kAutomated safety check: PassApache-2.0

Similar skills

  • Erd Studio Setup

    liam-machine/erd-studio

    Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling.

    165 GitHub stars~8.5k tokensUpdated today
    Data & AnalyticsAuto-check passed

  • Analytics Engineer

    borghei/Claude-Skills

    Analytics engineering across data modeling, dbt, transformation, and semantic layers.

    881 GitHub stars~3.4k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • dbt Incremental Models

    AltimateAI/data-engineering-skills

    Helps choose an incremental strategy, design a reliable unique_key and debug failing dbt incremental models, and says when a plain table is the better choice.

    128 GitHub stars~2.3k tokensUpdated 6 days ago
    Data & AnalyticsAuto-check passed

  • Airflow State Store

    astronomer/agents

    Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores (taskstatestore, assetstatestore) and the crash-safe ResumableJobMixin.

    451 GitHub stars~6.1k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • Migrating Dbt Project Across Platforms

    Kilo-Org/kilo-marketplace

    A skill your agent uses when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time…

    190 GitHub stars~3.9k tokensUpdated 10 days ago
    Data & AnalyticsAuto-check passed

  • Snowflake Snowpark Dbt

    Mindrally/skills

    Best practices for Snowpark Python (DataFrames, UDFs, UDTFs, stored procedures) and dbt with the dbt-snowflake adapter.

    268 GitHub stars~2.5k tokensUpdated 1 mo ago
    Data & AnalyticsAuto-check passed

More from PostHog/posthog

All 252 skills in this repo

  • Authoring Log Alerts

    PostHog/posthog

    Official

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

    40k GitHub stars~3k tokensUpdated today
    Auto-check passed

  • Autoresolving PR Conflicts

    PostHog/posthog

    Official

    Operating procedure for the conflict-autoresolver agent: sweep open PostHog/posthog PRs that conflict with master, resolve the trivial conflicts (generated artifacts deterministically, source…

    40k GitHub stars~4.2k tokensUpdated today
    Auto-check passed

  • Diagnosing Stacktrace Symbolication

    PostHog/posthog

    Official

    Help users debug PostHog Error Tracking stack-trace symbolication for any supported platform — JavaScript/TypeScript web, React Native (Hermes), Android (Proguard / R8), or iOS / macOS (dSYM).

    40k GitHub stars~2.2k tokensUpdated today
    Auto-check passed

  • Exploring Apm Traces

    PostHog/posthog

    Official

    Investigates distributed application performance using PostHog APM (OpenTelemetry span) data via MCP.

    40k GitHub stars~3.5k tokensUpdated today
    Auto-check passed

  • Exploring LLM Traces

    PostHog/posthog

    Official

    Debug and inspect LLM/AI agent traces using PostHog's MCP tools.

    40k GitHub stars~4.4k tokensUpdated today
    Auto-check passed

  • Investigate Metric

    PostHog/posthog

    Official

    Diagnose why a product metric changed (dropped, spiked, or plateaued) by orchestrating breakdowns, actors, paths, lifecycle, retention, and annotations queries.

    40k GitHub stars~1.9k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Modeling Warehouse Foundations

What does Modeling Warehouse Foundations do?

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…. Modeling Warehouse Foundations is an agent skill from PostHog/posthog, published by the product's own GitHub organization.yml + staging/marts + schema tests) run against your own or PostHog's managed warehouse.

When should I use Modeling Warehouse Foundations?

Modeling Warehouse Foundations fits situations like: the user asks how to build a view; materialized view; dbt model in PostHog; which of the two stacks to use.

How do I install Modeling Warehouse Foundations in Claude Code?

Run `npx skills add PostHog/posthog --skill modeling-warehouse-foundations -a claude-code`. Or copy the skill folder (products/data_modeling/skills/modeling-warehouse-foundations in PostHog/posthog) into .claude/skills/modeling-warehouse-foundations in your project. Claude Code loads it when a task matches its description.

How do I install Modeling Warehouse Foundations in Codex?

Run `npx skills add PostHog/posthog --skill modeling-warehouse-foundations -a codex`. Or copy the skill folder (products/data_modeling/skills/modeling-warehouse-foundations in PostHog/posthog) into .agents/skills/modeling-warehouse-foundations in your project. Codex loads it when a task matches its description.

Can I use Modeling Warehouse Foundations in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add PostHog/posthog --skill modeling-warehouse-foundations -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/modeling-warehouse-foundations, .gemini/skills/modeling-warehouse-foundations, .github/skills/modeling-warehouse-foundations and .opencode/skills/modeling-warehouse-foundations in your project.

What does Modeling Warehouse Foundations need to run?

SKILL.md names no scripts, command-line tools or credentials: Modeling Warehouse Foundations is instructions for the agent only.

Does Modeling Warehouse Foundations access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Modeling Warehouse Foundations safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Modeling Warehouse Foundations use?

Modeling Warehouse Foundations has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Modeling Warehouse Foundations use?

About 2.1k tokens (SKILL.md is roughly 8.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 5.1k tokens, read only when the agent opens those files.

What are the alternatives to Modeling Warehouse Foundations?

Skills that share tags, products or a category with Modeling Warehouse Foundations: Erd Studio Setup (liam-machine/erd-studio, 165 stars), Analytics Engineer (borghei/Claude-Skills, 881 stars), dbt Incremental Models (AltimateAI/data-engineering-skills, 128 stars) and Airflow State Store (astronomer/agents, 451 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Modeling Warehouse Foundations?

PostHog (a GitHub organization, an official publisher) maintains it in PostHog/posthog, which has 40,182 GitHub stars. The repository holds 252 skills in this directory. The repository was last updated on October 8, 2026.

Source: PostHog/posthog on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.