PostgreSQL Extension Catalogue

1442 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
count_distinct	3.0.2	An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate	FUNC	BSD-2-Clause	C	14–18	80
jdbc_fdw	1.2	foreign-data wrapper for remote servers available over JDBC	FDW	PostgreSQL	C	14–18	79
set_user	4.2.0	similar to SET ROLE but with added logging	SEC	PostgreSQL	C	14–18	78
pg_savior	0.1.0	Postgres extension to save OOPS mistakes	ADMIN	Apache-2.0	C	14–18	76
typesafe	0.0.1	SQL client for TypeSafe AI classification and scoring	RAG	MIT	C	16–17	76
bg_mon	—	Background worker for monitoring PostgreSQL	STAT	MIT	C	10–18	75
twitter_fdw	1.1.0	Legacy foreign data wrapper for the retired unauthenticated Twitter Search API.	FDW	PostgreSQL	C	—	73
pg_curl	2.4.6	Run curl actions for data transfer in URL syntax	UTIL	MIT	C	14–18	71
s3_fdw	0.1.0	Foreign data wrapper for reading Amazon S3 files through PostgreSQL COPY format.	FDW	PostgreSQL	C	—	70
pg_store_plans	1.10	track plan statistics of all SQL statements executed	STAT	BSD-3-Clause	C	14–18	69
pg_task	3.0.0	execute any sql command at any specific time at background	TIME	MIT	C	14–18	68
sr_plan	1.2	Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates.	ADMIN	PostgreSQL	C	10–11	64
pg_protobuf	1.0	Protobuf support for PostgreSQL	UTIL	MIT	C	14–18	63
qos	1.0	QoS resource governor extension for PostgreSQL sessions and queries	ADMIN	GPL-3.0	C	15–18	63
influxdb_fdw	1.3	Foreign data wrapper for querying InfluxDB from PostgreSQL.	FDW	PostgreSQL	C	13–17	62
pg_credereum	0.1	Cryptographically verifiable database auditing backed by blockchain-style transaction blocks.	SEC	GPL-3.0	C	10	62
pipeline_kafka	1.0.0	Integrate PipelineDB with Kafka for background-worker consumption, production, offsets, and lag monitoring	ETL	GPL-3.0	C	—	62
pg_ulid	0.0.4	Generate ULID strings in PostgreSQL with a C function.	FUNC	—	C	—	61
pg_sorted_heap	0.14.0	Sorted heap table AM with zone map scan pruning and built-in vector search	OLAP	PostgreSQL	C	16–18	60
hashlib	1.1	Stable hash functions for Postgres	UTIL	PostgreSQL	C	14–18	59
bytea_plphp	1.0	Binary-safe transform between bytea and PHP strings for PL/php	LANG	PostgreSQL	C	11–18	56
hstore_plphp	1.0	Transform between hstore and PHP associative arrays for PL/php	LANG	PostgreSQL	C	11–18	56
jsonb_plphp	1.0	Transform between jsonb and native PHP values for PL/php	LANG	PostgreSQL	C	11–18	56
pg_simula	1.0	Inject WAIT, ERROR, FATAL, or PANIC failures into PostgreSQL operations	FEAT	—	C	10	56
pg_statement_rollback	1.6	Server side rollback at statement level for PostgreSQL like Oracle or DB2	SIM	ISC	C	14–18	56
plphp	2.6	Embed PHP 8 as an untrusted PostgreSQL procedural language	LANG	PostgreSQL	C	11–18	56
ptrack	2.4	Tracks changed PostgreSQL blocks for incremental backup using a shared-memory map and core storage hooks.	ADMIN	PostgreSQL	C	11–18	56
pgnodemx	2.0.1	Capture node OS metrics via SQL queries	STAT	Apache-2.0	C	14–18	55
dump_fdw	1.0	Foreign data wrapper for querying rows directly from PostgreSQL custom-format dump files	FDW	BSD-3-Clause	C	—	54
libx509pq	1.3	X.509 certificate parsing library for PostgreSQL	SEC	GPL-3.0	C	12–18	54
pg_check	0.1.0	Provides basic integrity checks for data files.	ADMIN	BSD-3-Clause	C	10–18	52
url_encode	1.2.5	url_encode, url_decode functions	UTIL	PostgreSQL	C	14–18	52
pg_idx_advisor	0.1.2	PostgreSQL index advisor	FEAT	PostgreSQL	C	10–18	51
pg_stat_plans	2.1.0	Track per-plan call counts, execution times, and example EXPLAIN texts.	STAT	PostgreSQL	C	16–18	51
sphinx	0.3	C connector for querying and updating an external SphinxSearch server from PostgreSQL.	FTS	MIT	C	—	51
aggs_for_arrays	1.3.3	Various functions for computing statistics on arrays of numbers	FUNC	MIT	C	14–18	50
badapple	1.0.0	Play "Bad Apple!!" in the psql client.	FEAT	—	C	—	50
neurondb	4.0.0-devel	AI database extension for vector search, ML inference, hybrid search, and RAG in PostgreSQL.	RAG	Proprietary	C	16–18	50
pase	0.0.1	PostgreSQL ultra-high dimensional approximate nearest neighbor search extension.	RAG	—	C	—	50
pg_tm_aux	1.1.1	Transfer manager auxiliary functions	ETL	—	C	—	50
temporal	0.7.1	C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.	TIME	PostgreSQL	C	—	50
git_fdw	1.1.0	PostgreSQL Git Foreign Data Wrapper	FDW	MIT	C	10–18	49
coldfront	1.0	Transparent hot and cold tiering between PostgreSQL partitions and writable Apache Iceberg tables	OLAP	PostgreSQL	C	16–18	48
lolor	1.2.2	Logical-replication-friendly replacement for PostgreSQL large objects	ETL	PostgreSQL	C	15–18	48
ch_fdw	1.0	Foreign data wrapper for federated access from PostgreSQL to ClickHouse.	FDW	MIT	C	13	47
emailaddr	0	Email address type for PostgreSQL	TYPE	—	C	14–18	46
pg_rewrite	2.2	Tool allows read write to the table during the rewriting	ADMIN	BSD-3-Clause	C	14–18	46
pre_prepare	0.9	Pre Prepare your Statement server side	ADMIN	PostgreSQL	C	14–18	46
scan	1.0	Visual Studio Code - Development Container - PostgreSQL	FEAT	Apache-2.0	C	—	45
pgclone	4.4.2	Clone PostgreSQL databases, schemas, tables, and functions across environments	ETL	PostgreSQL	C	14–18	44

Quick links

PostgreSQL Extension Catalogue