piccolo-api
Utilities for using the Piccolo ORM in ASGI apps, plus essential ASGI middleware such as authentication and rate limiting.
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has no known vulnerabilities, installs cleanly, and solves a real problem—automating REST endpoint generation from Piccolo tables while providing essential middleware. It's a good fit if you're building with FastAPI or Starlette and Piccolo ORM. The MIT license poses no restrictions.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later and a working Piccolo ORM setup with database configuration.
- Low install friction with a pure-Python wheel.
- Active maintenance with a release within the last week.
License · maintenance · safety
MIT (permissive) — MIT license is permissive; you can use this package in commercial and proprietary projects with minimal restrictions.
last release 2026-08-07 (7 days) · last repo commit 2026-08-07 · 161 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 583,488 downloads/mo, #5,892 on PyPI
Alternatives
Verify before relying
pip install piccolo-api
from piccolo_api.rest import create_tables
from fastapi import FastAPI
app = FastAPI()
# Mount Piccolo table endpoints via create_tables or REST routing- Exact API surface and endpoint generation behavior for different table schemas.
- Performance characteristics under high concurrency or large result sets.
- Compatibility matrix with specific Piccolo and FastAPI versions beyond the stated Python support.
What it is and what it does
Piccolo API bridges Piccolo ORM tables and ASGI web frameworks like FastAPI and Starlette, automatically generating REST endpoints from your database schema. It eliminates boilerplate by letting you define a table in Piccolo and immediately expose it as a queryable API, with built-in support for filtering, pagination, and standard CRUD operations.
Beyond endpoint generation, the package includes a suite of production-ready ASGI middleware: session and token authentication, rate limiting, CSRF protection, and Content Security Policy headers. It also integrates tightly with Pydantic, allowing you to derive validation schemas directly from your Piccolo table definitions. The library targets modern Python versions and is actively maintained.
Use it for
- Quickly prototype a REST API backed by a Piccolo database without writing individual route handlers.
- Add authentication and rate limiting to an existing FastAPI or Starlette application via drop-in middleware.
- Generate Pydantic models from Piccolo tables to standardize request/response validation.
- Build a data admin interface or internal tool that exposes database tables as queryable endpoints.
- Secure an ASGI application with CSRF and CSP headers using pre-built middleware components.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has no known vulnerabilities, installs cleanly, and solves a real problem—automating REST endpoint generation from Piccolo tables while providing essential middleware. It's a good fit if you're building with FastAPI or Starlette and Piccolo ORM. The MIT license poses no restrictions.
Install
piccolo-api on PyPI
Before you install
Low install friction with a pure-Python wheel. Active maintenance with a release within the last week. Requires Python 3.10 or later and depends on FastAPI, Piccolo, Pydantic, and related web libraries.
Requires Python 3.10 or later and a working Piccolo ORM setup with database configuration.
License in practice
MIT license is permissive; you can use this package in commercial and proprietary projects with minimal restrictions.
Quickstart
pip install piccolo-api
from piccolo_api.rest import create_tables
from fastapi import FastAPI
app = FastAPI()
# Mount Piccolo table endpoints via create_tables or REST routingVerify before relying
- Exact API surface and endpoint generation behavior for different table schemas.
- Performance characteristics under high concurrency or large result sets.
- Compatibility matrix with specific Piccolo and FastAPI versions beyond the stated Python support.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.10.0 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 7 packagesJinja2piccolopydanticpython-multipartfastapiPyJWThttpx |
| Maintenance | Actively maintained 7 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 583,488 / month, #5,892 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: MIT LicenseProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: Implementation :: CPython |
Evidence: piccolo_api-1.11.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “piccolo orm rest api”
- piccolo-apiExposes Piccolo ORM tables as REST endpoints in ASGI applications and…
- piccolo-adminPiccolo Admin is a web-based admin interface and content management…
- piccoloPiccolo is an async-first ORM and query builder for Python that…
Give your agent the search over MCP, or paste the wish link into any chat.
More Dynamic Content packages
MarkupSafe provides a text object that escapes special characters so untrusted strings can be safely embedded in HTML and XML without injection attacks.
Jinja2 is a templating engine that renders dynamic content by combining templates with Python-like syntax and data, supporting template inheritance, macros, autoescaping, and sandboxed execution.
Soupsieve is a CSS selector library designed to work with Beautiful Soup 4 to select, match, and filter HTML and XML elements using modern CSS selectors from CSS level 1 through CSS level 4 specifications.
Install it if you use Beautiful Soup for HTML or XML parsing and want modern CSS selector support.
Werkzeug is a WSGI utility library providing request/response objects, URL routing, an interactive debugger, HTTP utilities, and a development server for building web applications.
Flask is a lightweight WSGI web application framework for building web applications in Python, from simple single-page sites to complex multi-route applications.
Mako compiles Python-embedded templates into Python modules for fast rendering, supporting layout inheritance, custom functions, and direct Python expressions within template syntax.
See also piccolo · piccolo-admin · asgi-csrf · slowapi · starlette-csrf · asgi-ratelimit · litestar · opentelemetry-instrumentation-asgi · fastapi-csrf-protect · secure