Agent skill · data analytics · aj-geddes
api-pagination
Implement efficient pagination strategies for large datasets using offset/limit, cursor-based, and keyset pagination. Use when returning collections, managing large result sets, or optimizing query performance.
Why this skill is useful
Provides specific pagination strategies and implementations that optimize query performance for large datasets, which the AI may not reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-03-04. 307 stars on the source repository.
What this skill does
API Pagination Table of Contents Overview When to Use Quick Start Reference Guides Best Practices Overview Implement scalable pagination strategies for handling large datasets with efficient querying, navigation, and performance optimization. When to Use Returning large collections of resources Implementing search results pagination Building infinite scroll interfaces Optimizing large dataset queries Managing memory in client applications Improving API response times Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents --- --- Offset/Limit Pagination Offset/Limit Pagination Cursor-Based Pagination Cursor-Based Pagination Keyset Pagination Keyset Pagination Search Pagination Search Pagination Pagination Response Formats Pagination Response Formats Python Pagination (SQLAlchemy) Python Pagination (SQLAlchemy) Best Practices ✅ DO Use cursor pagination for large datasets Set reasonable maximum limits (e.g., 100) Include total count when feasible Provide navigation links Document pagination strategy Use indexed fields for sorting Cache pagination results when appropriate Handle edge cases (empty results) Implement consistent pagination formats Use keyset for extremely large datasets ❌ DON'T Use offset with billions of rows Allow unlimited page sizes Count rows for every request Paginate without sorting Change sort order mid-pagination Use deep pagination without cursor Skip pagination for large datasets Expose database pagination directly Mix pagination strategies Ignore performance implications
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/api-pagination