awesome-postgresql
github.com/devton/awesome-postgresql ↗A curated list of awesome PostgreSQL tools, scripts, slides, and short examples. inspired by the other awesome lists
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me extensions and tools resources from awesome-postgresql"
Installation instructions →What's inside
Extensions and Tools
- 1bench
Desktop client for PostgreSQL with pgvector support, plus two dozen other engines.
- 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.
- dbdiff
Compare PostgreSQL schemas, detect drift, and generate migration SQL for review, including offline SQL-file and snapshot comparisons.
- Depesz
Resources
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 42 resources. View the full list on GitHub →