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.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/bytesagain/paginationPagination — 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]
Metadata
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 skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-bytesagain-pagination": {
"enabled": true,
"auto_update": true
}
}
}Tags
Related Skills
placed
Complete Placed career platform integration — resume builder, interview coach, job tracker, ATS checker, cover letter generator, LinkedIn optimizer, and salary tools. Use when the user wants to build or manage resumes, practice interviews, track job applications, optimize resumes for ATS, generate cover letters, research companies, or get salary insights via placed.exidian.tech.
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.
scrapebadger
Web scraping platform — Twitter/X data, Vinted marketplace, and general web scraping API
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.
arch-optimization
OpenClaw通信协议架构优化技能包 - 提供高性能、可靠的agent间通信框架。实现大消息59%性能提升,MessagePack 35%体积减少,统一传输层架构,智能路由算法,完整错误恢复和监控体系。