pagination-and-filtering
CommunityEfficient cursor-based pagination and filtering.
AuthorRaNDoM6913
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Efficiently delivering data to clients at scale by replacing OFFSET-based pagination with cursor-based pagination and robust filtering, reducing latency and avoiding inconsistencies when data changes between pages.
Core Features & Use Cases
- Cursor-based pagination with a composite (created_at, id) cursor to ensure stable, deterministic paging for feeds, lists, and admin tables.
- LIMIT+1 hasMore pattern to detect additional pages without extra COUNT queries.
- Debounced search and TanStack Infinite Queries integration for smooth front-end experiences.
- Composite indexes design guidelines and filtered queries for high-performance data access in SQL databases.
Quick Start
Set up your API to paginate results with a composite cursor (created_at, id) and return a hasMore flag for client navigation.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: pagination-and-filtering Download link: https://github.com/RaNDoM6913/claude-code-superkit/archive/main.zip#pagination-and-filtering Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.