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.

Contents:

• Getting Started
• Query Types
• Query Clauses
• Schema
• Projects and Apps
• Engines
• Migrations
• Authentication
• ASGI
• Serialization
• Testing
• Features
• Playground
• Ecosystem
• Tutorials
• Contributing
• Changes
• Help
• API reference
• About Piccolo v1

---

TLDR

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.

---

Videos

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