[[
wikihub
]]
Search
⌘K
Explore
People
For Agents
Sign in
Explore
People
For Agents
Sign in
@harrisonqian / Awesome / wiki/databases/postgresql.md
Suggest edit
Cancel
Submit suggestion
Title
Name
Note
--- visibility: public --- # PostgreSQL **repo:** [dhamaniasad/awesome-postgres](https://github.com/dhamaniasad/awesome-postgres) **category:** [[databases|Databases]] **related:** [[sqlalchemy|SQLAlchemy]] · [[mysql|Mysql]] · [[mongodb|Mongodb]] · [[cassandra|Cassandra]] --- # Awesome Postgres [](https://github.com/sindresorhus/awesome) [<img src="https://wiki.postgresql.org/images/a/a4/PostgreSQL_logo.3colors.svg" align="right" width="100">](https://www.postgresql.org/) > A curated list of awesome [PostgreSQL](https://www.postgresql.org/) software, libraries, tools and resources, inspired by [awesome-mysql](http://shlomi-noach.github.io/awesome-mysql/) [PostgreSQL](https://en.wikipedia.org/wiki/PostgreSQL), often simply Postgres, is an [object-relational database](https://en.wikipedia.org/wiki/Object-relational_database) (ORDBMS). PostgreSQL is [ACID-compliant](https://en.wikipedia.org/wiki/ACID) and [transactional](https://en.wikipedia.org/wiki/Transaction_processing). (see more: [wikipedia:PostgreSQL](https://en.wikipedia.org/wiki/PostgreSQL), [PostgreSQL.org](https://www.postgresql.org)) :elephant: Contributions welcome. Add links through [pull requests](https://github.com/dhamaniasad/awesome-postgres/pulls) or create an [issue](https://github.com/dhamaniasad/awesome-postgres/issues) to start a discussion. Please take a look at the [contribution guidelines](CONTRIBUTING.md). ## Contents - [Awesome Postgres](#[awesome](/@harrisonqian/awesome/wiki/miscellaneous/awesome)-postgres-) - [High-Availability](#high-availability) - [Backups](#backups) - [GUI](#gui) - [Distributions](#distributions) - [CLI](#cli) - [Server](#server) - [Monitoring](#monitoring) - [Extensions](#extensions) - [Platforms](#platforms) - [Work Queues](#work-queues) - [Optimization](#optimization) - [Utilities](#utilities) - [Language bindings](#language-bindings) - [PaaS (PostgreSQL as a Service)](#paas-postgresql-as-a-service) - [Docker images](#[docker](/@harrisonqian/awesome/wiki/back-end-development/docker)-images) - [Kubernetes](#kubernetes) - [Resources](#resources) - [Tutorials](#tutorials) - [Blogs](#blogs) - [Documentation](#documentation) - [Newsletters](#newsletters) - [Videos](#videos) - [Community](#community) - [Roadmaps](#roadmaps) - [External lists](#external-lists) ### High-Availability * [autobase](https://github.com/vitabaks/autobase) - Autobase for PostgreSQL® is an open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters. * [BDR](https://github.com/2ndQuadrant/bdr) - BiDirectional Replication - a multimaster replication system for PostgreSQL * [Patroni](https://github.com/zalando/patroni) - Template for PostgreSQL HA with ZooKeeper or etcd. * [Spock](https://github.com/pgEdge/spock) - 100% open-source logical multi-master PostgreSQL replication. * [Stolon](https://github.com/sorintlab/stolon) - PostgreSQL HA based on Consul or etcd, with [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) [integration](/@harrisonqian/awesome/wiki/platforms/integration). * [pglookout](https://github.com/aiven/pglookout) - Replication monitoring and failover daemon. * [repmgr](https://github.com/2ndQuadrant/repmgr) - Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers. * [Slony-I](https://slony.info/) - "Master to multiple slaves" replication system with cascading and failover. * [PAF](https://github.com/ClusterLabs/PAF) - PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync. * [SkyTools](https://github.com/pgq/skytools-legacy) - Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony. * [pg_auto_failover](https://github.com/citusdata/pg_auto_failover) - Postgres extension and service for automated failover and high-availability. * [pgrwl](https://github.com/hashmap-kz/pgrwl) - Stream write-ahead logs (WAL) from a PostgreSQL server in real time. A drop-in, container-friendly alternative to pg_receivewal. * [pg-status](https://github.com/krylosov-aa/pg-status) - A microservice that provides HTTP endpoints for instantly retrieving the current master host or a replica that meets various criteria. ### Backups * [Barman](https://www.pgbarman.org/index.html) - Backup and Recovery Manager for PostgreSQL by 2ndQuadrant. * [Databasus](https://databasus.com) - tool for scheduled PostgreSQL backups via web UI with external storages (local, S3, FTP, Google Drive, etc.), notifications (webhook, Discord, [Slack](/@harrisonqian/awesome/wiki/work/slack), etc.) and team management. * [OmniPITR](https://github.com/omniti-labs/omnipitr) - Advanced WAL File Management Tools for PostgreSQL. * [pg\_probackup](https://github.com/postgrespro/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](https://pgbackrest.org/) - Reliable PostgreSQL Backup & Restore. * [pgbackweb](https://github.com/eduardolat/pgbackweb) - A Complete [Docker](/@harrisonqian/awesome/wiki/back-end-development/docker)-based Postgres backup and maintenance tool with Web UI. * [pg\_back](https://github.com/orgrim/pg_back/) - pg\_back is a simple backup script * [pghoard](https://github.com/aiven/pghoard) - Backup and restore tool for cloud object stores (AWS S3, Azure, [Google Cloud](/@harrisonqian/awesome/wiki/platforms/google-cloud), OpenStack Swift). * [postgres-backup-oss](https://github.com/isaced/postgres-backup-oss) - A handy [Docker](/@harrisonqian/awesome/wiki/back-end-development/docker) container to periodically backup PostgreSQL to Alibaba Cloud Object Storage Service (OSS) * [wal-e](https://github.com/wal-e/wal-e) (obsolete) - Simple Continuous Archiving for PostgreSQL to S3, Azure, or [Swift](/@harrisonqian/awesome/wiki/programming-languages/swift) by [Heroku](/@harrisonqian/awesome/wiki/platforms/heroku). * [wal-g](https://github.com/wal-g/wal-g) - The successor of WAL-E rewritten in Go. Currently supports cloud object storage services by AWS (S3), [Google Cloud](/@harrisonqian/awesome/wiki/platforms/google-cloud) (GCS), Azure, as well as OpenStack [Swift](/@harrisonqian/awesome/wiki/programming-languages/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](/@harrisonqian/awesome/wiki/databases/mysql) and [MongoDB](/@harrisonqian/awesome/wiki/databases/mongodb) databases. * [pitrery](https://dalibo.[github](/@harrisonqian/awesome/wiki/development-environment/github).io/pitrery/) - pitrery is a set of Bash scripts to manage Point In Time Recovery (PITR) backups for PostgreSQL. * [pgbackup-sidecar](https://github.com/Musab520/pgbackup-sidecar) - `pgbackup-sidecar` is a lightweight [Docker](/@harrisonqian/awesome/wiki/back-end-development/docker) sidecar container designed to automate regular backups of a PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) using `pg_dump`, `cron`, and bash scripts while also sending output to a webhook. * [pg-backups-to-s3](https://github.com/Saicheg/pg-backups-to-s3) - [Docker](/@harrisonqian/awesome/wiki/back-end-development/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 * [Adminer](https://www.adminer.org/) - Full-featured [database](/@harrisonqian/awesome/wiki/databases/database) management tool written in PHP. * [Beekeeper Studio](https://www.beekeeperstudio.io) - Free and open source SQL client with a modern UI and great Postgres support. Cross platform. * [Bytebase](https://www.bytebase.com) - [Database](/@harrisonqian/awesome/wiki/databases/database) [DevSecOps](/@harrisonqian/awesome/wiki/security/devsecops) solution for Developer, [Security](/@harrisonqian/awesome/wiki/security/security), DBA, and Platform Engineering teams. * [Chartbrew](https://chartbrew.com) - Create live dashboards, charts, and client reports from PostgreSQL data. Features a query tool that works with SQL. * [Count](https://count.co/) - Web-based [analytics](/@harrisonqian/awesome/wiki/miscellaneous/analytics) platform with a notebook interface which connects to PostgreSQL (Commercial Software). * [DataGrip](https://www.jetbrains.com/datagrip/) - IDE with advanced tool sets and good [cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) experience (Commercial Software). * [Datazenit](https://datazenit.com/) - Web-based PostgreSQL GUI (Commercial Software). * [DataRow](https://www.datarow.com/) - [Cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) SQL Client for Amazon Redshift: Simple, Effortless, Extensible. * [DBConvert Streams](https://streams.dbconvert.com/) - A cloud-native platform for real-time data migration and CDC replication between PostgreSQL and [MySQL](/@harrisonqian/awesome/wiki/databases/mysql) databases across various cloud environments. (Commercial Software). * [DBeaver](https://dbeaver.io/) - Universal [Database](/@harrisonqian/awesome/wiki/databases/database) Manager with excellent support for PostgreSQL. * [dbForge Edge](https://www.devart.com/dbforge/edge/) - All-in-one multidatabase solution supporting PostgreSQL, [MySQL](/@harrisonqian/awesome/wiki/databases/mysql), MariaDB, SQL Server, Oracle, and a wide range of related cloud services (Commercial Software). * [DbVisualizer](http://www.dbvis.com) - [Cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) [database](/@harrisonqian/awesome/wiki/databases/database) client for developers, DBAs, and analysts (Commercial Software). * [Holistics](https://www.holistics.io/) - Online cross platform [database](/@harrisonqian/awesome/wiki/databases/database) management tool and SQL query reporting GUI with strong PostgreSQL support (Commercial Software). * [JackDB](https://www.jackdb.com/) - Web-based SQL query interface (Commercial Software). * [Luna Modeler](http://www.datensen.com) - [Cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) desktop data modeling tool (Commercial Software). * [Mathesar](https://mathesar.org/) - Web application providing an intuitive user experience to databases. * [Metabase](https://www.metabase.com/) - Simple dashboards, charts and query tool for PostgreSQL. * [Numeracy](https://numeracy.co/) - Fast SQL editor with charts and dashboards for PostgreSQL (Commercial Software). * [pgAdmin](https://www.pgadmin.org/) - PostgreSQL Administration and Management GUI. * [pgMagic🪄](https://pgmagic.app/?ref=awesomepostgres) - Chat to Postgres in Natural Language (Commercial Software). * [PgManage](https://github.com/commandprompt/pgmanage) - A modern multi-platform Postgres-centric [database](/@harrisonqian/awesome/wiki/databases/database) client/administration tool. * [pgModeler](https://pgmodeler.io/) - pgModeler is an open-source PostgreSQL [Database](/@harrisonqian/awesome/wiki/databases/database) Modeler. * [pgweb](https://github.com/sosedoff/pgweb) - Web-based PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) browser written in Go. * [phpPgAdmin](https://github.com/phppgadmin/phppgadmin) - The Premier Web Based Administration Tool for PostgreSQL. * [Postbird](https://github.com/Paxa/postbird) - PostgreSQL Client for macOS. * [PostgresCompare](https://www.postgrescompare.com) - [Cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) [database](/@harrisonqian/awesome/wiki/databases/database) comparison and deployment tool (Commercial Software). * [Postico](https://eggerapps.at/postico/) - Modern PostgreSQL Client for macOS (Commercial Software). * [PSequel](http://www.psequel.com/) - Clean and simple interface to perform common PostgreSQL tasks quickly (Commercial Software). * [Redash](https://github.com/getredash/redash) - Connect to any data source, easily visualize and share your data. * [SQL Tabs](http://www.sqltabs.com/) - Cross Platform Desktop Client for PostgreSQL written in JS. * [SQLPro for Postgres](http://macpostgresclient.com/) - Simple, powerful PostgreSQL manager for macOS (Commercial Software). * [temBoard](https://github.com/dalibo/temboard) - Web-based PostgreSQL GUI and monitoring. * [Teable](https://github.com/teableio/teable) - A Super fast, Real-time, Professional, Developer friendly, No code [database](/@harrisonqian/awesome/wiki/databases/database). * [TablePlus](https://tableplus.com/) - Native App which let you edit [database](/@harrisonqian/awesome/wiki/databases/database) and structure. High-end [security](/@harrisonqian/awesome/wiki/security/security) ensured (Commercial Software). * [Valentina Studio](https://www.valentina-db.com/en/valentina-studio-overview) - [Cross-platform](/@harrisonqian/awesome/wiki/platforms/cross-platform) [database](/@harrisonqian/awesome/wiki/databases/database) administration tool (Free/Commercial) * [DbGate](https://dbgate.org) - The Smartest (no)SQL [Database](/@harrisonqian/awesome/wiki/databases/database) Client * [WebDB](https://webdb.app) – Efficient [Database](/@harrisonqian/awesome/wiki/databases/database) IDE. ### Distributions * [Postgres.app](https://postgresapp.com/) - The Easiest Way to Get Started with PostgreSQL on macOS. * [Pigsty](https://github.com/Vonng/pigsty) - Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & [Database](/@harrisonqian/awesome/wiki/databases/database)-as-Code toolbox for developers. ### CLI * [atlas](https://github.com/ariga/atlas) - Atlas is a tool for managing and migrating [database](/@harrisonqian/awesome/wiki/databases/database) schemas using modern DevOps principles. * [pgcli](https://github.com/dbcli/pgcli) - Postgres CLI with autocompletion and syntax highlighting * [pgplan](https://github.com/JacobArthurs/pgplan) - compare and analyze PostgreSQL EXPLAIN plans from the CLI * [pgschema](https://www.pgschema.com) - [Terraform](/@harrisonqian/awesome/wiki/back-end-development/terraform)-style declarative schema migration for Postgres * [pg-schema-diff](https://github.com/stripe/pg-schema-diff) - CLI (and Golang library) for diffing Postgres schemas and generating SQL migrations with minimal locking. * [MigrationPilot](https://github.com/mickelsamuel/migrationpilot) - PostgreSQL migration safety CLI that catches dangerous DDL before production — 80 rules, lock classification, auto-fix, [GitHub](/@harrisonqian/awesome/wiki/development-environment/github) Action. * [pgsh](https://github.com/sastraxi/pgsh) - Branch your PostgreSQL [Database](/@harrisonqian/awesome/wiki/databases/database) like Git * [psql](https://www.postgresql.org/docs/current/static/app-psql.html) - The built-in PostgreSQL CLI client * [psql2csv](https://github.com/fphilipe/psql2csv) - Run a query in psql and output the result as CSV * [sabiql](https://github.com/riii111/sabiql) - A fast, driver-[less](/@harrisonqian/awesome/wiki/front-end-development/less) TUI to browse, query, and edit PostgreSQL databases. * [schemaspy](https://github.com/schemaspy/schemaspy) - SchemaSpy is a [JAVA](/@harrisonqian/awesome/wiki/programming-languages/java) JDBC-compliant tool for generating your [database](/@harrisonqian/awesome/wiki/databases/database) to HTML documentation, including Entity Relationship diagrams * [pdot](https://gitlab.com/dmfay/pdot) - Visualize and explore [database](/@harrisonqian/awesome/wiki/databases/database) structures in your [shell](/@harrisonqian/awesome/wiki/development-environment/shell), from high-context views of the foreign key graph to trigger cascades, role inheritance and permissions, and many more ### Server * [AgensGraph](https://bitnine.net/) - Powerful graph [database](/@harrisonqian/awesome/wiki/databases/database) based on the PostgreSQL. * [Apache Cloudberry](https://github.com/apache/cloudberry) - And MPP PostgreSQL fork. Open source alternative to Greenplum [Database](/@harrisonqian/awesome/wiki/databases/database). * [FerretDB](https://www.ferretdb.io) - A truly Open Source [MongoDB](/@harrisonqian/awesome/wiki/databases/mongodb) alternative on top of PostgreSQL. * [Postgres-XL](https://www.postgres-xl.org/) - Scalable Open Source PostgreSQL-based [Database](/@harrisonqian/awesome/wiki/databases/database) Cluster. * [YugabyteDB](https://yugabyte.com/) - Open Source Distributed SQL using a fork of PostgreSQL on top of distributed storage and transaction ### Security * [Acra](https://github.com/cossacklabs/acra) - SQL [database](/@harrisonqian/awesome/wiki/databases/database) [security](/@harrisonqian/awesome/wiki/security/security) suite: proxy for data protection with transparent "on the fly" data encryption, SQL firewall (SQL injections prevention), intrusion detection system. ### Monitoring * [check\_pgactivity](https://github.com/OPMDG/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](https://github.com/bucardo/check_postgres) - Nagios check\_postgres plugin for checking status of PostgreSQL databases. * [coroot](https://github.com/coroot/coroot) - Coroot is an open-source APM & Observability tool, a DataDog and NewRelic alternative. Powered by [eBPF](/@harrisonqian/awesome/wiki/platforms/ebpf) for rapid insights into system performance. * [Datadog](https://www.datadoghq.com/product/database-monitoring/) - SaaS monitoring that collects and visualizes metrics, queries, and explain plans, and sends alerts when problems are encountered (Commercial Software). * [Instrumental](https://github.com/Instrumental/instrumentald) - Real-time performance monitoring, including [pre-made graphs](https://instrumentalapp.com/docs/instrumentald/postgresql#suggested-graphs) for ease of setup (Commercial Software) * [libzbxpgsql](https://github.com/cavaliercoder/libzbxpgsql) - Comprehensive PostgreSQL monitoring module for Zabbix. * [myDBA](https://mydba.dev) - 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](https://github.com/percona/pmm) - Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, [MySQL](/@harrisonqian/awesome/wiki/databases/mysql), and [MongoDB](/@harrisonqian/awesome/wiki/databases/mongodb). * [Pome](https://github.com/rach/pome) - Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your [database](/@harrisonqian/awesome/wiki/databases/database). * [pgmetrics](https://pgmetrics.io/) - 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](/@harrisonqian/awesome/wiki/miscellaneous/json) and CSV for scripting. * [pg\_view](https://github.com/zalando/pg_view) - Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information. * [pgwatch2](https://github.com/cybertec-postgresql/pgwatch2) - Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards. * [pgbench](https://www.postgresql.org/docs/devel/static/pgbench.html) - Run a benchmark test on PostgreSQL. * [opm.io](http://opm.io) - Open PostgreSQL Monitoring is a [free software](/@harrisonqian/awesome/wiki/miscellaneous/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](https://okmeter.io/pg) - 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](https://github.com/ankane/dexter) - The automatic indexer for Postgres. Detects slow queries and creates indexes if configured to do so. * [pg_ash](https://github.com/NikolayS/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](/@harrisonqian/awesome/wiki/databases/supabase), etc.). * [pg_exporter](https://github.com/Vonng/pg_exporter) - Fully customizable [Prometheus](/@harrisonqian/awesome/wiki/miscellaneous/prometheus) exporter for PostgreSQL & Pgbouncer with fine-grained execution control. * [postgres_exporter](https://github.com/wrouesnel/postgres_exporter) - [Prometheus](/@harrisonqian/awesome/wiki/miscellaneous/prometheus) exporter for PostgreSQL server metrics. * [StatsMgr](https://codeberg.org/data-bene/statsmgr) - An open-source PostgreSQL extension designed for efficient and organized advanced statistics management. ### Extensions * [pgxn](https://pgxn.org/) PostgreSQL Extension Network - central distribution point for many open-source PostgreSQL extensions. * [Extensions listing by joelonsql](https://gist.[github](/@harrisonqian/awesome/wiki/development-environment/github).com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47) - 1000+ PostgreSQL extensions. * [Pigsty extensions catalogue](https://ext.pigsty.io/list/) - 400+ PostgreSQL extensions. * [AGE](https://github.com/apache/age) - Adds fully-functional graph [database](/@harrisonqian/awesome/wiki/databases/database) support including Cypher queries. * [OrioleDB](https://www.orioledb.com/) - The cloud-native storage engine for PostgreSQL. OrioleDB is a PostgreSQL extension that combines the advantages of both on-disk and in-memory engines. * [Citus](https://github.com/citusdata/citus) - Scalable PostgreSQL cluster for real-time workloads. * [cstore\_fdw](https://github.com/citusdata/cstore_fdw) - Columnar store for [analytics](/@harrisonqian/awesome/wiki/miscellaneous/analytics) with PostgreSQL. * [cyanaudit](https://pgxn.org/dist/cyanaudit/) - Cyan Audit provides in-[database](/@harrisonqian/awesome/wiki/databases/database) logging of all DML activity on a column-by-column basis. * [pg_search](https://github.com/paradedb/paradedb) - pg_search is a PostgreSQL extension that enables full-text search over SQL tables using the BM25 algorithm, the state-of-the-art ranking function for full-text search. * [pg_cron](https://github.com/citusdata/pg_cron) - Run periodic jobs in PostgreSQL. * [pglogical](https://github.com/2ndQuadrant/pglogical) - Extension that provides logical [streaming](/@harrisonqian/awesome/wiki/big-data/streaming) replication. * [pgcat](https://github.com/kingluo/pgcat) - Enhanced PostgreSQL logical replication * [pg\_barcode](https://github.com/btouchard/pg_barcode/) - PostgreSQL SVG QRcode & Datamatrix generator. * [pg\_partman](https://github.com/pgpartman/pg_partman) - Partition management extension for PostgreSQL. * [pg\_paxos](https://github.com/citusdata/pg_paxos/) - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes. * [pg\_shard](https://github.com/citusdata/pg_shard) - Extension to scale out real-time reads and writes. * [pg\_stat\_monitor](https://github.com/percona/pg_stat_monitor) - Query Performance Monitoring tool for PostgreSQL. * [pg\_squeeze](https://github.com/cybertec-postgresql/pg_squeeze) - An extension for automatic bloat cleanup with minimal locking. * [PGStrom](https://wiki.postgresql.org/wiki/PGStrom) - Extension to offload CPU intensive workloads to GPU. * [PipelineDB](https://www.confluent.io/blog/pipelinedb-team-joins-confluent/) - A PostgreSQL extension that runs SQL queries continuously on streams, incrementally storing results in tables. * [plpgsql\_check](https://github.com/okbob/plpgsql_check) - Extension that allows to check plpgsql source code. * [PostGIS](http://postgis.net/) - Spatial and Geographic objects for PostgreSQL. * [PG\_Themis](https://github.com/cossacklabs/pg_themis) - Postgres binding as extension for crypto library Themis, providing various [security](/@harrisonqian/awesome/wiki/security/security) services on PgSQL's side. * [zomboDB](https://github.com/zombodb/zombodb) - Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch. * [pgMemento](https://github.com/pgMemento/pgMemento) - Provides an audit trail for your data inside a PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) using triggers and server-side functions written in PL/pgSQL. * [TimescaleDB](https://www.timescale.com/) - Open-source time-series [database](/@harrisonqian/awesome/wiki/databases/database) fully compatible with Postgres, distributed as extension * [pgTAP](https://pgtap.org/) - [Database](/@harrisonqian/awesome/wiki/databases/database) [testing](/@harrisonqian/awesome/wiki/testing/testing) framework for Postgres * [HypoPG](https://github.com/HypoPG/hypopg) - HypoPG provides hypothetical/virtual indexes feature. * [pgRouting](https://github.com/pgRouting/pgrouting) - pgRouting extends the PostGIS/PostgreSQL geospatial [database](/@harrisonqian/awesome/wiki/databases/database) to provide geospatial routing and other [network analysis](/@harrisonqian/awesome/wiki/big-data/network-analysis) functionality. * [PGroonga](https://pgroonga.[github](/@harrisonqian/awesome/wiki/development-environment/github).io/) - PGroonga provides a new index access method that uses Groonga allowing super fast full text search feature against all languages. * [PGAudit](https://www.pgaudit.org/) - The PostgreSQL Audit Extension (or pgaudit) provides detailed session and/or object audit logging via the standard logging facility provided by PostgreSQL. * [PostgresML](https://postgresml.org/) - [Machine learning](/@harrisonqian/awesome/wiki/computer-science/machine-learning) and AI inside your [database](/@harrisonqian/awesome/wiki/databases/database), including vectors, LLMs, and classic ML. Train, predict and manage the entire lifecycle of machine [learning](/@harrisonqian/awesome/wiki/programming-languages/learning) models using only SQL. * [ParadeDB](https://github.com/paradedb/paradedb) - Postgres for Search and [Analytics](/@harrisonqian/awesome/wiki/miscellaneous/analytics) * [PostgreSQL Anonymizer](https://postgresql-anonymizer.readthedocs.io/en/stable/) - An extension to mask or replace personally identifiable information (PII) or commercially sensitive data from a Postgres [database](/@harrisonqian/awesome/wiki/databases/database), through PG [Security](/@harrisonqian/awesome/wiki/security/security) Labels. ### Platforms * [Atlas4D](https://github.com/crisbez/atlas4d-base) - Open-source 4D spatiotemporal platform combining PostGIS, TimescaleDB, pgvector, and H3 for unified geospatial and time-series intelligence. ### Work Queues * [BeanQueue](https://github.com/LaunchPlatform/bq) - A [Python](/@harrisonqian/awesome/wiki/programming-languages/python) work queue framework based on SKIP LOCKED, LISTEN and NOTIFY * [pgmq](https://github.com/pgmq/pgmq) - A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. * [river](https://github.com/riverqueue/river) - A high-performance job processing system for Go and Postgres. * [pgBoss](https://github.com/timgit/pg-boss) - Queueing jobs in Postgres from [Node.js](/@harrisonqian/awesome/wiki/platforms/node-js) like a boss. * [dbos](https://www.dbos.dev/) - Durable workflows in Typescript and [Python](/@harrisonqian/awesome/wiki/programming-languages/python) * [Graphile Worker](https://worker.graphile.org) - A high performance job queue for PostgreSQL, written in [Node.js](/@harrisonqian/awesome/wiki/platforms/node-js) * [@andyrmitchell/pg-queue](https://www.npmjs.com/package/@andyrmitchell/pg-queue) - The 'No Maintenance' Postgres Queue for [Node.js](/@harrisonqian/awesome/wiki/platforms/node-js) ### Optimization * [EverSQL](https://www.eversql.com/) - Automated query optimization tool, monitoring and analysis tool, indexing recommendation tool. (Commercial Software) * [PEV2](https://github.com/dalibo/pev2) - Online Postgres Explain Visualizer. * [pg_flame](https://github.com/mgartner/pg_flame) - A flamegraph generator for query plans. * [PgHero](https://github.com/ankane/pghero) - PostgreSQL insights made easy. * [pgMustard](https://www.pgmustard.com/) - A modern user interface for `EXPLAIN`, that also provides performance tips (Commercial Software). * [pgtune](https://github.com/gregs1104/pgtune/) - PostgreSQL configuration wizard. * [pgtune](https://github.com/le0pard/pgtune) - Online version of PostgreSQL configuration wizard. * [pgconfig.org](https://github.com/sebastianwebber/pgconfig) - PostgreSQL Online Configuration Tool (also based on pgtune). * [PoWA](https://powa.readthedocs.io/en/latest/) - PostgreSQL Workload Analyzer gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers. * [pg_web_stats](https://github.com/kirs/pg_web_stats) - Web UI to view pg_stat_statements. * [TimescaleDB Tune](https://github.com/timescale/timescaledb-tune) - a program for tuning a TimescaleDB [database](/@harrisonqian/awesome/wiki/databases/database) to perform its best based on the host's resources such as memory and number of CPUs. * [Metis](https://www.metisdata.io/product/troubleshooting) - Metis provides observability and performance tuning for SQL databases including PostgreSQL. (Commercial Software) * [aqo](https://github.com/postgrespro/aqo) - Adaptive query optimization for PostgreSQL. * [pgassistant](https://github.com/beh74/pgassistant-community) - A PostgreSQL tool for developers to help understand, optimize [database](/@harrisonqian/awesome/wiki/databases/database) with LLM and pgTune [integration](/@harrisonqian/awesome/wiki/platforms/integration). ### Utilities * [apgdiff](https://www.apgdiff.com/) - Compares two [database](/@harrisonqian/awesome/wiki/databases/database) dump files and creates output with DDL statements that can be used to update old [database](/@harrisonqian/awesome/wiki/databases/database) schema to new one. * [bemi](https://github.com/BemiHQ/bemi) - Automatic data change tracking for PostgreSQL * [ERAlchemy](https://github.com/Alexis-benoist/eralchemy) - ERAlchemy generates Entity Relation (ER) diagram from databases. * [flyway](https://flywaydb.org/) - Schema migration tool for Postgres and others. * [GatewayD](https://github.com/gatewayd-io/gatewayd) - Cloud-native [database](/@harrisonqian/awesome/wiki/databases/database) gateway and framework for building data-driven applications. Like API gateways, for databases. * [Hasura [GraphQL](/@harrisonqian/awesome/wiki/miscellaneous/graphql) Engine](https://github.com/hasura/graphql-engine) - Blazing fast, instant realtime [GraphQL](/@harrisonqian/awesome/wiki/miscellaneous/graphql) APIs on Postgres with fine grained access control, also trigger webhooks on [database](/@harrisonqian/awesome/wiki/databases/database) events. * [ldap2pg](https://github.com/dalibo/ldap2pg) - Synchronize roles and privileges from YML and LDAP. * [migra](https://github.com/djrobstep/migra) - Like diff but for Postgres schemas. * [mysql-postgresql-converter](https://github.com/lanyrd/mysql-postgresql-converter) - Lanyrd's [MySQL](/@harrisonqian/awesome/wiki/databases/mysql) to PostgreSQL conversion script. * [NServiceBus.Transport.PostgreSql](https://github.com/Particular/NServiceBus.SqlServer) - The NServiceBus.Transport.PostgreSql library allows .NET developers to [use a PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) as a message broker](https://docs.particular.net/transports/postgresql). (Commerical Software) * [ora2pg](http://ora2pg.darold.net) - [Perl](/@harrisonqian/awesome/wiki/programming-languages/perl) module to export an Oracle [database](/@harrisonqian/awesome/wiki/databases/database) schema to a PostgreSQL compatible schema. * [pg\_activity](https://github.com/dalibo/pg_activity) - top like application for PostgreSQL server activity monitoring. * [pg-formatter](https://github.com/gajus/pg-formatter) - A PostgreSQL SQL syntax beautifier (Node.js). * [pg-safe-migrate](https://github.com/defnotwig/pg-safe-migrate) - Safety-first [Node.js](/@harrisonqian/awesome/wiki/platforms/node-js) migration engine with advisory locks, SHA-256 drift detection, and 10 built-in lint rules for PostgreSQL. * [pganalyze](https://pganalyze.com) - PostgreSQL Performance Monitoring (Commercial Software). * [pgbadger](https://github.com/darold/pgbadger) - Fast PostgreSQL Log Analyzer. * [PgBouncer](http://www.pgbouncer.org/) - Lightweight connection pooler for PostgreSQL. * [pgCenter](https://github.com/lesovsky/pgcenter) - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating [database](/@harrisonqian/awesome/wiki/databases/database) backends. * [pg_chameleon](https://github.com/the4thdoctor/pg_chameleon) - Real time replica from [MySQL](/@harrisonqian/awesome/wiki/databases/mysql) to PostgreSQL with optional type override migration and migration capabilities. * [pgclimb](https://github.com/lukasmartinelli/pgclimb) - Export data from PostgreSQL into different data formats. * [pg_docs_bot](https://github.com/mchristofides/pg_docs_bot/) - Browser extension to redirect PostgreSQL docs links to the current version. * [pgfutter](https://github.com/lukasmartinelli/pgfutter) - Import CSV and [JSON](/@harrisonqian/awesome/wiki/miscellaneous/json) into PostgreSQL the easy way. * [PGInsight](http://pginsight.io/) - CLI tool to easily dig deep inside your PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database). * [pg_insights](https://github.com/lob/pg_insights) - Convenient SQL for monitoring Postgres [database](/@harrisonqian/awesome/wiki/databases/database) health. * [pgloader](https://github.com/dimitri/pgloader) - Loads data into PostgreSQL using the COPY [streaming](/@harrisonqian/awesome/wiki/big-data/streaming) protocol, and does so with separate threads for reading and writing data. * [pgMonitor](https://github.com/CrunchyData/pgmonitor) - Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes). * [pgpool-II](https://www.pgpool.net/mediawiki/index.php/Main_Page) - Middleware that provides connection pooling, replication, load balancing and limiting exceeding connections. * [pgspot](https://github.com/timescale/pgspot) - Spot vulnerabilities in PostgreSQL extension scripts. * [pg-spot-operator](https://github.com/pg-spot-ops/pg-spot-operator) - A daemon to run stateful Postgres on cheap AWS Spot VMs * [pgsync](https://github.com/ankane/pgsync) - Tool to sync PostgreSQL data to your local machine. * [PGXN client](https://github.com/pgxn/pgxnclient) - Command line tool to interact with the PostgreSQL Extension Network * [postgresql-metrics](https://github.com/spotify/postgresql-metrics) - Tool that extracts and provides metrics for your PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database). * [PostgREST](https://github.com/PostgREST/postgrest) - Serves a fully RESTful API from any existing PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database). * [pREST](https://github.com/prest/prest) - Serve a RESTful API from any PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) (Golang) * [PostGraphile](https://github.com/graphile/postgraphile) - Instant [GraphQL](/@harrisonqian/awesome/wiki/miscellaneous/graphql) API or GraphQL schema for your PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) * [yoke](https://github.com/nanopack/yoke) - PostgreSQL high-availability cluster with auto-failover and automated cluster recovery. * [pglistend](https://github.com/kabirbaidhya/pglistend) - A lightweight PostgresSQL `LISTEN`/`NOTIFY` daemon built on top of `node-postgres`. * [ZSON](https://github.com/postgrespro/zson) - PostgreSQL extension for transparent JSONB compression * [pg_bulkload](http://ossc-db.[github](/@harrisonqian/awesome/wiki/development-environment/github).io/pg_bulkload/index.html) - It's a high speed data loading utility for PostgreSQL. * [pg_migrate](https://github.com/jwdeitch/pg_migrate) - Manage PostgreSQL codebases and make VCS simple. * [pg_timetable](https://github.com/cybertec-postgresql/pg_timetable) - Advanced job scheduler for PostgreSQL. * [sqitch](https://github.com/sqitchers/sqitch) - Tool for managing versioned schema deployment * [pgmigrate](https://github.com/yandex/pgmigrate) - CLI tool to evolve schema migrations, developed by Yandex. * [pgcmp](https://github.com/cbbrowne/pgcmp) - Tool to compare [database](/@harrisonqian/awesome/wiki/databases/database) schemas, with capability to accept some persistent differences * [pg-differ](https://github.com/multum/pg-differ) - Tool for easy initialization / updating of the structure of PostgreSQL tables, migration alternative (Node.js). * [sqlcheck](https://github.com/jarulraj/sqlcheck) - Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries. * [postgres-checkup](https://gitlab.com/postgres-ai/postgres-checkup) - a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres [database](/@harrisonqian/awesome/wiki/databases/database). * [Pyrseas](https://github.com/perseas/Pyrseas) - Postgres [database](/@harrisonqian/awesome/wiki/databases/database) schema versioning. * [ScaffoldHub.io](https://scaffoldhub.io) - Generate fullstack PostgreSQL [apps](/@harrisonqian/awesome/wiki/platforms/apps) with [Angular](/@harrisonqian/awesome/wiki/front-end-development/angular), Vue or [React](/@harrisonqian/awesome/wiki/front-end-development/react) (Commercial Software). * [planter](https://github.com/achiku/planter) - Generate PlantUML ER diagram textual description from PostgreSQL tables * [pgroll](https://github.com/xataio/pgroll) - Zero-downtime, reversible, schema migrations for Postgres * [RegreSQL](https://github.com/dimitri/regresql) - Tool to build, maintain and execute a regression [testing](/@harrisonqian/awesome/wiki/testing/testing) suite for SQL queries. * [diesel-guard](https://github.com/ayarotsky/diesel-guard) - Linter for dangerous Postgres migration patterns in Diesel and SQLx. ### Language bindings * [Common Lisp](/@harrisonqian/awesome/wiki/programming-languages/common-lisp): [Postmodern](https://github.com/marijnh/Postmodern) * [Clojure](/@harrisonqian/awesome/wiki/programming-languages/clojure): [clj-postgresql](https://github.com/remodoy/clj-postgresql) * [Elixir](/@harrisonqian/awesome/wiki/programming-languages/elixir): [postgrex](https://github.com/elixir-ecto/postgrex) * Go: [pq](https://github.com/lib/pq), [pgx](https://github.com/jackc/pgx), [go-pg](https://github.com/go-pg/pg) * [Haskell](/@harrisonqian/awesome/wiki/programming-languages/haskell): [postgresql-simple](http://hackage.haskell.org/package/postgresql-simple) * [Java](/@harrisonqian/awesome/wiki/programming-languages/java): [PostgreSQL JDBC Driver](https://jdbc.postgresql.org/), [Vert.x PostgreSQL Client](https://vertx.io/docs/vertx-pg-client/java/) * Lua: [luapgsql](https://github.com/arcapos/luapgsql) * .Net/.Net [Core](/@harrisonqian/awesome/wiki/platforms/core): [Npgsql](https://github.com/npgsql/npgsql) * Node: [node-postgres](https://github.com/brianc/node-postgres), [pg-promise](https://github.com/vitaly-t/pg-promise), [pogi](https://github.com/holdfenytolvaj/pogi), [slonik](https://github.com/gajus/slonik), [postgres](https://github.com/porsager/postgres) * [Perl](/@harrisonqian/awesome/wiki/programming-languages/perl): [DBD-Pg](https://metacpan.org/pod/distribution/DBD-Pg/Pg.pm) * PHP: [Pomm](http://www.pomm-project.org), [pecl/pq](https://github.com/m6w6/ext-pq) * [Python](/@harrisonqian/awesome/wiki/programming-languages/python): [psycopg2](https://pypi.org/project/psycopg2/), [asyncpg](https://pypi.org/project/asyncpg/), [pg8000](https://pypi.org/project/pg8000/) * R: [RPostgres](https://github.com/r-dbi/RPostgres), [RPostgreSQL](https://github.com/tomoakin/RPostgreSQL) * [Ruby](/@harrisonqian/awesome/wiki/programming-languages/ruby): [pg](https://github.com/ged/ruby-pg) * [Rust](/@harrisonqian/awesome/wiki/programming-languages/rust): [rust-postgresql](https://github.com/sfackler/rust-postgres), [pgx](https://github.com/tcdi/pgx), [wtx](https://github.com/c410-f3r/wtx) * TypeScript: [zapatos](https://github.com/jawj/zapatos) * Zig: [pg.zig](https://github.com/karlseguin/pg.zig) ### PaaS *(PostgreSQL as a Service)* * [Aiven PostgreSQL](https://aiven.io/postgresql) - PostgreSQL as a service in AWS, Azure, [DigitalOcean](/@harrisonqian/awesome/wiki/platforms/digitalocean), [Google Cloud](/@harrisonqian/awesome/wiki/platforms/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](https://aws.amazon.com/rds/postgresql/) - Amazon Relational [Database](/@harrisonqian/awesome/wiki/databases/database) Service (RDS) for PostgreSQL * [Azure [Database](/@harrisonqian/awesome/wiki/databases/database) for PostgreSQL](https://azure.microsoft.com/en-us/services/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](/@harrisonqian/awesome/wiki/platforms/integration) with Azure ecosystem. * [Crunchy Bridge](https://www.crunchydata.com/products/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. * [Database Labs](https://www.databaselabs.io) - Get a production-ready cloud PostgreSQL server in minutes, from $20 a month Backups, monitoring, patches, and 24/7 tech support all included. * [DigitalOcean Managed Databases](https://www.[digitalocean](/@harrisonqian/awesome/wiki/platforms/digitalocean).com/products/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. * [Google Cloud SQL for PostgreSQL](https://cloud.google.com/sql/docs/postgres/) - Fully-managed [database](/@harrisonqian/awesome/wiki/databases/database) service that makes it easy to set up, maintain, manage, and administer your PostgreSQL relational databases on [Google Cloud](/@harrisonqian/awesome/wiki/platforms/google-cloud) Platform. * [Heroku Postgres](https://elements.[heroku](/@harrisonqian/awesome/wiki/platforms/heroku).com/addons/heroku-postgresql) - Plans from free to huge, operated by PostgreSQL experts. Does not require running your app on [Heroku](/@harrisonqian/awesome/wiki/platforms/heroku). Free plan includes 10,000 rows, 20 connections, up to two backups, and has PostGIS support. * [OVHcloud Cloud Databases](https://www.ovhcloud.com/en/public-cloud/databases/) - Highly available, scalable, and secured PostgreSQL. Daily backups with point-in-time recovery, no lock-in, free incoming and outgoing traffic. * [Render Managed PostgreSQL](https://render.com/docs/databases) - Secure, reliable, and completely hands-off managed PostgreSQL. Encryption at [rest](/@harrisonqian/awesome/wiki/miscellaneous/rest), automated backups, and expandable SSD storage included in all plans. Plans start at $7 per month for 256MB RAM and 1GB storage (free for first 90 days). * [ScaleGrid PostgreSQL DBaaS](https://scalegrid.io/postgresql.html) - Fully managed PostgreSQL hosting with high availability, dedicated servers, and superuser control on the #1 multi-cloud Amazon RDS alternative. * [Scaleway Managed Database](https://www.scaleway.com/en/database/) - Fully managed PostgreSQL databases with HA, scaling, and automated backups, hosted in the EU. Starting at €10 per month. * [Supabase](https://www.[supabase](/@harrisonqian/awesome/wiki/databases/supabase).com) - Fully managed Postgres with read replicas, point-in-time-recovery, support packages, browser based GUI, and a generous free tier. * [Neon](https://neon.tech) - Fully managed serverless PostgreSQL. [Neon](/@harrisonqian/awesome/wiki/databases/neon) separates storage and compute to offer modern developer features such as serverless, branching, bottomless storage, and more. * [Nile](https://www.thenile.dev/) - Fully managed PostgreSQL . Nile decouples storage from compute and virtualizes tenants to ship multi-tenant AI applications fast, safe, and with limitless scale. Free tier provides unlimited databases. * [PlanetScale](https://planetscale.com/postgres) - PlanetScale for Postgres provides fully-managed, high availability PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database) clusters built on modern cloud infrastructure. * [Vela](https://vela.run) - Postgres-based backend-as-a-service built for modern AI [apps](/@harrisonqian/awesome/wiki/platforms/apps). Offers instant [database](/@harrisonqian/awesome/wiki/databases/database) branches and clones, production-like test environments, and serverless scaling. * [Thalassa Cloud DBaaS](https://thalassa.cloud/products/databases/postgresql/) - Fully managed PostgreSQL [database](/@harrisonqian/awesome/wiki/databases/database), multi-AZ, automated backups, hosted in the Netherlands. ### Docker images * [citusdata/citus](https://hub.[docker](/@harrisonqian/awesome/wiki/back-end-development/docker).com/r/citusdata/citus/) - Citus official images with citus extensions. Based on the official Postgres container. * [mdillon/postgis](https://hub.[docker](/@harrisonqian/awesome/wiki/back-end-development/docker).com/r/mdillon/postgis/) - PostGIS 2.3 on Postgres 9. Based on the official Postgres container. * [paradedb/paradedb](https://hub.[docker](/@harrisonqian/awesome/wiki/back-end-development/docker).com/r/paradedb/paradedb/) - ParadeDB is Postgres for Search and [Analytics](/@harrisonqian/awesome/wiki/miscellaneous/analytics). Based on the official Postgres container with pg_search extension. * [postgres](https://hub.[docker](/@harrisonqian/awesome/wiki/back-end-development/docker).com/_/postgres/) - Official postgres container (from Docker) ### Kubernetes * [Crunchy Operator](https://github.com/CrunchyData/postgres-operator) - Production PostgreSQL for [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes), from high availability Postgres clusters to full-scale [database](/@harrisonqian/awesome/wiki/databases/database)-as-a-service. * [Fujitsu Enterprise Postgres for Kubernetes](https://www.postgresql.fastware.com/) - Enterprise-grade PostgreSQL on OpenShift Container Platform (Commercial Software). * [Kubegres Operator](https://github.com/reactive-tech/kubegres) - Kubegres is a [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup. * [StackGres Operator](https://github.com/ongres/stackgres/) - Full Stack PostgreSQL on [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes). * [Zalando Operator](https://github.com/zalando/postgres-operator) - Creates and manages PostgreSQL clusters running in [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes). * [CloudNativePG operator](https://github.com/cloudnative-pg/cloudnative-pg) - A comprehensive platform designed to seamlessly manage PostgreSQL databases within [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) environments. * [KubeDB operator](https://kubedb.com/) - Run Production-Grade Databases on [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) (Commercial Software). * [Percona PostgreSQL Operator](https://github.com/percona/percona-postgresql-operator) - Percona Operator for PostgreSQL based on Crunchy Data operator. * [Percona Everest Operator](https://github.com/percona/everest-operator) - Everest Operator is a [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) Operator responsible for managing the lifecycle of [MySQL](/@harrisonqian/awesome/wiki/databases/mysql), [MongoDB](/@harrisonqian/awesome/wiki/databases/mongodb), and PostgreSQL databases. It leverages Percona's [Kubernetes](/@harrisonqian/awesome/wiki/back-end-development/kubernetes) Operators for [MySQL](/@harrisonqian/awesome/wiki/databases/mysql), [MongoDB](/@harrisonqian/awesome/wiki/databases/mongodb), and PostgreSQL under the hood but provides a unified API and a single pane of glass for managing all three [database](/@harrisonqian/awesome/wiki/databases/database) types. ## Resources ### Tutorials * [Backup and recover a PostgreSQL DB using wal-e](https://coderwall.com/p/cwe2_a/backup-and-recover-a-postgres-db-using-wal-e) - Tutorial about setting up continuous archiving in PostgreSQL using wal-e. * [Operations cheat sheet](https://wiki.postgresql.org/wiki/Operations_cheat_sheet) - Operations [cheat sheet](/@harrisonqian/awesome/wiki/development-environment/cheat-sheet) from PostgreSQL Wiki. * [PG Casts](https://www.pgcasts.com) - Free weekly PostgreSQL screencasts by Hashrocket. * [Postgres Guide](http://postgresguide.com/) - Guide designed as an aid for beginners and experienced users to find specific [tips](/@harrisonqian/awesome/wiki/programming-languages/tips) and explore tools available within PostgreSQL. * [PostgreSQL Exercises](https://pgexercises.com/) - Site to make it easy to learn PostgreSQL by doing exercises. * [tutorialspoint PostgreSQL tutorial](http://www.tutorialspoint.com/postgresql/) - Very extensive collection of [tutorials](/@harrisonqian/awesome/wiki/computer-science/tutorials) on PostgreSQL * [postgresDBSamples](https://github.com/morenoh149/postgresDBSamples) - A collection of sample postgres schemas * [PostgreSQL Primer for Busy People](https://zaiste.net/posts/postgresql-primer-for-busy-people/) - A collection of the most common commands used in PostgreSQL * [pg-utils](https://github.com/dataegret/pg-utils) - Useful DBA tools by Data Egret * [pagila](https://github.com/xzilla/pagila) - Pagila, Postgres Sample [Database](/@harrisonqian/awesome/wiki/databases/database) * [SQL Syntax Cheat Sheet](https://github.com/mergisi/sql-syntax-cheat-sheet) - Comprehensive SQL syntax reference covering window functions, CTEs, and PostgreSQL-specific syntax (UPSERT, [JSON](/@harrisonqian/awesome/wiki/miscellaneous/json) queries, array operations). ### Blogs * [Planet PostgreSQL](https://planet.postgresql.org/) - Blog aggregation service for PostgreSQL. * [Andrew Dunstan's PostgreSQL and Technical blog](http://adpgtech.blogspot.com/search/label/PostgreSQL/) * [Bruce Momjian's PostgreSQL blog](https://momjian.us/main/blogs/pgblog.html) * [Craig Kerstiens PostgreSQL posts](http://www.craigkerstiens.com/categories/postgres/) - Set of posts on PostgreSQL cool features, [tips](/@harrisonqian/awesome/wiki/programming-languages/tips) and tricks. * [Database Soup](http://www.databasesoup.com/search/label/postgresql/) - Josh Berkus' blog. * [Michael Paquier's blog](https://paquier.xyz/) * [Percona's PostgreSQL blog posts](https://www.percona.com/blog/category/postgresql/) * [Robert Haas' blog](http://rhaas.blogspot.com/search/label/postgresql/) * [select * from depesz;](https://www.depesz.com/tag/postgresql/) - Hubert Lubaczewski's blog. * [Metis Blog](https://www.metisdata.io/blog) - Set of posts on PostgreSQL, SQL databases, performance, and tuning. * [Digoal's PostgreSQL and Technical blog(Chinese Language)](https://github.com/digoal/blog/blob/master/README.md) * [Pigsty blog / PostgreSQL](https://pigsty.io/blog/pg/) - Blog by the author of PIGSTY with insightful articles on PostgreSQL (as well as databases and cloud infrastructure). * [BigData Boutique Blog / PostgreSQL](https://bigdataboutique.com/blog/tagged/postgresql) - Blog by the BigData Boutique team, mostly with [analytics](/@harrisonqian/awesome/wiki/miscellaneous/analytics) focus). ### Books * [PostgreSQL Mistakes and How to Avoid Them](https://www.manning.com/books/postgresql-mistakes-and-how-to-avoid-them) * [The Internals of PostgreSQL](https://www.interdb.jp/pg/index.html) - A free e-book by Hironobu Suzuki * [PostgreSQL 14 Internals](https://postgrespro.com/community/books/internals) - A free e-book by Egor Rogov * [Lift the Elephant](https://leanpub.com/lift-the-elephant) - A practical guide to scaling Postgres in production, covering tuning, connection pooling, partitioning, and high availability. ### Documentation * [Wiki](https://wiki.postgresql.org/wiki/Main_Page) - user documentation, how-tos, and [tips](/@harrisonqian/awesome/wiki/programming-languages/tips) 'n' tricks * [pgPedia](https://pgpedia.info/) - An encyclopedia of things related to postgreSQL. * [create_pg_super_document](https://ryogrid.[github](/@harrisonqian/awesome/wiki/development-environment/github).io/create_pg_super_document/index.html) - A project that aim to generate documentation for all symbols in the PostgreSQL codebase using AI agents ### Newsletters * [Postgres Weekly](https://postgresweekly.com/) - Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL. * [pgMustard newsletter](https://www.pgmustard.com/newsletter) - Monthly newsletter that contains Postgres performance articles and videos. ### Podcasts * [PostgresFM](https://postgres.fm/) - Weekly discussions about Postgres topics. * [Scaling Postgres](https://www.scalingpostgres.com/) - Weekly roundups of PostgreSQL related content. * [Path to Citus Con](https://www.citusdata.com/podcast/path-to-citus-con/) - Monthly interviews with people in the Postgres world. ### Videos * [Citus Data Youtube channel](https://www.youtube.com/channel/UC8jpoK1BqQhDh6HDGFnM_DA/videos) - Citus related videos * [EnterpriseDB Youtube channel](https://www.youtube.com/channel/UCkIPoYyNr1OHgTo0KwE9HJw) - EnterpriseDB related videos * [Postgres Conference Youtube channel](https://www.youtube.com/channel/UCsJkVvxwoM7R9oRbzvUhbPQ/videos) - Conference videos * [Scaling Postgres](https://www.scalingpostgres.com/) - Postgres video blog series by Creston Jamison * [PostgresTV Youtube channel](https://www.youtube.com/@PostgresTV) - Postgres [talks](/@harrisonqian/awesome/wiki/theory/talks), [hacking](/@harrisonqian/awesome/wiki/security/hacking) sessions, interviews, and podcast episodes ### Community * [Mailing lists](https://www.postgresql.org/list/) - Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community. * [Reddit](https://www.reddit.com/r/PostgreSQL/) - A reddit community for PostgreSQL users with over 12000 users * [Slack](https://pgtreats.info/slack-invite) - [Slack](/@harrisonqian/awesome/wiki/work/slack) workspace for Postgres with over 20k members * Telegram - Several groups for PostgreSQL in different languages: [Russian](https://t.me/pgsql) >4200 people, [Brazilian Portuguese](https://t.me/postgresqlbr) >2300 people, [Indonesian](https://t.me/postgresql_id) ~1000 people, [English](https://t.me/postgreschat) >750 people * [#postgresql on Freenode](https://webchat.freenode.net/#postgresql) - The most popular IRC channel about Postgres on Freenode with over 1000 users * [Discord](https://discord.gg/bW2hsax8We) - A Discord server for Postgres with over 6k members ### Roadmaps * [PostgreSQL Roadmap](https://roadmap.sh/postgresql-dba) - A roadmap providing step wise guide to PostgreSQL. ### External lists * [Wikipedia admin tools list](https://en.wikipedia.org/wiki/Comparison_of_database_tools) - Comparison of [database](/@harrisonqian/awesome/wiki/databases/database) administration tools on Wikipedia * [PostgreSQL Wiki GUI tools list](https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools) - Community Guide to PostgreSQL GUI Tools * [PostgreSQL Wiki Foreign Data Wrappers list](https://wiki.postgresql.org/wiki/Foreign_data_wrappers) - Foreign data wrappers