Skip to main content

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

12k
GitHub Stars
314
Curated Resources
18
Categories
19 hours ago
Last Refreshed
High-AvailabilityBackupsGUIDistributionsCLIServerSecurityMonitoringExtensionsPlatformsWork QueuesOptimizationUtilitiesLanguage bindingsPaaS (PostgreSQL as a Service)Docker imagesKubernetesResources

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

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 →