dhamaniasad/awesome-postgres

Databases 2 months ago 7.8k

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

View byDAY/WEEK/README

View on Github

Apr 11th - Apr 17th, 2022

Backups

wal-e stars3.3k (obsolete) - Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.

Jan 31st - Feb 6th, 2022

Resources

Articles

Tricking Postgres into using an insane – but 200x faster – query plan

Oct 11th - Oct 17th, 2021

Utilities

pgMonitor stars330 - Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or Kubernetes.

PaaS (PostgreSQL as a Service)

Crunchy Bridge - Fully managed Postgres from the Postgres experts. Available across all major cloud providers: Amazon AWS, Google GCP, Microsoft Azure. No lock-in with full super-user support.

Sep 27th - Oct 3rd, 2021

GUI

Beekeeper Studio - Free and open source SQL client with a modern UI and great Postgres support. Cross platform.

Jul 12th - Jul 18th, 2021

GUI

Chartbrew - Create live dashboards, charts, and client reports from PostgreSQL data. Features a query tool that works with SQL.

Feb 1st - Feb 7th, 2021

GUI

Count - Web-based analytics platform with a notebook interface which connects to PostgreSQL (Commercial Software).

Jan 25th - Jan 31st, 2021

PaaS (PostgreSQL as a Service)

Scaleway Managed Database - Fully managed PostgreSQL databases with HA, scaling, and automated backups, hosted in the EU. Starting at €10 per month.

Dec 7th - Dec 13th, 2020

Resources

Tutorials

PostgreSQL Primer for Busy People - A collection of the most common commands used in PostgreSQL

Nov 30th - Dec 6th, 2020

Monitoring

dexter stars1.2k - The automatic indexer for Postgres. Detects slow queries and creates indexes if configured to do so.

Nov 23rd - Nov 29th, 2020

Extensions

pg_cron stars1.6k - Run periodic jobs in PostgreSQL.

Oct 5th - Oct 11th, 2020

PaaS (PostgreSQL as a Service)

Google Cloud SQL for PostgreSQL - Fully-managed database service that makes it easy to set up, maintain, manage, and administer your PostgreSQL relational databases on Google Cloud Platform.

Sep 14th - Sep 20th, 2020

Extensions

PGAudit - The PostgreSQL Audit Extension (or pgaudit) provides detailed session and/or object audit logging via the standard logging facility provided by PostgreSQL.

Aug 31st - Sep 6th, 2020

GUI

DataRow - Cross-platform SQL Client for Amazon Redshift: Simple, Effortless, Extensible.

OmniDB - Open Source Collaborative Environment

Jul 6th - Jul 12th, 2020

Language bindings

R: RPostgreSQL stars59

May 18th - May 24th, 2020

High-Availability

Slony-I - "Master to multiple slaves" replication system with cascading and failover.

Utilities

pg-differ stars32 - Tool for easy initialization / updating of the structure of PostgreSQL tables, migration alternative (Node.js).

pg_docs_bot stars16 - Browser extension to redirect PostgreSQL docs links to the current version.

Resources

Blogs

Bruce Momjian's PostgreSQL blog

Apr 27th - May 3rd, 2020

Utilities

ScaffoldHub.io - Generate fullstack PostgreSQL apps with Angular, Vue or React (Commercial Software).

Apr 20th - Apr 26th, 2020

Backups

wal-g stars2.2k - The successor of WAL-E rewritten in Go. Currently supports cloud object storage services by AWS (S3), Google Cloud (GCS), Azure, as well as OpenStack Swift, MinIO, and file system storages. Supports block-level incremental backups, offloading backup tasks to a standby server, provides parallelization and throttling options. In addition to Postgres, WAL-G can be used for MySQL and MongoDB databases.

CLI

pgsh stars479 - Branch your PostgreSQL Database like Git

schemaspy stars2.2k - SchemaSpy is a JAVA JDBC-compliant tool for generating your database to HTML documentation, including Entity Relationship diagrams

Monitoring

PMM stars245 - Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.

pgmetrics - pgmetrics is an open-source, zero-dependency, single-binary tool that can collect a lot of information and statistics from a running PostgreSQL server and display it in easy-to-read text format or export it as JSON and CSV for scripting.

okmeter.io - Commercial SaaS agent-based monitoring with a very detailed PostgreSQL plugin. It automatically gathers 100s of stats, displays dashboards on every aspect and sends alerts when something goes wrong (Commercial Software).

Extensions

PipelineDB - A PostgreSQL extension that runs SQL queries continuously on streams, incrementally storing results in tables.

Optimization

pg_flame stars1.5k - A flamegraph generator for query plans.

Utilities

Hasura GraphQL Engine stars26.9k - Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.

pg_activity stars1.5k - top like application for PostgreSQL server activity monitoring.

PgBouncer - Lightweight connection pooler for PostgreSQL.

pgpool-II - Middleware that provides connection pooling, replication, load balancing and limiting exceeding connections.

Language bindings

Go: pq stars7.3k, pgx stars5.5k

Node: node-postgres, pg-promise stars3.1k, pogi stars142, slonik stars3.1k, postgres stars4k

Python: psycopg2, asyncpg

Ruby: pg stars583

Resources

Articles

What PostgreSQL has over other open source SQL databases: Part II

the ultimate postgres vs mysql blog post

Superfast CSV imports using PostgreSQL's COPY command

Resources

Videos

Postgres Conference Youtube channel - Conference videos

Resources

Community

Mailing lists - Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community.

Reddit - A reddit community for PostgreSQL users with over 12000 users

Slack - Slack channel for Postgres with over 7000 users

Telegram - Several groups for PostgreSQL in different langauges: Russian >4200 people, Brazilian Portuguese >2300 people, Indonesian ~1000 people, English >750 people

#postgresql on Freenode - The most popular IRC channel about Postgres on Freenode with over 1000 users

Nov 18th - Nov 24th, 2019

Extensions

PGroonga - PGroonga provides a new index access method that uses Groonga allowing super fast full text search feature against all languages.

Sep 2nd - Sep 8th, 2019

Resources

Videos

Scaling Postgres - Postgres video blog series by Creston Jamison

CLI

nancy - The Nancy CLI is a unified way to manage automated database experiments either in clouds or on-premise

Utilities

postgres-checkup - a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres database.

Optimization

pgMustard - A modern user interface

Jun 24th - Jun 30th, 2019

Utilities

pg_insights stars277 - Convenient SQL for monitoring Postgres database health.

May 6th - May 12th, 2019

Extensions

Citus stars6.2k - Scalable PostgreSQL cluster for real-time workloads.

Apr 15th - Apr 21st, 2019

Resources

Tutorials

pg-utils stars615 - Useful DBA tools by Data Egret

Extensions

TimescaleDB - Open-source time-series database fully compatible with Postgres, distributed as extension

Apr 1st - Apr 7th, 2019

PaaS (PostgreSQL as a Service)

Azure Database for PostgreSQL - Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service. It provides builtin HA, elastic scaling and native integration with Azure ecosystem.

DigitalOcean Managed Databases - Fully managed PostgreSQL databases. No free plan. Starting at $15/mo. Daily backups with point-in-time recovery. Standby nodes with auto-failover.

Aiven PostgreSQL - PostgreSQL as a service in AWS, Azure, DigitalOcean, Google Cloud and UpCloud; plans range from $19/month single node instances to large highly-available setups, free trial for two weeks.

Amazon RDS for PostgreSQL - Amazon Relational Database Service (RDS) for PostgreSQL

Database Labs - Get a production-ready cloud PostgreSQL server in minutes, from $20 a month Backups, monitoring, patches, and 24/7 tech support all included.

ElephantSQL - Offers databases ranging from shared servers for smaller projects and proof of concepts, up to enterprise grade multi server setups. Has free plan for up to 5 DBs, 20 MB each.

Heroku Postgres - Plans from free to huge, operated by PostgreSQL experts. Does not require running your app on Heroku. Free plan includes 10,000 rows, 20 connections, up to two backups, and has PostGIS support.

Resources

Documentation

Wiki - user documentation, how-tos, and tips 'n' tricks

Docker images

citusdata/citus - Citus official images with citus extensions. Based on the official Postgres container.

mdillon/postgis - PostGIS 2.3 on Postgres 9. Based on the official Postgres container.

postgres - Official postgres container (from Docker)

Mar 25th - Mar 31st, 2019

Extensions

pgRouting stars909 - pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

Language bindings

Haskell: postgresql-simple

Jan 28th - Feb 3rd, 2019

Language bindings

Clojure: clj-postgresql stars151

Jan 21st - Jan 27th, 2019

Utilities

PGXN client stars94 - Command line tool to interact with the PostgreSQL Extension Network

Server

AgensGraph - Powerful graph database based on the PostgreSQL.

Dec 3rd - Dec 9th, 2018

Resources

Videos

Citus Data Youtube channel - Citus related videos

EnterpriseDB Youtube channel - EnterpriseDB related videos

Backups

pgBackRest - Reliable PostgreSQL Backup & Restore.

Barman - Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.

pghoard stars1.1k - Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).

GUI

DBeaver - Universal Database Manager with excellent support for PostgreSQL.

High-Availability

pglookout stars147 - Replication monitoring and failover daemon.

Distributions

Postgres.app - The Easiest Way to Get Started with PostgreSQL on macOS.

Extensions

pg_partman stars1.3k - Partition management extension for PostgreSQL.

pgTAP - Database testing framework for Postgres

Utilities

PostgREST stars18.7k - Serves a fully RESTful API from any existing PostgreSQL database.

sqitch stars2.4k - Tool for managing versioned schema deployment

Language bindings

Perl: DBD-Pg

Resources

Blogs

Andrew Dunstan's PostgreSQL and Technical blog

Michael Paquier's blog

Robert Haas' blog

Nov 12th - Nov 18th, 2018

GUI

Numeracy - Fast SQL editor with charts and dashboards for PostgreSQL (Commercial Software).

Oct 22nd - Oct 28th, 2018

Utilities

pgbadger stars2.7k - Fast PostgreSQL Log Analyzer.

sqlcheck stars2.1k - Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.

Server

Greenplum Database stars5.2k - Open source fork of PostgreSQL for large data volumes.

Jul 23rd - Jul 29th, 2018

Backups

pg_back stars240 - pg_back is a simple backup script

Utilities

pg_chameleon stars312 - Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.

pg_bulkload - It's a high speed data loading utility for PostgreSQL.

Jul 2nd - Jul 8th, 2018

High-Availability

PAF stars300 - PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.

Extensions

HypoPG stars695 - HypoPG provides hypothetical/virtual indexes feature.

Mar 26th - Apr 1st, 2018

Utilities

PostGraphile stars11.3k - Instant GraphQL API or GraphQL schema for your PostgreSQL database

Mar 19th - Mar 25th, 2018

Utilities

ldap2pg stars146 - Synchronize roles and privileges from YML and LDAP.

Dec 11th - Dec 17th, 2017

Monitoring

pgwatch2 stars1.3k - Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards.

Nov 6th - Nov 12th, 2017

Utilities

pREST stars3.2k - Serve a RESTful API from any PostgreSQL database (Golang)

Resources

Tutorials

postgresDBSamples stars225 - A collection of sample postgres schemas

Language bindings

Lua: luapgsql stars96

GUI

Metabase - Simple dashboards, charts and query tool for PostgreSQL.

Monitoring

opm.io - Open PostgreSQL Monitoring is a free software suite designed to help you manage your PostgreSQL servers. It can gather stats, display dashboards and send warnings when something goes wrong.

Sep 18th - Sep 24th, 2017

Extensions

pgMemento stars290 - Provides an audit trail for your data inside a PostgreSQL database using triggers and server-side functions written in PL/pgSQL.

Aug 28th - Sep 3rd, 2017

Server

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster.

Jul 3rd - Jul 9th, 2017

Distributions

PostgreSql.Binaries.Lite stars26 - Minimum set of Windows binaries of the PostgreSQL database. Also made available through NuGet.

GUI

Holistics - Online cross platform database management tool and SQL query reporting GUI with strong PostgreSQL support (Commercial Software).

Jun 5th - Jun 11th, 2017

Utilities

pg-formatter stars57 - A PostgreSQL SQL syntax beautifier (Node.js).

Apr 24th - Apr 30th, 2017

Resources

Articles

Why use Postgres?

Resources

Newsletters

Postgres Weekly - Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL.

Apr 17th - Apr 23rd, 2017

Language bindings

.Net/.Net Core: Npgsql stars2.6k

Apr 3rd - Apr 9th, 2017

Utilities

pg_migrate stars24 - Manage PostgreSQL codebases and make VCS simple.

Mar 20th - Mar 26th, 2017

Monitoring

Instrumental stars13 - Real-time performance monitoring, including pre-made graphs for ease of setup (Commercial Software)

Feb 27th - Mar 5th, 2017

Backups

pg_probackup stars484 – A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.

Extensions

PG_Themis stars29 - Postgres binding as extension for crypto library Themis, providing various security services on PgSQL's side.

cyanaudit - Cyan Audit provides in-database logging of all DML activity on a column-by-column basis.

pgxn PostgreSQL Extension Network - central distribution point for many open-source PostgreSQL extensions

Utilities

apgdiff - Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one.

ZSON stars436 - PostgreSQL extension for transparent JSONB compression

Jan 23rd - Jan 29th, 2017

High-Availability

SkyTools stars247 - Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.

Jan 9th - Jan 15th, 2017

Monitoring

pgbench - Run a benchmark test on PostgreSQL.

Nov 28th - Dec 4th, 2016

Resources

Blogs

Planet PostgreSQL - Blog aggregation service for PostgreSQL.

Nov 14th - Nov 20th, 2016

Utilities

pglistend stars26 - A lightweight PostgresSQL LISTEN/NOTIFY daemon built on top of node-postgres.

Nov 7th - Nov 13th, 2016

High-Availability

Patroni stars4.7k - Template for PostgreSQL HA with ZooKeeper or etcd.

Stolon stars3.7k - PostgreSQL HA based on Consul or etcd, with Kubernetes integration.

repmgr stars1.3k - Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.

Backups

OmniPITR stars170 - Advanced WAL File Management Tools for PostgreSQL.

GUI

Adminer - Full-featured database management tool written in PHP.

DataGrip - IDE with advanced tool sets and good cross-platform experience (Commercial Software).

Datazenit - Web-based PostgreSQL GUI (Commercial Software).

JackDB - Web-based SQL query interface (Commercial Software).

Monitoring

check_pgactivity stars150 - check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.

Check_postgres stars486 - Nagios check_postgres plugin for checking status of PostgreSQL databases.

libzbxpgsql stars150 - Comprehensive PostgreSQL monitoring module for Zabbix.

Pome stars1.1k - Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.

pg_view stars464 - Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.

Extensions

cstore_fdw stars1.7k - Columnar store for analytics with PostgreSQL.

pglogical stars600 - Extension that provides logical streaming replication.

pg_paxos stars294 - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes.

pg_shard stars1.1k - Extension to scale out real-time reads and writes.

PGStrom - Extension to offload CPU intensive workloads to GPU.

plpgsql_check stars395 - Extension that allows to check plpgsql source code.

PostGIS - Spatial and Geographic objects for PostgreSQL.

zomboDB stars4k - Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch.

Optimization

PgHero stars6.4k - PostgreSQL insights made easy.

Utilities

ERAlchemy stars906 - ERAlchemy generates Entity Relation (ER) diagram from databases.

mysql-postgresql-converter stars1.2k - Lanyrd's MySQL to PostgreSQL conversion script.

ora2pg - Perl module to export an Oracle database schema to a PostgreSQL compatible schema.

pganalyze - PostgreSQL Performance Monitoring (Commercial Software).

pgCenter stars1.4k - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.

pgclimb stars371 - Export data from PostgreSQL into different data formats.

pgfutter stars1.2k - Import CSV and JSON into PostgreSQL the easy way.

PGInsight - CLI tool to easily dig deep inside your PostgreSQL database.

pgloader stars3.9k - Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.

pgsync stars2.3k - Tool to sync PostgreSQL data to your local machine.

postgresql-metrics stars561 - Tool that extracts and provides metrics for your PostgreSQL database.

yoke stars1.4k - PostgreSQL high-availability cluster with auto-failover and automated cluster recovery.

Resources

Tutorials

Backup and recover a PostgreSQL DB using wal-e - Tutorial about setting up continuous archiving in PostgreSQL using wal-e.

PG Casts - Free weekly PostgreSQL screencasts by Hashrocket.

Postgres Guide - Guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within PostgreSQL.

PostgreSQL Exercises - Site to make it easy to learn PostgreSQL by doing exercises.

tutorialspoint PostgreSQL tutorial - Very extensive collection of tutorials on PostgreSQL

Resources

Blogs

Craig Kerstiens PostgreSQL posts - Set of posts on PostgreSQL cool features, tips and tricks.

Database Soup - Josh Berkus' blog.

select * from depesz; - Hubert Lubaczewski's blog.

Oct 31st - Nov 6th, 2016

CLI

psql - The built-in PostgreSQL CLI client

High-Availability

BDR stars349 - BiDirectional Replication - a multimaster replication system for PostgreSQL

Utilities

pgcmp stars32 - Tool to compare database schemas, with capability to accept some persistent differences

Oct 10th - Oct 16th, 2016

Utilities

pgmigrate stars524 - CLI tool to evolve schema migrations, developed by Yandex.

GUI

dbglass - Cross-platform desktop client for PostgreSQL, built with Electron.

Oct 3rd - Oct 9th, 2016

Resources

Articles

Debugging PostgreSQL performance, the hard way

Sep 12th - Sep 18th, 2016

Backups

pitrery - pitrery is a set of Bash scripts to manage Point In Time Recovery (PITR) backups for PostgreSQL.

Sep 5th - Sep 11th, 2016

Language bindings

Common Lisp: Postmodern stars323

Elixir: postgrex stars931

Rust: rust-postgresql stars2.5k

Jul 18th - Jul 24th, 2016

Resources

Articles

What PostgreSQL has over other open source SQL databases: Part I

Mar 7th - Mar 13th, 2016

Language bindings

PHP: Pomm, pecl/pq stars33

Jan 25th - Jan 31st, 2016

Language bindings

Java: PostgreSQL JDBC Driver

Nov 16th - Nov 22nd, 2015

CLI

psql2csv stars170 - Run a query in psql and output the result as CSV

Jul 27th - Aug 2nd, 2015

CLI

pgcli stars10.4k - Postgres CLI with autocompletion and syntax highlighting

Last Checked At: 2022-05-28T03:53:44.570Z

mohataher/awesome-tinkerpop

quangv/awesome-couchdb

Track Awesome List

// Track it, not just star it.

Top 50 Awesome List

Recently Updated

Platforms

Programming Languages

Front-End Development

Back-End Development

Computer Science

Big Data

Theory

Books

Editors

Gaming

Development Environment

Entertainment

Databases

Media

Learn

Security

Content Management Systems

Hardware

Business

Work

Networking

Decentralized Systems

Higher Education

Events

Testing

Miscellaneous

Unmaintained

Top 50 Awesome List

Recently Updated

Platforms

Programming Languages

Front-End Development

Back-End Development

Computer Science

Big Data

Theory

Books

Editors

Gaming

Development Environment

Entertainment

Databases

Media

Learn

Security

Content Management Systems

Hardware

Business

Work

Networking

Decentralized Systems

Higher Education

Events

Testing

Miscellaneous

Unmaintained

dhamaniasad/awesome-postgres

Backups

Jan 31st - Feb 6th, 2022

Resources

Articles

Oct 11th - Oct 17th, 2021

Utilities

PaaS (PostgreSQL as a Service)

Sep 27th - Oct 3rd, 2021

GUI

Jul 12th - Jul 18th, 2021

GUI

Feb 1st - Feb 7th, 2021

GUI

Jan 25th - Jan 31st, 2021

PaaS (PostgreSQL as a Service)

Dec 7th - Dec 13th, 2020

Resources

Tutorials

Nov 30th - Dec 6th, 2020