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

Build Securely on Azure with Proven Frameworks

Lay a foundation for success with Tested Reference Architectures developed by Fortinet’s experts. Learn more in this white paper.

Moving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.

Download Now

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