Python ORM

Open-source Python projects categorized as ORM

Top 23 Python ORM Projects

  • Django

    The Web framework for perfectionists with deadlines.

    Project mention: HStoreField sometimes returns str instead of dict | | 2023-01-26

  • Peewee

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

    Project mention: Top python libraries/ frameworks that you suggest every one | | 2022-03-28


  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

  • SQLAlchemy

    The Database Toolkit for Python

    Project mention: SQLAlchemy 2.0.0 Released | | 2023-01-26

    that said, most "pagination" is done for stateless web applications so you would want a strategy that SELECTs only the rows you want in the first place, a good article on that is at ; within SQLAlchemy, we have some (older API style, but still general idea works) wiki examples for both a criteria-based solution as well as one that uses window functions:

  • MongoEngine

    A Python Object-Document-Mapper for working with MongoDB

    Project mention: Are mongoengine and related projects maintained anymore? Any recommendations for decent ODM | | 2022-05-20

    My biggest issue with mongoengine has been the longstanding issue with poor performance on large documents. This is to a large extent a problem with the underlying data model I've worked with, but it's crazy when deserializing a mongo object takes longer than transferring it from the remote DB.

  • tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Example typescript project repos? | | 2022-10-27

    If I was answering this question but for python, I'd recommend something like prefect, boto3, or tortoise-orm -- not extremely complex and with a pretty comprehensible featureset.

  • PonyORM

    Pony Object Relational Mapper

    Project mention: This Week in Python | | 2022-05-20

    pony – Pony Object Relational Mapper

  • GINO

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

  • Sonar

    Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • PynamoDB

    A pythonic interface to Amazon's DynamoDB

  • sandman2

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

    Project mention: Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs | | 2022-10-04 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.

  • django-cacheops

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

    Project mention: Storing frequently used data in django | | 2022-03-28

    django-cacheops is a great package

  • orm

    An async ORM. 🗃 (by encode)

  • Orator

    The Orator ORM provides a simple yet beautiful ActiveRecord implementation.

  • ormar

    python async orm with fastapi in mind and pydantic validation

    Project mention: What Python library do you wish existed? | | 2023-01-15

    How about ormar?

  • walrus

    Lightweight Python utilities for working with Redis

  • beanie

    Asynchronous Python ODM for MongoDB

    Project mention: starlette-admin: Simple and extensible admin interface framework for Starlette/FastApi | | 2022-09-11

    You may want to look at swapping mongoengine for beanie. That supports native pydantic data structures and has async support.

  • prisma-client-py

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

    Project mention: Alternatives to SQLAlchemy for your project - Prisma case | | 2022-08-08

    Anyway, prisma is a relatively new project, and it is very pleasant to use. I encourage you to give it a try and support the python client (at least a star on GitHub). For me who doesn't like SQL, being able to retrieve models from the database and make queries with prisma is a breath of fresh air. 🤣

  • piccolo

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

  • django-mongodb-engine

    Django MongoDB Backend

  • odmantic

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

    Project mention: starlette-admin: support for Odmantic & many more | | 2022-12-21

    Hello u/everyone, the latest releases of starlette-admin add support for Odmantic (an async python ODM) , better support for dynamic list and embedded document, custom batch actions, ...

  • sqlalchemy-mixins

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

    Project mention: Django or Flask and why? | | 2022-02-05

    it is more low level, but there are several projects that build Django (active record style) abstraction on top of it.

  • aerich

    A database migrations tool for TortoiseORM, ready to production.

  • pyDAL

    A pure Python Database Abstraction Layer

  • redisco

    A Python Library for Simple Models and Containers Persisted in Redis

  • SaaSHub

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

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 2023-01-26.

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 68,369
2 Peewee 9,716
3 SQLAlchemy 6,580
4 MongoEngine 3,932
5 tortoise-orm 3,339
6 PonyORM 3,116
7 GINO 2,529
8 PynamoDB 2,090
9 sandman2 1,911
10 django-cacheops 1,754
11 orm 1,687
12 Orator 1,379
13 ormar 1,221
14 walrus 1,062
15 beanie 1,039
16 prisma-client-py 959
17 piccolo 949
18 django-mongodb-engine 860
19 odmantic 745
20 sqlalchemy-mixins 616
21 aerich 612
22 pyDAL 443
23 redisco 436
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives