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: 3..2..1 Launch!: My journey from zero to Django Contributions | dev.to | 2026-05-15

    PR: Link This is very interesting bug. You can perform coalesce to receive not-null first value from given columns fetching. However, column's type are vary. Let imagine you coalesce Column A (string), Column B (JSON).

  2. SaaSHub

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

    SaaSHub logo
  3. Peewee

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

  4. SQLAlchemy

    The Database Toolkit for Python

    Project mention: Are you expected to run five Python type-checkers now? | news.ycombinator.com | 2026-06-08

    What function signature isn't going to look messy with 36 keyword arguments.

    https://github.com/sqlalchemy/sqlalchemy/blob/0798e6cbe11b30...

  5. tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

  6. MongoEngine

    A Python Object-Document-Mapper for working with MongoDB

  7. PonyORM

    Pony Object Relational Mapper

  8. GINO

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

  9. beanie

    Asynchronous Python ODM for MongoDB

  10. PynamoDB

    A pythonic interface to Amazon's DynamoDB

  11. django-cacheops

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

  12. sandman2

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

  13. piccolo

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

    Project mention: Piccolo: Powerful async ORM, query builder, and admin GUI | news.ycombinator.com | 2025-07-15
  14. ormar

    python async orm with fastapi in mind and pydantic validation

  15. walrus

    Lightweight Python utilities for working with Redis

  16. odmantic

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

  17. aerich

    A database migrations tool for TortoiseORM, ready to production.

  18. django-mongodb-engine

    Django MongoDB Backend

  19. sqlalchemy-mixins

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

  20. oxyde

    Oxyde ORM is a type-safe, Pydantic-centric asynchronous ORM with a high-performance Rust core designed for clarity, speed, and reliability.

    Project mention: Show HN: Oxyde – Pydantic-native async ORM with a Rust core | news.ycombinator.com | 2026-03-13
  21. pyDAL

    A pure Python Database Abstraction Layer

  22. μMongo

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

  23. redisco

    A Python Library for Simple Models and Containers Persisted in Redis

  24. butterdb

    butterdb is a Python object mapper for Google Drive Spreadsheets. Still in development, but usable.

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

  • Are you expected to run five Python type-checkers now?

    4 projects | news.ycombinator.com | 8 Jun 2026
  • How to Add Error Handling and Monitoring to a Data Pipeline

    3 projects | dev.to | 27 Apr 2026
  • Show HN: Oxyde – Pydantic-native async ORM with a Rust core

    6 projects | news.ycombinator.com | 13 Mar 2026
  • Alembic: Versionamento de Banco de Dados

    1 project | dev.to | 12 Feb 2026
  • We Migrated from Python to Node.js

    7 projects | news.ycombinator.com | 3 Nov 2025
  • Automatic PR creation on GitHub for database schema change

    4 projects | dev.to | 21 Jul 2025
  • Piccolo: Powerful async ORM, query builder, and admin GUI

    1 project | news.ycombinator.com | 15 Jul 2025
  • A note from our sponsor - SaaSHub
    www.saashub.com | 9 Jun 2026
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

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

# Project Stars
1 Django 87,772
2 Peewee 11,969
3 SQLAlchemy 11,884
4 tortoise-orm 5,574
5 MongoEngine 4,350
6 PonyORM 3,823
7 GINO 2,808
8 beanie 2,677
9 PynamoDB 2,649
10 django-cacheops 2,269
11 sandman2 2,044
12 piccolo 1,905
13 ormar 1,809
14 walrus 1,204
15 odmantic 1,172
16 aerich 1,090
17 django-mongodb-engine 870
18 sqlalchemy-mixins 788
19 oxyde 732
20 pyDAL 534
21 μMongo 449
22 redisco 443
23 butterdb 340

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com

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