PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
kor_search	1.0.0	A PostgreSQL extension for Korean-English text search.	FTS	MIT	C	16	37
logerrors	2.1.5	Function for collecting statistics about messages in logfile	SEC	BSD-3-Clause	C	14–18	37
pgflake	0.0.1	Extension for fdw memory	FUNC	Apache-2.0	C	11–18	37
pgnats	1.1.0	NATS messaging integration with publish, subscribe, JetStream, key-value, and object store SQL APIs	ETL	MIT	Rust	14–18	37
promscale	0.8.0	Deprecated tables, types, and functions supporting Promscale.	STAT	—	Rust	—	37
rdf_fdw	2.7.0	Foreign data wrapper for RDF triplestores over SPARQL endpoints	FDW	MIT	C	14–18	37
sqlbench	1.0.0	a forked project from dbt2, can do a standard TPC-C test.	FEAT	—	C	—	37
texcaller	0	PostgreSQL functions for converting TeX or LaTeX source to DVI or PDF.	UTIL	MIT	C	10–18	37
fixeddecimal	1.1.0	Fixed-precision decimal type optimized for performance and storage.	TYPE	PostgreSQL	C	10–18	36
hstore_plruby	1.0	Transform between hstore and Ruby Hashes for PL/Ruby	LANG	MIT	C	11–18	36
jsonb_plruby	1.0	Transform between jsonb and native Ruby data for PL/Ruby	LANG	MIT	C	11–18	36
ltree_plruby	1.0	Transform between ltree and Ruby Arrays for PL/Ruby	LANG	MIT	C	11–18	36
pg_keeper	2.0	Background-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure.	ADMIN	PostgreSQL	C	—	36
pgbouncer_fdw	1.4.0	Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions	FDW	PostgreSQL	SQL	14–18	36
pgedge_vectorizer	1.1	Asynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector.	RAG	PostgreSQL	C	14–18	36
plruby	2.5	Embed MRI Ruby as an untrusted PostgreSQL procedural language	LANG	MIT	C	11–18	36
go_fdw	1.0	Experimental Go/cgo project template for building PostgreSQL foreign data wrappers.	FDW	MIT	Go	—	35
istore	0.1.12	Integer-to-integer key/value store for analytic workloads.	TYPE	MIT	C	10–16	35
ldap_fdw	0.1.1	Foreign data wrapper for querying LDAP servers	FDW	PostgreSQL	C	—	35
pg_headerkit	1.0	PostgreSQL SQL functions for reading PostgREST request headers inside database code	UTIL	ISC	SQL	—	35
pg_oidc_validator	1.1.0	OAuth and OIDC token validator for PostgreSQL 18	SEC	Apache-2.0	C++	18	35
pgcolumnar	1.0-alpha4	Native column-oriented table access method with compression, vectorized scans, and Parquet workflows.	OLAP	MIT	C	15–19	35
random_bytea	1.0	scrap code and various bug test cases for linking from bugtrackers	FUNC	—	C	—	35
vasco	0.1.0	discover hidden correlations in your data with MIC	FUNC	GPL-3.0	C	14–18	35
bgw_replstatus	1.0.8	Small PostgreSQL background worker to report whether a node is a replication master or standby	STAT	PostgreSQL	C	14–18	34
first_last_agg	0.1.4	first() and last() aggregate functions	FUNC	PostgreSQL	C	14–18	34
icu_ext	1.11.0	Access ICU functions	UTIL	PostgreSQL	C	14–18	34
jsonbx	1.0	Jsonb extension functions for PostgreSQL 9.4	FUNC	PostgreSQL	C	—	34
pg_crash	1.0	Send random signals to random processes	ADMIN	BSD-3-Clause	C	14–18	34
fio	1.0	PostgreSQL File I/O Functions	ADMIN	BSD-3-Clause	C	14–18	33
login_hook	1.7	login_hook - hook to execute login_hook.login() at login time	SEC	GPL-3.0	C	14–18	33
neo4j_fdw	1.0	C foreign data wrapper for Neo4j Cypher query results.	FDW	—	C	—	33
pg_themis	1.0	PostgreSQL encryption and decryption functions backed by the Themis cryptographic library.	SEC	Apache-2.0	C	—	33
pg_track_optimizer	0.9.2	Track planning decisions in comparison with execution reality	STAT	MIT	C	17–18	33
postgres_web3	1.0	Optimized PostgreSQL types and operators for 128/256-bit signed and unsigned integers plus 160/256-bit hexadecimal web3 values.	TYPE	MIT	C	15	33
couchdb_fdw	1.0	Foreign data wrapper for querying CouchDB from PostgreSQL.	FDW	PostgreSQL	C	—	32
nextgres_idcp	0.1.0	NEXTGRES in-database connection pool extension for PostgreSQL.	ADMIN	NEXTGRES	C	16	32
pg_cryogen	0.1	Experimental append-only compressed table access method for PostgreSQL 12 and later.	OLAP	PostgreSQL	C	12–18	32
pgmp	1.0.6	Multiple Precision Arithmetic extension	TYPE	LGPL-3.0	C	14–18	32
plx	2.0.0	Transpile multiple procedural dialects to PL/pgSQL	LANG	MIT	C	13–18	32
redis	0.0.1	Send redis pub/sub messages to Redis from PostgreSQL Directly	FDW	MIT	C	14–18	32
db2_fdw	18.2.0	foreign data wrapper for DB2 access	FDW	PostgreSQL	C	14–18	31
extra_window_functions	1.0	Extra Window Functions for PostgreSQL	FUNC	PostgreSQL	C	14–18	31
file_textarray_fdw	1.0.1	Foreign data wrapper returning each text-file row as a text array.	FDW	PostgreSQL	C	—	31
lsm3	1.0	LSM tree index access method based on PostgreSQL B-tree indexes	FEAT	PostgreSQL	C	—	31
pagevis	0.1	Visualise database pages in ascii code	STAT	MIT	SQL	14–18	31
pg_healer	1.0	Proof-of-concept extension for automatically repairing PostgreSQL data corruption	ADMIN	PostgreSQL	C	—	31
pg_xid	1.0	PostgreSQL extension exposing xid generation functions	FUNC	MIT	C	—	31
storage_engine	2.4.0	colcompress and rowcompress Table Access Methods with vectorized execution	OLAP	AGPL-3.0	C	15–18	31
town	0.1.0	Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes.	TIME	MIT	SQL	—	31

Quick links

PostgreSQL Extension Catalogue