CtrlK
BlogDocsLog inGet started
Tessl Logo

diagnosing-failed-warehouse-syncs

Diagnose why a data warehouse sync is failing and recommend the right recovery action. Use when the user asks "why isn't my Stripe/Postgres/Hubspot sync working?", "this table has been stuck for hours", "the data in the warehouse looks wrong", or wants to troubleshoot a specific source or schema. Covers source-level vs schema-level failures, stuck Running states, credential and schema-drift errors, incremental-field misconfig, CDC prerequisite failures, and the cancel / reload / resync / delete-data recovery actions.

77

Quality

96%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

High

Do not use without reviewing

SKILL.md
Quality
Evals
Security

Quality

Content

92%

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

A highly actionable, well-sequenced diagnostic workflow with concrete tools, parameters, and an explicit destructive-action checkpoint. Its only weakness is progressive disclosure: substantial reference tables sit inline in one long file with no bundle files to offload them.

Suggestions

Move the Available tools table and the latest_error substring→root-cause mapping table into a references/ file (e.g. tools-and-errors.md) and link to them from the main body to keep SKILL.md an overview.

Consider extracting the nine recovery-action branches (A–I) into a references/recovery-actions.md, leaving a compact decision pointer in the body that links out for each case.

DimensionReasoningScore

Conciseness

Dense, technical prose assuming Claude's competence with no concept padding; status and error mappings are compressed into tables so every token earns its place rather than being padded prose.

3 / 3

Actionability

Gives concrete tool names with exact parameter shapes (e.g. external-data-sources-partial-update with {job_inputs: {stripe_secret_key: "..."}}) and a worked example interaction, making the guidance copy-paste ready.

3 / 3

Workflow Clarity

Sequences a clear top-down process (locate → classify status → interpret latest_error → pick recovery → confirm destructive actions) with an explicit validation checkpoint in Step 5 requiring approval before destructive calls, satisfying the feedback-loop requirement for destructive operations.

3 / 3

Progressive Disclosure

The skill is self-contained with clear sections and no broken references, but it is a fairly long single file where large reference tables (the 20-row tool table and the error-substring mapping) are candidates for externalization that remain inline.

2 / 3

Total

11

/

12

Passed

Description

100%

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

A tightly written description that states concrete capabilities, gives explicit verbatim user triggers, and carves out a clearly distinct niche. It answers both what and when without verbosity or fluff.

DimensionReasoningScore

Specificity

Lists multiple concrete actions ("Diagnose why a data warehouse sync is failing and recommend the right recovery action") plus specific failure categories and the "cancel / reload / resync / delete-data recovery actions", matching the multiple-specific-actions anchor.

3 / 3

Completeness

Explicitly answers both what (diagnose failing sync + recommend recovery; covers listed failure types) and when via a "Use when..." clause with quoted triggers, matching the both-what-and-when anchor.

3 / 3

Trigger Term Quality

Embeds natural verbatim user phrases ("why isn't my Stripe/Postgres/Hubspot sync working?", "this table has been stuck for hours", "the data in the warehouse looks wrong") giving strong coverage of terms users would actually say.

3 / 3

Distinctiveness Conflict Risk

Clear niche of data-warehouse sync diagnosis with distinct triggers naming Stripe/Postgres/Hubspot syncs and specific failure modes, making it unlikely to fire for an unrelated skill.

3 / 3

Total

12

/

12

Passed

Validation

100%

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

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
PostHog/posthog
Reviewed

Table of Contents

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.