PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_follower	1.0	Educational logical-replication extension that captures and applies database changes	ETL	—	C	—	2
pg_fossa	1.7	Archived SQL extension supporting FOSSA hasGraph data structures and queries.	FEAT	—	SQL	—	2
pg_fsql	1.1.0	Recursive SQL template engine with JSONB-driven execution	UTIL	PostgreSQL	C	14–18	2
pg_fts_greek	0.1	Postgres FTS Improvements for Greek	FTS	—	SQL	—	2
pg_genotype	1.0	Provides a compact one-byte genotype type that preserves allele order and supports insertion and deletion symbols.	TYPE	PostgreSQL	C	—	2
pg_geohash_extra	0.0.1	Additional geohash functions for PostGIS	GIS	GPL-3.0	C	—	2
pg_get_queryid	1.0	get last queryid generated/used by pg_stat_statements for a given backend pid	STAT	PostgreSQL	C	10–18	2
pg_iceberg_am	0.1.0	Iceberg table developed by Robert Mu	OLAP	Apache-2.0	Rust	—	2
pg_idm	1.0	Exposes PostgreSQL role and membership management through updatable views and DML-trigger functions.	SEC	GPL-3.0	SQL	10–18	2
pg_imputed_genotype	1.0	Store imputed-genotype probability triples in a packed four-byte PostgreSQL type.	TYPE	PostgreSQL	C	—	2
pg_inet_addr	1.0	Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces.	STAT	BSD-3-Clause	C	10–18	2
pg_intmap	0.1	Compressed integer-to-integer map	TYPE	—	C	—	2
pg_knowledge_graph	0.1.0	Knowledge graph extension for PostgreSQL with graph algorithms and pgvector integration.	RAG	MIT	Rust	16–18	2
pg_lakebase_runtime	0.1.0	Shared runtime for Lakebase table access method extensions	OLAP	Apache-2.0	Rust	—	2
pg_liquid	0.1.7	Liquid-inspired Datalog graph query extension for PostgreSQL	FEAT	MIT	C	14–18	2
pg_lock_pool	0.0.1	Wait on a PostgreSQL advisory lock pool	ADMIN	PostgreSQL	SQL	12–17	2
pg_lockwatch	0.1.0	Sample blocking chains and score lock-contention risk	STAT	—	Rust	15–18	2
pg_log	1.0.0	displays log content from SQL	STAT	PostgreSQL	C	—	2
pg_login_stat	1.0	Per-user and per-database successful and failed authentication counters.	STAT	—	C	15–17	2
pg_median_utils	0.0.1	Median filter and iterative median filter window functions for PostgreSQL	FUNC	MIT	C	10–18	2
pg_metrics	1.0	Collects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions.	STAT	—	C	—	2
pg_money	0.3.0	Exact currency-aware monetary types, arithmetic, and allocation	TYPE	MIT	Rust	14–18	2
pg_monitoring	0.2	Provides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics.	STAT	PostgreSQL	SQL	10–18	2
pg_pageinspect_plus	1.0	Decode heap tuple data obtained with PostgreSQL pageinspect helpers	ADMIN	BSD-3-Clause	C	10–18	2
pg_procfs	0.0.1	displays /proc data from SQL	STAT	PostgreSQL	C	—	2
pg_promoter	1.0	pg promoter is simplified clustering module based on bgworker.	ADMIN	—	C	—	2
pg_pwhash	1.0	Advanced password hashing methods for PostgreSQL	SEC	MIT	C	14–18	2
pg_querylog	0.1	Captures current and recently completed backend queries in shared memory for SQL inspection.	STAT	—	C	10–12	2
pg_repeater	0.1	Replicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw.	ETL	PostgreSQL	C	—	2
pg_sample_ext	1.0.2	A Sample PostgreSQL extension	FUNC	PostgreSQL	SQL	—	2
pg_set_level	0.0.1	trigger action for SET statement	ADMIN	PostgreSQL	C	—	2
pg_sexp	0.1.0	Adds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing.	TYPE	Apache-2.0	C	14–18	2
pg_sexp_rs	0.1.0	PostgreSQL extension to add support for s-expressions store, query, index.	TYPE	Apache-2.0	Rust	—	2
pg_ssl	1.0	Create base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL	SEC	MIT	C	—	2
pg_str	0.3.1	Add Laravel-inspired string manipulation functions to PostgreSQL using pgrx	FUNC	MIT	Rust	11–15	2
pg_strverscmp	1.0	Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.	FUNC	ISC	C	—	2
pg_table_range	0.1.1	Planning-time partition pruning by per-partition data ranges, including non-key columns.	OLAP	MIT	Rust	16–18	2
pg_tamagotchi	0.1.0	A pet for your postgres db	FEAT	—	C	—	2
pg_tamperlog	1.1	Tamper-evident append-only audit logging with hash chaining	SEC	—	SQL	—	2
pg_tamperlog_rust	1.0.0	Rust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations.	SEC	—	Rust	—	2
pg_thud	0.1.0	Framework extending pgtap with scaffolding and test-data helpers for database unit tests.	FEAT	PostgreSQL	SQL	10–18	2
pg_tms	0.0.4	functions to tile rasters in TMS format	GIS	MIT	SQL	10–18	2
pg_toastinspect	1.0	Low-level inspection of TOAST chunk identifiers, sizes, and stored values.	ADMIN	PostgreSQL	C	—	2
pg_trex	0.1.0	pg trex: PostgreSQL extension for distributed trexsql	OLAP	—	Rust	—	2
pg_upless	0.0.3	Detect Useless UPDATE	ADMIN	PostgreSQL	SQL	14–18	2
pg_visibilitymap	1.0	Inspect relation visibility-map bits on historical PostgreSQL releases.	ADMIN	—	C	—	2
pg_wal_ext	1.0	Read WAL files and possibly generate the SQL	ETL	MIT	C	—	2
pg_web	0.1.0	Run an embedded HTTP server from a PostgreSQL background worker	FEAT	MIT	C	—	2
pg_xclaim	1.0.0-rc1	High-cardinality transaction-scoped logical claim primitive for PostgreSQL	FEAT	PostgreSQL	C	—	2
pgcodec7	1.0	C extension that encodes and decodes bytea values using compact 7-bit or 6-bit text grouping.	UTIL	—	C	11	2

Quick links

PostgreSQL Extension Catalogue