Python Postgresql

Open-source Python projects categorized as Postgresql | Edit details

Top 23 Python Postgresql Projects

  • Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    Project mention: Open source DW? | | 2022-01-03

    Its a bad idea use Redash as ETL and Data warehouse? Im not a data engineer just looking for a low/mid scale solution for experiment.

  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: Commandline Database Clients with Autocompletion and Syntax Highlighting | | 2021-02-18

    In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on or just dump the error message here so we can investigate?

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • full-stack-fastapi-postgresql

    Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.

    Project mention: Backend Developer building first big project, need your help | | 2022-01-10

    This full stack application template might be useful to check out. The frontend is Vuejs and seems to be well-structure.

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

    Project mention: MacOS Development workspace 2021 | | 2021-03-08

    donnemartin - dev setup

  • asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

    Project mention: Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service | | 2021-11-13

    Simple query runs long when DB schema contains thousands of tables #186

  • patroni

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

    Project mention: GCP Cloud SQL Migration without outage? | | 2021-12-17

    This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g or move to an HA Postgres setup like Patroni that has streaming replication (

  • MindsDB

    In-Database Machine Learning

    Project mention: MindsDB: Creating machine learning predictive models using SQL. | | 2022-01-19

    Want to try it out for yourself? Sign up for a free MindsDB account and join our community! Engage with MindsDB community on Slack or Github to ask questions, share and express ideas and thoughts!

  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • wal-e

    Continuous Archiving for Postgres

    Project mention: Recovering a PostgreSQL Database After a Hard Drive Failure | | 2021-12-31

    Hope this helps someone out there.

  • PonyORM

    Pony Object Relational Mapper

  • tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project mention: Show HN: Django Async ORM | | 2021-12-01

    Thanks, it's great to see Django adding slowly but surely in all sorts of places.

    By the way, have you looked at tortoise orm, which is a fully async python ORM with very Django-like syntax? [1]


  • migra

    Like diff but for PostgreSQL schemas

    Project mention: Atlas – Terraform but for Database Migrations | | 2022-01-20

    I use migra [] for PostgreSQL.

    I only put schema.sql into git, no migration scripts.

    To make changes, I update schema.sql and load it up into temporary db. Then I run migra prod_db temp_db and it spits out the SQL statements that take me from the old schema.sql (which was in production) to the new. I eyeball the statements and if they look good, I apply them to prod_db.

  • mara-pipelines

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

    Project mention: How to keep track of the different Transformations done in an ETL pipeline? | | 2021-08-22

    The closest I've found is Mara but not what I'm after.

  • Gopherus

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

    Project mention: Is the Web Application Hacker's Handbook still relevant? | | 2021-05-06
  • Barman

    Barman - Backup and Recovery Manager for PostgreSQL

    Project mention: Oracle RMAN equivalent backup tool for PostgreSQL | | 2021-04-11

    Why chose it over Barman?

  • pghoard

    PostgreSQL backup and restore service

    Project mention: Future PostgreSQL: improvement to the replication protocol | | 2022-01-13

    This story starts with our own PgHoard, a PITR backup tool for PostgreSQL. PgHoard offers several methods to archive the WAL (Write Ahead Log), including pg_receivewal, a small application shipping with PostgreSQL which connects to a PostgreSQL cluster using the physical replication protocol to stream WAL as they are produced, optionally keeping track of the position on the server using a replication slot.

  • spilo

    Highly available elephant herd: HA PostgreSQL cluster using Docker

    Project mention: Backup Postgresql Docker | | 2021-04-16
  • piccolo

    A fast, user friendly ORM and query builder which supports asyncio.

    Project mention: Piccolo - a modern, async query builder / ORM for Postgres | | 2022-01-08

    Hi, I'm a big fan of Postgres, and have been working on Piccolo for the last few years.

  • psycopg

    New generation PostgreSQL database adapter for the Python programming language

    Project mention: Building a Micro Business: What Services I Pay For | | 2021-12-30

    dvarrazzo: developer of psycopg

  • FeedHQ

    FeedHQ is a web-based feed reader

  • aerich

    A database migrations tool for TortoiseORM, ready to production.

    Project mention: FastAPI + Ormar + Alembic setup | | 2021-08-14

    We have successfully setup out FastAPI + ormar + alembic project. With pydantic support, ormar can generate pydantic models from ormar models. The generated pydantic models can be used by FastAPI during request/response data validation. ormar + alembic is a great duo to writing database code. Another great combination is tortoise ORM + aerich, which I'm planning to write soon.

  • django-migration-linter

    :rocket: Detect backward incompatible migrations for your django project

    Project mention: Does anyone use ci/cd for deploying database changes? | | 2021-08-18

    There's actually a Django package called django-migration-linter that can help with this by spotting migrations that could break under that condition:

  • postgrest-docs

    Documentation for PostgREST

    Project mention: How to CRUD with Node.js and MongoDB | | 2021-06-08
  • queries

    PostgreSQL database access simplified

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 2022-01-20.

Python Postgresql related posts


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

Project Stars
1 Redash 20,324
2 pgcli 10,038
3 full-stack-fastapi-postgresql 7,910
4 dev-setup 5,590
5 asyncpg 5,251
6 patroni 4,475
7 MindsDB 4,452
8 wal-e 3,321
9 PonyORM 2,789
10 tortoise-orm 2,623
11 migra 2,105
12 mara-pipelines 1,850
13 Gopherus 1,749
14 Barman 1,222
15 pghoard 1,090
16 spilo 924
17 piccolo 644
18 psycopg 579
19 FeedHQ 530
20 aerich 450
21 django-migration-linter 335
22 postgrest-docs 260
23 queries 236
Find remote Postgresql jobs at our new job board There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Less time debugging, more time building
Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.