Skip to main content

A curated list of awesome PostgreSQL tools, scripts, slides, and short examples. inspired by the other awesome lists

84
GitHub Stars
35
Curated Resources
4
Categories
18 hours ago
Last Refreshed
Extensions and ToolsUtilitiesBlogsScreencasts

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-postgresql"

Installation instructions →

What's inside

Extensions and Tools

  • Barman

    Backup and recovery manager.

  • Bemi

    Automatic data change tracking for PostgreSQL.

  • Citus

    Citus horizontally scales PostgreSQL across commodity servers using sharding and replication. Its query engine parallelizes incoming SQL queries across these servers to enable real-time responses on large datasets.

  • Depesz

  • ldap2pg

    manage roles and ACL.

  • pg

    Browser PostgreSQL, no server, just client and pglite (postgresql wasm)

Utilities

  • Full text search (PT_BR)

    Deep intro on full text search on postgresql

  • JSON Queries

    Real examples of using lateral joins and recursive queries on JSON structures

  • Listen / Notify in Node.js

    Tiny how to use about listen / notify

  • pgldapsync

    Python module that allows you to synchronize Postgres login roles with users in an LDAP directory

  • pg-ldap-sync

    This program helps to solve the issue by synchronizing users, groups and their memberships from LDAP to PostgreSQL

  • postgresql-ldap-sync

    This program synchronize users, groups and their memberships from LDAP to PostgreSQL

Screencasts

Showing a sample of 35 resources. View the full list on GitHub →