awesome-postgresql
github.com/awesomelistsio/awesome-postgresql ↗A curated list of awesome libraries, tools, frameworks, and resources for PostgreSQL, an advanced open-source relational database system known for its performance, extensibility, and SQL compliance.
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me libraries and clients resources from awesome-postgresql"
Installation instructions →What's inside
Libraries and Clients
- ActiveRecord PostgreSQL Adapter
The PostgreSQL adapter for Ruby on Rails.
- Diesel
A safe and extensible ORM and query builder for Rust, supporting PostgreSQL.
- JDBC PostgreSQL Driver
The official JDBC driver for PostgreSQL.
- node-postgres
A comprehensive PostgreSQL client for Node.js.
- pgx
A PostgreSQL driver and toolkit for Go that aims to be feature-rich and performant.
- psycopg2
The most popular PostgreSQL driver for Python.
Replication and Clustering
- Bucardo
A multi-master replication system for PostgreSQL.
- Citus
A distributed database solution for scaling PostgreSQL horizontally.
- Patroni
A high-availability solution for PostgreSQL based on streaming replication.
- pgPool-II
A middleware for PostgreSQL that provides connection pooling and load balancing.
- Spock
Logical multi-master PostgreSQL replication.
- Streaming Replication
The built-in streaming replication feature of PostgreSQL.
GUI Tools
- DataGrip
A powerful database IDE by JetBrains, with PostgreSQL support.
- DBeaver
A universal database tool supporting PostgreSQL and other databases.
- HeidiSQL
A lightweight and fast database client for Windows, supporting PostgreSQL.
- pgAdmin
The most popular open-source administration and development platform for PostgreSQL.
- TablePlus
A modern, native GUI tool for PostgreSQL and other databases.
Data Modeling and Schema Design
- DBDiagram
An online tool for visualizing database schemas, including PostgreSQL.
- ERAlchemy
A tool to generate Entity-Relationship (ER) diagrams from PostgreSQL databases.
- pgModeler
An open-source database modeler for PostgreSQL.
- PostgreSQL Schema Design Guide
Official PostgreSQL documentation on schema design.
Optimization and Monitoring
- EXPLAIN
A command to analyze and optimize query performance.
- pgHero
A performance monitoring tool for PostgreSQL.
- pg_stat_monitor
A statistics collection extension for PostgreSQL query performance monitoring.
- PMM (Percona Monitoring and Management)
A monitoring tool for PostgreSQL and other databases.
Backup and Migration
- Flyway
A database migration tool that supports PostgreSQL.
- Liquibase
An open-source tool for managing and tracking database schema changes.
- pgBackRest
Reliable, flexible backup and restore solution for PostgreSQL.
- pg_dump
The built-in PostgreSQL utility for backing up databases.
- WAL-G
A backup and restore tool for PostgreSQL with support for continuous archiving.
Learning Resources
- Leetcode: PostgreSQL Problems
Practice SQL queries with PostgreSQL challenges on Leetcode.
- Postgres Guide
A guide for developers to learn and use PostgreSQL effectively.
- PostgreSQL Documentation
The official PostgreSQL reference documentation.
- PostgreSQL Tutorial
A comprehensive guide to PostgreSQL, covering basic to advanced topics.
- The Art of PostgreSQL
A blog with articles on advanced PostgreSQL techniques.
Extensions
- pgcrypto
A cryptographic extension for PostgreSQL, providing various hashing and encryption functions.
- pg_stat_statements
A module that tracks execution statistics of all SQL statements.
- PostGIS
A spatial database extender for PostgreSQL, adding support for geographic objects.
- TimescaleDB
A time-series database built on top of PostgreSQL.
Showing a sample of 45 resources. View the full list on GitHub →