Top 9 Python Relational Database Projects

Peewee

2 9,243 8.3 Python

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

Project mention: Top python libraries/ frameworks that you suggest every one | reddit.com/r/Python | 2022-03-28

peewee
SQLAlchemy

54 5,616 9.8 Python

The Database Toolkit for Python

Project mention: SQLite or PostgreSQL? It's Complicated | news.ycombinator.com | 2022-06-28

And SQLAlchemy made the process of migrating from one to another quite simple too.
https://www.sqlalchemy.org/
SonarQube

www.sonarqube.org
sponsored

Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
PonyORM

2 2,950 7.6 Python

Pony Object Relational Mapper

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

pony – Pony Object Relational Mapper
GINO

0 2,446 5.1 Python

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

1 1,580 6.3 Python

An async ORM. 🗃 (by encode)

Project mention: A SQL ORM and migrations tool for a Django lover in a non-Django project? | reddit.com/r/Python | 2021-10-03

Alternatively, orm is really easy to use. But thats also in a state of having only been recently released and not having much documentation etc.
djongo

5 1,570 7.0 Python

Django and MongoDB database connector

Project mention: Where can I find the ORM documentation for Djongo (mongodb library for django)? | reddit.com/r/django | 2022-03-06
prisma-client-py

9 701 9.5 Python

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

Project mention: A beginners guide to building a Flask API with Prisma | dev.to | 2022-07-01

I really enjoyed using Prisma in javascript, and I am glad that Robert created a client for python. 🔥🔥
Scout APM

scoutapm.com
sponsored

Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
pyDAL

0 421 6.3 Python

A pure Python Database Abstraction Layer
pireal

1 32 6.6 Python

Relational Algebra Interpreter writting in Python and Qt

Project mention: Relational Algebra interpreter powered by Python | reddit.com/r/Python | 2022-04-17

I made a RA interpreter in Python, Pireal.

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 2022-07-01.

Python Relational Databases related posts

A beginners guide to building a Flask API with Prisma
1 project | dev.to | 1 Jul 2022
Should I use odbc lib or azure sql binding to query azure sql in a python azure function?
2 projects | reddit.com/r/AZURE | 22 Jun 2022
Any suggested modules for SQL processes with Python?
1 project | reddit.com/r/learnpython | 20 Jun 2022
Where to start with making an app like this.
1 project | reddit.com/r/learnprogramming | 13 Jun 2022
Using Django ORM in asyncio project without Django?
2 projects | reddit.com/r/django | 6 Jun 2022
Organising SQL queries in Flask app
1 project | reddit.com/r/learnpython | 21 May 2022
Approaches to writing a reporting REST API?
2 projects | reddit.com/r/dataengineering | 20 May 2022

Index

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

	Project	Stars
1	Peewee	9,243
2	SQLAlchemy	5,616
3	PonyORM	2,950
4	GINO	2,446
5	orm	1,580
6	djongo	1,570
7	prisma-client-py	701
8	pyDAL	421
9	pireal	32

Find remote jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.