Skip to content
91

Awesome Postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

12k stars1,098 forks53 entriesLast push Nov 5, 2026 (10 days ago)License CC0-1.0

This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.

General

PostgreSQL

, often simply Postgres, is an object-relational database (ORDBMS). PostgreSQL is ACID-compliant and transactional. (see more: wikipedia:PostgreSQL, PostgreSQL.org)

Resources >Tutorials

Backup and recover a PostgreSQL DB using wal-e

Tutorial about setting up continuous archiving in PostgreSQL using wal-e.

Operations cheat sheet

Operations cheat sheet from PostgreSQL Wiki.

PG Casts

Free weekly PostgreSQL screencasts by Hashrocket.

Postgres Guide

Guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within PostgreSQL.

PostgreSQL Access Control

The complete mental model: roles, grants, ownership, membership, policies, and default privileges as an integrated system. PDF + video, ~60 min.

PostgreSQL Exercises

Site to make it easy to learn PostgreSQL by doing exercises.

PostgreSQL Terminal Simulator

Guided psql lessons in a simulated terminal in the browser: meta-commands, EXPLAIN, indexes and transactions. Free, no signup.

tutorialspoint PostgreSQL tutorial

Very extensive collection of tutorials on PostgreSQL

postgresDBSamples

A collection of sample postgres schemas

PostgreSQL Primer for Busy People

A collection of the most common commands used in PostgreSQL

pg-utils

Useful DBA tools by Data Egret

In 2 lists

pagila

Pagila, Postgres Sample Database

SQL Syntax Cheat Sheet

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

Resources >Blogs

Planet PostgreSQL

Blog aggregation service for PostgreSQL.

Andrew Dunstan's PostgreSQL and Technical blog

Bruce Momjian's PostgreSQL blog

Craig Kerstiens PostgreSQL posts

Set of posts on PostgreSQL cool features, tips and tricks.

Database Soup

Josh Berkus' blog.

Link may be dead

Michael Paquier's blog

Percona's PostgreSQL blog posts

Robert Haas' blog

select * from depesz;

Hubert Lubaczewski's blog.

Metis Blog

Set of posts on PostgreSQL, SQL databases, performance, and tuning.

Link may be dead

Digoal's PostgreSQL and Technical blog(Chinese Language)

Pigsty blog / PostgreSQL

Blog by the author of PIGSTY with insightful articles on PostgreSQL (as well as databases and cloud infrastructure).

BigData Boutique Blog / PostgreSQL

Blog by the BigData Boutique team, mostly with analytics focus).

Resources >Books

PostgreSQL Mistakes and How to Avoid Them

The Internals of PostgreSQL

A free e-book by Hironobu Suzuki

In 2 lists

PostgreSQL 14 Internals

A free e-book by Egor Rogov

In 3 lists

Lift the Elephant

A practical guide to scaling Postgres in production, covering tuning, connection pooling, partitioning, and high availability.

Resources >Documentation

Wiki

user documentation, how-tos, and tips 'n' tricks

pgPedia

An encyclopedia of things related to postgreSQL.

Link may be dead

create_pg_super_document

A project that aim to generate documentation for all symbols in the PostgreSQL codebase using AI agents

Resources >Newsletters

Postgres Weekly

Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL.

In 2 lists

pgMustard newsletter

Monthly newsletter that contains Postgres performance articles and videos.

pgsql-hackers Weekly Digest

Weekly digest of the pgsql-hackers mailing list that provides a list of active threads, thread summaries, and more.

Resources >Podcasts

PostgresFM

Weekly discussions about Postgres topics.

Scaling Postgres

Weekly roundups of PostgreSQL related content.

Path to Citus Con

Monthly interviews with people in the Postgres world.

Link may be dead

Resources >Videos

Citus Data Youtube channel

Citus related videos

EnterpriseDB Youtube channel

EnterpriseDB related videos

Postgres Conference Youtube channel

Conference videos

Scaling Postgres

Weekly roundups of PostgreSQL related content.

PostgresTV Youtube channel

Postgres talks, hacking sessions, interviews, and podcast episodes

Resources >Community

Mailing lists

Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community.

Reddit

A reddit community for PostgreSQL users with over 12000 users

In 2 listsLink may be dead

Slack

Slack workspace for Postgres with over 20k members

Link may be dead

#postgresql on Freenode

The most popular IRC channel about Postgres on Freenode with over 1000 users

In 3 lists

Discord

A Discord server for Postgres with over 6k members

Resources >Roadmaps

PostgreSQL Roadmap

A roadmap providing step wise guide to PostgreSQL.

In 2 lists

Resources >External lists

Wikipedia admin tools list

Comparison of database administration tools on Wikipedia

PostgreSQL Wiki GUI tools list

Community Guide to PostgreSQL GUI Tools

PostgreSQL Wiki Foreign Data Wrappers list

Foreign data wrappers

See category
91

Awesome PocketBase

benallfree/awesome-pocketbase

A collection of PocketBase community resources.

Fresh★ 1.2k95 entriesPushed today
89

awesome-mysql

shlomi-noach/awesome-mysql

A curated list of awesome MySQL software, libraries, tools and resources

Fresh★ 2.6k111 entriesPushed 28 days ago
87

Awesome MongoDB

ramnes/awesome-mongodb

:leaves: A curated list of awesome MongoDB resources, libraries, tools and applications

Fresh★ 2.7k188 entriesPushed 9 days ago
84

Awesome Database Tools

mgramin/awesome-db-tools

Everything that makes working with databases easier

Fresh★ 5.4k320 entriesPushed 1 month ago
81

Awesome Database Development

huachaohuang/awesome-dbdev

Awesome materials about database development.

Fresh★ 1.6k40 entriesPushed 8 days ago
70

Awesome SQLAlchemy

dahlia/awesome-sqlalchemy

A curated list of awesome tools for SQLAlchemy

Active★ 3.1k29 entriesPushed 5 months ago