PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_ai	0.0.1	PostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors.	RAG	Apache-2.0	C	—	25
pg_dphyp	—	Preload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL.	FEAT	MIT	C	12–18	25
pg_ibc_0_1	0.1.1	PostgreSQL extension for decoding and handling IBC protocol data types	UTIL	—	Rust	14–16	25
pg_kazsearch	2.3.0	Kazakh full-text search extension for PostgreSQL	FTS	LGPL-3.0	Rust	16–18	25
pg_snakeoil	1.4	The PostgreSQL Antivirus	SEC	PostgreSQL	C	14–18	25
pg_sphere	1.5.2	spherical objects with useful functions, operators and index support	TYPE	BSD-3-Clause	C	14–18	25
pgchronos	1.0.2	SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays.	TIME	BSD-3-Clause	SQL	10–18	25
collection	2.1.3	Associative-array data types for high-performance PL/pgSQL workflows	TYPE	Apache-2.0	C	14–18	24
faker	0.5.3	Wrapper for the Faker Python library	LANG	PostgreSQL	Python	14–18	24
json_build	1.1.0	C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays.	FUNC	PostgreSQL	C	10–18	24
meta	0.4.0	Normalized, friendlier system catalog for PostgreSQL	STAT	BSD-2-Clause	SQL	14–18	24
parray_gin	1.5.0	GIN index operator class and partial-match operators for text arrays	FUNC	PostgreSQL	C	14–18	24
pg_meminfo	1.0	Backend memory and process usage inspection from SQL.	STAT	MIT	C	—	24
pg_orphaned	1.0	Deal with orphaned files	ADMIN	PostgreSQL	C	14–18	24
pg_query_rewrite	0.0.5	Rewrite SQL statements with a PostgreSQL ProcessUtility hook	ADMIN	PostgreSQL	C	14–18	24
pg_start_sql	1.0	runs SQL statement at instance start	ADMIN	PostgreSQL	C	—	24
pg_ttl_index	3.0.0	Automatic data expiration with TTL indexes	FEAT	PostgreSQL	C	15–18	24
pgauditlogtofile	1.8.5	pgAudit addon to redirect audit log to an independent file	SEC	PostgreSQL	C	14–18	24
pgraft	2.0.0	Raft consensus, leader election, and replicated key-value state	ADMIN	MIT	C	14–18	24
pgsloth	0.0.0	Intentionally delays every query by a random 100 to 9,999 milliseconds through an executor hook.	FEAT	—	Rust	12–17	24
bignum	0.8.0	Unlimited precision integers for PostgreSQL	TYPE	PostgreSQL	C	10–18	23
hello-world	0.0.1	RLS demo extension with users and products tables	SEC	MIT	C	—	23
pgbitmap	0.9.5	Bitmap-type extension for PostgreSQL	TYPE	BSD-2-Clause	C	10–18	23
sparql	1.0	Query SPARQL datasource with SQL	UTIL	Apache-2.0	SQL	14–18	23
supabase	0.0.1	A friendly playground for building and validating Supabase Row‑Level Security (RLS)	SEC	MIT	C	—	23
time_for_keys	0.0.1	C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers.	TIME	MIT	C	—	23
aiven_extras	1.1.20	Aiven PostgreSQL extras for non-superuser access to selected database features.	SEC	Apache-2.0	C	12–18	22
cassandra2_fdw	2.0	Foreign data wrapper for querying Cassandra 2.x and newer from PostgreSQL.	FDW	MIT	C	11–15	22
pg_kaboom	0.0.1	Blow things up in interesting and useful^W^W ways	FEAT	Apache-2.0	C	—	22
pg_lz4	1.0	LZ4 compression access method for a patched PostgreSQL development branch.	UTIL	—	C	—	22
pg_mustach	2.0	PostgreSQL implementation of Mustache templating	UTIL	MIT	C	—	22
pg_relusage	0.0.1	Log all the queries that reference a particular column	STAT	PostgreSQL	C	14–18	22
pg_shared_plans	0.0.1	Proof-of-concept shared-memory execution-plan cache for PostgreSQL	FEAT	PostgreSQL	C	12–17	22
pg_simdjson	0.1	Prototype SIMD-accelerated parser that converts JSON text to jsonb	UTIL	Apache-2.0	C++	—	22
prioritize	1.0.4	get and set the priority of PostgreSQL backends	ADMIN	PostgreSQL	C	14–18	22
column_encrypt	4.0	Transparent column-level encryption with encrypted_text and encrypted_bytea types	SEC	PostgreSQL	C	14–18	21
dblink_plus	1.0.11	Run SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL.	FDW	BSD-3-Clause	C	—	21
kilobase	17.4.1	Preloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views.	TIME	—	Rust	17–18	21
pg_index_stats	0.2	Create extended statistics on an index manually or automatically	ADMIN	MIT	C	—	21
pg_message_queue	0.2.1	Listen/Notify-based PostgreSQL message queue extension	FEAT	PostgreSQL	SQL	10–18	21
s2	0.0.2	PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy	GIS	MIT	Python	—	21
timestampandtz	1.0.0	C data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions.	TYPE	MIT	C	10–18	21
bitpolar_pg	0.3.3	BitPolar: near-optimal vector quantization — 3-8 bit compression with zero training. 58 integrations across every major AI framework.	RAG	—	Rust	—	20
chdb	0.1	Execute isolated chDB queries from PostgreSQL through a helper process	OLAP	Apache-2.0	C	15–19	20
chdb_hook	0.1.1	Headless hook for COPY and CREATE TABLE over chDB-supported URLs	ETL	Apache-2.0	C	15–19	20
currency	0.0.3	Custom PostgreSQL currency type in 1Byte	TYPE	MIT	C	14–18	20
custom_properties	0.0.3	Supabase RLS helper tables and functions for managing user properties and custom claims.	SEC	—	SQL	—	20
pgbouncer_wrapper	1.2.2	Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw	ADMIN	MIT	SQL	—	20
plxslt	0.20140221	XSLT procedural language for PostgreSQL	LANG	PostgreSQL	C	14–18	20
kafgres	0.1.0	Kafka protocol broker embedded in PostgreSQL	SIM	Elastic-2.0	Rust	16	19

Quick links

PostgreSQL Extension Catalogue