Awesome Postgres 
A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
PostgreSQL, often simply Postgres, is an object-relational database (ORDBMS). PostgreSQL is ACID-compliant and transactional. (see more: wikipedia:PostgreSQL, PostgreSQL.org)
:elephant: Contributions welcome. Add links through pull requests or create an issue to start a discussion. Please take a look at the contribution guidelines.
Contents
High-Availability
- autobase - Autobase for PostgreSQL® is an open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters.
- BDR - BiDirectional Replication - a multimaster replication system for PostgreSQL
- Patroni - Template for PostgreSQL HA with ZooKeeper or etcd.
- Spock - 100% open-source logical multi-master PostgreSQL replication.
- Stolon - PostgreSQL HA based on Consul or etcd, with Kubernetes integration.
- pglookout - Replication monitoring and failover daemon.
- repmgr - Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.
- Slony-I - "Master to multiple slaves" replication system with cascading and failover.
- PAF - PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
- SkyTools - Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.
- pg_auto_failover - Postgres extension and service for automated failover and high-availability.
- pgrwl - Stream write-ahead logs (WAL) from a PostgreSQL server in real time. A drop-in, container-friendly alternative to pg_receivewal.
- pg-status - A microservice that provides HTTP endpoints for instantly retrieving the current master host or a replica that meets various criteria.
Backups
- Barman - Backup and Recovery Manager for PostgreSQL by 2ndQuadrant.
- Databasus - tool for scheduled PostgreSQL backups via web UI with external storages (local, S3, FTP, Google Drive, etc.), notifications (webhook, Discord, Slack, etc.) and team management.
- OmniPITR - Advanced WAL File Management Tools for PostgreSQL.
- pg_probackup – A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.
- pgBackRest - Reliable PostgreSQL Backup & Restore.
- pgbackweb - A Complete Docker-based Postgres backup and maintenance tool with Web UI.
- pg_back - pg_back is a simple backup script
- pghoard - Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).
- postgres-backup-oss - A handy Docker container to periodically backup PostgreSQL to Alibaba Cloud Object Storage Service (OSS)
- wal-e (obsolete) - Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.
- wal-g - 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.
- pitrery - pitrery is a set of Bash scripts to manage Point In Time Recovery (PITR) backups for PostgreSQL.
- pgbackup-sidecar -
pgbackup-sidecar is a lightweight Docker sidecar container designed to automate regular backups of a PostgreSQL database using pg_dump, cron, and bash scripts while also sending output to a webhook.
- pg-backups-to-s3 - Docker-first solution on top of pg_dump with support for environment-based configuration for scheduled PostgreSQL backups with optional compression, GPG encryption, webhooks, automatic upload to Amazon S3.
GUI
- 1bench - Native cross-platform GUI with first-class Postgres support alongside Redis, Elasticsearch, ClickHouse, Qdrant, and more (Commercial Software).
- Adminer - Full-featured database management tool written in PHP.
- AI for Database - Chat with your PostgreSQL database in natural language. No SQL needed — get instant insights, build self-refreshing dashboards, and trigger automated workflows based on database changes. (Commercial Software).
- Beekeeper Studio - Free and open source SQL client with a modern UI and great Postgres support. Cross platform.
- Bytebase - Database DevSecOps solution for Developer, Security, DBA, and Platform Engineering teams.
- Chartbrew - Create live dashboards, charts, and client reports from PostgreSQL data. Features a query tool that works with SQL.
- Count - Web-based analytics platform with a notebook interface which connects to PostgreSQL (Commercial Software).
- DataGrip - IDE with advanced tool sets and good cross-platform experience (Commercial Software).
- Dekart - Open-source platform to turn PostGIS queries into shareable interactive maps.
- Datazenit - Web-based PostgreSQL GUI (Commercial Software).
- DataRow - Cross-platform SQL Client for Amazon Redshift: Simple, Effortless, Extensible.
- DBConvert Streams - Database IDE with migration, federated SQL, and CDC replication for PostgreSQL, MySQL, files, and S3-compatible storage. (Commercial Software).
- DBeaver - Universal Database Manager with excellent support for PostgreSQL.
- dbForge Edge - All-in-one multidatabase solution supporting PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and a wide range of related cloud services (Commercial Software).
- DbVisualizer - Cross-platform database client for developers, DBAs, and analysts (Commercial Software).
- Holistics - Online cross platform database management tool and SQL query reporting GUI with strong PostgreSQL support (Commercial Software).
- JackDB - Web-based SQL query interface (Commercial Software).
- Luna Modeler - Cross-platform desktop data modeling tool (Commercial Software).
- Mathesar - Web application providing an intuitive user experience to databases.
- Metabase - Simple dashboards, charts and query tool for PostgreSQL.
- Numeracy - Fast SQL editor with charts and dashboards for PostgreSQL (Commercial Software).
- OrcaQ - A modern, open-source database editor for PostgreSQL, MySQL, Redis, and more. Features an AI assistant, ERD visualizer, schema diff, and visual role management.
- pgAdmin - PostgreSQL Administration and Management GUI.
- pgMagic🪄 - Chat to Postgres in Natural Language (Commercial Software).
- PgManage - A modern multi-platform Postgres-centric database client/administration tool.
- pgModeler - pgModeler is an open-source PostgreSQL Database Modeler.
- PgStudio - Open-source VS Code / Open VSX extension for PostgreSQL management with SQL notebooks, AI assistant, Easy to use code snippets and Full-fledged DBMS with real-time monitoring dashboard.
- pgweb - Web-based PostgreSQL database browser written in Go.
- phpPgAdmin - The Premier Web Based Administration Tool for PostgreSQL.
- Postbird - PostgreSQL Client for macOS.
- PostgresCompare - Cross-platform database comparison and deployment tool (Commercial Software).
- Postico - Modern PostgreSQL Client for macOS (Commercial Software).
- QueryGlow - Self-hosted, web-based database GUI with AI SQL generation, EXPLAIN visualizer, and schema-aware autocomplete (Commercial Software).
- PSequel - Clean and simple interface to perform common PostgreSQL tasks quickly (Commercial Software).
- Redash - Connect to any data source, easily visualize and share your data.
- SQL Tabs - Cross Platform Desktop Client for PostgreSQL written in JS.
- SQLPro for Postgres - Simple, powerful PostgreSQL manager for macOS (Commercial Software).
- temBoard - Web-based PostgreSQL GUI and monitoring.
- Teable - A Super fast, Real-time, Professional, Developer friendly, No code database.
- TablePlus - Native App which let you edit database and structure. High-end security ensured (Commercial Software).
- TablePro - Native macOS PostgreSQL client with explain visualization, ER diagrams, and AI assistant. Free, open-source.
- Valentina Studio - Cross-platform database administration tool (Free/Commercial)
- DbGate - The Smartest (no)SQL Database Client
- WebDB – Efficient Database IDE.
Distributions
- Postgres.app - The Easiest Way to Get Started with PostgreSQL on macOS.
- Pigsty - Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers.
CLI
- atlas - Atlas is a tool for managing and migrating database schemas using modern DevOps principles.
- pgcli - Postgres CLI with autocompletion and syntax highlighting
- pgfence - Lints Postgres SQL migrations for lock modes and risky DDL, with safe expand/contract rewrites. CLI plus LSP. Extractors for Prisma, TypeORM, and Knex.
- pgxcli - Postgres CLI with autocompletion and syntax highlighting written in Go.
- pgplan - compare and analyze PostgreSQL EXPLAIN plans from the CLI
- pgschema - Terraform-style declarative schema migration for Postgres
- pg-schema-diff - CLI (and Golang library) for diffing Postgres schemas and generating SQL migrations with minimal locking.
- MigrationPilot - PostgreSQL migration safety CLI that catches dangerous DDL before production — 80 rules, lock classification, auto-fix, GitHub Action.
- pgsh - Branch your PostgreSQL Database like Git
- psql - The built-in PostgreSQL CLI client
- psql2csv - Run a query in psql and output the result as CSV
- sabiql - A fast, driver-less TUI to browse, query, and edit PostgreSQL databases.
- schemaspy - SchemaSpy is a JAVA JDBC-compliant tool for generating your database to HTML documentation, including Entity Relationship diagrams
- pdot - Visualize and explore database structures in your shell, from high-context views of the foreign key graph to trigger cascades, role inheritance and permissions, and many more
- squix - SQL command-line client with query management and interactive results.
Server
- AgensGraph - Powerful graph database based on the PostgreSQL.
- Apache Cloudberry - And MPP PostgreSQL fork. Open source alternative to Greenplum Database.
- FerretDB - A truly Open Source MongoDB alternative on top of PostgreSQL.
- Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster.
- YugabyteDB - Open Source Distributed SQL using a fork of PostgreSQL on top of distributed storage and transaction
Security
- Acra - SQL database security suite: proxy for data protection with transparent "on the fly" data encryption, SQL firewall (SQL injections prevention), intrusion detection system.
- pgrls - static analyzer for row-level security policies; 36 rules across security, performance, and hygiene with 10 mechanically auto-fixable; includes a semantic policy-diff command for CI gating.
Monitoring
- check_pgactivity - check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.
- Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases.
- coroot - Coroot is an open-source APM & Observability tool, a DataDog and NewRelic alternative. Powered by eBPF for rapid insights into system performance.
- Datadog - SaaS monitoring that collects and visualizes metrics, queries, and explain plans, and sends alerts when problems are encountered (Commercial Software).
- Instrumental - Real-time performance monitoring, including pre-made graphs for ease of setup (Commercial Software)
- libzbxpgsql - Comprehensive PostgreSQL monitoring module for Zabbix.
- myDBA - PostgreSQL performance monitoring with 75+ automated health checks, cluster-aware index advisor, query analysis, and extension monitoring for TimescaleDB, pgvector, and PostGIS (Commercial Software).
- PMM - Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.
- Pome - Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.
- 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.
- pg_view - Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.
- pgwatch2 - Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards.
- pgwd - monitors PostgreSQL connection usage and stale sessions, with threshold alerts, Prometheus metrics, and multiple notification backends.
- pgbench - Run a benchmark test on PostgreSQL.
- 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.
- 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).
- dexter - The automatic indexer for Postgres. Detects slow queries and creates indexes if configured to do so.
- pg_ash - Active Session History for PostgreSQL. Samples pg_stat_activity once per second via pg_cron, stores encoded snapshots, and provides 32 SQL functions for wait event analysis. Pure SQL, no extensions, works on managed providers (RDS, Cloud SQL, Supabase, etc.).
- pg_exporter - Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer with fine-grained execution control.
- postgres_exporter - Prometheus exporter for PostgreSQL server metrics.
- StatsMgr - An open-source PostgreSQL extension designed for efficient and organized advanced statistics management.
- pgvitals - collection of 40 read-only diagnostic queries for spotting common performance problems (slow queries, bloat, vacuum lag, lock contention, replication lag, wraparound risk) using only
这是一个精心整理的 PostgreSQL 软件、库、工具和资源索引，仿照 awesome-mysql 的模式。它把整个生态汇集在一处：备份工具、图形界面客户端、高可用集群、监控、教程等等。