PostgreSQL Extension Catalogue

1476 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version
pg_hybrid	1.0	hybrid storage engine: columnar, vector, fulltext	RAG	Apache-2.0	C	—
pg_iban	1.1	PostgreSQL extension providing IBAN (International Bank Account Number) data type and validation functions	TYPE	Apache-2.0	C	—
pg_ical	0.2.0	RRULE recurrence functions for PostgreSQL backed by libical	TIME	MIT	C	11–12
pg_isok	1.4.1	Query-based data integrity management and soft alerting for PostgreSQL	UTIL	AGPL-3.0	SQL	14–18
pg_isolate	1.0	Assign PostgreSQL backends to Linux cgroups for resource isolation	ADMIN	MIT	C	—
pg_jalali_calendar	0.1.0	Jalali/Persian calendar date conversion and helper functions for PostgreSQL.	TIME	—	Rust	18
pg_jsonpatch	1.0.0	PostgreSQL implementation of JSON Patch	FUNC	MIT	SQL	—
pg_kafka	0.0.0	Kafka foreign data wrapper for PostgreSQL.	FDW	Apache-2.0	Rust	—
pg_kalman	0.1	A Kalman filter extension for PostgreSQL.	FUNC	—	C	—
pg_kmersearch	1.0	A PostgreSQL extension adding 2 datatypes of 2-bit or 4-bit per 1-mer for nucleotide sequence data and GIN index based on k-mer	RAG	MIT	C	—
pg_learned	0.1.0	PostgreSQL extension for learned indexes - 2-10x faster queries with machine learning	FEAT	—	Rust	—
pg_llm	1.1	Integrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features.	RAG	PostgreSQL	C++	14–18
pg_llm_bgw	0.1.0	example of Rust implementation of background workder to call LLM from within PostGres client DML SQL	RAG	MIT	Rust	—
pg_local_cache	2.0.4	Transaction-aware shared-memory cache for explicit PostgreSQL primary-key mget and optional RESP2 reads	FEAT	MIT	C	14–18
pg_logical_ddl	1.0	Experimental DDL replication implementation for PostgreSQL	ETL	—	C	—
pg_logicalinspect	1.0	Logical decoding components inspection	STAT	PostgreSQL	C	18
pg_logtap	0.3.0	Structured PostgreSQL log capture and delivery to Vector, HTTP, TCP, or files.	STAT	MIT	Zig	15–18
pg_microbench	1.0	Perf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open	STAT	MIT	C	—
pg_mysql	1.0	A PostgreSQL extension for launching MySQL servers from within PostgreSQL	SIM	Apache-2.0	C	—
pg_nanoid	0.0.0	PostgreSQL extension adding a NanoID type and NanoID generation functions.	TYPE	—	Rust	18
pg_nice	0.0.1	Lower the I/O scheduling priority of the current PostgreSQL backend with Linux ionice	ADMIN	MIT	C	—
pg_overexplain	1.0	Allow EXPLAIN to dump even more details	STAT	PostgreSQL	C	18
pg_phonenumber	1.0	C++ libphonenumber-backed phone type, equality operators, and supported-region helpers	TYPE	—	C++	—
pg_plpgsql_ext	1.0.0	A PostgreSQL extension with a PL/pgSQL function to subtract numbers	FUNC	PostgreSQL	SQL	—
pg_policy	0.1.0	Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls	SEC	PostgreSQL	SQL	14–18
pg_prewarm	1.2	prewarm relation data	ADMIN	PostgreSQL	C	14–18
pg_projection	1.0.0	MongoDB-like read projections for JSONB in PostgreSQL	SIM	MIT	SQL	14–18
pg_pulse	1.0	Active Session History (ASH) for PostgreSQL	STAT	—	C	—
pg_py_plan_forwarding	0.1	Forward PostgreSQL planner and executor data to embedded Python callbacks	FEAT	BSD-3-Clause	C	—
pg_query_rules	0.1.0	ProxySQL Query Rules but for PostgreSQL	ADMIN	—	C	—
pg_reactive	0.1.8	Live SQL query subscriptions with result deltas over LISTEN/NOTIFY	FEAT	PostgreSQL	C	15–18
pg_relay	1.0	Durable event processor for PostgreSQL	FEAT	—	SQL	—
pg_restore_points	1.0	Create, catalog, list, and remove named PostgreSQL restore points.	ADMIN	—	SQL	—
pg_ros2	0.2.0	ROS 2 graph snapshots and topic subscriptions in PostgreSQL	FEAT	MIT	Rust	18
pg_running_stats	1.0	Mergeable Running Statistics (Welford/Chan) Extension for PostgreSQL	FUNC	MIT	C	—
pg_sakila_db	0.0.1	PostgreSQL extension for deploying a port of the Sakila example database.	FEAT	GPL-3.0	SQL	—
pg_seal	1.0.0	Tamper-evident audit log for PostgreSQL 🦭	SEC	BSD-3-Clause	Rust	—
pg_shardman	1.0	Manages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication.	OLAP	PostgreSQL	C	10
pg_siose_bench	0.0.1	A PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc))	FEAT	GPL-3.0	SQL	—
pg_smolid	0.1.0	A Postgres pgrx extension adding smolid type and helper functions.	TYPE	MIT	Rust	13–18
pg_snowflake_id	0.0.1	Snowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx	FUNC	MIT	Rust	13–17
pg_ssh	0.3.0	Run remote commands over SSH from PostgreSQL (libssh2; in-memory private-key auth)	UTIL	MIT	Rust	—
pg_stash_advice	1.0	Store plan advice by query ID and automatically apply it during PostgreSQL query planning	ADMIN	PostgreSQL	C	19
pg_stat_conn	1.0	Cumulative connection, disconnection, and authentication-failure counts by database and role.	STAT	PostgreSQL	C	15–18
pg_stat_error	1.0	TencentDB provider-managed error statistics extension; version 1.0 is currently listed for PostgreSQL 10-13.	STAT	—	C	10–13
pg_stat_statements	1.11	track planning and execution statistics of all SQL statements executed	STAT	PostgreSQL	C	14–18
pg_stat_statements2	1.2	Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall	STAT	PostgreSQL	C	—
pg_surgery	1.0	extension to perform surgery on a damaged relation	ADMIN	PostgreSQL	C	14–18
pg_sysload	0.0.0	Expose Linux system load averages from PostgreSQL	STAT	—	Rust	11–16
pg_table_bloat	0.1.0	PostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required	ADMIN	MIT	Rust	—

Quick links

PostgreSQL Extension Catalogue