fastapi-pagination

Introduction

fastapi-pagination is a Python library designed to simplify pagination in FastAPI applications. It provides a set of utility functions and data models to help you paginate your database queries and return paginated responses to your clients.

With fastapi-pagination, you can easily define pagination parameters in your FastAPI endpoint functions, and use them to generate paginated responses that include the requested subset of your data. The library supports a variety of pagination strategies, including cursor-based pagination and page-based pagination.

fastapi-pagination is built on top of the popular fastapi library, and it works with a wide range of SQL and NoSQL database frameworks. It also supports async/await syntax and is compatible with Python 3.10 and higher.

Features:

Simplifies pagination in FastAPI applications.
Supports a variety of pagination strategies, including cursor-based pagination and page-based pagination
Works with a wide range of SQL and NoSQL database frameworks, including SQLAlchemy, Tortoise ORM, and PyMongo.
Supports async/await syntax.
Compatible with Python 3.10 and higher.

For more information on how to use fastapi-pagination, please refer to the official documentation.

Installation

pip install fastapi-pagination

Quickstart

All you need to do is to use Page class as a return type for your endpoint and call paginate function on data you want to paginate.

from fastapi import FastAPI
from pydantic import BaseModel, Field

# import all you need from fastapi-pagination
from fastapi_pagination import Page, add_pagination, paginate

app = FastAPI()  # create FastAPI app
add_pagination(app)  # important! add pagination to your app


class UserOut(BaseModel):  # define your model
    name: str = Field(..., example="Steve")
    surname: str = Field(..., example="Rogers")


users = [  # create some data
    UserOut(name="Steve", surname="Rogers"),
    # ...
]


# req: GET /users
@app.get("/users")
async def get_users() -> Page[UserOut]:
    # use Page[UserOut] as return type annotation
    return paginate(users)  # use paginate function to paginate your data

Please, be careful when you work with databases, because default paginate will require to load all data in memory.

For instance, if you use SQLAlchemy you can use paginate from fastapi_pagination.ext.sqlalchemy module.

from sqlalchemy import select
from fastapi_pagination.ext.sqlalchemy import paginate


@app.get("/users")
def get_users(db: Session = Depends(get_db)) -> Page[UserOut]:
    return paginate(db, select(User).order_by(User.created_at))

Code from Quickstart will generate OpenAPI schema as below:

Metadata

Release files for fastapi-pagination 0.16.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for fastapi-pagination 0.16.1
File	Size	Uploaded
fastapi_pagination-0.16.1.tar.gz	618.2 kB	Oct 8, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for fastapi-pagination 0.16.1
File	Interpreter	ABI	Platform	Reset
fastapi_pagination-0.16.1-py3-none-any.whl 52.6 kB Oct 8, 2026	Python 3	none	any	Details

Total release size: 670.7 kB

Release files / fastapi_pagination-0.16.1.tar.gz

Download URL	fastapi_pagination-0.16.1.tar.gz
Size	618.2 kB
Tags	Source
SHA-256 checksum How to use checksums	`c43a4286f7dd4c25501da7f5ae84a89172d3c5f3c4a93b4bc8c6639ed754d11d`
BLAKE2b-256 checksum How to use checksums	`3975f1040bac6fa6125b95ce5f399c32342674ac91b59c00eb157ba73b74d26d`
Upload date	Oct 8, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`

Release files / fastapi_pagination-0.16.1-py3-none-any.whl

Download URL	fastapi_pagination-0.16.1-py3-none-any.whl
Size	52.6 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`a91f030f764a5077b6cea41bc1df8c4cf738ac5bad2dc29977f3f0482e6202d2`
BLAKE2b-256 checksum How to use checksums	`139c5a6dec42593fd408e564960340ef930bbe0fcae3ce7b11641f2bcb6278c3`
Upload date	Oct 8, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`