Skip to main content
skill CX Codex

setting-up-data-catalog — Claude Code skill: data catalog setup

setting-up-data-catalog fills a project's data catalog: canonical metric definitions, trust marks on warehouse tables, and reviewed join proposals.

no license 182 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-data-catalog -a claude-code
Open on GitHub

What setting-up-data-catalog does

The skill keeps a per-project inventory of three things: what a metric means, which of several similar tables can be trusted, and how tables join. Your data stays where it is. Reads go through SQL against system.information_schema; writes go through the data-catalog MCP tools.

Setup runs top-down. It proposes certifications for the tables your team leans on and deprecation for stale or duplicate copies, samples candidate keys with posthog:execute-sql before any join is proposed, and builds metrics out of the project's most-used insights, linking each to its source_insight_short_id so later drift can be detected.

Nothing an agent writes counts until a person approves it. Promotion tools come in pairs: the -prepare call shows a confirmation message, you type confirm, then the -execute call takes the returned hash. Without the data-catalog MCP tools there is no write path at all — plain SQL only reads.

What it helps with

  • certify the warehouse tables the team actually relies on
  • measure a join key's match rate before proposing the relationship
  • turn a heavily used insight into a canonical metric
  • clear the review queue of pending certifications and joins
  • catch a metric that drifted from its source query

Example prompts for the agent

  • Seed the data catalog: propose certifications for the main tables and the joins between them
  • Show the pending relationship proposals with their match-rate evidence and wait for my confirmation
  • Create a metric from the project's most-used insight and record its grain

How to install setting-up-data-catalog

1Skills CLI (Vercel)

npx skills add PostHog/ai-plugin --skill setting-up-data-catalog -a claude-code

2Manually: put the files in place

~/.claude/skills/setting-up-data-catalog/SKILL.md

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

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about setting-up-data-catalog

How do I install setting-up-data-catalog in Claude Code?

Run npx skills add PostHog/ai-plugin --skill setting-up-data-catalog -a claude-code. The skill file lands at ~/.claude/skills/setting-up-data-catalog/SKILL.md.

What does setting-up-data-catalog do?

It builds and curates the semantic layer: canonical metrics, certifications on warehouse tables and views, and table relationships backed by measured evidence.

Why don't the agent's changes apply right away?

Everything an agent writes is stored unapproved. Promotion is a two-step call: -prepare returns a confirmation message, and after you type confirm, -execute applies it with the returned hash.

Similar skills

All skills for Data and databases →

From the same set82

The whole set →
review-hog-perspective-performance-reliability The review-hog-perspective-performance-reliability skill reviews code for performance and reliability concerns, from database access to error recovery. Use it when checking a change before it ships. CX Codex +1 187installs review-hog-perspective-logic-correctness review-hog-perspective-logic-correctness reviews one slice of a pull request for correctness: arithmetic, branches, data mapping, database queries. Useful when you want a focused second pass before merging. CX Codex +1 187installs copying-endpoints-across-projects copying-endpoints-across-projects duplicates PostHog API endpoints across projects in the same organization or clones them under a new name. Useful for promoting HogQL endpoints between environments. CX Codex +1 183installs signals-scout-conversations The signals-scout-conversations skill checks PostHog Conversations analytics for SLA breaches, slow first replies, and support-queue imbalances. Use it to spot operational changes across tickets. CX Codex +1 183installs signals-scout-tasks signals-scout-tasks — a scout skill for PostHog Tasks: it tracks how task runs get delivered and, on a slower pass, looks for the same request coming up again in tasks people wrote. CX Codex +1 179installs managing-streamlit-apps managing-streamlit-apps controls Streamlit apps in PostHog sandboxes using MCP tools, handling everything from provisioning to safe code patching. CX Codex +1 179installs modeling-activation-metrics modeling-activation-metrics builds an activation model: a per-user or per-account activated flag plus an activation-rate metric. Useful while the “aha moment” is still a guess. CX Codex +1 178installs modeling-conversion-metrics modeling-conversion-metrics builds a reusable conversion model: funnel steps, a conversion window, drop-off and time to convert. Works on PostHog warehouse views in HogQL or in a dbt project. CX Codex +1 178installs

Project sponsors

Companies that keep this analytics open