A curated list of awesome PostgreSQL tools, scripts, slides, and short examples. inspired by the other awesome lists.
- Citus - Citus horizontally scales PostgreSQL across commodity servers using sharding and replication. Its query engine parallelizes incoming SQL queries across these servers to enable real-time responses on large datasets.
- ldap2pg - manage roles and ACL.
- PL/V8 - Content for starting and do quick consults about PL/V8.
- PGBouncer - Lightweight connection pooler for PostgreSQL.
- pgpool-II - Connection pooler, load balancer, replicator, also implementing parallel query.
- Postgres Connection Pool Sizer - Free tool to calculate the optimal pool size, per-instance limit, and max_connections from CPU cores, using the widely-used HikariCP formula.
- PGStrom (GPU Process)
- Designed to off-load several CPU intensive workloads to GPU devices.
- PostgREST - Standalone web server that tuns your database directly into a RESTful API.
- pgloader - Load data into PostgreSQL. Any Data.
- pgbundle - Manage your PostgreSQL extensions with Pgbundle.
- psql_bm25s - PostgreSQL extension for BM25-family lexical retrieval with a native index access method and SQL query APIs.
- pgcli - Postgres CLI with autocompletion and syntax highlighting.
- Barman - Backup and recovery manager.
- RowSafe - Open-source PostgreSQL tooling for backups, restore testing, health checks and tuning, with an Apache-2.0 CLI, Linux server agent and MCP integration.
- psql2csv - Run a query in psql and output the result as CSV.
- pome - A Postgres Metrics Dashboard which can be deployed as a binary.
- pg_bulkload - It's a high speed data loading utility for PostgreSQL.
- pg - Browser PostgreSQL, no server, just client and pglite (postgresql wasm)
- Bemi - Automatic data change tracking for PostgreSQL.
- 1bench - Desktop client for PostgreSQL with pgvector support, plus two dozen other engines.
- RowShield - Checks a Supabase (PostgREST) deployment from the outside for tables and storage that anonymous callers can read; free read-only probe, paid scheduled RLS policy and drift checks.
- Scribase - Self-hosted control plane for Supabase + Neon: provision, pool, and manage your own Postgres projects without the hosted-vendor lock-in, open source.
- SolidPing - Self-hosted uptime monitoring with a PostgreSQL check that connects, runs a query (default
SELECT 1) and alerts on failure.
- OLake - Open-source PostgreSQL to Apache Iceberg replication using logical replication (CDC), full refresh and incremental sync. Written in Go.
- dbdiff - Compare PostgreSQL schemas, detect drift, and generate migration SQL for review, including offline SQL-file and snapshot comparisons.
- Depesz
- Tatiyants
- Rivestack - Managed PostgreSQL with pgvector for AI workloads. Built-in SQL editor lets you query your database with natural language (automatically converted to vector embeddings). Free tier includes 2GB storage.
- Views dependency handle - Script to handle with tabe and view dependencies easy.
- pg-ldap-sync - This program helps to solve the issue by synchronizing users, groups and their memberships from LDAP to PostgreSQL
- pgldapsync - Python module that allows you to synchronize Postgres login roles with users in an LDAP directory
- postgresql-ldap-sync - This program synchronize users, groups and their memberships from LDAP to PostgreSQL
gem-hunter