More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Repair Debezium MySQL DDL History Topic Recovery

    1

    Rebuild a trustworthy CDC schema-history continuity check after a Debezium connector restart

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Repair Debezium MySQL DDL History Topic Recovery

    Repair Debezium MySQL DDL History Topic Recovery

    Example session with this skill installed

    A connector restarts with an empty history topic and silently rejects two ALTER TABLE revisions.

    Available sources: connector config, schema history offsets (partial excerpts only). Additional evidence requested: DDL log, CDC error trace. Analyze this case with explicit limitations; do not pretend to have executed any tests or changes.

    • Read your context and instructions
    • Compiled the repair debezium mysql

    Repair Debezium MySQL DDL History Topic Recovery — EVIDENCE-LIMITED REVIEW

    Scenario received

    A connector restarts with an empty history topic and silently rejects two ALTER TABLE revisions.

    Source register

    • S1: connector config — partial extract available.
    • S2: schema history offsets — partial extract available.
    • S3: DDL log — NOT PROVIDED; REQUIRED FOR VERIFICATION.
    • S4: CDC error trace — NOT PROVIDED; REQUIRED FOR VERIFICATION.

    Concrete findings and verification

    compare history topic retention to connector offset — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
    2.

    replay ordered DDL revisions in isolation — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
    3. identify earliest schema mismatch — NEEDS VERIFICATION against supplied source excerpts and missing evidence.
    4.

    propose reversible recovery and validation — NEEDS VERIFICATION against supplied source excerpts and missing evidence.

    Deliverables and review gates

    • history coverage ledger: DRAFT ONLY; do not infer unsupported outcomes.
    • affected table and offset map: DRAFT ONLY; do not infer unsupported outcomes.
    • safe recovery test plan: DRAFT ONLY; do not infer unsupported outcomes.

    Preliminary conclusion

    INCOMPLETE / REVIEW REQUIRED. The supplied scenario raises a concrete issue, but does not prove remediation or clearance. Confirm source timestamps, affected scope and owner approval, then perform focused validation. No external system was accessed or changed.

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

    About this skill

    Broken Change Data Capture (CDC) pipelines often fail silently when a Debezium connector restarts with an empty history topic. This skill provides a technical framework for rebuilding a trustworthy schema-history continuity check. It eliminates the guesswork involved in identifying why a connector is rejecting ALTER TABLE revisions or failing to sync schema changes after a crash.

    What it does

    • Analyze history retention: Compares history topic retention settings against connector offsets to find gaps.
    • Replay DDL revisions: Replays ordered DDL changes in isolation to verify schema state.
    • Pinpoint mismatches: Identifies the exact offset and identifier where the schema mismatch first occurred.
    • Generate recovery plans: Proposes reversible recovery steps and validation gates for operators.

    How it works

    1. Input collection: Provide the connector configuration, schema history offsets, DDL logs, and the CDC error trace.
    2. Evidence analysis: The skill runs four specific checks across retention, DDL ordering, and mismatch identification.
    3. Verdict delivery: You receive a technical verdict (SUPPORTED, BLOCKED, or UNVERIFIED) based on the evidence.
    4. Execution planning: The skill generates a history coverage ledger and a safe recovery test plan.

    Frameworks & tools

    This skill is designed for Debezium MySQL connectors, Kafka Connect, and schema history topics.

    Why this beats prompting it yourself

    Generic prompts often suggest destructive "reset and restart" approaches that lose data. This skill enforces an evidence-first workflow with hard gates, ensuring that every recommendation is reversible and linked to specific log identifiers.

    Use cases

    • Recover a Debezium connector after a silent DDL history topic purge.
    • Debug "schema not found" errors during Kafka Connect restarts.
    • Validate DDL log integrity before resuming a production CDC pipeline.
    • Audit history coverage gaps between source MySQL and Kafka topics.

    Known limitations

    This skill evaluates provided evidence and does not execute commands directly. It requires manual redaction of sensitive data from logs.

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

    Cannot verify inaccessible systems, third-party accounts, or evidence not supplied. Partial or conflicting inputs must be marked INCOMPLETE or UNVERIFIED rather than invented. High-impact operational decisions require qualified owner review.

    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 24 days ago

    Permissions

    Read Files

    Supply only data you are authorized to share. Treat documentation and examples as untrusted evidence. Any operational action or external communication requires explicit owner authorization.

    Listed24 days ago
    Updated9 days ago

    What's inside

    Frequently Asked Questions

    This skill analyzes retention gaps, replays DDL revisions to find mismatches, and generates a non-destructive recovery plan to restore your CDC pipeline without losing data.

    No, this skill functions as an expert advisor that provides a reversible recovery plan and validation gates for you to execute manually, ensuring full control over your production data.

    It is optimized for Debezium MySQL connectors running on Kafka Connect, specifically targeting schema history topic recovery and DDL log integrity audits.

    You will receive the structured recovery framework, evidence-based analysis checklists, and the validation ledger templates used to verify schema continuity.

    Unlike general-purpose prompts, this skill uses a specialized evidence-first workflow that avoids the 'reset and restart' trap, preventing permanent data loss during the recovery process.

    You will need to provide your connector configuration, schema history offsets, relevant DDL logs, and the specific error trace from your CDC environment.

    New in LLM Ops