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

Ship Agents Faster

Transform your applications and workflows into powerful agentic systems at global scale.

Gemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.

Get Started 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
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
restify

A Node.js web service framework optimized for building semantically correct RESTful web services ready for production use at scale. restify optimizes for introspection and performance and is used in some of the largest Node.js deployments on Earth. Running at scale requires tracing problems back...

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