Python Postgresql

Open-source Python projects categorized as Postgresql

Top 23 Python Postgresql Projects

  1. 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.

    Project mention: Ask HN: Local RAG with private knowledge base | news.ycombinator.com | 2024-10-29
  2. 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.

    InfluxDB logo
  3. 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-10

    GitHub: Redash GitHub Repository

  4. 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.

    Project mention: 7 Best Data Integration Platforms: Reviews & Top Picks | dev.to | 2025-05-26

    Website: https://airbyte.com/

  5. pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: PostgreSQL IDE in VS Code | news.ycombinator.com | 2025-05-23
  6. patroni

    A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes

    Project mention: High Availability PostgreSQL: Clustering with Patroni | dev.to | 2025-01-28

    Now according to Patroni Docs we will config Patroni using etc/patroni/config.yml/ file. mine looks like this:

  7. asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

    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.

  8. 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.

  9. SaaSHub

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

    SaaSHub logo
  10. ibis

    the portable Python dataframe library

    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

  11. tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    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.

  12. PonyORM

    Pony Object Relational Mapper

    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.

  13. wal-e

    Continuous Archiving for Postgres

    Project mention: Ask HN: What do you use to backup your VMs? | news.ycombinator.com | 2024-09-27

    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.

  14. Gopherus

    This tool generates gopher link for exploiting SSRF and gaining RCE in various servers

  15. migra

    Like diff but for PostgreSQL schemas

    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

  16. 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-03

    Go to the official PGAdmin website and download the latest version.

  17. ingestr

    ingestr is a CLI tool to copy data between any databases with a single command seamlessly.

    Project mention: I built a data pipeline tool in Go | dev.to | 2024-12-23

    📥 ingest data with ingestr / Python

  18. 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-19

    Try out Baserow 1.32: https://baserow.io

  19. pg_activity

    pg_activity is a top like application for PostgreSQL server activity monitoring.

    Project mention: Pg_activity: Htop for PostgreSQL | news.ycombinator.com | 2025-05-13
  20. Barman

    Barman - Backup and Recovery Manager for PostgreSQL

  21. mara-pipelines

    A lightweight opinionated ETL framework, halfway between plain scripts and Apache Airflow

  22. 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.

    Project mention: Supabase Python | dev.to | 2024-08-30

    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.

  23. borgmatic

    Simple, configuration-driven backup software for servers and workstations

    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/

  24. psycopg

    New generation PostgreSQL database adapter for the Python programming language

    Project mention: Hyrum's Law in Golang | news.ycombinator.com | 2024-11-21

    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.

  25. spilo

    Highly available elephant herd: HA PostgreSQL cluster using Docker

  26. SaaSHub

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

    SaaSHub logo
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

Log in or Post with

Python Postgresql related posts

  • Memelang: Hybrid graph-relational query language for RAG

    1 project | dev.to | 19 May 2025
  • Pg_activity: Htop for PostgreSQL

    1 project | news.ycombinator.com | 13 May 2025
  • Show HN: Bracket – the first open source tournament system

    5 projects | news.ycombinator.com | 5 May 2025
  • Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy

    3 projects | news.ycombinator.com | 23 Apr 2025
  • 7 Best Change Data Capture (CDC) Tools in 2025

    2 projects | dev.to | 11 Apr 2025
  • Build your first AI Agent for Postgres on Azure

    3 projects | dev.to | 8 Apr 2025
  • Doge staffer's YouTube nickname accidentally revealed his teen hacking activity

    1 project | news.ycombinator.com | 4 Apr 2025
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 14 Jun 2025
    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 →

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

Did you know that Python is
the 2nd most popular programming language
based on number of references?