Open-Awesome
CategoriesAlternativesStacksSelf-HostedExplore
Open-Awesome

© 2026 Open-Awesome. Curated for the developer elite.

TermsPrivacyAboutGitHubRSS
  1. Home
  2. Categories
  3. Databases
  4. PostgreSQL

PostgreSQL

The "Awesome PostgreSQL" project is a curated collection of resources focused on PostgreSQL, a powerful open-source object-relational database management system. This list encompasses a variety of categories, including libraries, tools, extensions, tutorials, and community resources that enhance the PostgreSQL experience. It is beneficial for developers, database administrators, and data analysts of all skill levels, providing them with essential tools and knowledge to effectively work with PostgreSQL. Users can explore performance optimization techniques, data modeling strategies, and best practices to maximize their use of this robust database system.

postgresqldatabasesqldata-managementopen-sourcedevelopment-toolsdatabase-administration
RSSView on GitHub
11.8k stars947 forks0 contributorsUpdated
Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a projectStar on GitHub

Table of Contents

27 sections · 270 projects

High-Availability

10 projects
autobase
autobase

An open-source automated database platform for deploying and managing production-ready, highly available PostgreSQL clusters.

TypeScript4,2513 days ago
BDR
BDR

Bi-Directional Multi-Master Replication (BDR) extension for PostgreSQL, enabling multi-master database synchronization.

C3606 years ago
Spock
Spock

A PostgreSQL extension providing logical multi-master replication for high availability and write scalability.

C7281 day ago
stolon
stolon

A cloud-native PostgreSQL manager providing high availability, leveraging streaming replication and cluster stores like etcd or Consul.

Go4,8171 year ago
repmgr
repmgr

A lightweight suite of open-source tools to manage replication and failover within PostgreSQL clusters.

C1,7002 months ago
Slony-I
slony.info
PostgreSQL Automatic Failover
PostgreSQL Automatic Failover

An OCF resource agent for PostgreSQL that provides automatic failover capabilities using Pacemaker and Corosync.

Perl3492 years ago
pg_auto_failover
pg_auto_failover

A PostgreSQL extension and service for automated failover and high-availability, optimized for simplicity and correctness.

C1,3486 months ago
pgrwl
pgrwl

A cloud-native PostgreSQL WAL receiver for zero-data-loss streaming, compression, encryption, and remote archiving.

Go1764 days ago
pg-status
pg-status

A lightweight sidecar microservice that instantly determines PostgreSQL host status, master/replica roles, and replication lag.

C7319 days ago

Backups

7 projects
Barman
pgbarman.org
Databasus
databasus.com
pg_probackup
pg_probackup

A utility for managing PostgreSQL database backups and recovery with incremental backup, parallel operations, and retention policies.

Python7891 month ago
pgBackRest
pgbackrest.org
pgbackweb
pgbackweb

A user-friendly web interface for managing automated PostgreSQL backups with scheduling, monitoring, and encryption.

Go2,5866 months ago
pg_back
pg_back

A PostgreSQL backup tool that dumps databases, globals, and configuration in flexible formats with encryption and cloud upload support.

Go5626 days ago
pitrery
dalibo.github.io

GUI

36 projects
Adminer
adminer.org
Beekeeper Studio
beekeeperstudio.io
Bytebase
bytebase.com
Chartbrew
chartbrew.com
Count
count.co
DataGrip
jetbrains.com
Datazenit
datazenit.com
DataRow
datarow.com
DBConvert Streams
streams.dbconvert.com
DBeaver
dbeaver.io
dbForge Edge
devart.com
DbVisualizer
dbvis.com
Holistics
holistics.io
JackDB
jackdb.com
Luna Modeler
datensen.com
Mathesar
mathesar.org
Metabase
metabase.com
Numeracy
numeracy.co
pgAdmin
pgadmin.org
pgMagic
pgmagic.app
PgManage
PgManage

A modern, multi-platform database client and administration tool for PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and Oracle.

PLpgSQL1,0103 days ago
pgModeler
pgmodeler.io
Pgweb
Pgweb

A simple, cross-platform web-based PostgreSQL database explorer written in Go, distributed as a single binary.

Go9,3725 days ago
Postbird
Postbird

A cross-platform open-source PostgreSQL GUI client for macOS, Linux, and Windows.

JavaScript1,62511 months ago
PostgresCompare
postgrescompare.com
Postico
eggerapps.at
PSequel
psequel.com
redash
redash

An open-source data visualization and dashboard platform that connects to any data source, enabling teams to query, visualize, and share data insights.

Python28,6237 days ago
SQL Tabs
sqltabs.com
SQLPro for Postgres
macpostgresclient.com
temBoard
temBoard

A web-based administration and monitoring interface for PostgreSQL databases with agent-based architecture.

Python7614 days ago
Teable
Teable

A no-code database platform with a spreadsheet-like interface, built on PostgreSQL for real-time collaboration and scalability.

TypeScript21,31320 hours ago
TablePlus
tableplus.com
Valentina Studio
valentina-db.com
DbGate
dbgate.org
WebDB
webdb.app

Distributions

2 projects
Postgres.app
postgresapp.com
Pigsty
Pigsty

Enterprise-grade open-source PostgreSQL distribution with HA, monitoring, 460+ extensions, and Infrastructure as Code for self-hosting.

Shell5,16028 days ago

CLI

9 projects
Atlas
Atlas

A language-agnostic tool for managing and migrating database schemas using declarative and versioned workflows.

Go8,4634 days ago
pgschema
pgschema.com
pg-schema-diff
pg-schema-diff

A Go library for diffing Postgres schemas and generating SQL migrations with minimal downtime and locks.

Go8565 months ago
pgsh
pgsh

A CLI tool that enables Git-like branching for PostgreSQL databases to simplify local development workflows.

JavaScript6013 years ago
psql
postgresql.org
psql2csv
psql2csv

A command-line tool that runs PostgreSQL queries and outputs results directly as CSV format.

Shell1864 years ago
sabiql
sabiql

A fast, driver-less PostgreSQL TUI written in Rust with vim-first navigation, ER diagrams, and safe editing.

Rust1971 day ago
Schema Spy
Schema Spy

A database metadata analyzer that generates interactive HTML documentation and entity-relationship diagrams.

HTML3,6543 months ago
pdot
gitlab.com

Related Awesome Lists

📦
Database Tools

The "Awesome Database Tools" project is a comprehensive collection of resources aimed at simplifying database management and development. This list covers a wide range of tools, including database management systems, GUI clients, ORM libraries, migration tools, and performance monitoring utilities. It is designed for developers, database administrators, and data analysts of all experience levels, providing them with valuable tools to enhance productivity and streamline workflows. Whether you are looking to optimize your database performance or simplify data manipulation tasks, this collection offers a wealth of resources to support your database endeavors.

5.1k
📦
SQLAlchemy

The "Awesome SQLAlchemy" project is a curated resource list designed to support developers using SQLAlchemy, a powerful SQL toolkit and Object-Relational Mapping (ORM) system for Python. This list includes libraries, extensions, tutorials, documentation, and community resources that enhance the use of SQLAlchemy in various applications. Whether you are a beginner looking to understand the basics of ORM or an experienced developer seeking advanced techniques and best practices, this collection offers valuable insights and tools. Dive into the world of SQLAlchemy and discover how to effectively manage database interactions in your Python projects.

3.0k
🐹
MongoDB

The "Awesome MongoDB" project is a curated collection of resources dedicated to MongoDB, a popular document-oriented NoSQL database designed for scalability and flexibility. This list encompasses a wide range of categories, including official documentation, libraries, tools, tutorials, and community resources that facilitate the use of MongoDB in various applications. Whether you are a beginner looking to learn the basics or an experienced developer seeking advanced techniques, this list offers valuable insights and tools to enhance your MongoDB experience. Dive into this collection to unlock the full potential of MongoDB in your projects.

2.6k
📦
MySQL

The "Awesome MySQL" project is a curated collection of resources dedicated to MySQL, a widely-used open-source relational database management system. This list encompasses a variety of categories including libraries, tools, tutorials, performance optimization techniques, and community resources. It serves as a valuable asset for beginners looking to learn database management as well as experienced developers seeking advanced techniques and best practices. Users can explore everything from basic SQL queries to complex database architectures, making it an essential guide for anyone looking to harness the power of MySQL in their projects.

2.6k