setting-up-a-data-warehouse-source

Guide the user through connecting a new data warehouse source — Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery, Snowflake, and so on. Use when the user wants to "connect Stripe", "import data from Postgres", "add a new data source", "sync my warehouse tables", or wants to pick sync methods for each table. Walks through source-type discovery, credential validation, table discovery, per-table sync_type selection, and the final create call. Also covers picking a good prefix and what to do right after creation.

Quality

95%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

Quality

Content

90%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The content is a high-quality, actionable runbook with executable tool calls, concrete examples, and clearly sequenced workflows with validation checkpoints and error-recovery loops. Its only weakness is moderate redundancy between the inline flow guidance and the closing 'Important notes' section.

Suggestions

Dedupe the credential gotchas, webhook two-step reminder, and prefix advice between the inline steps and the 'Important notes' section — keep each point in one canonical place and cross-reference instead.

The 'Important notes' bullet about destinations is dense and partly tangential to source creation; consider moving it to a reference file or trimming to the load-bearing fact.

Dimension	Reasoning	Score
Conciseness	The body is information-dense and assumes Claude's competence (no boilerplate explanations of what a database or webhook is), but a few sections restate guidance already covered elsewhere (e.g. credential gotchas, webhook two-step setup, prefix advice appear in both the main flow and the 'Important notes'), which could be trimmed.	4 / 5
Actionability	Provides fully executable guidance throughout — concrete tool call signatures with parameters, a complete copy-paste-ready `external-data-sources-create` JSON payload, exact Supabase host/port/username values, and per-source key requirements — covering the common cases precisely.	5 / 5
Workflow Clarity	Multi-step processes (one-step and three-step flows, CDC, webhook registration) are explicitly sequenced with numbered steps, validation checkpoints (db-schema before create, webhook-info-retrieve to avoid duplicate registration, CDC prerequisites), and error-recovery feedback loops for webhook permission failures.	5 / 5
Progressive Disclosure	SKILL.md is a clear overview with well-signaled one-level-deep references to the real `./references/sync-types.md` file (linked twice in context), and the sync-type detail is appropriately split out rather than inlined; navigation is easy and references are not nested.	5 / 5
	Total	19 / 20 Passed

Description

100%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description is a strong, third-person summary that names concrete capabilities and pairs them with realistic user trigger phrases across multiple source types. It cleanly answers both what the skill does and when to invoke it, with low conflict risk.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions ('source-type discovery, credential validation, table discovery, per-table sync_type selection, and the final create call') plus prefix selection and post-creation steps, giving comprehensive coverage of the skill's capabilities.	5 / 5
Completeness	Explicitly answers both what ('Guide the user through connecting a new data warehouse source...') and when ('Use when the user wants to...') with concrete trigger phrases, satisfying the highest anchor.	5 / 5
Trigger Term Quality	Quotes natural phrases users actually say across varied verbs and sources ('connect Stripe', 'import data from Postgres', 'add a new data source', 'sync my warehouse tables'), with comprehensive synonym coverage.	5 / 5
Distinctiveness Conflict Risk	Targets a clear niche (connecting external data sources to PostHog's warehouse) with distinct, source-specific triggers, giving minimal overlap with unrelated skills.	5 / 5
	Total	20 / 20 Passed

Validation

100%

Warnings & errors only

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository: PostHog/posthog
Path: products/warehouse_sources/skills/setting-up-a-data-warehouse-source/SKILL.md
Commit: b0fece0

Reviewed: 3 days ago

Table of Contents

Discovery Implementation Validation

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.