PostgreSQL
Object-relational database.
Contents
Backups
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.
Monitoring
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.
Extensions
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.
Utilities
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.
Kubernetes
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.
Tutorials
GUI
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.