Your first time on this page? Allow me to give some explanations.
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.
Thank you dhamaniasad & contributors
View Topic on GitHub:
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.
Bi-Directional Multi-Master Replication (BDR) for PostgreSQL, deprecated, please visit 2ndQuadrant website for latest BDR3
A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
PostgreSQL cloud native High Availability and more.
PostgreSQL replication monitoring and failover daemon
The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 5.2.0 (2020-10-22)
PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
Obsolete, see https://github.com/pgq/ for maintained code.
Advanced WAL File Management Tools for PostgreSQL
Backup and recovery manager for PostgreSQL
Simple backup script for PostgreSQL
PostgreSQL backup and restore service
Continuous Archiving for Postgres
Archival and Restoration for Postgres
Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.
Cross-platform client for PostgreSQL databases
the premier web-based administration tool for postgresql
Open source PostgreSQL GUI client for macOS, Linux and Windows
PostgreSQL Remote Control
IDE with advanced tool sets and good cross-platform experience (Commercial Software).
Cross-platform SQL Client for Amazon Redshift: Simple, Effortless, Extensible.
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]
Cross-platform database comparison and deployment tool (Commercial Software).
Simple, powerful PostgreSQL manager for macOS (Commercial Software).
Postgres CLI with autocompletion and syntax highlighting
Branch your PostgreSQL Database like Git
Run a query in psql and output the result as CSV.
SchemaSpy code home
Nagios remote agent
Nagios check_postgres plugin for checking status of PostgreSQL databases
Instrumental System and Service Daemon
Monitor PostgreSQL with Zabbix
PMM general repo
A Postgres Metrics Dashboard
Get a detailed, real-time view of your PostgreSQL database and system metrics
PostgreSQL metrics monitor/dashboard
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.
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.
Distributed PostgreSQL as an extension - for multi-tenant and real-time analytics workloads
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
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.
Partition management extension for PostgreSQL
Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes
ATTENTION: pg_shard is superseded by Citus, its more powerful replacement
plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).
Postgres Themis plugin
Making Postgres and Elasticsearch work together like it's 2020
Audit trail with schema versioning for PostgreSQL using transaction-based logging
Hypothetical Indexes for PostgreSQL
Repository contains pgRouting library. Development branch is "develop", stable branch is "master"
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.
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.
A flamegraph generator for Postgres EXPLAIN ANALYZE output.
A performance dashboard for Postgres
PostgreSQL configuration wizard
Pgtune - tuning PostgreSQL config by your hardware
Web Based PostgreSQL configuration tool
Web UI to view pg_stat_statements
A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.
Entity Relation Diagrams generation tool
Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
Manage PostgreSQL roles and privileges from YAML or LDAP
Lanyrd's MySQL to PostgreSQL conversion script
pg_activity is a top like application for PostgreSQL server activity monitoring.
A PostgreSQL SQL syntax beautifier.
A fast PostgreSQL Log Analyzer
Command-line admin tool for observing and troubleshooting Postgres.
MySQL to PostgreSQL replica system
Export data from PostgreSQL into different data formats
A browser extension (Firefox or Chrome) for getting to the current Postgres docs by default.
Import CSV and JSON into PostgreSQL the easy way
A collection of convenient SQL for monitoring Postgres database health.
Migrate to PostgreSQL in a single command!
Sync data from one Postgres database to another
A command line client for the PostgreSQL Extension Network
Tool that extracts and provides metrics on your PostgreSQL database
REST API for any Postgres database
pREST (PostgreSQL REST), simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!
Postgres high-availability cluster with auto-failover and automated cluster recovery.
pglistend - A lightweight PostgreSQL LISTEN Daemon using Node.js/Systemd
ZSON is a PostgreSQL extension for transparent JSONB compression
Manage postgres schema, triggers, procedures, and views
Sensible database change management
Simple tool to evolve PostgreSQL schema easily.
Tool for comparing Postgres database schemas
Node.js migration tool for PostgreSQL
Automatically identify anti-patterns in SQL queries
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.
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.
A Common Lisp PostgreSQL programming interface
PostgreSQL helpers for Clojure projects
PostgreSQL driver for Elixir
Pure Go Postgres driver for database/sql
Npgsql is the .NET data provider for PostgreSQL.
PostgreSQL client for node.js.
A PostgreSQL client library for Ruby
Native PostgreSQL driver for the Rust programming language
Lua binding for PostgreSQL
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)
Citus official images with citus extensions. Based on the official Postgres container.
PostGIS 2.3 on Postgres 9. Based on the official Postgres container.
Sample databases for postgres
Useful PostgreSQL utilities
Tutorial about setting up continuous archiving in PostgreSQL using wal-e.
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
Set of posts on PostgreSQL cool features, tips and tricks.
EnterpriseDB related videos
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