setting-up-warehouse-properties — Claude Code skill: setup
The setting-up-warehouse-properties Claude Code skill maps warehouse columns to person or group properties in PostHog. It runs for reverse ETL setup or when replacing a recurring identify job.
no license 148 installs ★ 101 updated 2026-10-24
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a claude-codeWhat setting-up-warehouse-properties does
The skill sets up property sync from a table or materialized view that is already connected to PostHog. It identifies the source and the column holding a distinct ID or group key, then drafts one complete column-to-property mapping for approval. Existing property names are checked for collisions before the source is created.
The identifier column, $-prefixed fields, and email, name, and username are left out of the proposed mapping. Null values leave current properties unchanged, and rows with no matching PostHog person are skipped; the sync does not create profiles. Person and group targets require the warehouse-person-properties feature. Group targets also need the group:write scope. A materialized view must already be materialized.
What it helps with
- copy warehouse table columns into PostHog person properties
- replace a recurring identify job with warehouse property sync
- spot mapped names that collide with existing properties
- populate existing people or groups from historical warehouse rows
Example prompts for the agent
- Map
postgres.customer_attributescolumns to PostHog person properties. - Set up warehouse property sync to replace our recurring identify job.
- Prepare a column mapping from a materialized view to group properties.
How to install setting-up-warehouse-properties
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a claude-code2Manually: put the files in place
~/.claude/skills/setting-up-warehouse-properties/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/setting-up-warehouse-properties/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a codex2Manually: put the files in place
.agents/skills/setting-up-warehouse-properties/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a cursor2Manually: put the files in place
.cursor/skills/setting-up-warehouse-properties/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install PostHog/ai-plugin skills/setting-up-warehouse-properties2Manually: put the files in place
.github/skills/setting-up-warehouse-properties/SKILL.md1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a gemini-cli2Platform CLI
gemini skills install https://github.com/PostHog/ai-plugin --path skills/setting-up-warehouse-propertiesManually: put the files in place
.devin/skills/setting-up-warehouse-properties/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about setting-up-warehouse-properties
How do I install setting-up-warehouse-properties in Claude Code?
Run npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a claude-code. The skill file is at ~/.claude/skills/setting-up-warehouse-properties/SKILL.md.
What does setting-up-warehouse-properties do?
It helps configure a sync from an existing warehouse table or materialized view into PostHog person or group properties. It also checks the identifier and existing property names before the mapping is created.
What does setting-up-warehouse-properties need to run?
The source table must already be syncing, and a view must be materialized. Person and group targets need the warehouse-person-properties feature; group targets also require the group:write scope.