SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python Postgre Projects
-
I primarily use psql for quick queries, but pgcli is definitely what I'd reach for when I want a richer terminal experience. The autocompletion and syntax highlighting save time. That said, pgxcli's zero-dependency approach is compelling — if you're in environments where Python setup is friction (containers, minimal systems), it's worth trying. The startup speed difference is noticeable too. Ultimately, both are solid; it comes down to whether you prefer Python's maturity or Go's simplicity.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
I'm curious because I have a similar use case for a querying frontend. Did you consider using https://github.com/tobymao/sqlglot? If so, what was missing to justify writing your own parser?
-
pgadmin4
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
pgAdmin is the classic open-source administration and development platform for PostgreSQL. It can run on desktop platforms or as a web application.
-
-
-
fastapi-react
🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker
-
supabase-py
Python Client for Supabase. Query Postgres from Flask, Django, FastAPI. Python user authentication, security policies, edge functions, file storage, and realtime data streaming. Good first issue.
-
-
RSS-to-Telegram-Bot
A Telegram RSS bot that cares about your reading experience (calling for new maintainers: https://github.com/Rongronggg9/RSS-to-Telegram-Bot/issues/747)
-
FastAPI-boilerplate
An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis.
-
Udacity-Data-Engineering-Projects
Few projects related to Data Engineering including Data Modeling, Infrastructure setup on cloud, Data Warehousing and Data Lake development.
-
Another one is how much time it takes to maintain vs how much interest it has. This is different than burnout.
I created and maintain example Docker Compose starter projects for Flask[0], Rails[1], Django[2] and Node[3]. I've had these going for 6-7 years and I maintain them at least once a week to keep everything up to date.
I used to also support Phoenix but I stopped after ~5 years because it was the least popular project but also took up more time to upgrade than all of the other example projects combined because Live View has changed in drastic ways so many times.
Plus it became no longer enjoyable to work on it since I stopped using Phoenix in my day to day as well. That combined with it being the least popular example app between the 5 projects.
I put together a 6 month plan to archive the repo in https://github.com/nickjj/docker-phoenix-example/issues/16, received zero feedback and then archived it at the start of 2026.
[0]: https://github.com/nickjj/docker-flask-example
[1]: https://github.com/nickjj/docker-rails-example
[2]: https://github.com/nickjj/docker-django-example
[3]: https://github.com/nickjj/docker-node-example
-
Project mention: Show HN: PgQueuer v1.0 – Python job queue using only PostgreSQ | news.ycombinator.com | 2026-05-11
-
raglite
🥤 RAGLite is a Python toolkit for Retrieval-Augmented Generation (RAG) with DuckDB or PostgreSQL
-
aegra
Open source alternative to LangGraph Platform (now LangSmith Deployments) - Self-hosted AI agent backend with FastAPI and PostgreSQL. Zero vendor lock-in, full control over your agent infrastructure.
Project mention: Aegra - Open Source LangGraph Platform Alternative | news.ycombinator.com | 2025-12-10 -
-
Another one is how much time it takes to maintain vs how much interest it has. This is different than burnout.
I created and maintain example Docker Compose starter projects for Flask[0], Rails[1], Django[2] and Node[3]. I've had these going for 6-7 years and I maintain them at least once a week to keep everything up to date.
I used to also support Phoenix but I stopped after ~5 years because it was the least popular project but also took up more time to upgrade than all of the other example projects combined because Live View has changed in drastic ways so many times.
Plus it became no longer enjoyable to work on it since I stopped using Phoenix in my day to day as well. That combined with it being the least popular example app between the 5 projects.
I put together a 6 month plan to archive the repo in https://github.com/nickjj/docker-phoenix-example/issues/16, received zero feedback and then archived it at the start of 2026.
[0]: https://github.com/nickjj/docker-flask-example
[1]: https://github.com/nickjj/docker-rails-example
[2]: https://github.com/nickjj/docker-django-example
[3]: https://github.com/nickjj/docker-node-example
-
I like the idea of PGLite!
Unfortunately, when I tried to use it with https://github.com/wey-gu/py-pglite to speed up tests, I got stuck on it not being able to handle cell contents above a few thousand characters, which was a deal breaker for my project :(
-
-
-
-
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 Postgres discussion
Python Postgres related posts
-
Dumb Ways for an Open Source Project to Die
-
Show HN: PgQueuer v1.0 – Python job queue using only PostgreSQ
-
pgxbackup: Continuity Support for pgBackRest
-
PgAdmin: The Most Popular PostgreSQL Admin Tool
-
pgxcli VS pgcli - a user suggested alternative
2 projects | 1 May 2026 -
Show HN: DbCls, terminal client for various databases
-
PGLite Evangelism
-
A note from our sponsor - SaaSHub
www.saashub.com | 17 Jun 2026
Index
What are some of the best open-source Postgre projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | pgcli | 13,216 |
| 2 | frappe | 10,224 |
| 3 | sqlglot | 9,318 |
| 4 | pgadmin4 | 3,667 |
| 5 | wal-e | 3,468 |
| 6 | Barman | 3,171 |
| 7 | fastapi-react | 2,578 |
| 8 | supabase-py | 2,519 |
| 9 | Alerta | 2,511 |
| 10 | RSS-to-Telegram-Bot | 2,097 |
| 11 | FastAPI-boilerplate | 1,958 |
| 12 | Udacity-Data-Engineering-Projects | 1,907 |
| 13 | docker-django-example | 1,529 |
| 14 | pgqueuer | 1,488 |
| 15 | raglite | 1,165 |
| 16 | aegra | 972 |
| 17 | jupysql | 847 |
| 18 | docker-flask-example | 763 |
| 19 | py-pglite | 621 |
| 20 | pg_net | 361 |
| 21 | marcel | 355 |
| 22 | condenser | 333 |
| 23 | sgr | 324 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com