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

Setting Up Warehouse Properties

by PostHog in PostHog/posthog

Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights.

OfficialCustom licenceAuto-check passedDatabases

Install Setting Up Warehouse Properties

skills CLI
$ npx skills add PostHog/posthog --skill setting-up-warehouse-properties -a claude-code

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

GitHub CLI
$ gh skill install PostHog/posthog setting-up-warehouse-properties --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/customer_analytics/skills/setting-up-warehouse-properties .claude/skills/setting-up-warehouse-properties && 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
setting-up-warehouse-properties
GitHub stars
40k
Token cost
~2.3k tokens
SKILL.md length
1,096 words
Files
1
Skills in repo
252
Repo updated
First seen
Licence
Custom licence

At a glance

Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights.

  • Works in 5 steps: Find the table and its columns → Pick the identifier column, and say why… → Propose the mapping before creating… → …
  • The user wants to sync my Postgres columns to person properties
  • SKILL.md covers When to use this skill, Tools, The flow and Notes that save a round trip
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Setting Up Warehouse Properties is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights. Use when the user wants to "sync my Postgres columns to person properties", "map a warehouse table to people", "replace our daily identify cron", "update person properties from the warehouse", or asks for reverse ETL into PostHog. Covers picking the table and the identifier column, proposing a whole-table column mapping in one call, excluding…

Its SKILL.md is about 2.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Data warehousing, Data pipelines and ETL and Scheduled and recurring tasks. It works with PostHog and PostgreSQL. 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 wants to sync my Postgres columns to person properties
  • Map a warehouse table to people
  • Replace our daily identify cron
  • Update person properties from the warehouse

Example prompts

  • “sync my Postgres columns to person properties”
  • “map a warehouse table to people”
  • “replace our daily identify cron”
  • “/setting-up-warehouse-properties”

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Find the table and its columns
  2. Pick the identifier column, and say why it matters
  3. Propose the mapping before creating anything
  4. Create it
  5. Backfill and verify

What it can do on your machine

Read from SKILL.md and the folder at commit 812e5c6. 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

Setting Up Warehouse Properties loads about 2.3k tokens when it runs. Until then it costs about 168 tokens; SKILL.md has 1,096 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~168
When it runs · the whole SKILL.md, loaded when a task matches
~2.3k

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 1,096 words (~2,318 tokens).

“Warehouse properties write columns from a warehouse table or materialized view onto matching people or groups, on the schedule that table already syncs on. They replace a cron that sends $set identify events.”

— opening of SKILL.md by PostHog, Custom licence
name
setting-up-warehouse-properties

Read the full SKILL.md on GitHub

Files

Just SKILL.md in products/customer_analytics/skills/setting-up-warehouse-properties of PostHog/posthog.

Open the folder on GitHubat commit 812e5c6

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

Setting Up Warehouse Properties 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.

Setting Up Warehouse Properties compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Setting Up Warehouse Properties this skillPostHog/posthog40k—~2.3kAutomated safety check: PassCustom licence
DB SculptorEliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT
Clickhouse IohellangleZ/burn-in-cceverywhere-ralph11214 repos~2.5kAutomated safety check: PassNone
Analyzing Dataastronomer/agents451—~1.3kAutomated safety check: PassApache-2.0
Altimate Data Warehouse DelegateAltimateAI/data-engineering-skills128—~1.4kAutomated safety check: PassMIT
TimescaleDB Reference2025Emma/vibe-coding-cn23k1 repos~750Automated safety check: PassMIT

Similar skills

  • DB Sculptor

    EliasOulkadi/shokunin

    Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

    114 GitHub stars~3.1k tokensUpdated 4 days ago
    DatabasesAuto-check: notes

  • Clickhouse Io

    hellangleZ/burn-in-cceverywhere-ralph

    ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

    112 GitHub starsUsed in 14 repos~2.5k tokens
    DatabasesAuto-check passed

  • Analyzing Data

    astronomer/agents

    Queries the data warehouse with SQL and answers business questions about data.

    451 GitHub stars~1.3k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • Altimate Data Warehouse Delegate

    AltimateAI/data-engineering-skills

    Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

    128 GitHub stars~1.4k tokensUpdated yesterday
    DatabasesAuto-check passed

  • TimescaleDB Reference

    2025Emma/vibe-coding-cn

    TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time…

    23k GitHub starsUsed in 1 repo~750 tokens
    DatabasesAuto-check passed

  • Snowflake Development

    sickn33/agentic-awesome-skills

    Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…

    47k GitHub starsUsed in 2 repos~2.1k tokens
    DatabasesAuto-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 Setting Up Warehouse Properties

What does Setting Up Warehouse Properties do?

Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights. Setting Up Warehouse Properties is an agent skill from PostHog/posthog, published by the product's own GitHub organization. Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights.

When should I use Setting Up Warehouse Properties?

Setting Up Warehouse Properties fits situations like: the user wants to sync my Postgres columns to person properties; map a warehouse table to people; replace our daily identify cron; update person properties from the warehouse.

How do I install Setting Up Warehouse Properties in Claude Code?

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

How do I install Setting Up Warehouse Properties in Codex?

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

Can I use Setting Up Warehouse Properties 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 setting-up-warehouse-properties -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/setting-up-warehouse-properties, .gemini/skills/setting-up-warehouse-properties, .github/skills/setting-up-warehouse-properties and .opencode/skills/setting-up-warehouse-properties in your project.

What does Setting Up Warehouse Properties need to run?

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

Does Setting Up Warehouse Properties 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 Setting Up Warehouse Properties 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 Setting Up Warehouse Properties use?

Setting Up Warehouse Properties 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 Setting Up Warehouse Properties use?

About 2.3k tokens (SKILL.md is roughly 9.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Setting Up Warehouse Properties?

Skills that share tags, products or a category with Setting Up Warehouse Properties: DB Sculptor (EliasOulkadi/shokunin, 114 stars), Clickhouse Io (hellangleZ/burn-in-cceverywhere-ralph, 112 stars), Analyzing Data (astronomer/agents, 451 stars) and Altimate Data Warehouse Delegate (AltimateAI/data-engineering-skills, 128 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Setting Up Warehouse Properties?

PostHog (a GitHub organization, an official publisher) maintains it in PostHog/posthog, which has 40,200 GitHub stars. The repository holds 252 skills in this directory. The repository was last updated on October 9, 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.