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. 29, 2021, 3:03 p.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

351
54
1y 9m
n/a

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

4.35K
548
27d
MIT

PostgreSQL cloud native High Availability and more.

3.43K
380
53d
Apache-2.0

PostgreSQL replication monitoring and failover daemon

136
14
69d
Apache-2.0

A lightweight replication manager for PostgreSQL (Postgres) - latest version 5.3.0 (2021-10-12)

1.26K
222
32d
n/a

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

294
47
74d
n/a

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

247
84
4y 5m
n/a

Backups

Advanced WAL File Management Tools for PostgreSQL

168
34
2y 5m
n/a

Backup and recovery manager for PostgreSQL

441
59
29d
n/a

Simple backup script for PostgreSQL

138
42
28d
n/a

PostgreSQL backup and restore service

1.06K
84
27d
Apache-2.0

Continuous Archiving for Postgres

3.3K
322
8m
BSD-3-Clause

Archival and Restoration for Postgres

1.93K
279
26d
n/a

GUI

Distributions

CLI

Postgres CLI with autocompletion and syntax highlighting

9.93K
457
12d
BSD-3-Clause

Branch your PostgreSQL Database like Git

458
18
70d
MIT

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

160
23
2y 7m
MIT

SchemaSpy code home

1.97K
226
35d
LGPL-3.0

Server

Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.

4.84K
1.38K
26d
n/a

Monitoring

Nagios remote agent

145
48
95d
PostgreSQL

Nagios check_postgres plugin for checking status of PostgreSQL databases

461
157
57d
n/a

Instrumental System and Service Daemon

13
4
3y 75d
MIT

Monitor PostgreSQL with Zabbix

149
71
2y 32d
n/a

PMM general repo

219
44
26d
AGPL-3.0

A Postgres Metrics Dashboard

1.08K
40
1y 87d
Apache-2.0

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

455
43
1y 40d
n/a

PostgreSQL metrics monitor/dashboard

1.1K
188
32d
BSD-3-Clause

The automatic indexer for Postgres

1.08K
29
70d
MIT

Extensions

Distributed PostgreSQL as an extension

5.44K
417
26d
AGPL-3.0

Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.

1.63K
165
8m
Apache-2.0

Run periodic jobs in PostgreSQL

1.21K
109
27d
PostgreSQL

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.

530
99
28d
n/a

Partition management extension for PostgreSQL

1.21K
215
54d
n/a

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

299
39
5y 17d
PostgreSQL

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

1.06K
68
5y 4m
LGPL-3.0

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

359
39
46d
n/a

Postgres Themis plugin

28
5
4y 11m
Apache-2.0

Making Postgres and Elasticsearch work together like it's 2021

3.74K
168
29d
n/a

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

276
31
7m
LGPL-3.0

Hypothetical Indexes for PostgreSQL

647
42
53d
n/a

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

868
337
38d
n/a

Optimization

A flamegraph generator for Postgres EXPLAIN ANALYZE output.

1.43K
26
1y 10m
Apache-2.0

A performance dashboard for Postgres

6.14K
366
14d
MIT

PostgreSQL configuration wizard

952
91
105d
BSD-3-Clause

Pgtune - tuning PostgreSQL config by your hardware

1.23K
130
29d
MIT

Web Based PostgreSQL configuration tool

90
10
1y 102d
n/a

Web UI to view pg_stat_statements

91
16
3y 48d
n/a

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

259
24
47d
Apache-2.0

Utilities

Entity Relation Diagrams generation tool

855
92
71d
Apache-2.0

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

24.36K
2.08K
27d
n/a

Manage PostgreSQL roles and privileges from YAML or LDAP

134
23
42d
PostgreSQL

Lanyrd's MySQL to PostgreSQL conversion script

1.18K
446
96d
BSD-2-Clause

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

1.36K
141
40d
PostgreSQL

A PostgreSQL SQL syntax beautifier.

50
8
27d
n/a

A fast PostgreSQL Log Analyzer

2.49K
276
54d
PostgreSQL

Command-line admin tool for observing and troubleshooting Postgres.

1.33K
79
32d
n/a

MySQL to PostgreSQL replica system

295
63
11m
BSD-2-Clause

Export data from PostgreSQL into different data formats

362
34
1y 5m
MIT

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

15
2
4m
MIT

Import CSV and JSON into PostgreSQL the easy way

1.2K
116
1y 89d
MIT

A collection of convenient SQL for monitoring Postgres database health.

263
13
1y 11m
MIT

Migrate to PostgreSQL in a single command!

3.72K
426
11m
n/a

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data

276
55
26d
n/a

Sync data from one Postgres database to another

2.1K
119
69d
MIT

A command line client for the PostgreSQL Extension Network

89
13
92d
n/a

Tool that extracts and provides metrics on your PostgreSQL database

544
40
4m
Apache-2.0

REST API for any Postgres database

17.84K
823
27d
MIT

pREST (PostgreSQL REST), low-code, simplify and accelerate development, โšก instant, realtime, high-performance on any Postgres application, existing or new

2.97K
216
7d
MIT

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

10.8K
505
32d
MIT

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

1.36K
67
5y 10m
n/a

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

26
4
4y 8m
MIT

ZSON is a PostgreSQL extension for transparent JSONB compression

418
19
6m
MIT

Manage postgres schema, triggers, procedures, and views

24
2
4y 51d
MIT

Sensible database change management

2.25K
182
30d
MIT

Simple tool to evolve PostgreSQL schema easily.

504
55
48d
PostgreSQL

Tool for comparing Postgres database schemas

29
4
1y 6m
n/a

Node.js migration tool for PostgreSQL

30
4
7m
MIT

Automatically identify anti-patterns in SQL queries

2.04K
93
1y 7m
Apache-2.0

Language bindings

A Common Lisp PostgreSQL programming interface

298
79
34d
n/a

PostgreSQL helpers for Clojure projects

146
14
5m
BSD-2-Clause

PostgreSQL driver for Elixir

875
238
33d
n/a

Pure Go Postgres driver for database/sql

6.9K
828
22d
n/a

Npgsql is the .NET data provider for PostgreSQL.

2.39K
706
6d
PostgreSQL

PostgreSQL client for node.js.

10.02K
1.04K
11d
MIT

Automatically exported from code.google.com/p/rpostgresql

53
18
40d
n/a

A PostgreSQL client library for Ruby

504
121
49d
n/a

Native PostgreSQL driver for the Rust programming language

2.34K
269
6d
n/a

Lua binding for PostgreSQL

95
22
58d
n/a

PaaS *(PostgreSQL as a Service)*

Docker images

Tutorials

Blogs

Articles

Documentation

Newsletters

Videos

Community