Api Pagination

This covers the three main pagination approaches you'll actually need: offset/limit for simple cases, cursor-based for feeds and infinite scroll, and keyset for massive datasets where offset breaks down. The reference guides include working examples in Node.js and Python with SQLAlchemy, plus specific patterns for search results and response formatting. The best practices are solid reminders, like capping page sizes at 100 and never using offset pagination on billions of rows. It's a practical reference when you're building an API and need to pick the right strategy without overthinking it. The code examples are clean and include the pagination metadata structure you'd actually want to return.

Install to Claude Code

npx -y skills add aj-geddes/useful-ai-prompts --skill api-pagination --agent claude-code