More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Repair PostgreSQL Replica Identity Update Stream Gap

    1

    Restore consistent downstream UPDATE events when replica identity settings omit required old-row keys

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Repair PostgreSQL Replica Identity Update Stream Gap

    Repair PostgreSQL Replica Identity Update Stream Gap

    Example session with this skill installed

    An UPDATE on orders is visible on the primary but the connector cannot resolve prior customer keys.

    Available sources: publication config and table replica identity (partial excerpts only). Additional evidence requested: CDC before/after samples, connector errors. Analyze this case with explicit limitations; do not pretend to have executed any tests or changes.

    • Read your context and instructions
    • Compiled the repair postgresql replica

    Repair PostgreSQL Replica Identity Update Stream Gap — EVIDENCE-LIMITED REVIEW

    Scenario received

    An UPDATE on orders is visible on the primary but the connector cannot resolve prior customer keys.

    Source register

    • S1: publication config — partial extract described, independent verification not provided.
    • S2: table replica identity — partial extract described, independent verification not provided.
    • S3: CDC before/after samples — NOT PROVIDED; validation pending.
    • S4: connector errors — NOT PROVIDED; validation pending.

    Case-specific checks

    1. compare replica identity with primary-key contract — NEEDS VERIFICATION against S1/S2 and missing sources.
    2. trace before-image availability — NEEDS VERIFICATION against S1/S2 and missing sources.
    3. identify impacted UPDATE operations — NEEDS VERIFICATION against S1/S2 and missing sources.
    4. stage reversible table and connector checks — NEEDS VERIFICATION against S1/S2 and missing sources.

    Deliverables and review gates

    • before-image coverage table: DRAFT ONLY; do not infer unsupported outcomes.
    • affected stream window: DRAFT ONLY; do not infer unsupported outcomes.
    • safe schema and connector repair plan: DRAFT ONLY; do not infer unsupported outcomes.

    Preliminary conclusion

    INCOMPLETE / REVIEW REQUIRED. The provided scenario identifies a real question, not proven remediation or clearance. Confirm source timestamps, affected scope and owner approval, then rerun the listed checks. No external system was accessed or changed.

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

    About this skill

    Repair PostgreSQL Replica Identity Update Stream Gap is a ToolForge Labs ChatGPT Skill workflow. Restore consistent downstream UPDATE events when replica identity settings omit required old-row keys.

    What this skill checks

    1. compare replica identity with primary-key contract.
    2. trace before-image availability.
    3. identify impacted UPDATE operations.
    4. stage reversible table and connector checks.

    What to provide

    • publication config.
    • table replica identity.
    • CDC before/after samples.
    • connector errors.

    Deliverables

    • before-image coverage table.
    • affected stream window.
    • safe schema and connector repair plan.

    Evidence policy Only supplied, authorized evidence is used. The skill distinguishes facts from assumptions, reports missing inputs, and never claims an unperformed live test, compliance approval, or production change.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    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 25 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.

    Listed25 days ago
    Updated9 days ago

    What's inside

    Frequently Asked Questions

    This skill identifies why UPDATE events in your CDC pipeline are missing 'before' values or failing to sync, then provides the precise SQL commands and connector settings needed to fix the replica identity without causing unnecessary database bloat.

    The skill is compatible with all versions of PostgreSQL that support logical replication (9.4+) and is designed for use with popular downstream consumers like Debezium, AWS DMS, and Apache Flink.

    Unlike a basic prompt, this skill uses a four-step diagnostic framework that prioritizes performance, ensuring you don't default to 'REPLICA IDENTITY FULL' unless it is strictly necessary for your data integrity requirements.

    No direct database access is required; you simply provide the agent with requested configuration snippets and log errors, and it generates the repair plan for you to review and execute.

    You receive the full diagnostic framework, the step-by-step repair staging logic, and a guide on how to provide the necessary evidence from your logs and schema to get the best results.

    New in Data & Databases