Awesome Postgres

plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).

PostgreSQL Remote Control

A PostgreSQL extension for automatic bloat cleanup

Nagios check_postgres plugin for checking status of PostgreSQL databases

Query Performance Monitoring Tool for PostgreSQL

ZSON is a PostgreSQL extension for transparent JSONB compression

Sample databases for postgres

A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.

Adaptive query optimization for PostgreSQL

Audit trail with schema versioning for PostgreSQL using transaction-based logging

Automatic data change tracking for PostgreSQL

Enhanced PostgreSQL logical replication

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

Fast, safe-by-design, Vim-first TUI for PostgreSQL, MySQL, and SQLite, built in Rust.

database gateway for building data-driven applications

:elephant: :busts_in_silhouette: Manage PostgreSQL roles and privileges from YAML or LDAP

The open source | Next Generation database editor

Monitor PostgreSQL with Zabbix

Spot vulnerabilities in postgres SQL scripts

Linter for dangerous Postgres migration patterns in Diesel and SQLx. Prevents downtime caused by unsafe schema changes.

A microservice (sidecar) that helps instantly determine the status of your PostgreSQL hosts including whether they are alive, which one is the master, which ones are replicas, and how far each replica is lagging behind the master.

A PostgreSQL SQL syntax beautifier.

The PostgreSQL Sample Database

Postgres CLI with autocompletion and syntax highlighting

A PostgreSQL assistant for developers Understand, optimize, and improve your PostgreSQL database with ease.

Tool for comparing Postgres database schemas

Node.js migration tool for PostgreSQL

Postgres Themis plugin

BeanQueue, a lightweight Python task queue framework based on SQLAlchemy, PostgreSQL SKIP LOCKED queries and NOTIFY / LISTEN statements.

Static analyzer for Postgres Row-Level Security — 67 lint rules covering tenant and per-user row-scoping bugs, performance traps, and hygiene; 20 mechanically auto-fixable; semantic policy-diff command for CI gating; pytest plugin for RLS isolation tests.

Self-hosted 4D spatiotemporal AI platform built on PostgreSQL, PostGIS, TimescaleDB, H3 and pgvector, with anomaly & threat detection, NLQ interface and full observability.

Compare and analyze PostgreSQL EXPLAIN plans from the CLI

40 copy-paste PostgreSQL diagnostic queries — one for every performance bottleneck. No extensions. No installation. Just SQL.

Safety-first PostgreSQL migration engine for Node.js — advisory locks, drift detection, checksum verification, 10 lint rules, CLI, and GitHub Action