implementing-query-pagination

What problem does it solve?

Efficient pagination is essential for large datasets. This Skill teaches correct Prisma 6 pagination patterns, including cursor-based and offset-based approaches and the trade-offs.

Core Features & Use Cases

• Cursor pagination: stable performance regardless of dataset size; ideal for infinite scroll.
• Offset pagination: simple but degrades with large data; best for small, static datasets.
• Indexing and ordering considerations to support pagination efficiently.

Quick Start

Start with cursor pagination by default, using take, cursor, and orderBy; reserve offset pagination for small admin tables or internal tooling when page jumps are required.