PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
opm_core	2.6	Central module of the OPM suite	STAT	PostgreSQL	C	—	146
postal	1.0	PostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components.	GIS	MIT	C	10–18	146
psql_bm25s	0.4.14	PostgreSQL extension for BM25-family lexical retrieval	FTS	Apache-2.0	C	17–18	146
hdfs_fdw	2.0.5	foreign-data wrapper for remote hdfs servers	FDW	PostgreSQL	C	14–18	141
pgcalendar	1.1.0	Recurring calendar, schedule, and exception management for PostgreSQL	TYPE	MIT	SQL	14–18	141
postpic	0.9.1	A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities.	TYPE	LGPL-3.0	C	—	137
pg_trickle	0.107.0	Streaming tables and differential view maintenance for PostgreSQL 18	FEAT	Apache-2.0	Rust	18	135
pgprolog	0.0.0	PostgreSQL procedural language handler for Prolog, embedding Scryer Prolog.	LANG	BSD-3-Clause	Rust	11–16	134
basejump-supabase_test_helpers	0.0.6	A collection of functions designed to make testing Supabase projects easier.	FEAT	MIT	SQL	—	131
kv_fdw	0.0.1	Foreign data wrapper for key-value storage backed by RocksDB/VidarDB.	FDW	Apache-2.0	C++	13	131
pg_ducklake	1.0.0	DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet	OLAP	MIT	C++	14–18	130
postgres_protobuf	0.2	C++ functions for querying protobuf values stored as bytea and converting Protocol Buffers to and from their JSON representation.	UTIL	MIT	C++	11–18	130
goldenmatch_pg	0.13.0	GoldenMatch entity-resolution functions for deduplication, matching, scoring, and golden-record workflows.	RAG	MIT	Rust	15–17	129
plr	8.4.8.6	load R interpreter and execute R script from within a database	LANG	GPL-2.0	C	14–18	128
smlar	1.0	Effective similarity search	RAG	—	C	14–18	128
www_fdw	0.1.9	Foreign data wrapper for accessing web services from PostgreSQL.	FDW	PostgreSQL	C	—	126
graph_accel	0.5.0	In-memory graph traversal acceleration extension for Apache AGE.	FEAT	Apache-2.0	Rust	13–18	124
pg_stat_ch	0.4	Export PostgreSQL query telemetry to ClickHouse	STAT	Apache-2.0	C++	16–18	123
ora_migrator	1.1.0	Tools to migrate Oracle databases to PostgreSQL	ETL	PostgreSQL	SQL	10–18	121
pg_plan_advsr	0.1	Automated execution plan tuning extension	FEAT	—	C	12–16	121
pg_turret	0.0.0	Capture PostgreSQL logs and export structured events to HTTP, Kafka, or Sentry	STAT	MIT	Rust	13–18	121
launchql-base32	0.0.3	RFC6238 TOTP implementation in pure PostgreSQL plpgsql	SEC	MIT	C	—	118
tin	1.0.3	TIN-compatible text search for development and testing	FTS	AGPL-3.0-or-later	Rust	17–18	117
multicorn	3.2	Fetch foreign data in Python in your PostgreSQL server.	FDW	PostgreSQL	C	14–18	116
tuid	0.3.0	tuid datatype	FUNC	MIT	C	—	114
kafka_fdw	0.0.3	kafka Foreign Data Wrapper for CSV formatted messages	FDW	PostgreSQL	C	14–18	113
pxf	1.0	Historical Greenplum extension for accessing unmanaged data through PXF.	FDW	Apache-2.0	C	—	113
cartodb	0.37.1	Archived PostgreSQL extension for turning a database into a CartoDB user database.	GIS	BSD-3-Clause	Python	11–18	112
kafka	0.0.1	Produce messages to Apache Kafka from PostgreSQL	ETL	MIT	C	10–18	112
pgfincore	1.4.0	examine and manage the os buffer cache	ADMIN	BSD-3-Clause	C	14–18	111
synchdb	1.0	Mixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources.	ETL	Apache-2.0	C	16–18	111
json_fdw	1.0	Foreign data wrapper for local and remote JSON document access.	FDW	GPL-3.0	C	—	110
pg_statviz	1.2	Capture PostgreSQL statistics snapshots for time-series analysis and visualization	STAT	PostgreSQL	SQL	14–18	108
kmeans	1.1.0	K-means clustering window function for PostgreSQL	RAG	PostgreSQL	C	10–18	106
pg_failover_slots	1.2.1	PG Failover Slots extension	ETL	PostgreSQL	C	14–18	106
prefix	1.2.11	Prefix Range module for PostgreSQL	TYPE	PostgreSQL	C	14–18	106
pgbson	2.1.0	BSON data type and accessor functions for PostgreSQL	TYPE	MIT	C	14–18	104
plprofiler	4.2.5	server-side support for profiling PL/pgSQL functions	LANG	Artistic-1.0	C	14–18	104
eva_pg	0.0.1	EVA ICS pgrx extension for the EVA industrial IoT platform.	FUNC	Apache-2.0	Rust	13–18	103
metagration	1.0.4	Migrate Postgres with Postgres	ETL	PostgreSQL	SQL	—	102
pg_sqids	0.1.0	Encode numbers as short URL-safe Sqids and decode them in PostgreSQL	FUNC	MIT	Rust	13–18	102
pgextwlist	1.20	PostgreSQL Extension Whitelisting	SEC	PostgreSQL	C	14–18	102
rag	0.0.0	Deprecated RAG helper extension for document extraction/chunking and remote embedding, reranking, and chat APIs.	RAG	Apache-2.0	Rust	13–18	101
rag_bge_small_en_v15	0.0.0	rag_bge_small_en_v15: local bge-small-en-v1.5 embeddings in PostgreSQL	RAG	Apache-2.0	Rust	13–18	101
rag_jina_reranker_v1_tiny_en	0.0.0	Runs jina-reranker-v1-tiny-en locally in a preloaded background worker and exposes SQL rerank scores and distances.	RAG	Apache-2.0	Rust	13–18	101
pg_bestmatch	0.0.2	Generate BM25 sparse vector inside PostgreSQL	FTS	Apache-2.0	Rust	14–18	100
pg_column_tetris	0.1.0	Enforce optimal column alignment to minimize row padding	ADMIN	MIT	SQL	14–18	100
uuidv7-sql	1.1	Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values.	FUNC	PostgreSQL	SQL	—	100
pgl_ddl_deploy	2.2.1	automated ddl deployment using pglogical	ETL	MIT	C	14–18	99
pgtt	4.6	Extension to add Global Temporary Tables feature to PostgreSQL	SIM	ISC	C	14–18	99

Quick links

PostgreSQL Extension Catalogue