piccolo-orm/piccolo

Health v2 · maintenance only

Adoption not part of the score

1937 stars · 114 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Piccolo is a fast, user-friendly ORM and query builder for Python with first-class asyncio support. It includes batteries like migrations, a User model, authentication, and integrates with ASGI frameworks such as FastAPI and Starlette.

Use cases

• query a postgres database with async python
• orm for fastapi app
• build a web app with sqlite and asyncio
• manage database migrations in python
• type-annotated query builder for python
• add user authentication to a python backend
• scaffold an asgi web app with an orm

When to choose

• you need async or sync database access in Python with Postgres or SQLite
• you want a modern, fully type-annotated ORM with tab completion
• you're building an ASGI web app (FastAPI, Starlette, Litestar, etc.) and want an integrated ORM with migrations and auth

When to avoid

• you need databases other than Postgres, SQLite, or CockroachDB
• your team is heavily invested in Django ORM or SQLAlchemy ecosystems
• you need a synchronous-only, minimal ORM without extra batteries

Facets

library · maturity active

orm database auth middleware databases web-development backend developer-tools python cross-platform asyncio query-builder postgresql sqlite asgi fastapi migrations type-annotated

Member repositories

For agents

markdown · JSON · MCP: product_card(name="piccolo-orm/piccolo")