More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Repair Pagination Drift

    1

    Repair APIs where users see duplicate, missing, or reordered records while paging through changing data.

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Repair Pagination Drift

    Repair Pagination Drift

    Example session with this skill installed

    Fix the duplicate items appearing in our GET /v1/activity-feed endpoint when users scroll while new posts are being created. We use Postgres and Sequelize.

    • Read your context and instructions
    • Compiled the repair pagination drift

    I have updated the activity repository to use keyset pagination.

    • Added a unique tie-breaker (id) to the sort order.
    • Replaced OFFSET with a WHERE clause for the last seen ID.
    • Verified fix with a concurrent insert test script.

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

    About this skill

    Repair APIs where users see duplicate, missing, or reordered records while paging through changing data.

    This skill traces sort keys, cursors, filters, and concurrent writes. It replaces unstable offset logic with deterministic ordering, safe cursors, snapshot boundaries, and pagination tests.

    • Stop duplicate and skipped items
    • Stabilize infinite scroll
    • Preserve filters across cursors
    • Verify concurrent inserts and deletes

    Ideal for SaaS, feeds, catalogs, and admin systems.

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

    • Requires access to database schema and query logic.
    • Cannot fix drift caused by third-party APIs that do not support cursors or snapshots.

    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

    Software
    prismaNode.js

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    Permissions are limited to the active local workspace and are used to inspect user-supplied or local workspace 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
    Updated8 days ago

    What's inside

    Frequently Asked Questions

    It prefers Keyset (cursor) pagination for high-concurrency feeds but can stabilize Offset pagination using deterministic tie-breakers if architecture changes are restricted.

    The skill traces request parameters to database queries to ensure sort fields are unique, often by adding a primary key tie-breaker to the ORDER BY clause.

    It works with any standard SQL (PostgreSQL, MySQL) or NoSQL database by identifying the underlying query builder or ORM logic.