Api Pagination

Solid reference implementation covering the three main pagination patterns you'll actually need in production. Offset/limit for simple cases, cursor-based for infinite scroll and real-time feeds, and keyset for performant queries on large datasets. The comparison table is helpful for choosing between them, and the examples show practical details like encoding cursors in base64, capping page sizes at 100, and avoiding expensive count queries. If you've ever written the same pagination logic three times across different projects or shipped offset pagination that crawled to a halt at page 500, this gives you patterns worth copying.

skills.sh installs: 433
GitHub stars: 248
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add secondsky/claude-skills --skill api-pagination --agent claude-code

Installs into .claude/skills of the current project.

Files

API Pagination

Implement scalable pagination strategies for handling large datasets efficiently.

Pagination Strategies

Strategy	Best For	Performance
Offset/Limit	Small datasets, simple UI	O(n)
Cursor	Infinite scroll, real-time	O(1)
Keyset	Large datasets	O(1)

Offset Pagination

app.get('/products', async (req, res) => {
  const page = parseInt(req.query.page) || 1;
  const limit = Math.min(parseInt(req.query.limit) || 20, 100);
  const offset = (page - 1) * limit;

  const [products, total] = await Promise.all([
    Product.find().skip(offset).limit(limit),
    Product.countDocuments()
  ]);

  res.json({
    data: products,
    pagination: {
      page,
      limit,
      total,
      totalPages: Math.ceil(total / limit)
    }
  });
});

Cursor Pagination

app.get('/posts', async (req, res) => {
  const limit = 20;
  const cursor = req.query.cursor;

  const query = cursor
    ? { _id: { $gt: Buffer.from(cursor, 'base64').toString() } }
    : {};

SKILL.md on GitHub