
Piccolo
Python ORM and query builder with asyncio support, for PostgreSQL and SQLite databases.
piccolo-orm.com/repositorydocs
Piccolo is an ORM and query builder for Python that works with asyncio, and its README says it supports sync as well. The README’s piccolo asgi new command scaffolds an ASGI web app with Piccolo as its ORM; the README names Starlette, FastAPI and other frameworks as supported.
Worth knowing
The homepage and README name an admin interface among the features, but it is the separate Piccolo Admin package from the project’s ecosystem, not part of the piccolo package. Piccolo API, which exposes tables as REST endpoints, is also a separate package.
Sources
- 2026-11-16: links
piccolo-orm.com/ - 2026-11-16: links, Written in, License model, GitHub stars
api.github.com/repos/piccolo-orm/piccolo - 2026-11-16: links, Categories, Databases
github.com/piccolo-orm/piccolo/blob/1.39.0/README.md - 2026-11-16: First release
api.github.com/repos/piccolo-orm/piccolo/commits/0.1.0 - 2026-11-16: Maintainer
github.com/piccolo-orm/piccolo/blob/1.39.0/LICENSE - 2026-11-16: Runtime
piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/installing_piccolo.html - 2026-11-16: Minimum runtime, License
github.com/piccolo-orm/piccolo/blob/1.39.0/setup.py - 2026-11-16: Install with
piccolo-orm.readthedocs.io/en/latest/ - 2026-11-16: Current major version, Last release
api.github.com/repos/piccolo-orm/piccolo/releases/tags/1.39.0 - 2026-11-16: Contributors
api.github.com/repos/piccolo-orm/piccolo/contributors?per_page=1 - 2026-11-16: Dependent packages, Dependent repositories
packages.ecosyste.ms/api/v1/registries/pypi.org/packages/piccolo