Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add PostHog/ai-plugin --skill setting-up-warehouse-properties -a claude-code
Open on GitHub

What 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_attributes columns 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-code

2Manually: put the files in place

~/.claude/skills/setting-up-warehouse-properties/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/setting-up-warehouse-properties/

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.

Similar skills

All skills for Data and databases →

From the same set82

The whole set →
validating-and-publishing-canvases The validating-and-publishing-canvases skill for Claude Code checks PostHog Canvas source projects and publishes them with version guards. It verifies declared capabilities and handles merge conflicts without data loss. CX Codex +1 148installs analyzing-task-runs analyzing-task-runs — a Claude Code skill that breaks down a completed task run from its log and records the activities. It starts when asked to analyze a run or review an attached log. CX Codex +1 148installs review-hog-resolution-criteria The review-hog-resolution-criteria Claude Code skill resolves open pull request review comments. It makes verifiable changes, explains declines, and hands risky decisions to a person. CX Codex +1 148installs working-with-scouts The working-with-scouts Claude Code skill helps manage PostHog Signals scouts that watch a project and send reports to the Signals inbox. Assign monitoring tasks, review findings, and steer the scouts with feedback. CX Codex +1 148installs suggesting-path-cleaning-rules suggesting-path-cleaning-rules is a Claude Code skill that proposes URL path-cleaning rules for web analytics. It engages on requests to generate or inspect suggestions and troubleshoot path_cleaning_suggestions issues. CX Codex +1 148installs authoring-data-quality-checks authoring-data-quality-checks is a Claude Code skill that adds and runs dbt-style data quality checks on warehouse tables and HogQL metrics. It runs when validating models or checking for nulls and duplicates. CX Codex +1 148installs querying-canvas-data The querying-canvas-data Claude Code skill helps put PostHog data into a canvas and make its metrics traceable to their source. It applies when a canvas needs charts, tables, analytics events, or data from GitHub or an MCP server. CX Codex +1 148installs creating-surveys The creating-surveys Claude Code skill creates PostHog surveys and forms through MCP. It activates for requests to build a survey or call survey-create. CX Codex +1 127installs

Project sponsors

Companies that keep this analytics open