PostgreSQL

Advanced WAL File Management Tools for PostgreSQL.

A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.

A Complete Docker-based Postgres backup and maintenance tool with Web UI.

pg_back is a simple backup script

Backup and restore tool for cloud object stores (AWS S3, Azure, Google Cloud, OpenStack Swift).

A handy Docker container to periodically backup PostgreSQL to Alibaba Cloud Object Storage Service (OSS)

(obsolete) – Simple Continuous Archiving for PostgreSQL to S3, Azure, or Swift by Heroku.

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.

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.

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.

check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.

Nagios check_postgres plugin for checking status of PostgreSQL databases.

Coroot is an open-source APM & Observability tool, a DataDog and NewRelic alternative. Powered by eBPF for rapid insights into system performance.

Real-time performance monitoring, including pre-made graphs for ease of setup (Commercial Software)

Comprehensive PostgreSQL monitoring module for Zabbix.

Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.

Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.

Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.

Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards.

The automatic indexer for Postgres. Detects slow queries and creates indexes if configured to do so.

Active Session History for PostgreSQL. Samples pgstatactivity 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.).

Fully customizable Prometheus exporter for PostgreSQL & Pgbouncer with fine-grained execution control.

Prometheus exporter for PostgreSQL server metrics.

An open-source PostgreSQL extension designed for efficient and organized advanced statistics management.

Adds fully-functional graph database support including Cypher queries.

Scalable PostgreSQL cluster for real-time workloads.

Columnar store for analytics with PostgreSQL.

Postgres for Search and Analytics

Run periodic jobs in PostgreSQL.

Extension that provides logical streaming replication.

Enhanced PostgreSQL logical replication

PostgreSQL SVG QRcode & Datamatrix generator.

Partition management extension for PostgreSQL.

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

Extension to scale out real-time reads and writes.

Query Performance Monitoring tool for PostgreSQL.

An extension for automatic bloat cleanup with minimal locking.

Extension that allows to check plpgsql source code.

Postgres binding as extension for crypto library Themis, providing various security services on PgSQL's side.

Extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch.

Provides an audit trail for your data inside a PostgreSQL database using triggers and server-side functions written in PL/pgSQL.

HypoPG provides hypothetical/virtual indexes feature.

pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geospatial routing and other network analysis functionality.

Open-source 4D spatiotemporal platform combining PostGIS, TimescaleDB, pgvector, and H3 for unified geospatial and time-series intelligence.

Automatic data change tracking for PostgreSQL

ERAlchemy generates Entity Relation (ER) diagram from databases.

Cloud-native database gateway and framework for building data-driven applications. Like API gateways, for databases.

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

Synchronize roles and privileges from YML and LDAP.

Like diff but for Postgres schemas.

Lanyrd's MySQL to PostgreSQL conversion script.

The NServiceBus.Transport.PostgreSql library allows .NET developers to use a PostgreSQL database as a message broker. (Commerical Software)

top like application for PostgreSQL server activity monitoring.

A PostgreSQL SQL syntax beautifier (Node.js).

Fast PostgreSQL Log Analyzer.

Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.

Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.

Export data from PostgreSQL into different data formats.

Browser extension to redirect PostgreSQL docs links to the current version.

Import CSV and JSON into PostgreSQL the easy way.

Convenient SQL for monitoring Postgres database health.

Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.

Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or Kubernetes.

Command line tool to interact with the PostgreSQL Extension Network

Tool that extracts and provides metrics for your PostgreSQL database.

Serves a fully RESTful API from any existing PostgreSQL database.

Serve a RESTful API from any PostgreSQL database (Golang)

Instant GraphQL API or GraphQL schema for your PostgreSQL database

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

A lightweight PostgresSQL LISTEN/NOTIFY daemon built on top of node-postgres.

PostgreSQL extension for transparent JSONB compression

Manage PostgreSQL codebases and make VCS simple.

Advanced job scheduler for PostgreSQL.

Tool for managing versioned schema deployment

CLI tool to evolve schema migrations, developed by Yandex.

Tool to compare database schemas, with capability to accept some persistent differences

Tool for easy initialization / updating of the structure of PostgreSQL tables, migration alternative (Node.js).

Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.

Postgres database schema versioning.

Generate PlantUML ER diagram textual description from PostgreSQL tables

Zero-downtime, reversible, schema migrations for Postgres

Tool to build, maintain and execute a regression testing suite for SQL queries.

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

Safety-first Node.js migration engine with advisory locks, SHA-256 drift detection, and 10 built-in lint rules for PostgreSQL.

Spot vulnerabilities in PostgreSQL extension scripts.

A daemon to run stateful Postgres on cheap AWS Spot VMs

Tool to sync PostgreSQL data to your local machine.

Linter for dangerous Postgres migration patterns in Diesel and SQLx.

Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.

Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.

Full Stack PostgreSQL on Kubernetes.

Creates and manages PostgreSQL clusters running in Kubernetes.

A comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments.

Percona Operator for PostgreSQL based on Crunchy Data operator.

Everest Operator is a Kubernetes Operator responsible for managing the lifecycle of MySQL, MongoDB, and PostgreSQL databases. It leverages Percona's Kubernetes Operators for MySQL, MongoDB, and PostgreSQL under the hood but provides a unified API and a single pane of glass for managing all three database types.

A collection of sample postgres schemas

Useful DBA tools by Data Egret

Pagila, Postgres Sample Database

Comprehensive SQL syntax reference covering window functions, CTEs, and PostgreSQL-specific syntax (UPSERT, JSON queries, array operations).

A modern multi-platform Postgres-centric database client/administration tool.

Web-based PostgreSQL database browser written in Go.

The Premier Web Based Administration Tool for PostgreSQL.

PostgreSQL Client for macOS.

Connect to any data source, easily visualize and share your data.

Web-based PostgreSQL GUI and monitoring.

A Super fast, Real-time, Professional, Developer friendly, No code database.

Battery-Included Open-Source Distribution for PostgreSQL with ultimate observability & Database-as-Code toolbox for developers.

Atlas is a tool for managing and migrating database schemas using modern DevOps principles.

Postgres CLI with autocompletion and syntax highlighting

compare and analyze PostgreSQL EXPLAIN plans from the CLI

CLI (and Golang library) for diffing Postgres schemas and generating SQL migrations with minimal locking.

PostgreSQL migration safety CLI that catches dangerous DDL before production — 80 rules, lock classification, auto-fix, GitHub Action.

Branch your PostgreSQL Database like Git

Run a query in psql and output the result as CSV

A fast, driver-less TUI to browse, query, and edit PostgreSQL databases.

SchemaSpy is a JAVA JDBC-compliant tool for generating your database to HTML documentation, including Entity Relationship diagrams

And MPP PostgreSQL fork. Open source alternative to Greenplum Database.

SQL database security suite: proxy for data protection with transparent "on the fly" data encryption, SQL firewall (SQL injections prevention), intrusion detection system.

Autobase for PostgreSQL is an open-source DBaaS that automates the deployment and management of highly available PostgreSQL clusters.

BiDirectional Replication - a multimaster replication system for PostgreSQL

Template for PostgreSQL HA with ZooKeeper or etcd.

100% open-source logical multi-master PostgreSQL replication.

PostgreSQL HA based on Consul or etcd, with Kubernetes integration.

Replication monitoring and failover daemon.

Open-source tool suite to manage replication and failover in a cluster of PostgreSQL servers.

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

Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.

Postgres extension and service for automated failover and high-availability.

Stream write-ahead logs (WAL) from a PostgreSQL server in real time. A drop-in, container-friendly alternative to pg_receivewal.

A microservice that provides HTTP endpoints for instantly retrieving the current master host or a replica that meets various criteria.