// the find
awtkns/fastapi-crudrouter
A dynamic FastAPI router that automatically creates CRUD routes for your models
fastapi-crudrouter generates standard CRUD endpoints from your Pydantic/ORM models with one line of code. It supports SQLAlchemy, Tortoise, Ormar, Gino, and an in-memory backend. Aimed at prototyping and internal tools where you want boilerplate out of the way fast.
Dependency injection hooks let you slot in auth or validation per-route without forking the router. Pagination is built in and the skip/limit params show up in the OpenAPI docs automatically. The test suite covers all six backends against real databases, so the feature parity claims are actually verified. Dynamic schema generation means you don't need separate Create/Update Pydantic models if your fields are mostly the same.
Dead project — last commit was November 2023 and the maintainer has gone quiet with open PRs sitting unmerged. The generated routes are a fixed shape: get-all, get-one, create, update, delete. Anything more complex (bulk ops, partial updates, filtered queries) means you're writing your own router anyway and wondering why you bothered. No support for composite primary keys, which rules it out for a lot of existing schemas. FastAPI itself has moved fast since the last release and there's no one steering this to keep up.