skills.rest
kangmomin
kangmominCOMMUNITY
Explore all skills by this author →
GitHub

pagenation-mm

Standardize cursor-based pagination with deterministic ordering and SQL-safe queries.

1|1|Updated Apr 9, 2026
Search Tags:#backend#pagination#gorm#api-design#cloudkit#cursor-based-pagination
One-click install
npx skills add https://github.com/kangmomin/harness-plugins --skill pagenation-mm
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pagenation-mm
Source: https://github.com/kangmomin/harness-plugins/tree/main/plugins/minmos-harness/skills/pagenation-mm
Command: npx skills add https://github.com/kangmomin/harness-plugins --skill pagenation-mm

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Cursor-based pagination is standardized to ensure deterministic ordering and reliable navigation through API lists.

Core Features & Use Cases

  • Deterministic ordering across pages even with concurrent data changes.
  • Cursor encode/decode support for next-page navigation with stable ties.
  • Query safety with snake_case mapping and ID-based tie-breakers to avoid duplicates.

Quick Start

Follow the Cursor-based Pagination Convention to implement consistent cursor-based pagination across list endpoints.

Frequently Asked Questions about pagenation-mm

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How does cursor-based pagination ensure deterministic ordering across API list pages?▼

Cursor-based pagination ensures deterministic ordering by using stable tie-breakers like ID-based sorting, encoding cursors for navigation, and validating order consistency to prevent duplicates across concurrent data changes.

How do I implement cursor-based pagination with GORM for large datasets?▼

Implement cursor-based pagination with GORM by decoding cursors, building SQL-safe queries with snake_case mapping, applying ID-based tie-breakers for stable ties, and returning a nextCursor value for subsequent page navigation.

Why does my API pagination skip or duplicate records when data changes concurrently?▼

API pagination duplicates or skips records because standard offset pagination lacks deterministic ordering. Implementing cursor-based pagination with ID-based tie-breakers ensures stable ties and consistent ordering across concurrent data modifications.

Can I use cursor-based pagination with multiple sort keys in backend API design?▼

Yes, cursor-based pagination supports multiple sort keys by validating order consistency and applying SQL-safe queries with ID-based tie-breakers, ensuring stable and deterministic results across large datasets.

What is the best way to standardize cursor encode and decode for next-page navigation?▼

Standardize cursor encode and decode by implementing a consistent cursor-based pagination convention that handles stable ties, validates ordering consistency, and generates a nextCursor value for reliable API list navigation.

Related Skills

Explore More Software Engineering Skills→
SebdysartSebdysart

pagination-implementer

Enforces offset-based pagination with `{ collection, total }` return shapes in HustleXP backend SQL and Prisma patterns.

Community
Intermediate
hendrax5hendrax5

phase-6-ui-integration

Implement frontend UI and integrate it with backend APIs.

Community
Intermediate
salvo-rssalvo-rs
20

salvo-testing

Validate Salvo handlers, middleware, and routing with TestClient.

Official
Intermediate
7a336e6e7a336e6e
1

Building API Routes

Develop RESTful Flask API routes with validation and pagination.

Community
Intermediate