PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pgcozy	1.0	Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.	ADMIN	PostgreSQL	SQL	14–18	2
pgembed	0.1.0	Generate vector embeddings through Ollama, OpenAI, or custom HTTP services	RAG	LicenseRef-Tecnisys-Community-1.0	Python	13–18	2
pgerror	0.2.1	Tools for better error handling	UTIL	MIT	SQL	—	2
pgfga	0.1.0	Experimental ReBAC/Zanzibar-style fine-grained authorization functions for PostgreSQL.	SEC	MIT	Rust	11–16	2
pghll	1.0	Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.	FUNC	MIT	C	—	2
pgocrypto	1.0	encrypt data between Go and PG	SEC	—	SQL	—	2
pgparts	0.0.15	SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers	OLAP	BSD-3-Clause	SQL	—	2
pgpm-base32	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	UTIL	MIT	C	—	2
pgpm-defaults	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	SEC	MIT	C	—	2
pgpm-faker	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgpm-inflection	0.30.0	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgpm-measurements	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FEAT	MIT	C	—	2
pgpm-types	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	TYPE	MIT	C	—	2
pgqbw	1.0	postgres queue backgound worker	FEAT	—	C	—	2
pgsqlauditengine	1.0	SQL policy checks with an embedded rule and audit REST API	SEC	GPL-3.0-only	C	11–18	2
pgsqlmock	1.0.1	Mocking and faking helpers for PostgreSQL unit tests	LANG	PostgreSQL	SQL	14–18	2
pgstrtranslate	1.0	Adds multi-character string replacement and text-array element removal functions.	FUNC	—	C	—	2
pgtoken	1.0	PostgreSQL extension for compact, codebook-compressed LLM token ID storage. Encode once, retrieve forever. O(1) token count without decoding.	RAG	MIT	Python	—	2
pguri	1.0	provide indexable URI and domain-name types and URI text search	TYPE	PostgreSQL	C	—	2
pgxc_dns	1.0	PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover.	ADMIN	PostgreSQL	C	—	2
pigiaminja	0.1.0	PostgreSQL extension to export using Jinja templates	ETL	PostgreSQL	Rust	—	2
pjpg	1.0	provide general-purpose SQL utilities for time zones and ranges	UTIL	MIT	SQL	—	2
pljulia	0.8	Embeds Julia as an untrusted PostgreSQL procedural language with SPI access, DO blocks, triggers, arrays, and composite-type conversion.	LANG	PostgreSQL	C	14–18	2
plpy_venv	1.0	Select and manage Python virtual environments for PL/Python functions.	LANG	—	SQL	—	2
postllm	0.1.0	postllm: PostgreSQL-native access to OpenAI-compatible and local LLM runtimes	RAG	MIT	Rust	13–18	2
postr	0.1.0	Embeds Ruby as an untrusted PostgreSQL procedural language supporting functions, DO blocks, triggers, and set-returning functions.	LANG	MIT	Rust	13–18	2
product_logic	1.1.0	Provides operators to evaluate fuzzy logic expressions according to product logic.	FUNC	BSD-3-Clause	SQL	—	2
proven	0.5.0	proven: PostgreSQL C bindings for formally verified safety functions from libproven	FUNC	MPL-2.0	C	—	2
rasterdb	0.1	rasterdb: filesystem-backed PostGIS raster foreign data wrapper	FDW	—	C	—	2
resources	0.1.0	Linux server resource monitoring views backed by file_fdw PROGRAM foreign tables.	STAT	—	SQL	10–18	2
rpc	1.0	Synchronous JSON-to-JSON RPC client for PostgreSQL over a Unix domain socket, with a companion Go server example	UTIL	—	C	—	2
rtosm	0.1	Real-time simplification of spatial objects in an OpenStreetMap API database.	GIS	GPL-2.0	C	—	2
safecast	0.0.1	Pure-SQL helper functions that return NULL for some invalid text-to-number casts.	FUNC	Apache-2.0	SQL	—	2
setrank	1.0	TF-IDF and cover-density ranking functions for tsvector/tsquery using document-frequency statistics from a table.	FTS	—	C	—	2
siguanet_quest	1.0	Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases.	GIS	GPL-3.0	SQL	10–18	2
similarity	1.0	C extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm.	FTS	GPL-2.0	C	—	2
snowball_ext	1.0	Extensible Snowball text-search dictionary template with a Nepali stemmer.	FTS	PostgreSQL	C	—	2
soundex-type	1.0.0	soundex - type	FTS	PostgreSQL	C	—	2
sparse_vector	0.1	C data type and functions for sparse float vectors, normalization, dot product, and cosine similarity.	RAG	MIT	C	10–18	2
srf	1.0	Minimal C example implementing an inclusive integer set-returning function.	FUNC	—	C	—	2
stat_record	0.4.0	Background-worker snapshot recorder and reporting suite for PostgreSQL server statistics.	STAT	—	C	10–18	2
statsmgr	0.1-alpha	C extension that snapshots PostgreSQL cumulative WAL, SLRU, checkpoint, archiver, I/O, and background-writer statistics in dynamic shared memory.	STAT	PostgreSQL	C	17–18	2
supamonitor	0.0.6	Preloaded pgrx query hook that logs query text, query ID, planning time, and execution time as JSON.	STAT	—	Rust	13–18	2
supasession	0.1.2	Advanced session management for Supabase.	SEC	PostgreSQL	SQL	—	2
svs	0.1.0	SVS Vamana approximate-nearest-neighbor index with LeanVec and LVQ compression for pgvector.	RAG	PostgreSQL	C	—	2
synchronize_logical_slots	1.0	Synchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers.	ETL	—	C	12	2
table_guard	1.0	Configurable protection against DROP, TRUNCATE, and unqualified whole-table DELETE.	SEC	—	C	14–18	2
table_log	0.6.4	record table modification logs and PITR for table/row	ADMIN	PostgreSQL	C	14–18	2
tablelog	0.1	Trigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL.	SEC	—	SQL	10–18	2
track_renames	0.1	Event-trigger function that forwards PostgreSQL object rename details to a configurable callback.	ADMIN	PostgreSQL	C	10–18	2

Quick links

PostgreSQL Extension Catalogue