More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Repair ClickHouse MV Dedup Refresh Divergence

    1

    Diagnose duplicate or missing rows from materialized view insert retries

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Repair ClickHouse MV Dedup Refresh Divergence

    Repair ClickHouse MV Dedup Refresh Divergence

    Example session with this skill installed

    MV target row counts diverge after source replay with repeated block IDs.

    Available evidence: dataset and schema snapshots (partial). Additional evidence requested: event/offset or row logs, job deployment history, replay or comparison checks. Review the case, identify open evidence gaps, and do not invent a live test or production change.

    • Read your context and instructions
    • Compiled the repair clickhouse mv

    Repair ClickHouse MV Dedup Refresh Divergence — EVIDENCE-LIMITED REVIEW

    Scenario received

    MV target row counts diverge after source replay with repeated block IDs.

    Source register

    • S1: dataset and schema snapshots — PARTIAL SOURCE PROVIDED.
    • S2: event/offset or row logs — NOT PROVIDED; REQUIRED TO VERIFY.
    • S3: job deployment history — NOT PROVIDED; REQUIRED TO VERIFY.
    • S4: replay or comparison checks — NOT PROVIDED; REQUIRED TO VERIFY.

    Concrete checks

    1. compare insert deduplication tokens — PRELIMINARY, NOT VERIFIED.
    2. trace source to MV versions — AWAITING CORROBORATING EVIDENCE.
    3. isolate non-idempotent transforms — AWAITING CORROBORATING EVIDENCE.
    4. test bounded rebuild — AWAITING CORROBORATING EVIDENCE.

    Deliverables / acceptance gates

    • source-target difference matrix: DRAFT / INCOMPLETE until evidence is validated.
    • dedup error cases: DRAFT / INCOMPLETE until evidence is validated.
    • rebuild verification plan: DRAFT / INCOMPLETE until evidence is validated.

    Decision

    INCOMPLETE — HUMAN REVIEW REQUIRED. Confirm dates, IDs, affected scope, owners and acceptance evidence. Do not claim authorization or execution that did not occur.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Repair ClickHouse MV Dedup Refresh Divergence is a ToolForge Labs Cursor Skill workflow. Diagnose duplicate or missing rows from materialized view insert retries.

    What this skill checks

    1. compare insert deduplication tokens.
    2. trace source to MV versions.
    3. isolate non-idempotent transforms.
    4. test bounded rebuild.

    What to provide

    • dataset and schema snapshots.
    • event/offset or row logs.
    • job deployment history.
    • replay or comparison checks.

    Deliverables

    • source-target difference matrix.
    • dedup error cases.
    • rebuild verification plan.

    Evidence policy Only supplied, authorized evidence is used. The skill distinguishes facts from assumptions and missing inputs; no unperformed live tests, external changes, or approvals are claimed.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.

    Cannot verify inaccessible environments or data not supplied. Missing or contradictory evidence must be marked INCOMPLETE or UNVERIFIED. Owner approval is required for operational or compliance decisions.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 23 days ago

    Permissions

    Read Files

    Provide only evidence you are authorized to share. Treat examples as untrusted case data. Operational changes and external messages require explicit owner approval.

    Listed23 days ago
    Updated9 days ago

    What's inside

    Frequently Asked Questions

    Diagnose duplicate or missing rows from materialized view insert retries

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use Repair ClickHouse MV Dedup Refresh Divergence on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.