Piccolo

Piccolo is a modern, fast, and type-safe ORM for Python, designed with developer ergonomics in mind. It provides a clean syntax for defining schemas and building queries while supporting both sync and async execution. With built-in admin tools and rich introspection, Piccolo is suitable for web apps, APIs, and small-to-medium scale backends that prioritize clarity and speed.

Features

Type-safe schema definition and query building
Supports both async and sync database operations
Built-in admin GUI for quick data exploration
Rich introspection and automatic migrations
Works with PostgreSQL out of the box
Lightweight with no heavy dependencies

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow Piccolo

Piccolo Web Site

Other Useful Business Software

Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.

Create free account

Rate This Project

User Reviews

Be the first to post a review of Piccolo!

Additional Project Details

Programming Language

Python

Related Categories

Python Frameworks

Registered

2025-06-06

Similar Business Software

Rio

Rio is an open source Python framework that enables developers to build modern web and desktop applications entirely in Python. Inspired by frameworks like React and Flutter, Rio introduces a declarative UI model where components are defined as Python data classes with a build() method, allowing...

See Software
ent

An entity framework for Go. Simple, yet powerful ORM for modeling and querying data. Simple API for modeling any database schema as Go objects. Run queries, and aggregations and traverse any graph structure easily. 100% statically typed and explicit API using code generation. The latest version...

See Software
Webix

JavaScript UI library and framework for speeding up web development. JS Framework for cross-platform web Apps development 102 UI widgets and feature-rich CSS / HTML5 JavaScript controls. Save at least 3000+ development hours by using ready-made widgets and UI controls. Develop Web UI 30% faster....

See Software
Swoole

Powering the next-generation microservices and applications. Build high-performance, scalable, concurrent TCP, UDP, Unix Socket, HTTP, GRPC services with PHP and easy-to-use coroutine, fibers API. Write your next scalable async application with PHP coroutines and fibers. Compared with other...

See Software
Yii

Yii is a fast, secure, and efficient PHP framework. Flexible yet pragmatic, works right out of the box, and has reasonable defaults. While Yii can virtually eliminate most repetitive coding tasks, you are responsible for the real creative work. This often starts with designing the whole system...

See Software
Atri Framework

Atri framework is a full-stack web development framework to build Progressive Web Apps. Use our visual editor to increase your productivity. You can also add your custom React code. Currently, we support Python for backend development. We are planning to add support for NodeJS soon. Our CLI...

See Software