Note

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

For v0.x docs go here.

Piccolo

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


TLDR

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.


Videos

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