User Experience on mobile might not be great yet, but I'm working on it.

Your first time on this page? Allow me to give some explanations.

Awesome PostgreSQL

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

Here you can see meta information about this topic like the time we last updated this page, the original creator of the awesome list and a link to the original GitHub repository.

Last Update: Nov. 26, 2020, 9:03 a.m.

Thank you dhamaniasad & contributors
View Topic on GitHub:
dhamaniasad/awesome-postgres

Search for resources by name or description.
Simply type in what you are looking for and the results will be filtered on the fly.

Further filter the resources on this page by type (repository/other resource), number of stars on GitHub and time of last commit in months.

High-Availability

Bi-Directional Multi-Master Replication (BDR) for PostgreSQL, deprecated, please visit 2ndQuadrant website for latest BDR3

347
52
9m
n/a

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

3.62K
430
2d
MIT

PostgreSQL cloud native High Availability and more.

3.04K
346
5m
Apache-2.0

PostgreSQL replication monitoring and failover daemon

121
12
24d
Apache-2.0

The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 5.2.0 (2020-10-22)

1.16K
213
2d
n/a

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

282
39
64d
n/a

Obsolete, see https://github.com/pgq/ for maintained code.

245
85
3y 5m
n/a

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

Backups

Advanced WAL File Management Tools for PostgreSQL

166
33
1y 5m
n/a

Backup and recovery manager for PostgreSQL

337
47
6d
n/a

Simple backup script for PostgreSQL

87
35
5m
n/a

PostgreSQL backup and restore service

979
74
15d
Apache-2.0

Continuous Archiving for Postgres

3.18K
312
9m
BSD-3-Clause

Archival and Restoration for Postgres

1.61K
205
1d
n/a

Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.

Reliable PostgreSQL Backup & Restore.

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

GUI

Cross-platform client for PostgreSQL databases

6.67K
502
39d
MIT

the premier web-based administration tool for postgresql

472
191
17d
n/a

Open source PostgreSQL GUI client for macOS, Linux and Windows

1.03K
86
40d
MIT

PostgreSQL Remote Control

202
32
14d
PostgreSQL

Database management in a single PHP file.

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

Web-based PostgreSQL GUI (Commercial Software).

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

Universal SQL Client.

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

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

Secure, collaborative environment for your queries and data-driven insights. ![Open-Source Software][OSS Icon] ![Freeware][Freeware Icon]

Simple dashboards, charts and query tool for PostgreSQL.

Fast, clean SQL client and business intelligence.

Open Source Collaborative Environment

PostgreSQL Administration and Management GUI.

pgModeler is an open-source PostgreSQL Database Modeler.

Cross-platform database comparison and deployment tool (Commercial Software).

A modern PostgreSQL client.

A PostgreSQL GUI tool. ![Freeware][Freeware Icon]

Cross Platform Desktop Client for PostgreSQL written in JS.

Simple, powerful PostgreSQL manager for macOS (Commercial Software).

A modern, native GUI for multiple databases.

Cross-platform database administration tool (Free/Commercial)

Distributions

The Easiest Way to Get Started with PostgreSQL on macOS.

CLI

Postgres CLI with autocompletion and syntax highlighting

9.12K
415
43d
BSD-3-Clause

Branch your PostgreSQL Database like Git

410
14
7d
MIT

Run a query in psql and output the result as CSV.

151
23
1y 7m
MIT

SchemaSpy code home

1.52K
182
55d
LGPL-3.0

The built-in PostgreSQL CLI client

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

Server

Greenplum Database

4.27K
1.23K
3d
n/a

Scalable Open Source PostgreSQL-based Database Cluster.

Powerful graph database based on the PostgreSQL.

Monitoring

Nagios remote agent

133
42
2d
PostgreSQL

Nagios check_postgres plugin for checking status of PostgreSQL databases

428
150
20d
n/a

Instrumental System and Service Daemon

13
3
2y 71d
MIT

Monitor PostgreSQL with Zabbix

152
65
1y 7m
n/a

PMM general repo

179
36
42d
AGPL-3.0

A Postgres Metrics Dashboard

1.08K
39
4y 6m
Apache-2.0

Get a detailed, real-time view of your PostgreSQL database and system metrics

438
40
55d
n/a

PostgreSQL metrics monitor/dashboard

886
155
3d
BSD-3-Clause

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.

Run a benchmark test on PostgreSQL.

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.

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

Distributed PostgreSQL as an extension - for multi-tenant and real-time analytics workloads

4.42K
347
2d
AGPL-3.0

Columnar store for analytics with Postgres, developed by Citus Data. Check out the mailing list at https://groups.google.com/forum/#!forum/cstore-users or join our slack channel at https://slack.citusdata.com

1.51K
151
10m
Apache-2.0

Logical Replication extension for PostgreSQL 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

422
80
52d
n/a

Partition management extension for PostgreSQL

1.03K
180
6m
n/a

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

297
36
4y 13d
PostgreSQL

ATTENTION: pg_shard is superseded by Citus, its more powerful replacement

1.06K
66
4y 116d
LGPL-3.0

plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).

299
34
10d
n/a

Postgres Themis plugin

27
5
3y 11m
Apache-2.0

Making Postgres and Elasticsearch work together like it's 2020

3.06K
143
5d
n/a

Audit trail with schema versioning for PostgreSQL using transaction-based logging

251
31
115d
LGPL-3.0

Hypothetical Indexes for PostgreSQL

555
34
4m
n/a

Repository contains pgRouting library. Development branch is "develop", stable branch is "master"

760
288
7d
n/a

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

Extension to offload CPU intensive workloads to GPU.

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

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

Spatial and Geographic objects for PostgreSQL.

Built as an extension on top of PostgreSQL, TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.

Database testing framework for Postgres

Optimization

A flamegraph generator for Postgres EXPLAIN ANALYZE output.

1.36K
20
10m
Apache-2.0

A performance dashboard for Postgres

5.61K
318
2d
MIT

PostgreSQL configuration wizard

922
90
5m
BSD-3-Clause

Pgtune - tuning PostgreSQL config by your hardware

991
100
8d
MIT

Web Based PostgreSQL configuration tool

92
10
98d
n/a

Web UI to view pg_stat_statements

92
16
2y 44d
n/a

A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.

172
19
2d
Apache-2.0

A modern user interface

PostgreSQL Workload Analyzer gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.

Utilities

Entity Relation Diagrams generation tool

730
72
2y 5m
Apache-2.0

Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.

19.45K
1.71K
2d
n/a

Manage PostgreSQL roles and privileges from YAML or LDAP

124
0
101d
PostgreSQL

Lanyrd's MySQL to PostgreSQL conversion script

1.14K
413
4y 8m
BSD-2-Clause

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

1.03K
118
62d
PostgreSQL

A PostgreSQL SQL syntax beautifier.

39
3
8m
n/a

A fast PostgreSQL Log Analyzer

2.13K
243
2d
PostgreSQL

Command-line admin tool for observing and troubleshooting Postgres.

1.02K
60
26d
n/a

MySQL to PostgreSQL replica system

267
55
64d
BSD-2-Clause

Export data from PostgreSQL into different data formats

333
30
1y 12m
MIT

A browser extension (Firefox or Chrome) for getting to the current Postgres docs by default.

8
0
5m
MIT

Import CSV and JSON into PostgreSQL the easy way

1.12K
109
1y 6m
MIT

A collection of convenient SQL for monitoring Postgres database health.

243
11
11m
MIT

Migrate to PostgreSQL in a single command!

3.16K
365
5d
n/a

Sync data from one Postgres database to another

1.83K
100
7d
MIT

A command line client for the PostgreSQL Extension Network

72
12
2d
n/a

Tool that extracts and provides metrics on your PostgreSQL database

517
31
1y 9m
Apache-2.0

REST API for any Postgres database

16.03K
747
3d
MIT

pREST (PostgreSQL REST), simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new

2.47K
152
2d
MIT

Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!

9.61K
461
8d
MIT

Postgres high-availability cluster with auto-failover and automated cluster recovery.

1.36K
66
4y 10m
n/a

pglistend - A lightweight PostgreSQL LISTEN Daemon using Node.js/Systemd

22
4
3y 8m
MIT

ZSON is a PostgreSQL extension for transparent JSONB compression

381
19
2y 5m
MIT

Manage postgres schema, triggers, procedures, and views

24
2
3y 47d
MIT

Sensible database change management

2.08K
173
46d
MIT

Simple tool to evolve PostgreSQL schema easily.

474
44
28d
PostgreSQL

Tool for comparing Postgres database schemas

25
3
6m
n/a

Node.js migration tool for PostgreSQL

26
2
29d
MIT

Automatically identify anti-patterns in SQL queries

1.93K
81
7m
Apache-2.0

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

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

PostgreSQL Performance Monitoring (Commercial Software).

Lightweight connection pooler for PostgreSQL.

CLI tool to easily dig deep inside your PostgreSQL database.

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

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

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

Generate full Angular Material applications with MongoDB, SQL or Firebase Firestore databases.

Language bindings

A Common Lisp PostgreSQL programming interface

248
73
90d
n/a

PostgreSQL helpers for Clojure projects

123
15
1y 60d
BSD-2-Clause

PostgreSQL driver for Elixir

783
214
18d
n/a

Pure Go Postgres driver for database/sql

6.23K
767
3d
n/a

Npgsql is the .NET data provider for PostgreSQL.

2.11K
657
4d
PostgreSQL

PostgreSQL client for node.js.

9.08K
973
13d
MIT

A PostgreSQL client library for Ruby

412
106
65d
n/a

Native PostgreSQL driver for the Rust programming language

1.93K
205
9d
MIT

Lua binding for PostgreSQL

88
21
6m
n/a

pecl/pq](https://github.com/m6w6/ext-pq)

asyncpg](https://pypi.org/project/asyncpg/)

PaaS *(PostgreSQL as a Service)*

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 Relational Database Service (RDS) 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.

Production grade scaled out PostgreSQL as a service enabling real-time workloads and sharding your multi-tenant apps.

PostgreSQL as a service in AWS, Google Cloud Platform, and IBM Cloud; plans range from $17.5/month for 1GB storage and scale at $12/GB beyond that. Free trial for 30 days available.

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

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

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.

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

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.

Docker images

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

PostGIS 2.3 on Postgres 9. Based on the official Postgres container.

Official postgres container (from Docker)

Tutorials

Sample databases for postgres

135
60
1y 106d
n/a

Useful PostgreSQL utilities

500
95
72d
n/a

Tutorial about setting up continuous archiving in PostgreSQL using wal-e.

Free weekly PostgreSQL screencasts by Hashrocket.

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

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

Very extensive collection of tutorials on PostgreSQL

A collection of the most common commands used in PostgreSQL

Blogs

Articles

Documentation

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

Newsletters

A free, once–weekly e-mail round-up of PostgreSQL news and articles.

Videos

Community

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

A reddit community for PostgreSQL users with over 12000 users

Slack channel for Postgres with over 7000 users

4200 people, Brazilian Portuguese >2300 people, Indonesian ~1000 people, English >750 people

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