RP

    Repair Pagination Drift

    by Mariusz Wrzeszczynski

    1

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

    Secure checkout via Stripe

    0 installsSecurity scanned

    Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLIVVS CodeWWindsurfMManus+14 more

    See it in action

    You say

    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.

    Your agent does

    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.

    What you get

    Migrate from unstable offset to cursor-based pagination.Add deterministic tie-breakers to non-unique sort fields.Verify pagination consistency during concurrent data writes.Protect tenant boundaries within paginated results.

    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.

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean today

    Listedtoday

    Creator

    Mariusz Wrzeszczynski
    Mariusz Wrzeszczynski

    109 skills on Agensi

    Frequently Asked Questions

    Browse More Skills