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
1 hour 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 →