Python ORM

Open-source Python projects categorized as ORM

Top 23 Python ORM Projects

  1. Django

    The Web framework for perfectionists with deadlines.

    Project mention: Django Codebase Updates: January 2025 | dev.to | 2025-02-07

    Added automatic model imports to Django shell command, a GSoC 2024 project (by Salvo Polizzi - commit)

  2. Nutrient

    Nutrient - The #1 PDF SDK Library. Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.

    Nutrient logo
  3. Peewee

    a small, expressive orm -- supports postgresql, mysql, sqlite and cockroachdb

    Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24

    Alternative ORMs: there are many such as peewee, PonyORM, etc.

  4. SQLAlchemy

    The Database Toolkit for Python

    Project mention: Creating an Application with Amazon RDS and MySQL in the Cloud | dev.to | 2024-12-11

    SQLAlchemy Documentation. "SQLAlchemy ORM." https://www.sqlalchemy.org/.

  5. tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Django and Postgres for the Busy Rails Developer | news.ycombinator.com | 2024-12-11

    Wouldn't know. However, some standalone projects are attempting to replicate the same experience, check Tortoise ORM - https://github.com/tortoise/tortoise-orm.

  6. MongoEngine

    A Python Object-Document-Mapper for working with MongoDB

  7. PonyORM

    Pony Object Relational Mapper

    Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24

    Alternative ORMs: there are many such as peewee, PonyORM, etc.

  8. GINO

    GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

  9. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  10. PynamoDB

    A pythonic interface to Amazon's DynamoDB

    Project mention: Scaffolding Serverless Web Application on AWS | dev.to | 2024-07-22

    https://github.com/pynamodb/PynamoDB A pythonic interface to Amazon's DynamoDB, that provide an ORM-like interface with query and scan filters. It supports many features which makes it more comfortable to interact with DynamoDB API.

  11. beanie

    Asynchronous Python ODM for MongoDB

  12. django-cacheops

    A slick ORM cache with automatic granular event-driven invalidation.

  13. sandman2

    Automatically generate a RESTful API service for your legacy database. No code required!

    Project mention: Automatically Generate REST and GraphQL APIs From Your Database | dev.to | 2024-12-19

    Some solutions are flexible to handle multiple types of databases. Often allowing you to combine them into a single API. We already mentioned Dreamfactory, but others include Apinizer, Directus, and sandman2.

  14. prisma-client-py

    Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use

  15. orm

    An async ORM. 🗃 (by encode)

  16. ormar

    python async orm with fastapi in mind and pydantic validation

  17. piccolo

    A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)

    Project mention: Piccolo ORM – A powerful async ORM for Python | news.ycombinator.com | 2024-11-20
  18. walrus

    Lightweight Python utilities for working with Redis

  19. odmantic

    Sync and Async ODM (Object Document Mapper) for MongoDB based on python type hints

  20. aerich

    A database migrations tool for TortoiseORM, ready to production.

  21. django-mongodb-engine

    Django MongoDB Backend

  22. sqlalchemy-mixins

    Active Record, Django-like queries, nested eager load and beauty __repr__ for SQLAlchemy

    Project mention: Understanding JSONify(), to_dict(), make_response(), and SerializerMixin in Flask | dev.to | 2024-10-31

    SQLAlchemy SerializerMixin

  23. pyDAL

    A pure Python Database Abstraction Layer

  24. μMongo

    sync/async MongoDB ODM, yes. (by Scille)

  25. redisco

    A Python Library for Simple Models and Containers Persisted in Redis

  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python ORM discussion

Log in or Post with

Python ORM related posts

  • Creating an Application with Amazon RDS and MySQL in the Cloud

    3 projects | dev.to | 11 Dec 2024
  • Piccolo ORM – A powerful async ORM for Python

    1 project | news.ycombinator.com | 20 Nov 2024
  • Understanding JSONify(), to_dict(), make_response(), and SerializerMixin in Flask

    1 project | dev.to | 31 Oct 2024
  • Leveraging Python for Scalable Data Pipelines

    1 project | dev.to | 10 Oct 2024
  • Peewee: A small, expressive ORM (PostgreSQL, MySQL, SQLite, CockroachDB)

    1 project | news.ycombinator.com | 15 Sep 2024
  • Creating an arXiv DB

    7 projects | dev.to | 31 Aug 2024
  • Announcing the public beta for dedicated clusters

    6 projects | dev.to | 25 Jul 2024
  • A note from our sponsor - Nutrient
    nutrient.io | 18 Feb 2025
    Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free. Learn more →

Index

What are some of the best open-source ORM projects in Python? This list will help you:

# Project Stars
1 Django 82,296
2 Peewee 11,368
3 SQLAlchemy 10,032
4 tortoise-orm 4,841
5 MongoEngine 4,284
6 PonyORM 3,690
7 GINO 2,692
8 PynamoDB 2,479
9 beanie 2,191
10 django-cacheops 2,151
11 sandman2 2,015
12 prisma-client-py 1,964
13 orm 1,782
14 ormar 1,704
15 piccolo 1,535
16 walrus 1,158
17 odmantic 1,099
18 aerich 878
19 django-mongodb-engine 863
20 sqlalchemy-mixins 768
21 pyDAL 508
22 μMongo 449
23 redisco 438

Sponsored
Nutrient - The #1 PDF SDK Library
Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.
nutrient.io

Did you know that Python is
the 2nd most popular programming language
based on number of references?