PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
merge_ips	1.0	Functions to merge IP addresses, ignoring gaps	FUNC	PostgreSQL	SQL	—	3
moss_uuidgen	1.0	Generates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type	FUNC	GPL-3.0	C++	—	3
nextid	0.1	Generate Instagram-style sharded integer IDs.	FUNC	MIT	C	—	3
nfiesta	5.0.0	PostgreSQL extension implementing nFIESTA forest inventory estimation functionality.	FUNC	EUPL-1.2	SQL	16	3
numpgsql	0.0.1	Array and numerical computing library for PostgreSQL	FUNC	MIT	C++	11	3
pg_aa	1.0	ASCII art extension for PostgreSQL	FUNC	PostgreSQL	C	—	3
pg_array_multi_index	1.0	simultaneous multiple-indexing of PostgreSQL arrays	FUNC	PostgreSQL	C	—	3
pg_bedtools_rs	0.1.0	A PostgreSQL plugin for bedtools, implemented in Rust.	FUNC	MIT	Rust	13	3
pg_gsl	0.0.2	Wraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL.	FUNC	GPL-3.0	C	—	3
pg_libnumbertext	0.1.0	Converts numbers to words in multiple languages through libnumbertext.	FUNC	BSD-3-Clause	C++	—	3
pg_linearAlgebra	1.0	A linear algebra extension	FUNC	—	Rust	—	3
pg_normalize_email	1.0.9	Normalize email addresses in PostgreSQL	FUNC	PostgreSQL	SQL	12–18	3
pg_purr	0.2.0	A PostgreSQL extension (via PL/Python) that brings quantum computing capabilities.	FUNC	MIT	Python	—	3
pg_uuid_v8	1.1.0	UUID v8 generator with embedded timestamps for PostgreSQL	FUNC	PostgreSQL	C	14–18	3
short_ids	0.1.0	PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks.	FUNC	PostgreSQL	SQL	10–18	3
tanimoto	1.0	Fast C implementation of the Tanimoto similarity coefficient for PostgreSQL bit-varying fingerprints.	FUNC	—	C	—	3
weighted_statistics	1.0.0	High-performance weighted statistics functions for sparse data	FUNC	PostgreSQL	C	14–18	3
ddsketch	1.0.1	Provides ddsketch aggregate function	FUNC	PostgreSQL	C	14–18	2
fakeset	1.0	postgres extension to generate fake sentences	FUNC	—	Rust	—	2
fast_guid	0.1	Fast GUID generator function for PostgreSQL.	FUNC	PostgreSQL	C	—	2
fibonacci	0.0.2	Fibonacci extension for PostgreSQL.	FUNC	GPL-2.0	C	—	2
generate_date_series	1.0.0	generate_series()-style set-returning function for date ranges with integer day steps.	FUNC	PostgreSQL	C	10–18	2
godel_logic	1.1.0	Provides operators to evaluate fuzzy logic expressions according to Gödel logic.	FUNC	BSD-3-Clause	SQL	—	2
json_utils	0.1	JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+.	FUNC	PostgreSQL	SQL	10–18	2
jsonb_set_lax	1.0.0	Backport of PostgreSQL 13 jsonb_set_lax for PostgreSQL 9.5 through 12	FUNC	PostgreSQL	C	10–12	2
libuuid	1.0	Generate UUIDs through the system libuuid library	FUNC	PostgreSQL	C	10–12	2
lukasiewicz_logic	1.1.0	Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic.	FUNC	BSD-3-Clause	SQL	—	2
pcg_random	0.0.1	PCG pseudo-random number generator functions for PostgreSQL.	FUNC	Apache-2.0	C	—	2
pg_base58	0.0.1	Base58 Encoder/Decoder Extension for PostgreSQL	FUNC	MIT	Rust	14–18	2
pg_etag	1.0	Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates.	FUNC	BSD-3-Clause	C	—	2
pg_median_utils	0.0.1	Median filter and iterative median filter window functions for PostgreSQL	FUNC	MIT	C	10–18	2
pg_sample_ext	1.0.2	A Sample PostgreSQL extension	FUNC	PostgreSQL	SQL	—	2
pg_str	0.3.1	Add Laravel-inspired string manipulation functions to PostgreSQL using pgrx	FUNC	MIT	Rust	11–15	2
pg_strverscmp	1.0	Natural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order.	FUNC	ISC	C	—	2
pghll	1.0	Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.	FUNC	MIT	C	—	2
pgpm-faker	0.15.5	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgpm-inflection	0.30.0	PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.	FUNC	MIT	C	—	2
pgstrtranslate	1.0	Adds multi-character string replacement and text-array element removal functions.	FUNC	—	C	—	2
product_logic	1.1.0	Provides operators to evaluate fuzzy logic expressions according to product logic.	FUNC	BSD-3-Clause	SQL	—	2
proven	0.5.0	proven: PostgreSQL C bindings for formally verified safety functions from libproven	FUNC	MPL-2.0	C	—	2
safecast	0.0.1	Pure-SQL helper functions that return NULL for some invalid text-to-number casts.	FUNC	Apache-2.0	SQL	—	2
srf	1.0	Minimal C example implementing an inclusive integer set-returning function.	FUNC	—	C	—	2
translate_isbn	1.0	C function that converts text ISBN codes between ISBN-10 and ISBN-13 forms for Evergreen-compatible search expansion.	FUNC	—	C	—	2
validadores	0.0.2	Brazilian CPF check-digit validator, operator, and domain	FUNC	PostgreSQL	SQL	—	2
wrapper_deltalake	0.0.0	Unfinished pgrx hello-world prototype originally planned as a Delta Lake foreign data wrapper.	FUNC	Apache-2.0	Rust	14–16	2
approx_count	1.0	Fast approximate row counts for tables and indexes in PostgreSQL 14+ from pg class.reltuples, with a governed ANALYZE refresh	FUNC	—	SQL	—	1
array_concat	1.0	aggregates and functions for PostgreSQL Server	FUNC	—	C	—	1
bigintarray	1.0	Postgres extension like intarray, but for bigints	FUNC	—	C	—	1
bitstring_helpers	1.0	Helper C functions and aggregates for PostgreSQL bit varying data.	FUNC	—	C	—	1
cmath	1.2	C11 math functions exposed to PostgreSQL with C-backed implementations.	FUNC	GPL-3.0	C	—	1

merge_ips

1.0

Functions to merge IP addresses, ignoring gaps

—

1.0

Generates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type

Quick links

PostgreSQL Extension Catalogue