Repolode
dhamaniasad

dhamaniasad/awesome-postgres

A curated, community-maintained list of PostgreSQL software, libraries, tools, extensions and learning resources.

Stars
12,122
Forks
1,053
Open issues
106
Last commit
2 months ago

What is it?

Awesome Postgres is an curated index of projects and resources around PostgreSQL, the open-source object-relational database. Entries are grouped by purpose, including high availability and replication, backups, GUI clients, command-line tools, monitoring, extensions, work queues, query optimization, language drivers, managed hosting providers, Docker images and Kubernetes operators.

It is useful as a starting point when you need to find a tool for a specific PostgreSQL task, such as choosing a failover manager, a migration tool or a Node.js or Go driver. Many entries are short one-line descriptions with links, and some are marked as commercial software.

The list is inspired by awesome-mysql and is released under CC0, and contributions are accepted through pull requests and issues.

Key features

  • 01Covers high availability, backups, GUI clients and CLI tools for PostgreSQL.
  • 02Lists extensions for search, time-series, geospatial data, auditing and more.
  • 03Includes language bindings for many programming languages.
  • 04Points to managed PostgreSQL hosting providers and Docker images.
  • 05Organizes resources such as tutorials, blogs and documentation.

Use cases

  • Finding a replication or failover tool when setting up a highly available Postgres cluster.
  • Choosing a backup solution such as pgBackRest or Barman for production databases.
  • Discovering extensions like PostGIS, TimescaleDB or pgvector for specialized workloads.
  • Comparing GUI clients and monitoring tools before adopting one for a team.

Topics

FAQ

What is awesome-postgres?
A curated, community-maintained list of PostgreSQL software, libraries, tools, extensions and learning resources. Awesome Postgres is an curated index of projects and resources around PostgreSQL, the open-source object-relational database. Entries are grouped by purpose, including high availability and replication, backups, GUI clients, command-line tools, monitoring, extensions, work queues, query optimization, language drivers, managed hosting providers, Docker images and Kubernetes operators.
Is awesome-postgres free to use? What license does it have?
awesome-postgres is open source under the CC0-1.0 license. Check the license terms before using it in commercial products.
Is awesome-postgres still maintained?
Updated within 6 months. The last commit to awesome-postgres was on Aug 31, 2026.
What can I use awesome-postgres for?
Finding a replication or failover tool when setting up a highly available Postgres cluster. Choosing a backup solution such as pgBackRest or Barman for production databases. Discovering extensions like PostGIS, TimescaleDB or pgvector for specialized workloads. Comparing GUI clients and monitoring tools before adopting one for a team.
Where can I get awesome-postgres?
The source code and installation instructions are on GitHub: https://github.com/dhamaniasad/awesome-postgres

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects