SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python Sqlalchemy Projects
-
an SQLModel entity backed by a database table doesn't validate its fields on creation, which is the point of Pydantic.
https://github.com/fastapi/sqlmodel/issues/52#issuecomment-1...
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
Project mention: How to Make Websites That Will Require Lots of Your Time and Energy | news.ycombinator.com | 2025-07-28
at the very least, if you are really writing lots of INSERTs by hand I bet you are either not quoting properly or you are writing queries with 15 placeholders and someday you'll put one in the wrong place.
ORMs and related toolkits have come a long way since they were called the "Vietnam of Computer Science". I am a big fan of JooQ in Java
https://www.jooq.org/
and SQLAlchemy in Python
https://www.sqlalchemy.org/
Note both of these support both an object <-> SQL mapper (usually with generated objects) that covers the case of my code sample above, and a DSL for SQL inside the host language which is delightful if you want to do code generation to make query builders and stuff like that. I work on a very complex search interface which builds out joins, subqueries, recursive CTEs, you name it, and the code is pretty easy to maintain.
-
-
AwaitableModel is a model base class in UtilMeta to provide fully async query in Django using encode/databases, which will unleash the async performance for Django ORM
-
-
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
fastapi-react
🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker
-
-
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.
-
indico
Indico - A feature-rich event management system, made @ CERN, the place where the Web was born.
Project mention: Ask HN: Organize local communities without Facebook? | news.ycombinator.com | 2025-01-21Indico is a not-framasoft open-source made in CERN event organisation solution : https://getindico.io/
-
-
-
-
-
FastAPI-boilerplate
An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis.
-
-
-
-
fastcrud
FastCRUD is a Python package for FastAPI, offering robust async CRUD operations and flexible endpoint creation utilities.
fastcrud - CRUD operations for FastAPI
-
fastapi-alembic-sqlmodel-async
This is a project template which uses FastAPI, Pydantic 2.0, Alembic and async SQLModel as ORM. It shows a complete async CRUD using authentication and role base access control.
-
-
-
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).
Python Sqlalchemy discussion
Python Sqlalchemy related posts
-
Shillelagh: Query APIs Using SQL
-
Litestar Is Worth a Look
-
Identificador Único Universal (UUID): o que a pgcrypto e a sua mãe têm em comum...
-
Architecture Patterns with Python
-
Ask HN: SQL ORM with nested atomic updates?
-
Ask HN: Python ORM Solutions in 2025?
-
This Week In Python
-
A note from our sponsor - SaaSHub
www.saashub.com | 1 Sep 2025
Index
What are some of the best open-source Sqlalchemy projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | sqlmodel | 16,663 |
| 2 | SQLAlchemy | 10,813 |
| 3 | flask-sqlalchemy | 4,308 |
| 4 | databases | 3,935 |
| 5 | factory_boy | 3,677 |
| 6 | alembic | 3,563 |
| 7 | GINO | 2,712 |
| 8 | fastapi-react | 2,396 |
| 9 | sqladmin | 2,317 |
| 10 | sandman2 | 2,033 |
| 11 | indico | 1,941 |
| 12 | aiomysql | 1,832 |
| 13 | ormar | 1,766 |
| 14 | PyHive | 1,686 |
| 15 | eventsourcing | 1,583 |
| 16 | FastAPI-boilerplate | 1,422 |
| 17 | aiopg | 1,419 |
| 18 | fastapi-boilerplate | 1,383 |
| 19 | eralchemy | 1,251 |
| 20 | fastcrud | 1,230 |
| 21 | fastapi-alembic-sqlmodel-async | 1,116 |
| 22 | flask-bones | 996 |
| 23 | graphene-sqlalchemy | 990 |
Sponsored
Deploy and host your apps and databases, now with $50 credit!
Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
sevalla.com