Postgres Top Query

Script designed for recreating indexes 'concurrently' to tackle 'index bloat' without locking tables (0 downtime).

SQL-Structure diffs between servers and definitions in Yaml

A flamegraph generator for Postgres EXPLAIN ANALYZE output.

A complete end-end project that demonstrates the 'Traditional backup with WAL streaming' architecture implementation (Backup via rsync/SSH + WAL streaming). This is chosen as it provides incremental backup/restore & a bunch of other features.

postgresql_tool

A PostgreSQL function that returns a custom value if two booleans match.

Postgresql client

Lightweight database updater and update modification tracker for PostgreSQL family databases.

Run large PostgreSQL UPDATE and DELETE queries with small batches to prevent locks

PGCon is an annual conference held in Canada dedicated to PostgreSQL!

SQLynx_WEB SQL-IDE

Declarative permissions management for PostgreSQL

pgBasEnv - PostgreSQL Base Environment Tool

pgOperate - PostgreSQL Operation Tool

Manage PostgreSQL with Ansible

A tiny bash utility that automates full‑database backups to NFS/S3 or local drive with pg_dump and (optionally) restores them to another server all configurable via either script defaults or CLI flags.

Complete SQL Keywords Guide with Examples

Command-line tool and PowerShell module for MSSQL Server, PostgreSQL and MySQL.