FindSoftware

Piccolo

Python ORM and query builder with asyncio support, for PostgreSQL and SQLite databases.

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.

Identity

Status
Active
Maintainer
Daniel Townsend5
First release
20184

Rendering and deploy

Install with
pip8

Releases

Current major version
19
Last release
2026-10-289

Adoption

GitHub stars
1,9552
Contributors
5910
Dependent repositories
6611
Dependent packages
611

Why these figures do not compare

Sources

  1. 2026-11-16: links
    piccolo-orm.com/
  2. 2026-11-16: links, Written in, License model, GitHub stars
    api.github.com/repos/piccolo-orm/piccolo
  3. 2026-11-16: links, Categories, Databases
    github.com/piccolo-orm/piccolo/blob/1.39.0/README.md
  4. 2026-11-16: First release
    api.github.com/repos/piccolo-orm/piccolo/commits/0.1.0
  5. 2026-11-16: Maintainer
    github.com/piccolo-orm/piccolo/blob/1.39.0/LICENSE
  6. 2026-11-16: Runtime
    piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/installing_piccolo.html
  7. 2026-11-16: Minimum runtime, License
    github.com/piccolo-orm/piccolo/blob/1.39.0/setup.py
  8. 2026-11-16: Install with
    piccolo-orm.readthedocs.io/en/latest/
  9. 2026-11-16: Current major version, Last release
    api.github.com/repos/piccolo-orm/piccolo/releases/tags/1.39.0
  10. 2026-11-16: Contributors
    api.github.com/repos/piccolo-orm/piccolo/contributors?per_page=1
  11. 2026-11-16: Dependent packages, Dependent repositories
    packages.ecosyste.ms/api/v1/registries/pypi.org/packages/piccolo

Last reviewed · Listed since Edit on GitHubThis page as markdownas JSON