ponyorm/pony

Health v2 · maintenance only

Adoption not part of the score

3819 stars · 256 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Pony is a Python object-relational mapper that lets developers write database queries using Python generator expressions and lambdas, which it translates into SQL via AST analysis. It supports SQLite, MySQL, PostgreSQL, Oracle, and CockroachDB with a concise, Pythonic API.

Use cases

• query a database using python generator expressions instead of raw sql
• map python classes to database tables with compact entity definitions
• build a python backend app with sqlite or postgresql
• prototype database schemas with an entity-relationship diagram editor
• get readable generated sql and precise error messages during development

When to choose

• you want a lightweight, easy-to-learn Python ORM with a distinctive query syntax
• your project uses SQLite, MySQL, PostgreSQL, Oracle, or CockroachDB
• you prefer writing queries as Python expressions over string-based SQL or query builders

When to avoid

• you need an ORM with a large ecosystem, async-first design, or extensive third-party tooling
• you require databases not supported by Pony, such as SQL Server or MongoDB
• your team prefers mainstream ORMs like SQLAlchemy or Django ORM for hiring and community support

Facets

library · maturity active

orm database databases web-development backend developer-tools python cross-platform python-orm generator-expressions sql-generation sqlite postgresql mysql oracle cockroachdb

Member repositories

For agents

markdown · JSON · MCP: product_card(name="ponyorm/pony")