Safe typed filtering for FastAPI.

Paramora

Paramora turns user-controlled HTTP query parameters into safe, typed backend query outputs for MongoDB, raw SQL, SQLAlchemy, SQLModel, and Mongo ODM adapters.

Use it when you want FastAPI filtering APIs that are explicit, validated, type-aware, documented, and safe by default.

/items?price__gte=10&status__in=free,busy&sort=-created_at&limit=20

Paramora validates that request against your query contract, coerces values into Python types, builds a small backend-neutral AST, and emits the backend output you selected.

Install

uv add paramora

Optional backend extras:

uv add "paramora[sqlalchemy]"
uv add "paramora[sqlmodel]"
uv add "paramora[postgres]"
uv add "paramora[odm]"
uv add "paramora[all]"

Start here

• Quickstart: build your first FastAPI endpoint.
• Usage guide: learn the common patterns.
• How-to guides: solve practical scenarios.
• Query syntax: supported operators, sorting, and pagination.

Backends

• MongoDB
• Raw SQL
• SQLAlchemy and SQLModel
• Mongo ODM adapters

Reliability

Paramora is tested with unit tests, FastAPI integration tests, SQLite execution tests, mongomock-backed MongoDB tests, and optional PostgreSQL / SQLAlchemy / SQLModel checks.

See Testing and Continuous Integration.