pony
Pony Object-Relational Mapper
Decision gist · record as of 2026-08-14
Yes. Pony is actively maintained, has no runtime dependencies, carries a permissive Apache-2.0 license, and offers a genuinely Pythonic query interface that sets it apart from conventional ORMs. It's well-suited for developers who want to write database queries as Python code rather than SQL strings or builder chains. No known vulnerabilities and broad Python version support (3.10–3.14) make it a low-risk choice.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later (3.10–3.14 supported).
- Low friction install with no runtime dependencies.
- Actively maintained as of 2026-08-10 with recent releases and a stable repository.
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions.
last release 2026-08-09 (5 days) · last repo commit 2026-08-10 · 3,820 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 646,516 downloads/mo, #5,594 on PyPI
Alternatives
Verify before relying
pip install pony
from pony.orm import *
db = Database()
db.bind('sqlite', ':memory:')
class Product(db.Entity):
name = PrimaryKey(str)
cost = Required(int)
db.generate_mapping(create_tables=True)
with db_session:
select(p for p in Product if p.cost <= 1000)- Performance characteristics compared to other ORMs for large result sets or complex joins.
- Whether the package handles database migrations or schema versioning.
- Support status and timeline for Python 3.15 and beyond.
What it is and what it does
Pony is an object-relational mapper that bridges Python and relational databases by translating Python generator expressions and lambdas into SQL. Instead of writing raw SQL or using a separate query DSL, you define your database entities as Python classes and query them using Pythonic syntax—Pony analyzes the abstract syntax tree and generates the appropriate SQL for your target database (SQLite, MySQL, PostgreSQL, or Oracle).
The package emphasizes developer productivity through compact entity definitions, readable generated SQL output, and clear error messages that pinpoint problems in your query. It supports interactive use in a Python interpreter and works with modern Python versions (3.10–3.14). With zero runtime dependencies and low install friction, it's designed to let you focus on application logic rather than database plumbing.
Use it for
- Build web applications with declarative database models and Pythonic queries instead of raw SQL.
- Prototype database schemas interactively using the Pony Entity-Relationship Diagram Editor.
- Write data access layers for multi-database applications that need to target SQLite, MySQL, PostgreSQL, or Oracle.
- Debug database queries by inspecting the readable SQL that Pony generates from your Python expressions.
- Develop applications where you want ORM functionality without heavyweight framework dependencies.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Pony is actively maintained, has no runtime dependencies, carries a permissive Apache-2.0 license, and offers a genuinely Pythonic query interface that sets it apart from conventional ORMs. It's well-suited for developers who want to write database queries as Python code rather than SQL strings or builder chains. No known vulnerabilities and broad Python version support (3.10–3.14) make it a low-risk choice.
Install
pony on PyPI
Before you install
Low friction install with no runtime dependencies. Actively maintained as of 2026-08-10 with recent releases and a stable repository.
Requires Python 3.10 or later (3.10–3.14 supported).
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions.
Quickstart
pip install pony
from pony.orm import *
db = Database()
db.bind('sqlite', ':memory:')
class Product(db.Entity):
name = PrimaryKey(str)
cost = Required(int)
db.generate_mapping(create_tables=True)
with db_session:
select(p for p in Product if p.cost <= 1000)Verify before relying
- Performance characteristics compared to other ORMs for large result sets or complex joins.
- Whether the package handles database migrations or schema versioning.
- Support status and timeline for Python 3.15 and beyond.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release <3.15,>=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Actively maintained 5 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 646,516 / month, #5,594 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: Implementation :: PyPyTopic :: DatabaseTopic :: Software Development :: Libraries |
Evidence: pony-0.7.20-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “python orm query generator”
- ponyPony is an object-relational mapper that lets you write database…
- aerichAerich is a database migration tool for TortoiseORM that generates,…
- sqlacodegenReads an existing database schema and generates SQLAlchemy model code…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also tortoise-orm · SQLAlchemy · django-mysql · peewee · sqlalchemy-mixins · sqlalchemy-risingwave · pypika-tortoise · mongo-query-match · djongo · prisma