PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_safer_settings_table_dependent_extension	forever	A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer.	ADMIN	—	SQL	—	7
pg_safer_settings_table_dependent_subextension	monover	A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer.	ADMIN	—	SQL	—	7
pg_session_stats	0.0.1	Records per-session and parallel-worker CPU, process status, and I/O data into an external SQLite database.	STAT	GPL-3.0	C	12	7
pg_shmemviz	0.1	Capture shared-memory snapshots for offline structural visualization	STAT	GPL-2.0-or-later	C	20	7
pg_sqlog	1.6	Provide SQL interface to logs	STAT	BSD-3-Clause	SQL	14–18	7
pg_text_semver	1.2.1	Semantic version domain and comparison operators for PostgreSQL	TYPE	PostgreSQL	SQL	14–18	7
pgbrtypes	1.0	Brazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support	TYPE	—	C	10–18	7
pgc_fdw	1.0	Access remote PostgreSQL tables through a postgres_fdw-derived wrapper with a FoundationDB-backed query cache	FDW	Apache-2.0	C	12	7
pgfr_control	2.28.1	Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record.	ADMIN	—	SQL	—	7
pggeojson	1.0	A GeoJSON generating extension for PostGIS	GIS	Apache-2.0	SQL	—	7
pgorafunc	9.4	Oracle compatibility functions and packages for PostgreSQL	SIM	AGPL-3.0	C	—	7
pgosql	9.4	C procedural-language handler providing PL/SQL-style compatibility and Oracle-like sys catalog views.	LANG	AGPL-3.0	C	—	7
pgtera	0.0.0	render Tera HTML templates inside PostgreSQL	UTIL	MIT	Rust	11–16	7
pgzint	0.2.0	Generate PNG barcodes and QR codes inside PostgreSQL with the Zint library	UTIL	MIT	C	10–18	7
plotpg	1.0	plot PostgreSQL result sets and analytic functions with gnuplot	UTIL	PostgreSQL	C	—	7
popcount	1.0.0	provide population-count functions for PostgreSQL bit(n) values	FUNC	MIT	C	10–18	7
postbis	1.0	Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.	TYPE	PostgreSQL	C	14–18	7
postile	0.0.1	A pgrx PostgreSQL extension for map-tile generation helpers and gzip/Brotli bytea compression.	GIS	MIT	Rust	13–18	7
quria	0.0.0	quria: experimental pgrx extension for BM25 full-text and HNSW vector search	RAG	Apache-2.0	Rust	11–15	7
redis_fdw_rs	0.6.0	This extension allows PostgreSQL to directly query and manipulate Redis data as if it were regular PostgreSQL tables.	FDW	Apache-2.0	Rust	14–18	7
schedulerx	1.0	Prototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs.	TIME	BSD-3-Clause	C	—	7
traceam	0.1	Simple table access method that just prints out what functions in the access methods and related functions that are called.	FEAT	Apache-2.0	C	—	7
uints	0.9	C extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions.	TYPE	PostgreSQL	C	—	7
unidecode	0.0.6	ASCII transliterations of Unicode text	FTS	—	C	10–18	7
vasavgeom	1.1	Vague geometry handler - VASA	GIS	GPL-2.0	C	—	7
wildspeed	1.0	GIN operator class for fast wildcard LIKE searches using permuterm indexing	FTS	GPL-2.0	C	—	7
aerospike_fdw	1.0	Foreign Data Wrapper for Aerospike.	FDW	—	C	—	6
ajbool	0.0.3	Three-valued boolean type with a pseudo-NULL unknown state for primary keys.	TYPE	PostgreSQL	C	10–16	6
array_textsort	1.1	C functions for sorting and de-duplicating one-dimensional text arrays.	FUNC	BSD-4-Clause	C	—	6
bztree	1.0	BzTree index access method with equality operator classes for common PostgreSQL scalar types.	FEAT	Apache-2.0	C++	—	6
db2fce	0.0.17	DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.	SIM	PostgreSQL	SQL	14–18	6
dbpatch	1.3.0	PostgreSQL database patch change management extension	ADMIN	BSD-3-Clause	SQL	—	6
email	0.1	Email address data type with validation, equality operators, and user/domain helper functions.	TYPE	PostgreSQL	C	10–18	6
envvar	1.0.1	Fetch the value of an environment variable	UTIL	PostgreSQL	C	14–18	6
festival	1.1.1	FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices	GIS	GPL-3.0	C	—	6
fetchq	4.0.2	Postgres extension that enables FetchQ capabilities	FEAT	MIT	SQL	—	6
format_x	0.0.1	Polymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values.	FUNC	MIT	C	10–18	6
g_cube	1.0	GPU version of contrib/cube	TYPE	—	C	—	6
konfigraf	0.0.2	Git based application configuration	FEAT	MIT	SQL	—	6
micromanage	0.0.1	example extension to inject plans	FEAT	—	C	—	6
nanomsgtopdb	1.0	Receive nanomsg messages into a PipelineDB stream.	ETL	—	C	—	6
noset	0.3.0	Module for blocking SET variables for non-super users.	SEC	AGPL-3.0	C	14–18	6
pg_algorand	2.0	Algorand address, application, asset, transaction, and checksum encoding utilities.	UTIL	MIT	C	—	6
pg_datatype_password	0.0.1	SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage.	TYPE	MIT	SQL	10–18	6
pg_dbms_lock	2.0	Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL	SIM	PostgreSQL	SQL	14–18	6
pg_disorder	0.1.0	Perturb unordered SELECT row order to expose order-dependent tests	FEAT	PostgreSQL	C	14–18	6
pg_dropbuffers	0.0.1	Drop PostgreSQL shared buffers and the operating-system page cache for testing	FEAT	PostgreSQL	C	—	6
pg_handlebars	1.0	PostgreSQL handlebars	UTIL	MIT	C	—	6
pg_hello	1.0	Postgres "Hello world" extension	FEAT	MIT	C	—	6
pg_html5_email_address	1.2.3	PostgreSQL email validation that is consistent with the HTML5 spec	UTIL	PostgreSQL	SQL	14–18	6

Quick links

PostgreSQL Extension Catalogue