awesome-postgres
github.com/dhamaniasad/awesome-postgres ↗A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me blogs resources from awesome-postgres"
Installation instructions →What's inside
Security
- Acra
SQL database security suite: proxy for data protection with transparent "on the fly" data encryption, SQL firewall (SQL injections prevention), intrusion detection system.
GUI
- Adminer
Full-featured database management tool written in PHP.
- Beekeeper Studio
Free and open source SQL client with a modern UI and great Postgres support. Cross platform.
- Bytebase
Database DevSecOps solution for Developer, Security, DBA, and Platform Engineering teams.
- Chartbrew
Create live dashboards, charts, and client reports from PostgreSQL data. Features a query tool that works with SQL.
- Count
Web-based analytics platform with a notebook interface which connects to PostgreSQL (Commercial Software).
- DataGrip
IDE with advanced tool sets and good cross-platform experience (Commercial Software).
Extensions
- AGE
Adds fully-functional graph database support including Cypher queries.
- Citus
Scalable PostgreSQL cluster for real-time workloads.
- cstore_fdw
Columnar store for analytics with PostgreSQL.
- cyanaudit
Cyan Audit provides in-database logging of all DML activity on a column-by-column basis.
- Extensions listing by joelonsql
1000+ PostgreSQL extensions.
- HypoPG
HypoPG provides hypothetical/virtual indexes feature.
Server
- AgensGraph
Powerful graph database based on the PostgreSQL.
- Apache Cloudberry
And MPP PostgreSQL fork. Open source alternative to Greenplum Database.
- FerretDB
A truly Open Source MongoDB alternative on top of PostgreSQL.
PaaS (PostgreSQL as a Service)
- Aiven PostgreSQL
PostgreSQL as a service in AWS, Azure, DigitalOcean, Google Cloud and UpCloud; plans range from $19/month single node instances to large highly-available setups, free trial for two weeks.
- Amazon RDS for PostgreSQL
Amazon Relational Database Service (RDS) for PostgreSQL
- Azure Database for PostgreSQL
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service. It provides builtin HA, elastic scaling and native integration with Azure ecosystem.
- Crunchy Bridge
Fully managed Postgres from the Postgres experts. Available across all major cloud providers: Amazon AWS, Google GCP, Microsoft Azure. No lock-in with full super-user support.
- Database Labs
Get a production-ready cloud PostgreSQL server in minutes, from $20 a month Backups, monitoring, patches, and 24/7 tech support all included.
- DigitalOcean Managed Databases
Fully managed PostgreSQL databases. No free plan. Starting at $15/mo. Daily backups with point-in-time recovery. Standby nodes with auto-failover.
Resources
- Andrew Dunstan's PostgreSQL and Technical blogBlogs
- Backup and recover a PostgreSQL DB using wal-eTutorials
Tutorial about setting up continuous archiving in PostgreSQL using wal-e.
- BigData Boutique Blog / PostgreSQLBlogs
Blog by the BigData Boutique team, mostly with analytics focus).
- Bruce Momjian's PostgreSQL blogBlogs
- Citus Data Youtube channelVideos
Citus related videos
- Craig Kerstiens PostgreSQL postsBlogs
Set of posts on PostgreSQL cool features, tips and tricks.
Work Queues
- @andyrmitchell/pg-queue
The 'No Maintenance' Postgres Queue for Node.js
- BeanQueue
A Python work queue framework based on SKIP LOCKED, LISTEN and NOTIFY
- dbos
Durable workflows in Typescript and Python
- Graphile Worker
A high performance job queue for PostgreSQL, written in Node.js
- pgBoss
Queueing jobs in Postgres from Node.js like a boss.
- pgmq
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Utilities
- apgdiff
Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one.
- bemi
Automatic data change tracking for PostgreSQL
- diesel-guard
Linter for dangerous Postgres migration patterns in Diesel and SQLx.
- ERAlchemy
ERAlchemy generates Entity Relation (ER) diagram from databases.
- flyway
Schema migration tool for Postgres and others.
- GatewayD
Cloud-native database gateway and framework for building data-driven applications. Like API gateways, for databases.
Showing a sample of 314 resources. View the full list on GitHub →