These are the docs for Piccolo v1. Read more here.

For v0.x docs go here.


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, Litestar and Esmerald are currently supported, with more coming soon.


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