PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
mumak	0.0.6	Cardano CBOR parser	UTIL	Apache-2.0	Rust	11–16	19
online_advisor	1.0	Suggest missing indexes and extended statistics online	ADMIN	PostgreSQL	C	14–18	19
pg_backtrace	1.0	Show backtrace for errors and signals	STAT	PostgreSQL	C	—	19
pg_diffix	fir	Provides strong dynamic anonymization for PostgreSQL query results.	SEC	MIT	C	13–18	19
pg_math	1.1.0	GSL statistical functions for postgresql	FUNC	GPL-3.0	C	14–18	19
pg_normalize_query	1.0	Normalize constants in SQL statements using PostgreSQL parser logic	FUNC	BSD-3-Clause	C	10–13	19
pg_otel_tracer	0.1.0	Rust based Postgres extension that adds query lifecycle events to OTEL traces.	STAT	—	Rust	—	19
pg_readonly	1.0.6	cluster database read only	ADMIN	PostgreSQL	C	14–18	19
pg_stats	1.0	Customized statistics views	STAT	—	SQL	—	19
pg_strict	1.0.5	Prevent dangerous UPDATE and DELETE without WHERE clause	ADMIN	MIT	Rust	14–18	19
pg_zlog	0.1	Logical table replication using Ceph and ZLog	ETL	—	C	—	19
pgs2	0.0.1	Postgres extension for S2 spherical geometry	GIS	Apache-2.0	C	—	19
pgsampler	1.0	Experimental PostgreSQL background worker that collects time-series status and performance metrics.	STAT	PostgreSQL	C	—	19
pgsocket	1.0	send bytes from PostgreSQL to a TCP/IP socket	UTIL	BSD-3-Clause	C	10	19
re2	0.4.1	ClickHouse-compatible regex functions using RE2	UTIL	PostgreSQL	C++	16–18	19
adaptive_counter	1.3.3	Aggregation functions and data type for distinct estimation based on adaptive sampling.	FUNC	BSD-3-Clause	C	10–18	18
ast_postgis	1.1.1	Advanced spatial data types and spatial integrity constraints for PostGIS.	GIS	MIT	SQL	15–17	18
bitmap_counter	1.3.5	Aggregation functions and data type for distinct estimation based on s-bitmap.	FUNC	BSD-3-Clause	C	10–18	18
ccnumber	1.0	data type representing encrypted CC numbers	TYPE	—	C	—	18
hyperloglog_counter	1.2.6	Aggregation functions and data type for distinct estimation based on HyperLogLog.	FUNC	BSD-2-Clause	C	10–18	18
loglog_counter	1.2.4	Aggregation functions and data type for distinct estimation based on LogLog.	FUNC	BSD-2-Clause	C	10–18	18
pcsa_counter	1.3.3	Aggregation functions and data type for distinct estimation based on PCSA.	FUNC	BSD-2-Clause	C	10–18	18
pg_fhe	0.1	Microsoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL.	SEC	—	C++	—	18
pg_healpix	1.0	Provides PostgreSQL functions that convert sky coordinates to and from HEALPix nested and ring pixel identifiers.	GIS	GPL-2.0	C	10–13	18
pg_sampletolog	2.0.0	Samples statements or whole transactions into PostgreSQL logs through executor and utility hooks.	STAT	PostgreSQL	C	10–11	18
pg_slug_gen	1.0.0	Generate cryptographically secure timestamp-based slugs	FUNC	MIT	C	15–18	18
pg_stat_sysinfo	0.0.1	Query host load, CPU, memory, swap, and disk statistics from PostgreSQL, with optional shared-memory caching.	STAT	MIT	Rust	14–15	18
pgpyml	0.3.1	Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers.	RAG	PostgreSQL	Python	—	18
pgtokdb	0.0.1	PostgreSQL to kdb+ Extension	FDW	Apache-2.0	C	—	18
pgzan	0.0.0	Proof-of-concept pgrx extension for evaluating Zanzibar-style authorization inside PostgreSQL row-level security policies.	SEC	—	Rust	11–15	18
probabilistic_counter	1.3.3	A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm.	FUNC	BSD-2-Clause	C	10–18	18
quasar_fdw	1.4.1	quasar_fdw: push PostgreSQL queries down to Quasar-supported data backends	FDW	Apache-2.0	C	—	18
solverapi	1.2	SolveDB: A PostgreSQL-based DBMS for optimization applications	FEAT	Apache-2.0	Shell	—	18
sphinxlink	1.4	C extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol.	FTS	—	C	—	18
superloglog_counter	1.2.3	C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm.	FUNC	BSD-3-Clause	C	10–18	18
wal2mongo	1.0.7	PostgreSQL logical decoding output plugin for MongoDB	ETL	Apache-2.0	C	14–18	18
zcurve	1.3	Two- and three-dimensional Z-order bit interleaving plus direct range lookup over numeric B-tree indexes.	GIS	—	C	—	18
arraymath	1.1	Array math and operators that work element by element on the contents of arrays	FUNC	MIT	C	14–18	17
base36	1.0.0	Integer Base36 types	FUNC	MIT	C	14–18	17
base36_gist	1.0	PostgreSQL base36 data type input/output support, internally a bigint.	FEAT	—	C	—	17
monq	0.1	MongoDB-like query support for jsonb data	SIM	—	C	10–18	17
mpartman	0.1.1	Modern partition manager for PostgreSQL	OLAP	MIT-0	SQL	—	17
pg_datasentinel	1.0	Observability and activity monitoring extension for PostgreSQL	STAT	BSD-3-Clause	C	15–18	17
pg_geohash	1.0	Handle geohash based functionality for spatial coordinates	GIS	MIT	C	14–18	17
pg_quota	1.0	Enforce soft per-role disk-space quotas with background workers	ADMIN	PostgreSQL	C	—	17
pg_sentence_transformer	0.1	Runs a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table.	RAG	BSD-2-Clause	Python	—	17
pg_tsparser	1.0	Parser for PostgreSQL text search	FTS	PostgreSQL	C	—	17
pgqr	1.0	QR Code generator from PostgreSQL	UTIL	BSD-3-Clause	C	14–18	17
pgspeck	1.0	Encrypt and decrypt 32-bit and 48-bit integer blocks with the Speck symmetric cipher	SEC	MIT	C	10–18	17
pgtt_rsl	2.0.0	Provide Oracle/DB2-style global temporary tables using unlogged tables, row-level security, views, and a cleanup worker	SIM	PostgreSQL	C	10–18	17

Quick links

PostgreSQL Extension Catalogue