# Piccolo

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


Source: https://findsoftware.frbit.cloud/piccolo/
Last reviewed: 2026-11-16
Listed since: 2026-11-16

## Record

### Links

- home: https://piccolo-orm.com/
- repository: https://github.com/piccolo-orm/piccolo
- docs: https://piccolo-orm.readthedocs.io/en/latest/
- x: https://twitter.com/piccolo_orm
- discord: https://discord.gg/JbXBgPM2GY
- youtube: https://www.youtube.com/channel/UCE7x5nm1Iy9KDfXPNrNQ5lA

### Identity

- status: active
- maintainer: Daniel Townsend
- maintainerType: unknown
- parent: unknown
- firstRelease: 2018
- hqCountry: unknown

### Kind

- category: library
- hosting: python
- language: python
- runtime: python
- runtimeMin: python 3.10
- basedOn: unknown

### Content

- contentStore: not applicable
- databases: postgres, sqlite
- adminUi: not applicable
- headlessApi: not applicable
- templating: not applicable
- i18n: not applicable

### Rendering and deploy

- runsAs: not applicable
- renderingModes: not applicable
- installMethod: pip

### License

- licenseModel: open-source
- license: MIT

### Releases

- currentMajor: 1
- latestReleaseDate: 2026-10-28

### Adoption

- githubStargazers: 1955
- packagistDownloads: not applicable
- npmWeeklyDownloads: not applicable
- contributors: 59
- pluginCount: unknown
- packagistMonthlyDownloads: unknown
- ecosystemsMonthlyDownloads: unknown
- httpArchiveSites: unknown
- wordpressActiveInstalls: unknown
- dependentRepos: 66
- dependentPackages: 6

### Sources

- urls: https://piccolo-orm.com/ (read 2026-11-16)
- urls: https://api.github.com/repos/piccolo-orm/piccolo (read 2026-11-16)
- urls: https://github.com/piccolo-orm/piccolo/blob/1.39.0/README.md (read 2026-11-16)
- firstRelease: https://api.github.com/repos/piccolo-orm/piccolo/commits/0.1.0 (read 2026-11-16)
- maintainer: https://github.com/piccolo-orm/piccolo/blob/1.39.0/LICENSE (read 2026-11-16)
- language: https://api.github.com/repos/piccolo-orm/piccolo (read 2026-11-16)
- category: https://github.com/piccolo-orm/piccolo/blob/1.39.0/README.md (read 2026-11-16)
- runtime: https://piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/installing_piccolo.html (read 2026-11-16)
- runtimeMin: https://github.com/piccolo-orm/piccolo/blob/1.39.0/setup.py (read 2026-11-16)
- databases: https://github.com/piccolo-orm/piccolo/blob/1.39.0/README.md (read 2026-11-16)
- databases: https://github.com/piccolo-orm/piccolo/blob/1.39.0/README.md (read 2026-11-16)
- installMethod: https://piccolo-orm.readthedocs.io/en/latest/ (read 2026-11-16)
- license: https://github.com/piccolo-orm/piccolo/blob/1.39.0/setup.py (read 2026-11-16)
- licenseModel: https://api.github.com/repos/piccolo-orm/piccolo (read 2026-11-16)
- currentMajor: https://api.github.com/repos/piccolo-orm/piccolo/releases/tags/1.39.0 (read 2026-11-16)
- latestReleaseDate: https://api.github.com/repos/piccolo-orm/piccolo/releases/tags/1.39.0 (read 2026-11-16)
- githubStargazers: https://api.github.com/repos/piccolo-orm/piccolo (read 2026-11-16)
- contributors: https://api.github.com/repos/piccolo-orm/piccolo/contributors?per_page=1 (read 2026-11-16)
- dependentPackages: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/piccolo (read 2026-11-16)
- dependentRepos: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/piccolo (read 2026-11-16)

## Notes

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.

---

Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Attributes are recorded, never scored; absent means unknown.
Credit, in full: FindSoftware, CC BY 4.0
