fastapi-paginate

Effortless pagination for FastAPI + SQLAlchemy

Install

pip install fastapi-paginate

Usage

from fastapi import FastAPI, Depends
from fastapi_paginate import paginate, PaginationParams, Page
from sqlalchemy import select

@app.get("/users", response_model=Page[UserResponse])
async def list_users(
    params: PaginationParams = Depends(),
    db: AsyncSession = Depends(get_db),
):
    query = select(User).order_by(User.created_at.desc())
    return await paginate(db, query, params, schema=UserResponse)

Response:

{
    "items": [...],
    "total": 150,
    "page": 1,
    "size": 20,
    "pages": 8,
    "has_next": true,
    "has_prev": false
}

Features

• One function call — paginate(db, query, params)
• Auto-counts total rows
• has_next / has_prev for frontend navigation
• Generic Page[T] works with any Pydantic schema
• Query params auto-extracted via PaginationParams dependency
• Works with any SQLAlchemy select query

License

MIT