A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.
, often simply Postgres, is an object-relational database (ORDBMS). PostgreSQL is ACID-compliant and transactional. (see more: wikipedia:PostgreSQL, PostgreSQL.org)
Tutorial about setting up continuous archiving in PostgreSQL using wal-e.
Operations cheat sheet from PostgreSQL Wiki.
Free weekly PostgreSQL screencasts by Hashrocket.
Guide designed as an aid for beginners and experienced users to find specific tips and explore tools available within PostgreSQL.
The complete mental model: roles, grants, ownership, membership, policies, and default privileges as an integrated system. PDF + video, ~60 min.
Site to make it easy to learn PostgreSQL by doing exercises.
Very extensive collection of tutorials on PostgreSQL
A collection of sample postgres schemas
A collection of the most common commands used in PostgreSQL
Useful DBA tools by Data Egret
Pagila, Postgres Sample Database
Comprehensive SQL syntax reference covering window functions, CTEs, and PostgreSQL-specific syntax (UPSERT, JSON queries, array operations).
Blog aggregation service for PostgreSQL.
Set of posts on PostgreSQL cool features, tips and tricks.
Josh Berkus' blog.
Hubert Lubaczewski's blog.
Set of posts on PostgreSQL, SQL databases, performance, and tuning.
Blog by the author of PIGSTY with insightful articles on PostgreSQL (as well as databases and cloud infrastructure).
Blog by the BigData Boutique team, mostly with analytics focus).
A free e-book by Hironobu Suzuki
A free e-book by Egor Rogov
A practical guide to scaling Postgres in production, covering tuning, connection pooling, partitioning, and high availability.
user documentation, how-tos, and tips 'n' tricks
An encyclopedia of things related to postgreSQL.
A project that aim to generate documentation for all symbols in the PostgreSQL codebase using AI agents
Weekly newsletter that contains articles, news, and repos relevant to PostgreSQL.
Monthly newsletter that contains Postgres performance articles and videos.
Weekly digest of the pgsql-hackers mailing list that provides a list of active threads, thread summaries, and more.
Weekly discussions about Postgres topics.
Weekly roundups of PostgreSQL related content.
Monthly interviews with people in the Postgres world.
Citus related videos
EnterpriseDB related videos
Conference videos
Weekly roundups of PostgreSQL related content.
Postgres talks, hacking sessions, interviews, and podcast episodes
Official mailing lists for Postgres for support, outreach, and more. One of the primary channels of communication in the Postgres community.
A reddit community for PostgreSQL users with over 12000 users
Slack workspace for Postgres with over 20k members
The most popular IRC channel about Postgres on Freenode with over 1000 users
A Discord server for Postgres with over 6k members
A roadmap providing step wise guide to PostgreSQL.
Comparison of database administration tools on Wikipedia
Community Guide to PostgreSQL GUI Tools
Foreign data wrappers
shlomi-noach/awesome-mysql
A curated list of awesome MySQL software, libraries, tools and resources
benallfree/awesome-pocketbase
A collection of PocketBase community resources.
leomaurodesenv/game-datasets
:video_game: A curated list of awesome game datasets, and tools to artificial intelligence in games
ramnes/awesome-mongodb
:leaves: A curated list of awesome MongoDB resources, libraries, tools and applications
mgramin/awesome-db-tools
Everything that makes working with databases easier
lyqht/awesome-supabase
Official awesome-list of Supabase Starters & Resources ⚡️