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

Train ML Models With SQL You Already Know

BigQuery automates data prep, analysis, and predictions with built-in AI assistance.

Build and deploy ML models using familiar SQL. Automate data prep with built-in Gemini. Query 1 TB and store 10 GB free monthly.

Try Free

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
Ionic

The Ionic Platform allows you to bring your apps to market faster with an integrated app platform built on the leading cross-platform mobile SDK. Build, secure, and deliver new mobile apps—and transform existing ones—across iOS, Android, and Web platforms from a single codebase. Full...

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