SkillVaultskills Browse all 500 skills

Data · Version 1.2.0 · Reviewed 2026-08-02

Data Quality Contract Designer

Make data systems more correct and operable for contract definition and freshness and completeness checks with evidence, explicit trade-offs, and a verification plan.

4 method steps 6 documented failure modes 5 diagnostic checks 7 quality gates

Designs enforceable data contracts with schema, semantic, freshness, and completeness expectations plus a defined breach response.

₹149 one-time

Get this skill archive

What this skill helps you do

  • Contract definition
  • Freshness and completeness checks
  • Breach escalation design

How Data Quality Contract Designer works

You provide

Producer schema, consumer expectations, and past breakages

It inspects

Schema, semantic, freshness, and completeness assertions

It decides

Contract terms plus the breach response for each

You verify

A deliberately violated batch triggers the defined action

What it checks first

Data Quality Contract Designer designs enforceable data contracts with schema, semantic, freshness, and completeness expectations plus a defined breach response. Use it when the work involves Contract definition, Freshness and completeness checks, Breach escalation design.

  1. Whether the test asserts behavior or implementation, because implementation-coupled tests break on safe refactors.
  2. Sources of nondeterminism: time, randomness, ordering, concurrency, network, and shared state.
  3. Whether tests share mutable state, which makes failures depend on execution order.
  4. The test pyramid balance, since a suite dominated by end-to-end tests is slow and flaky by construction.
  5. Whether a failing test failed for the intended reason, verified by making it fail deliberately.

Failure modes it recognizes

  • A flaky test caused by a fixed sleep instead of waiting for the actual condition.
  • Tests passing in isolation and failing in suite because of leaked global or database state.
  • Time-dependent assertions failing at month or year boundaries or across daylight-saving transitions.
  • Over-mocking that verifies the mock rather than the integration, so the suite passes while production breaks.
  • A test asserting on unordered collection order, which passes until the implementation changes hashing.
  • Coverage measured but assertions absent, so lines execute without being verified.

Answers it will reject

  • Retrying a flaky test to make CI green, which converts a real intermittent bug into an invisible one.
  • Chasing a coverage percentage, which produces tests that execute code without asserting behavior.
  • Writing an end-to-end test for logic that a unit test could cover deterministically and instantly.
  • Deleting a failing test to unblock a release without recording the risk that was accepted.

Decision rules it applies

  • Choose the cheapest test level that can actually observe the failure mode.
  • A flaky test is a defect in the test or the system; quarantine with an owner and a deadline, never ignore.
  • Assert on observable behavior and public contracts so refactors stay free.
  • Every bug fix gets a test that fails before the fix and passes after it.

Evidence it asks for

  • Run the suite in randomized order to expose inter-test dependencies.
  • Track flake rate per test over time rather than treating each failure as isolated.
  • Verify a new test fails when the behavior is broken, not only that it passes when correct.

The method inside

  1. Translate contract definition into observable risks and falsifiable acceptance criteria.
  2. Choose the cheapest test level that can expose failures in freshness and completeness checks.
  3. Add representative positive, negative, boundary, and regression cases for breach escalation design.
  4. Define deterministic pass/fail signals, ownership, and the release decision when a check fails.

Deliverables

  • Contract definition assessment
  • Freshness and completeness checks decision and action plan
  • Breach escalation design verification checklist

Evidence requirements

  • Schema, access patterns, query plans, or event contracts
  • Volume, cardinality, retention, and freshness
  • Consistency, latency, and migration constraints

Quality gates

  • Every material claim traces to supplied evidence or is labeled as a hypothesis.
  • The response follows the declared deliverable contract.
  • No execution, access, measurement, or verification is invented.
  • Secrets and personal data are redacted rather than repeated.
  • The user receives a concrete independent verification step.
  • The relevant failure modes in this domain were considered rather than only the reported symptom.
  • No listed anti-pattern was recommended as a solution.

Example task

Input

Our downstream dashboards silently show wrong numbers whenever an upstream team changes their event schema.

Expected output

Silent wrongness means the pipeline accepts bad data rather than rejecting it. A contract needs both a schema assertion and a semantic assertion, because a field can stay the correct type while its meaning changes. Define the breach response before the checks: fail the pipeline, quarantine the batch, or serve stale...

Boundaries and compatibility

Ideal for

  • Contract definition: produce a decision or artifact grounded in supplied evidence.
  • Freshness and completeness checks: produce a decision or artifact grounded in supplied evidence.
  • Breach escalation design: produce a decision or artifact grounded in supplied evidence.

Out of scope

  • Recommending indexes without a workload
  • Treating eventual consistency as universally acceptable

Agent compatibility

  • GitHub Copilot custom agents
  • Claude Agent Skills / SKILL.md
  • Any instruction-following chat model

Tool policy: Advisory by default. No tools are assumed. If the host provides tools, use read-only evidence gathering unless the user explicitly approves a scoped write or execution action.