Piccolo is a modern, async query builder and ORM for Python, with lots of batteries included.


Install Piccolo:

pip install piccolo

Experiment with queries:

piccolo playground run

Give me an ASGI web app!

piccolo asgi new

FastAPI, Starlette, BlackSheep, and Litestar are currently supported, with more coming soon.


Piccolo has some tutorial videos on YouTube, which are a great companion to the docs.