Python Postgres

Open-source Python projects categorized as Postgres

Top 23 Python Postgre Projects

  • MindsDB

    The platform for customizing AI from enterprise data

    Project mention: What’s the Difference Between Fine-tuning, Retraining, and RAG? | | 2024-04-08

    Check us out on GitHub.

  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • frappe

    Low code web framework for real world applications, in Python and Javascript

  • sqlglot

    Python SQL Parser and Transpiler

    Project mention: Transpile Any SQL to PostgreSQL Dialect | | 2024-03-18

    Recommend checking out if you are interested in this capability for other SQL dialects

    Tools like this are helpful for:

    - Rendering SQL in a consistent way, eg for snapshot testing

  • databases

    Async database support for Python. 🗄

  • wal-e

    Continuous Archiving for Postgres

    Project mention: Run PostgreSQL. The Kubernetes Way | | 2023-09-22

    See the GitHub:

    Unmaintained would’ve made more sense to say, but the maintainer choose the words “obsolete” so I took those. :)

    Seems to be obsolete due to a lack of interest and contributions.

  • data-diff

    Compare tables within or across databases

    Project mention: How to Check 2 SQL Tables Are the Same | | 2023-07-26

    If the issue happen a lot, there is also:

    That is a nice tool to do it cross database as well.

    I think it's based on checksum method.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • Alerta

    Alerta monitoring system

  • mathesar

    Web application providing an intuitive user experience to databases.

    Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | | 2024-03-11

    Congratulations on launching, it's nice to see more open source products in this area (I work on Feel free to reach out if you'd like to talk and compare notes.

  • 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: Using migrations with Golang | | 2024-04-17

    If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

  • fastapi-react

    🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker

  • Barman

    Barman - Backup and Recovery Manager for PostgreSQL

  • Udacity-Data-Engineering-Projects

    Few projects related to Data Engineering including Data Modeling, Infrastructure setup on cloud, Data Warehousing and Data Lake development.

    Project mention: Pitanje za data engineering? | /r/programiranje | 2023-06-30
  • docker-django-example

    A production ready example Django app that's using Docker and Docker Compose.

    Project mention: Django 5.0 Is Released | | 2023-12-04

    Congrats on the release to the Django community!

    If anyone is curious, I updated my Django / Docker starter kit app to use Django 5.0 at:

    It pulls together gunicorn, Celery, Redis, Postgres, esbuild and Tailwind with Docker Compose. It's set up to run in both development and production.

  • jupysql

    Better SQL in Jupyter. 📊

    Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | | 2023-12-06

    Hey, HN community!

    We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!

    To get started, check out our tutorial:

    SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.

    Here are some of JupySQL's main features:

    - Syntax highlighting

  • docker-flask-example

    A production ready example Flask app that's using Docker and Docker Compose.

    Project mention: We Have to Talk About Flask | | 2023-10-19

    I've been maintaining my Build a SAAS App with Flask video course[0] for 8 years. It has gone from pre-1.0 to 2.3 and has been recorded twice with tons of incremental updates added over the years to keep things current.

    In my opinion tutorial creators should pin their versions so that anyone taking the course or going through the tutorial will have a working version that matches the video or written material.

    I'm all for keeping things up to date and do update things every few months but rolling updates don't tend to work well for tutorials because sometimes a minor version requires a code change or covering new concepts. As a tutorial consumer it's frustrating when the content doesn't match the source code unless it's nothing but a version bump.

    I've held off upgrading Flask to 3.0 and Python 3.12 due to these open issues with 3rd party dependencies


  • FastAPI-boilerplate

    An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis. (by igorbenav)

    Project mention: 🚀FastAPI boilerplate (starter project) | /r/Python | 2023-11-14

    Yet another FastAPI Boilerplate (starter project) to help you productizing Machine Learning or just creating an API 🚀

  • marcel

    A modern shell (by geophile)

    Project mention: Generating graphs from the marcel command line | | 2024-03-08

    Marcel is one of the pipe-objects-instead-of-strings shells (

    Here's a blog post showing how to use marcel to generate graphs directly from the command line.

  • sgr

    sgr (command line client for Splitgraph) and the splitgraph Python library

    Project mention: Show HN: Loofi – Our AI-Powered SQL Query Builder | | 2023-05-21
  • astro-sdk

    Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.

    Project mention: Orchestration: Thoughts on Dagster, Airflow and Prefect? | /r/dataengineering | 2023-06-01

    Have you tried the Astro SDK?

  • condenser

    Condenser is a database subsetting tool

    Project mention: Jailer, a unique open-source database tool | | 2023-08-07


  • pgANN

    Fast Approximate Nearest Neighbor (ANN) searches with a PostgreSQL database.

    Project mention: Pinecone raises $100M Series B | | 2023-04-27

    Why do you use pgvector instead of pgANN? My understanding is pgANN is built with FAISS. When I compared pgvector with FAISS, pgvector was 3-5x slower.

  • FastAPIQuickCRUD

    Generate CRUD methods in FastApi from an SQLAlchemy schema

  • 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). The latest post mention was on 2024-04-17.

Python Postgres related posts


What are some of the best open-source Postgre projects in Python? This list will help you:

Project Stars
1 MindsDB 21,160
2 pgcli 11,687
3 frappe 6,464
4 sqlglot 5,389
5 databases 3,692
6 wal-e 3,424
7 data-diff 2,824
8 Alerta 2,326
9 mathesar 2,188
10 pgadmin4 2,056
11 fastapi-react 2,055
12 Barman 1,836
13 Udacity-Data-Engineering-Projects 1,295
14 docker-django-example 1,093
15 jupysql 591
16 docker-flask-example 541
17 FastAPI-boilerplate 336
18 marcel 331
19 sgr 326
20 astro-sdk 315
21 condenser 298
22 pgANN 289
23 FastAPIQuickCRUD 248
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives