SaaSHub helps you find the best software and product alternatives 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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
-
airbyte
Open-source data movement for ELT pipelines and AI agents — from APIs, databases & files to warehouses, lakes, and AI applications. Both self-hosted and Cloud.
Project mention: Show HN: Airbyte Agents – context for agents across multiple data sources | news.ycombinator.com | 2026-05-05 -
WrenAI
Give AI agents the context to query business data correctly through the open context layer that gives AI agents grounded, governed memory, context, SQL across 20+ data sources, that helps you build agentic GenBI, text-to-sql, dashboards, and agentic analytics.
Project mention: Revolutionize Your Data Workflow with Wren AI: The Open-Source GenBI Agent | dev.to | 2025-09-01View the Project on GitHub
-
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.
-
Project mention: PgDog is funded and coming to a database near you | news.ycombinator.com | 2026-06-10
Patroni 1.0 was released in 2016, i.e ~10 years ago.
https://github.com/patroni/patroni
-
-
NewsBlur
NewsBlur is a personal news reader that brings people together to talk about the world. A new sound of an old instrument.
Unless I misunderstand, it also misses that Newsblur is open source and can be self hosted https://github.com/samuelclay/NewsBlur
-
-
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.
-
-
baserow
Build databases, automations, apps & agents with AI — no code. Open source platform available on cloud and self-hosted. GDPR, HIPAA, SOC 2 compliant. Best Airtable alternative.
Project mention: Baserow: Build databases, automations and agents with AI, Airtable alternative | news.ycombinator.com | 2026-01-03 -
sqlit
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.
- Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).
Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).
Built with Python and Textual. First shared here in December (https://news.ycombinator.com/item?id=46276002) - a lot has shipped since.
Repo: https://github.com/Maxteabag/sqlit
Feedback welcome, especially on what's still missing for daily-driver use.
My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.
-
-
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.
-
-
-
-
Project mention: Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite | news.ycombinator.com | 2026-02-04
-
-
-
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.
-
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
-
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip
-
pgxbackup: Continuity Support for pgBackRest
-
pgxcli VS pgcli - a user suggested alternative
2 projects | 1 May 2026 -
Building a Local Data Analytics Pipeline with dbt Core and DuckDB
-
📰 All Data and AI Weekly #231-02March2026
-
Pg_plan_alternatives – eBPF tracing of all plans the optimizer considers
-
High-Altitude Adventure with a DIY Pico Balloon
-
A note from our sponsor - SaaSHub
www.saashub.com | 17 Jun 2026
Index
What are some of the best open-source Postgresql projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | quivr | 39,155 |
| 2 | Redash | 28,636 |
| 3 | airbyte | 21,430 |
| 4 | WrenAI | 15,526 |
| 5 | pgcli | 13,216 |
| 6 | patroni | 8,519 |
| 7 | asyncpg | 8,045 |
| 8 | NewsBlur | 7,497 |
| 9 | ibis | 6,570 |
| 10 | dev-setup | 6,264 |
| 11 | tortoise-orm | 5,578 |
| 12 | baserow | 5,044 |
| 13 | sqlit | 4,317 |
| 14 | PonyORM | 3,823 |
| 15 | pgadmin4 | 3,667 |
| 16 | wal-e | 3,468 |
| 17 | Gopherus | 3,340 |
| 18 | Barman | 3,171 |
| 19 | migra | 3,048 |
| 20 | pg_activity | 3,020 |
| 21 | Yamtrack | 2,808 |
| 22 | supabase-py | 2,519 |
| 23 | psycopg | 2,416 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com