A fast, user friendly ORM and query builder which supports asyncio.
Project Links
Meta
Author: Daniel Townsend
Requires Python: >=3.10.0
Classifiers
License
- OSI Approved :: MIT License
Programming Language
- Python
- Python :: 3
- Python :: 3.10
- Python :: 3.11
- Python :: 3.12
- Python :: 3.13
- Python :: 3.14
- Python :: Implementation :: CPython
Framework
- AsyncIO
Typing
- Typed
Topic
- Database
Piccolo is a fast, user friendly ORM and query builder which supports asyncio. Read the docs.
Features
Some of it’s stand out features are:
- Support for sync and async.
- A builtin playground, which makes learning a breeze.
- Tab completion support - works great with iPython and VSCode.
- Batteries included - a User model, authentication, migrations, an admin GUI, and more.
- Modern Python - fully type annotated.
- Make your codebase modular and scalable with Piccolo apps (similar to Django apps).
Syntax
The syntax is clean and expressive.
You can use it as a query builder:
# Select:
await Band.select(
Band.name
).where(
Band.popularity > 100
)
# Join:
await Band.select(
Band.name,
Band.manager.name
)
# Delete:
await Band.delete().where(
Band.popularity < 1000
)
# Update:
await Band.update({Band.popularity: 10000}).where(
Band.name == 'Pythonistas'
)
Or like a typical ORM:
# To create a new object:
b = Band(name='C-Sharps', popularity=100)
await b.save()
# To fetch an object from the database, and update it:
b = await Band.objects().get(Band.name == 'Pythonistas')
b.popularity = 10000
await b.save()
# To delete:
await b.remove()
Installation
Installing with PostgreSQL driver:
pip install 'piccolo[postgres]'
Installing with SQLite driver:
pip install 'piccolo[sqlite]'
Installing with all optional dependencies (easiest):
pip install 'piccolo[all]'
Building a web app?
Let Piccolo scaffold you an ASGI web app, using Piccolo as the ORM:
piccolo asgi new
Starlette, FastAPI, BlackSheep, Litestar, Esmerald, Lilya, Quart, Falcon and Sanic are currently supported.
Are you a Django user?
We have a handy page which shows the equivalent of common Django queries in Piccolo.
Documentation
Our documentation is on Read the docs.
We also have some great tutorial videos on YouTube.
1.30.0
Oct 21, 2025
1.29.0
Oct 11, 2025
1.28.0
Jul 29, 2025
1.27.1
Jun 05, 2025
1.27.0
Jun 03, 2025
1.26.1
May 16, 2025
1.26.0
May 12, 2025
1.25.0
Apr 26, 2025
1.24.2
Apr 03, 2025
1.24.1
Mar 21, 2025
1.24.0
Mar 14, 2025
1.23.0
Feb 13, 2025
1.22.0
Oct 23, 2024
1.21.0
Oct 18, 2024
1.20.0
Oct 04, 2024
1.19.1
Oct 01, 2024
1.19.0
Sep 24, 2024
1.18.0
Sep 21, 2024
1.17.1
Sep 14, 2024
1.17.0
Aug 20, 2024
1.16.0
Aug 08, 2024
1.15.0
Jul 30, 2024
1.14.0
Jul 21, 2024
1.13.1
Jul 04, 2024
1.13.0
Jun 27, 2024
1.12.0
Jun 19, 2024
1.11.0
Jun 15, 2024
1.10.0
Jun 14, 2024
1.9.0
Jun 13, 2024
1.8.0
Jun 07, 2024
1.7.0
May 31, 2024
1.6.0
May 30, 2024
1.5.2
May 28, 2024
1.5.1
May 21, 2024
1.5.0
Mar 22, 2024
1.4.2
Mar 13, 2024
1.4.1
Mar 12, 2024
1.4.0
Mar 11, 2024
1.3.2
Mar 04, 2024
1.3.1
Feb 25, 2024
1.3.0
Jan 23, 2024
1.2.0
Dec 23, 2023
1.1.1
Nov 10, 2023
1.1.0
Nov 03, 2023
1.0.0
Oct 20, 2023
1.0a3
Oct 19, 2023
1.0a2
Sep 08, 2023
1.0a1
Aug 02, 2023
0.121.0
Sep 11, 2023
0.120.0
Sep 08, 2023
0.119.0
Jul 21, 2023
0.118.0
Jul 14, 2023
0.117.0
Jul 07, 2023
0.116.0
Jun 28, 2023
0.115.0
Jun 19, 2023
0.114.0
Jun 03, 2023
0.113.0
May 28, 2023
0.112.1
May 24, 2023
0.112.0
May 24, 2023
0.111.1
May 16, 2023
0.111.0
May 03, 2023
0.110.0
Apr 26, 2023
0.109.0
Mar 05, 2023
0.108.0
Mar 01, 2023
0.107.0
Feb 27, 2023
0.106.0
Feb 21, 2023
0.105.0
Jan 07, 2023
0.104.0
Jan 02, 2023
0.103.0
Dec 22, 2022
0.102.0
Dec 17, 2022
0.101.0
Dec 08, 2022
0.100.0
Dec 07, 2022
0.99.0
Dec 02, 2022
0.98.0
Dec 02, 2022
0.97.0
Nov 22, 2022
0.96.0
Nov 09, 2022
0.95.0
Oct 28, 2022
0.94.0
Oct 23, 2022
0.93.0
Oct 21, 2022
0.92.0
Oct 11, 2022
0.91.0
Sep 24, 2022
0.90.0
Sep 07, 2022
0.89.0
Sep 01, 2022
0.88.0
Aug 27, 2022
0.87.0
Aug 25, 2022
0.86.0
Aug 20, 2022
0.85.1
Aug 18, 2022
0.85.0
Aug 18, 2022
0.84.0
Aug 12, 2022
0.83.0
Aug 11, 2022
0.82.0
Jul 19, 2022
0.81.0
Jul 19, 2022
0.80.2
Jul 06, 2022
0.80.1
Jul 03, 2022
0.80.0
Jun 21, 2022
0.79.0
Jun 17, 2022
0.78.0
Jun 16, 2022
0.77.0
Jun 15, 2022
0.76.1
Jun 14, 2022
0.76.0
Jun 13, 2022
0.75.0
Jun 05, 2022
0.74.4
May 13, 2022
0.74.3
Apr 30, 2022
0.74.2
Apr 27, 2022
0.74.1
Apr 23, 2022
0.74.0
Apr 13, 2022
0.73.0
Apr 08, 2022
0.72.0
Mar 30, 2022
0.71.1
Mar 13, 2022
0.71.0
Mar 11, 2022
0.70.1
Mar 09, 2022
0.70.0
Mar 08, 2022
0.69.5
Mar 06, 2022
0.69.4
Mar 05, 2022
0.69.3
Mar 01, 2022
0.69.2
Feb 13, 2022
0.69.1
Feb 04, 2022
0.69.0
Feb 03, 2022
0.68.0
Feb 02, 2022
0.67.0
Jan 28, 2022
0.66.1
Jan 25, 2022
0.66.0
Jan 21, 2022
0.65.1
Jan 21, 2022
0.65.0
Jan 20, 2022
0.64.0
Jan 16, 2022
0.63.1
Jan 12, 2022
0.63.0
Jan 11, 2022
0.62.3
Jan 10, 2022
0.62.2
Dec 31, 2021
0.62.1
Dec 22, 2021
0.62.0
Dec 19, 2021
0.61.2
Dec 14, 2021
0.61.1
Dec 01, 2021
0.61.0
Nov 26, 2021
0.60.2
Nov 25, 2021
0.60.1
Nov 24, 2021
0.60.0
Nov 15, 2021
0.59.0
Nov 09, 2021
0.58.0
Oct 24, 2021
0.57.0
Oct 13, 2021
0.56.0
Oct 11, 2021
0.55.0
Oct 06, 2021
0.54.0
Oct 05, 2021
0.53.0
Sep 30, 2021
0.52.0
Sep 26, 2021
0.51.1
Sep 25, 2021
0.51.0
Sep 21, 2021
0.50.0
Sep 20, 2021
0.49.0
Sep 16, 2021
0.48.0
Sep 15, 2021
0.47.0
Sep 14, 2021
0.46.0
Sep 14, 2021
0.45.1
Sep 10, 2021
0.45.0
Sep 09, 2021
0.44.1
Sep 08, 2021
0.44.0
Sep 07, 2021
0.43.0
Sep 02, 2021
0.42.0
Sep 01, 2021
0.41.1
Aug 31, 2021
0.41.0
Aug 31, 2021
0.40.1
Aug 30, 2021
0.40.0
Aug 29, 2021
0.39.0
Aug 28, 2021
0.38.2
Aug 26, 2021
0.38.1
Aug 26, 2021
0.38.0
Aug 25, 2021
0.37.0
Aug 25, 2021
0.36.0
Aug 25, 2021
0.35.0
Aug 25, 2021
0.34.0
Aug 22, 2021
0.33.1
Aug 22, 2021
0.33.0
Aug 20, 2021
0.32.0
Aug 17, 2021
0.31.0
Aug 10, 2021
0.30.0
Aug 09, 2021
0.29.0
Aug 05, 2021
0.28.0
Aug 04, 2021
0.27.0
Aug 02, 2021
0.26.0
Jul 09, 2021
0.25.0
Jul 03, 2021
0.24.1
Jun 30, 2021
0.24.0
Jun 30, 2021
0.23.0
Jun 29, 2021
0.22.0
Jun 25, 2021
0.21.2
Jun 22, 2021
0.21.1
Jun 12, 2021
0.21.0
Jun 08, 2021
0.20.0
May 25, 2021
0.19.1
May 13, 2021
0.19.0
May 07, 2021
0.18.4
May 05, 2021
0.18.3
May 05, 2021
0.18.2
Apr 29, 2021
0.18.1
Apr 26, 2021
0.18.0
Apr 26, 2021
0.17.5
Mar 25, 2021
0.17.4
Mar 23, 2021
0.17.3
Mar 21, 2021
0.17.2
Feb 25, 2021
0.17.1
Feb 14, 2021
0.17.0
Feb 14, 2021
0.16.5
Feb 09, 2021
0.16.4
Feb 05, 2021
0.16.3
Feb 04, 2021
0.16.2
Jan 31, 2021
0.16.1
Jan 30, 2021
0.16.0
Jan 27, 2021
0.15.1
Jan 20, 2021
0.15.0
Jan 12, 2021
0.14.13
Jan 08, 2021
0.14.12
Jan 06, 2021
0.14.11
Jan 04, 2021
0.14.10
Jan 02, 2021
0.14.9
Dec 22, 2020
0.14.8
Dec 20, 2020
0.14.7
Dec 16, 2020
0.14.6
Dec 03, 2020
0.14.5
Nov 15, 2020
0.14.4
Nov 12, 2020
0.14.3
Nov 08, 2020
0.14.2
Oct 23, 2020
0.14.1
Oct 13, 2020
0.14.0
Oct 07, 2020
0.13.5
Oct 05, 2020
0.13.4
Sep 28, 2020
0.13.3
Sep 21, 2020
0.13.2
Sep 20, 2020
0.13.1
Sep 12, 2020
0.13.0
Sep 12, 2020
0.12.6
Sep 07, 2020
0.12.5
Sep 07, 2020
0.12.4
Aug 12, 2020
0.12.3
Jul 31, 2020
0.12.2
Jul 21, 2020
0.12.1
Jul 21, 2020
0.12.0
Jul 21, 2020
0.11.8
Jun 18, 2020
0.11.7
Jun 18, 2020
0.11.6
Jun 17, 2020
0.11.5
Jun 11, 2020
0.11.4
Jun 11, 2020
0.11.3
Jun 11, 2020
0.11.2
Jun 11, 2020
0.11.1
Jun 09, 2020
0.11.0
May 26, 2020
0.10.8
May 21, 2020
0.10.7
May 17, 2020
0.10.6
May 17, 2020
0.10.5
May 17, 2020
0.10.4
May 14, 2020
0.10.3
May 14, 2020
0.10.2
May 14, 2020
0.10.1
May 07, 2020
0.10.0
Apr 22, 2020
0.9.3
Apr 16, 2020
0.9.2
Apr 12, 2020
0.9.1
Apr 12, 2020
0.9.0
Mar 31, 2020
0.8.3
Mar 01, 2020
0.8.2
Mar 01, 2020
0.8.1
Feb 03, 2020
0.8.0
Jan 23, 2020
0.7.7
Jan 15, 2020
0.7.6
Jan 05, 2020
0.7.5
Dec 15, 2019
0.7.4
Dec 01, 2019
0.7.3
Dec 01, 2019
0.7.2
Dec 01, 2019
0.7.1
Nov 27, 2019
0.7.0
Nov 25, 2019
0.6.1
Nov 15, 2019
0.6.0
Nov 15, 2019
0.5.2
Oct 29, 2019
0.5.1
Sep 15, 2019
0.5.0
Sep 12, 2019
0.4.1
Aug 20, 2019
0.4.0
Aug 20, 2019
0.3.7
Jul 16, 2019
0.3.6
Jul 11, 2019
0.3.5
Jul 10, 2019
0.3.4
Jul 02, 2019
0.3.3
Jun 30, 2019
0.3.2
Jun 25, 2019
0.3.1
Jun 25, 2019
0.3.0
Jun 24, 2019
0.2.0
Jan 14, 2019
0.1.2
Jan 07, 2019
0.1.1
Jan 01, 2019
0.1.0
Dec 09, 2018
