Official Verified

pagination

Pagination pattern reference — offset, cursor, keyset, and hybrid strategies for APIs and databases. Use when designing paginated endpoints, choosing pagination strategies, or optimizing large dataset traversal.

skill-install — Terminal

Install via CLI (Recommended)

clawhub install openclaw/skills/skills/bytesagain/pagination

Download Source Code (.zip)

Pagination — Pagination Pattern Reference

Quick-reference skill for pagination strategies, trade-offs, and implementation patterns.

When to Use

Designing paginated REST or GraphQL APIs
Choosing between offset, cursor, and keyset pagination
Optimizing database queries for large datasets
Implementing infinite scroll or page-based navigation
Debugging pagination edge cases (duplicates, missing items)

Commands

`intro`

scripts/script.sh intro

Overview of pagination — why it exists, core concepts, and terminology.

`offset`

scripts/script.sh offset

Offset-based pagination (LIMIT/OFFSET) — how it works, SQL examples, and pitfalls.

`cursor`

scripts/script.sh cursor

Cursor-based pagination — opaque tokens, GraphQL Relay spec, implementation details.

`keyset`

scripts/script.sh keyset

Keyset (seek) pagination — using WHERE clauses instead of OFFSET for O(1) performance.

`compare`

scripts/script.sh compare

Side-by-side comparison of all pagination strategies with trade-off matrix.

`pitfalls`

scripts/script.sh pitfalls

Common pagination bugs: phantom reads, duplicates on insert, off-by-one errors.

`api`

scripts/script.sh api

API design patterns for pagination — headers, link relations, envelope formats.

`sql`

scripts/script.sh sql

SQL cookbook — optimized queries for each pagination strategy with index advice.

`help`

scripts/script.sh help

`version`

scripts/script.sh version

Configuration

Variable	Description
`PAGINATION_DIR`	Data directory (default: ~/.pagination/)

Powered by BytesAgain | bytesagain.com | [email protected]

Read Full Documentation on GitHub

Metadata

Author@bytesagain

Stars3500

Updated2026-03-27

View Author Profile

AI Skill Finder

Not sure this is the right skill?

Describe what you want to build — we'll match you to the best skill from 16,000+ options.

Find the right skill

Add to Configuration

Paste this into your clawhub.json to enable this plugin.

{
  "plugins": {
    "official-bytesagain-pagination": {
      "enabled": true,
      "auto_update": true
    }
  }
}

Related Skills

mcp-builder

Bootstraps new Model Context Protocol (MCP) servers from a natural language description. Use when the user asks to build an MCP server, create an MCP tool, scaffold an MCP integration, or add MCP capabilities to an existing project. NOT for: general API design, non-MCP tool building, or frontend tasks.

asimons81 4473

scrapebadger

Web scraping platform — Twitter/X data, Vinted marketplace, and general web scraping API

0xghostcasper 4473

clinicaltrials-gov-parser

Monitor and summarize competitor clinical trial status changes from ClinicalTrials.gov. Trigger: When user asks to track clinical trials, monitor trial status changes, get updates on specific trials, or analyze competitor trial activities. Use cases: Pharma competitive intelligence, trial monitoring, status tracking, recruitment updates, completion alerts.

aipoch-ai 4473

aethercore

AetherCore v3.3.4 - Security-focused final release. High-performance JSON optimization with universal smart indexing for all file types. All security review issues fixed, ready for production.

aetherclawai 4473

agent3-hub

Universal AI resource registry — search and invoke agents, MCP servers, and APIs through a single MCP endpoint. Includes Telegram content search, Google search, X/Twitter search, and more.

agent3-666 4473