PostgreSQL Extension Catalogue

587 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
hostname	1.0.0	Get the server host name	UTIL	PostgreSQL	C	10–18	13
pg_dbms_metadata	1.0.0	Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL	SIM	PostgreSQL	SQL	14–18	13
pg_readme	0.7.1	Generate a Markdown README from PostgreSQL COMMENT objects	UTIL	PostgreSQL	SQL	14–18	13
pg_readme_test_extension	0.7.1	Fixture extension used to test pg_readme document generation	UTIL	PostgreSQL	SQL	14–18	13
pg_sortstats	0.0.1	Collect per-query sort statistics and estimate required work_mem	STAT	PostgreSQL	C	—	13
pg_variables	1.2.5	Session-scoped variables with scalar, array, and record types	FEAT	PostgreSQL	C	14–18	13
pginstall	1.0	PostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives.	ADMIN	PostgreSQL	C	—	13
sslutils	1.4	A Postgres extension for managing SSL certificates through SQL	SEC	PostgreSQL	C	14–18	13
dict_voikko	1.0	Finnish full-text-search dictionary using Voikko morphological analysis.	FTS	PostgreSQL	C	—	12
json_schema_validate	0.1.0	Validate JSON and JSONB data against JSON Schema in PostgreSQL	FEAT	PostgreSQL	C	14–18	12
orb_fdw	0.13.3	A foreign data wrapper for Orb	FDW	PostgreSQL	Rust	14–17	12
pair	0.1.2	A key/value pair data type for PostgreSQL	TYPE	PostgreSQL	C	10–18	12
pg_log_statements	0.0.2	Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters.	STAT	PostgreSQL	C	10–16	12
pg_log_userqueries	1.0.0	Module to log user queries	STAT	PostgreSQL	C	—	12
tsexact	1.0	Full-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier.	FTS	PostgreSQL	C	10–18	12
vgram	1.0	Variable-length grams	FTS	PostgreSQL	C	13–18	12
weighted_mean	1.0.1	Weighted average aggregate function for PostgreSQL numeric values.	FUNC	PostgreSQL	C	10–18	12
colors	0.0.1	C functions for perceptual color-distance calculations in the CIE Lab* color space	FUNC	PostgreSQL	C	10–18	11
fuzzywuzzy	0.0.2	fuzzywuzzy ratio for postgres	FTS	PostgreSQL	SQL	—	11
generic_plan	1.0	Generate a generic plan for a parameterized SQL statement.	STAT	PostgreSQL	SQL	—	11
l10n_table_dependent_extension	0.8.3	PostgreSQL l10n toolbox	TYPE	PostgreSQL	SQL	14–18	11
pg_subtrans_infos	1.0	Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps.	ADMIN	PostgreSQL	C	10–13	11
pg_xenophile	0.8.3	More than the bare necessities for PostgreSQL i18n and l10n.	TYPE	PostgreSQL	SQL	14–18	11
pgsynck	1.0	Parse SQL text without execution and return per-statement syntax diagnostics	UTIL	PostgreSQL	C	—	11
plpgsql_wrap	1.0	Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.	SIM	PostgreSQL	C	14–18	11
log_functions	1.0.0	Module to log functions	STAT	PostgreSQL	C	—	10
pg_remote_exec	1.0	Executes shell commands from SQL and optionally returns their standard output.	ADMIN	PostgreSQL	C	12–16	10
pg_stat_sql_plans	0.2	Track execution statistics by normalized SQL query and plan ID.	STAT	PostgreSQL	C	14–18	10
pg_subxact_counters	1.0	Global counters for PostgreSQL subtransaction activity	STAT	PostgreSQL	C	13–16	10
pg_timeout	1.0	PostgreSQL background-worker extension for terminating idle database sessions.	ADMIN	PostgreSQL	C	10–16	10
pgsql_rrule	0.0.4	Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules.	TYPE	PostgreSQL	SQL	10–18	10
saio	0.0.1	Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO	FEAT	PostgreSQL	C	—	10
colnames	1.7.0	Lists the column names in a PostgreSQL RECORD value	FUNC	PostgreSQL	C	10–18	9
config_log	0.1.7	custom background worker process to log changes to postgresql.conf to a table	STAT	PostgreSQL	C	10–18	9
country	0.0.3	Country data type, ISO 3166-1	TYPE	PostgreSQL	C	14–18	9
cryptint	1.0.0	Encryption functions for int and bigint values	UTIL	PostgreSQL	C	14–18	9
datalink	0.5.0	SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL	TYPE	PostgreSQL	C	10–18	9
hash64	0.1.0	Stable 64-bit hash function whose results do not change across PostgreSQL major versions.	FUNC	PostgreSQL	C	—	9
json_accessors	1.3.6	JSON accessor functions	FUNC	PostgreSQL	C	—	9
json_query	0.9	Generate PostgreSQL WHERE clause predicates from JSONB filter objects.	FUNC	PostgreSQL	SQL	10–18	9
llama_embed	0.1.0	llama.cpp embedding extension for dense and multivector search	RAG	PostgreSQL	C	—	9
pg_colbert_llama	0.1.0	ColBERT embedding companion extension for pgturbohybrid	RAG	PostgreSQL	C	—	9
pg_octopus	0.1	Runs a background worker that periodically connects to configured PostgreSQL nodes and records their health status.	STAT	PostgreSQL	C	10–18	9
pgaut	1.0.0	Auto Update Timestamp for PostgreSQL	FUNC	PostgreSQL	SQL	10–11	9
pgturbohybrid	0.2.0	hybrid vector and BM25 search for PostgreSQL on top of pgvector	RAG	PostgreSQL	C	—	9
pgturbohybrid_experimental	0.2.0	experimental sparse and multivector features for pgturbohybrid	RAG	PostgreSQL	C	—	9
shacrypt	1.1	Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes	UTIL	PostgreSQL	C	14–18	9
pg_bman	1.0	PostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers.	ADMIN	PostgreSQL	C	—	8
pg_cgroup	1.0	Provides SQL-callable functions to create, configure, and attach processes to Linux cgroups.	ADMIN	PostgreSQL	C	10	8
pg_extra_time	2.1.0	Some date time functions and operators that,	UTIL	PostgreSQL	SQL	14–18	8

Quick links

PostgreSQL Extension Catalogue