More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Repair Search Index Drift

    1

    Repair search indexes that contain missing, stale, duplicated, or deleted records and add safe reconciliation and rebuild controls.

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Repair Search Index Drift

    Repair Search Index Drift

    Example session with this skill installed

    Our Elasticsearch index is missing about 5% of our Postgres records after a worker crash. Can you reconcile the drift and fix the indexing pipeline to prevent this from happening again?

    • Read your context and instructions
    • Compiled the repair search index

    I detected 412 missing documents and 18 stale versions. I have implemented a versioned indexing contract using your Postgres 'xmin' as a monotonic version and added a reconciliation script that detects drift. Missing records have been backfilled without downtime using a temporary index.

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

    About this skill

    The problem

    Search results frequently fall out of sync with your database due to lost queue events, race conditions, or failed reindexing. Users see "ghost" results that were deleted or miss new records entirely because indexing updates were reordered or dropped.

    What it does

    • Detects missing, stale, and duplicate search documents by reconciling index state against your authoritative database.
    • Implements version-aware indexing to prevent older updates from overwriting newer data.
    • Automates safe, zero-downtime index rebuilds using alias-based cutovers and validation checks.
    • Repairs broken deletion logic by implementing stable tombstones and idempotent event processing.

    Frameworks & tools

    Elasticsearch, OpenSearch, Algolia, Meilisearch, and Typesense. Works with SQL and NoSQL databases using queues, transactional outboxes, or CDC pipelines.

    Why this beats prompting it yourself

    Generic prompts often suggest a full "delete and reindex," which causes downtime and ignores the root cause of drift. This skill enforces a versioned consistency model that handles specific edge cases like reordered events and partial bulk-update failures that basic prompts miss.

    Use cases

    • Fixing search results that stay stale after a database update or restore.
    • Removing deleted records that still appear in search results.
    • Implementing a transactional outbox to ensure every database change hits your index.
    • Migrating search mappings without losing data or risking downtime.

    Known limitations

    Requires an existing project workspace and access to both the database schema and search provider configuration. Cannot guarantee consistency if the database lacks a monotonic version or timestamp.

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

    Requires a workspace with database and search config. Cannot enforce safety if your database lacks monotonic versions (sequences or increments). No production deletes without validation.

    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 3 months ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    Permissions are limited to the active local workspace. They are used to inspect user-supplied or local project files; create or modify bounded local fixes, tests, documentation, or review artifacts; run repository-supported local tests, checks, builds, or parsing commands. The skill package does not require bundled credentials, unrestricted external network access, or automatic production changes.

    Listed3 months ago
    Updated9 days ago

    What's inside

    Frequently Asked Questions

    This skill identifies and fixes 'ghost' results, duplicate entries, and missing records by reconciling your search index against your authoritative database to ensure 100% data consistency.

    It is compatible with major search engines including Elasticsearch, OpenSearch, Algolia, Meilisearch, and Typesense, working alongside both SQL and NoSQL database environments.

    Unlike a basic reindex, this skill uses version-aware logic and alias-based cutovers to repair your index in the background, ensuring users never experience search downtime during the process.

    You will need an existing project workspace with access to your search provider's configuration and your database schema, ideally with a timestamp or versioning system in place for record tracking.

    The skill includes the logic for drift detection, version-aware indexing workflows, and automated reconciliation scripts, along with documentation for integrating it into your existing data pipeline.

    The skill implements a transactional outbox pattern and idempotent event processing, which ensures that even if a network error occurs, the indexing update will eventually succeed without creating duplicates.

    New in Agents & Orchestration