Python ORM

Open-source Python projects categorized as ORM

Top 23 Python ORM Projects

  • Django

    The Web framework for perfectionists with deadlines.

    Project mention: An Introduction to Testing with Django for Python | | 2024-02-14

    You should not test Django's own code — it's already been tested. For example, you don't need to write a test that checks if an object is retrieved with get_object_or_404 — Django's testing suite already has that covered.

  • Peewee

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

    Project mention: Any Python ORMs worthy of production? | | 2023-12-18
  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • SQLAlchemy

    The Database Toolkit for Python

    Project mention: Introducing Flama for Robust Machine Learning APIs | | 2023-12-18

    Besides, flama also provides support for SQL databases via SQLAlchemy, an SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. Finally, flama also provides support for HTTP clients to perform requests via httpx, a next generation HTTP client for Python.

  • MongoEngine

    A Python Object-Document-Mapper for working with MongoDB

  • tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: How to Connect a FastAPI Server to PostgreSQL and Deploy on GCP Cloud Run | | 2023-05-26

    To do this, we can use the Tortoise-ORM. Begin by installing the package:

  • PonyORM

    Pony Object Relational Mapper

  • GINO

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

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • PynamoDB

    A pythonic interface to Amazon's DynamoDB

  • django-cacheops

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

    Project mention: Ban 1+N in Django | | 2023-03-26

    Here is an example of such thing

  • sandman2

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

  • orm

    An async ORM. 🗃 (by encode)

  • beanie

    Asynchronous Python ODM for MongoDB

    Project mention: Ask HN: Where do I find good code to read? | | 2023-08-24

    I recently came across Beanie. A Python ORM for MongoDb. A pleasure to work with and integrates well with FastAPI, the tests document the code well, and at this point it’s only as complicated as it needs to be.

  • ormar

    python async orm with fastapi in mind and pydantic validation

  • prisma-client-py

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

    Project mention: Sunday Daily Thread: What's everyone working on this week? | /r/Python | 2023-04-16

    almost samezies, although I'm trying prisma-client-py for team-specific reasons.

  • Orator

    The Orator ORM provides a simple yet beautiful ActiveRecord implementation.

    Project mention: Im writing a telegram bot that simulates the Uber apps. I would have to store the orders that receives so I can fulfill them. What’s the best way to store them so I can process them? | /r/TelegramBots | 2023-04-16

    If you write in Python, I recommend using the Orator-ORM library, a very handy thing for quickly and safely working with MySQL.

  • piccolo

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

    Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | | 2023-11-07
  • walrus

    Lightweight Python utilities for working with Redis

  • odmantic

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

    Project mention: Is there mongoose alternative in Python? (A NoSQL ORM) | /r/learnpython | 2023-05-14
  • django-mongodb-engine

    Django MongoDB Backend

  • aerich

    A database migrations tool for TortoiseORM, ready to production.

  • sqlalchemy-mixins

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

  • pyDAL

    A pure Python Database Abstraction Layer

  • μMongo

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


    Learn 300+ open source libraries for free using AI. LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!

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). The latest post mention was on 2024-02-14.

Python ORM related posts


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

Project Stars
1 Django 75,706
2 Peewee 10,678
3 SQLAlchemy 8,462
4 MongoEngine 4,135
5 tortoise-orm 4,131
6 PonyORM 3,478
7 GINO 2,635
8 PynamoDB 2,352
9 django-cacheops 1,999
10 sandman2 1,978
11 orm 1,754
12 beanie 1,712
13 ormar 1,530
14 prisma-client-py 1,496
15 Orator 1,421
16 piccolo 1,217
17 walrus 1,129
18 odmantic 941
19 django-mongodb-engine 866
20 aerich 760
21 sqlalchemy-mixins 703
22 pyDAL 470
23 μMongo 442
Learn 300+ open source libraries for free using AI.
LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!