PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_mockable	1.1.0	Create mockable wrappers for PostgreSQL functions in tests	LANG	PostgreSQL	SQL	14–18	8
pg_no_seqscan	0.1.1	Prevents or reports sequential scans in development and CI by inspecting query plans.	FEAT	MIT	Rust	14–18	8
pg_orca	1.0.0	ORCA query optimizer as a PostgreSQL extension	OLAP	Apache-2.0	C++	18	8
pg_pageprep	0.1	Prepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise.	ETL	PostgreSQL	C	10–11	8
pg_rowalesce	0.1.12	rowalesce() is like coalesce(), but for rows and other composite types.	FUNC	PostgreSQL	SQL	—	8
pg_semantic_cache	0.1.0-beta4	Caches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies.	RAG	PostgreSQL	C	14–18	8
pg_tileless	0.1	Tools for packaging twkb in sqlite for tileless	GIS	GPL-2.0	C	—	8
pgbrotli	1.0	Brotli compression and decompression functions for PostgreSQL.	UTIL	—	C	10–14	8
pgjwt_rs	0.1.2	JWT verification for RS256 and Ed25519 tokens inside PostgreSQL	SEC	MIT	Rust	13–18	8
pgmock	0.2	SQL/PLpgSQL extension for mocking function and table dependencies in PostgreSQL unit tests	FEAT	MIT	SQL	10	8
pgotel	1.0	PostgreSQL extension exposing OpenTelemetry functionality for other extensions.	STAT	Apache-2.0	C++	—	8
plid	0.0.0	A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation.	TYPE	MIT	Rust	13–18	8
plswipl	0.1	Execute PostgreSQL functions and inline blocks in an embedded SWI-Prolog runtime	LANG	MIT	C	—	8
progress	0.0.1	progress: query-progress estimation for a patched PostgreSQL 9.3 development branch	STAT	PostgreSQL	C	—	8
sveddy	0.1.0	A PostgreSQL extension for collaborative filtering using low-rank matrix approximation techniques.	RAG	MIT	C	—	8
telephone	0.0.1	PostgreSQL data type for normalized telephone numbers with dialing-plan validation.	TYPE	PostgreSQL	C	10–18	8
treasuredata_fdw	1.2	C foreign data wrapper backed by a Rust td-client bridge for querying and inserting Treasure Data datasets.	FDW	Apache-2.0	C	10–18	8
tzf	0.3.0	Fast lookup timezone name by GPS coordinates	GIS	MIT	Rust	14–18	8
unique_id	1.0	Time-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs.	FUNC	BSD-3-Clause	C	—	8
yeti	1.14.1	helper functions for YETI project	FUNC	—	C	16–18	8
bktree	1.0	SP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches.	RAG	—	C	15	7
bwcontrol	1.0	Bottledwater control extension	ETL	PostgreSQL	C	10–18	7
cbor	0.1.0	Concise Binary Object Representation data type for PostgreSQL.	TYPE	PostgreSQL	C	10–18	7
cms_topn	1.0.0	Count-min sketch data type and aggregates for approximate frequency and top-N queries	FUNC	—	C	—	7
dc_fdw	1.0	Historical foreign data wrapper for document collections stored on local disk.	FDW	—	C	—	7
douban_fdw	1.0	Foreign data wrapper for querying Douban public movie-ranking APIs	FDW	MIT	Go	10–18	7
drop_role_helper	1.0	Generates SQL to revoke all privileges held by a role in the current database.	SEC	PostgreSQL	SQL	—	7
fhirpath	1.0	data type for jsonb inspection	FEAT	—	C	—	7
gogudb	1.1	PostgreSQL extension for distributed hash and range partitioning across foreign servers.	OLAP	PostgreSQL	C	10–11	7
grpc_fdw	1.0	Foreign data wrapper that delegates table operations to services over gRPC.	FDW	—	Rust	—	7
hamming_distance	0.0.1	Hamming distance and similarity functions for hexadecimal feature-vector strings.	RAG	MIT	C	—	7
hashtypes	0.1.5	sha1, md5 and other data types for PostgreSQL	TYPE	PostgreSQL	C	14–18	7
hstore_plpython2u	1.0	transform between hstore and plpython2u	LANG	—	C	—	7
intpair	0.2	Packed int64pair data type with comparison, hash, and index operator support.	TYPE	Apache-2.0	C	—	7
jansson-json	0.0.2	JSON data type, operators, and functions backed by the Jansson JSON library.	TYPE	MIT	C	10–18	7
noddl	1.0	Cluster-wide DDL blocker with role and database exceptions.	SEC	MIT	C	—	7
norm	0.0.1	No-ORM helper extension that generates simple CRUD functions.	FEAT	GPL-3.0	SQL	—	7
pg-json	0.0.1	A json data type and related functions	TYPE	MIT	C	—	7
pg_bigmr	0.1.0	text similarity measurement and index searching based on bigrams	FTS	PostgreSQL	Rust	12–17	7
pg_cuvs	0.5.0	⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS.	RAG	PostgreSQL	C	—	7
pg_debug_scan	0.1.0	Debug PostgreSQL table scans with custom MVCC snapshot definitions.	FEAT	Apache-2.0	Rust	11–16	7
pg_drop_events	0.1.0	logs transaction ids of drop table, drop column, drop materialized view statements	ADMIN	PostgreSQL	SQL	14–18	7
pg_feedback	1.0	PostgreSQL extension that generates a report about database usage	STAT	PostgreSQL	C	—	7
pg_jinx	2.3	JNI bridge for PostgreSQL stored procedures, triggers, and foreign data wrappers written in Java.	LANG	—	C	—	7
pg_kafka_events	1.0	Publishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker.	ETL	Apache-2.0	C	—	7
pg_landmetrics	0.0.1	A PostgreSQL/PostGIS extension for calculating landscape metrics.	GIS	GPL-3.0	SQL	—	7
pg_linegazer	1.0	Transparent code coverage for PL/pgSQL	LANG	MIT	C	—	7
pg_markdown	0.1	Pre-release Markdown-to-HTML conversion extension for PostgreSQL.	UTIL	PostgreSQL	C	—	7
pg_partition	0.2.0	Generate and manage timestamp-based PostgreSQL table partitions	OLAP	MIT	SQL	10–18	7
pg_safer_settings	1.0.0	Functions and mechanisms for handling PostgreSQL settings more safely.	ADMIN	PostgreSQL	SQL	—	7

Quick links

PostgreSQL Extension Catalogue