A PostgreSQL extension for high-performance real-time analytics on time-series and event data.
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
Free multi-platform desktop SQL client and database tool supporting 100+ databases via JDBC and ODBC drivers.
TypeScript ORM for Node.js that gives type-safe database access across PostgreSQL, MySQL, SQLite, MongoDB and other databases.
Free browser-based database schema editor that draws ER diagrams and generates SQL scripts, with no account required.
A free, local-first, AI-assisted database client and SQL workspace supporting 40+ databases across desktop, web, Docker and CLI.
Open-source database governance platform that controls schema changes, access, and queries across major databases for both humans and AI agents.