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. Learn more →
Top 23 Python Postgresql Projects
-
quivr
Opiniated RAG for integrating GenAI in your apps 🧠Focus on your product rather than the RAG. Easy integration in existing products with customisation! Any LLM: GPT4, Groq, Llama. Any Vectorstore: PGVector, Faiss. Any Files. Anyway you want.
-
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.
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Project mention: The 50 best open-source alternatives to popular SaaS software | dev.to | 2024-07-10GitHub: Redash GitHub Repository
-
airbyte
The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
Website: https://airbyte.com/
-
-
Now according to Patroni Docs we will config Patroni using etc/patroni/config.yml/ file. mine looks like this:
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
asyncpg: this was the gold standard async database driver for Postgres, being one of the first to market and most performant. While all other drivers use the C library libpq to interface with Postgres, MagicStack opted to rewrite their own custom implementation and also deviate from Python DBAPI spec. If performance is your main criteria here, then asyncpg is probably the best option.
-
dev-setup
macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Project mention: Why Pandas feels clunky when coming from R (2024) | news.ycombinator.com | 2025-06-07
pandas* per the style guide (nobody follows it)
also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues
https://ibis-project.org
-
Project mention: Why Developers Are Choosing Tortoise ORM as Python’s Modern ORM | dev.to | 2025-05-11
For more detailed usage, please refer to the Tortoise ORM Official Documentation.
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
Alternative ORMs: there are many such as peewee, PonyORM, etc.
-
For me, it's case-by-case. I don't back up the VMs directly, just the date of the stateful applications running on the VMs (or bare metal servers, I do identical stuff for them).
For postgres, I used to just have a systemd timer that would `pg_dumpall` and throw it in s3.
Now I use https://github.com/wal-e/wal-e to backup my postgresql databases.
For other local files, I use borg backup for personal files and services I just run for myself, and I use restic to backup server files to s3.
The operating system's configuration is all stored in git via the magic of NixOS, so I don't have to worry about files in /etc, they all are 100% reproducible from my NixOS configuration.
-
-
Project mention: Declarative Schemas for Simpler Database Management | news.ycombinator.com | 2025-04-03
Hey, are you using some tool like the unmaintained migra https://github.com/djrobstep/migra (perhaps using this tool https://github.com/blainehansen/postgres_migrator) or pg-schema-diff https://github.com/stripe/pg-schema-diff or maybe this other unrelated pg-schema-diff https://github.com/zombodb/pg-schema-diff anything like it?
Is it open source?
I mean, I see you say
> We then use a schema diff tool, like migra, to figure out the necessary updates to views and functions when generating the migration file.
But "like migra" is very nonspecific. I guess you are not using migra itself
-
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.
Project mention: Asynchronous SQLAlchemy 2: A simple step-by-step guide to configuration, models, relationships, and migrations using Alembic | dev.to | 2025-06-03Go to the official PGAdmin website and download the latest version.
-
📥 ingest data with ingestr / Python
-
baserow
The official repository is hosted on https://gitlab.com/bramw/baserow. Baserow is an open source no-code database tool and Airtable alternative.
Project mention: Baserow 1.32: Dashboards, enhanced Airtable import, SSO for Application Builder, and more - Open Source Airtable Alternative | dev.to | 2025-03-19Try out Baserow 1.32: https://baserow.io
-
-
-
mara-pipelines
A lightweight opinionated ETL framework, halfway between plain scripts and Apache Airflow
-
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.
supabase-py was originally started by maintainer lqmanh in September of 2020, and was shortly after joined by fedden and J0 (who went on to become a full time member of the Supabase Team). In recent years development has been driven by silentworks and juancarlospaco who have both been instrumental in the push to reaching feature parity with supabase-js.
-
Project mention: Syncthing – A decentralized continuous file synchronization program | news.ycombinator.com | 2024-08-18
You could use Syncthing just to empty the incoming files from your phone (ingest) and then move the photos via cron to a second folder (also Syncthing) which is just shared with the replicas.
Another approach would be to push the files from Syncthing to borg (borgmatic can do replicas) https://torsion.org/borgmatic/
-
Nope, exceptions in Python are not the same. There are a lot of standard exceptions
https://docs.python.org/3/library/exceptions.html#concrete-e...
and standard about exception type hierarchy
https://github.com/psycopg/psycopg/blob/d38cf7798b0c602ff43d...
https://peps.python.org/pep-0249/#exceptions
Also in most languages "catch Exception:" (or similar expression) is considered a bad style. People are taught to catch specific exceptions. Nothing like that happens in Go.
-
-
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 Postgresql discussion
Python Postgresql related posts
-
Memelang: Hybrid graph-relational query language for RAG
-
Pg_activity: Htop for PostgreSQL
-
Show HN: Bracket – the first open source tournament system
-
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
-
7 Best Change Data Capture (CDC) Tools in 2025
-
Build your first AI Agent for Postgres on Azure
-
Doge staffer's YouTube nickname accidentally revealed his teen hacking activity
-
A note from our sponsor - InfluxDB
www.influxdata.com | 14 Jun 2025
Index
What are some of the best open-source Postgresql projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | quivr | 37,970 |
| 2 | Redash | 27,409 |
| 3 | airbyte | 18,383 |
| 4 | pgcli | 12,493 |
| 5 | patroni | 7,403 |
| 6 | asyncpg | 7,368 |
| 7 | dev-setup | 6,191 |
| 8 | ibis | 5,846 |
| 9 | tortoise-orm | 5,124 |
| 10 | PonyORM | 3,734 |
| 11 | wal-e | 3,464 |
| 12 | Gopherus | 3,033 |
| 13 | migra | 3,006 |
| 14 | pgadmin4 | 2,978 |
| 15 | ingestr | 2,967 |
| 16 | baserow | 2,710 |
| 17 | pg_activity | 2,597 |
| 18 | Barman | 2,379 |
| 19 | mara-pipelines | 2,080 |
| 20 | supabase-py | 2,054 |
| 21 | borgmatic | 1,987 |
| 22 | psycopg | 1,984 |
| 23 | spilo | 1,673 |
Sponsored
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.
www.influxdata.com