PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
rum	1.3.15	RUM index access method	FEAT	PostgreSQL	C	14–18	840
jsquery	1.2	data type for jsonb inspection	FEAT	PostgreSQL	C	14–18	710
aqo	1.6	Adaptive query optimization extension using execution statistics to improve cardinality estimation.	FEAT	AGPL-3.0	C	10–18	499
pgq	3.5.1	Generic queue for PostgreSQL	FEAT	ISC	C	14–18	425
onesparse	1.0.0	Sparse linear algebra and graph extension for PostgreSQL 18	FEAT	Apache-2.0	C	18	405
babelfishpg_unit	1.0.0	C test runner for invoking all or selected Babelfish unit tests from SQL.	FEAT	Apache-2.0	C	—	338
imgsmlr	1.0	Image similarity with haar	FEAT	PostgreSQL	C	14–18	264
pg_incremental	1.5.0	Incremental Processing by Crunchy Data	FEAT	PostgreSQL	C	16–18	228
is_jsonb_valid	0.1.4	Native PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7.	FEAT	MIT	C	10–18	173
pg_plan_advsr	0.1	Automated execution plan tuning extension	FEAT	—	C	12–16	121
plan_filter	0.0.1	filter statements by their execution plans.	FEAT	PostgreSQL	C	14–18	96
gitgres	0.1	Store Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type.	FEAT	MIT	C	—	88
pg_simula	1.0	Inject WAIT, ERROR, FATAL, or PANIC failures into PostgreSQL operations	FEAT	—	C	10	56
pg_idx_advisor	0.1.2	PostgreSQL index advisor	FEAT	PostgreSQL	C	10–18	51
badapple	1.0.0	Play "Bad Apple!!" in the psql client.	FEAT	—	C	—	50
scan	1.0	Visual Studio Code - Development Container - PostgreSQL	FEAT	Apache-2.0	C	—	45
postgraph	0.1.0	All in One Graph Extension for Postgres	FEAT	AGPL-3.0	C	—	44
sqlbench	1.0.0	a forked project from dbt2, can do a standard TPC-C test.	FEAT	—	C	—	37
lsm3	1.0	LSM tree index access method based on PostgreSQL B-tree indexes	FEAT	PostgreSQL	C	—	31
pgtam	0.0.1	Experimental in-memory PostgreSQL table access method implemented as a C extension.	FEAT	MIT	C	—	30
pg_worker_pool	0.1	A background worker pool for executing SQL queries	FEAT	—	C	—	26
pg_dphyp	—	Preload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL.	FEAT	MIT	C	12–18	25
pg_ttl_index	3.0.0	Automatic data expiration with TTL indexes	FEAT	PostgreSQL	C	15–18	24
pg_kaboom	0.0.1	Blow things up in interesting and useful^W^W ways	FEAT	Apache-2.0	C	—	22
pg_shared_plans	0.0.1	Proof-of-concept shared-memory execution-plan cache for PostgreSQL	FEAT	PostgreSQL	C	12–17	22
base36_gist	1.0	PostgreSQL base36 data type input/output support, internally a bigint.	FEAT	—	C	—	17
hstore_ops	1.1	Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.	FEAT	GPL-2.0	C	—	16
undam	0.1	UNDO storage table access method with in-place updates	FEAT	—	C	—	16
ulak	0.2.0	Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery	FEAT	Apache-2.0	C	14–18	15
pg_variables	1.2.5	Session-scoped variables with scalar, array, and record types	FEAT	PostgreSQL	C	14–18	13
pgchess	0.1.7	A Chess extension	FEAT	GPL-3.0	C	—	13
json_schema_validate	0.1.0	Validate JSON and JSONB data against JSON Schema in PostgreSQL	FEAT	PostgreSQL	C	14–18	12
pg_oltp_bench	1.0	Helper function and pgbench scripts for a sysbench-style OLTP benchmark.	FEAT	—	C	—	12
schema_triggers	0.1	Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.	FEAT	BSD-2-Clause	C	10–18	11
mv_rewrite	0.6.2	Query rewriting extension that transparently rewrites queries to use lower-cost materialized views.	FEAT	—	C	—	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
accel_ext	1.0	Fine-grained accelerator offload runtime that overlaps GPU, HSM, or inference work with other PostgreSQL requests.	FEAT	MIT	C	—	9
notify_now	1.0	PostgreSQL Extension to send multiple responses from one SQL Query using LISTEN/NOFITY API	FEAT	MIT	C	—	9
pgweb	0.0.1	Simple HTTP server to help build intuition for MemoryContexts in Postgres	FEAT	MIT	C	—	9
fhirpath	1.0	data type for jsonb inspection	FEAT	—	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
micromanage	0.0.1	example extension to inject plans	FEAT	—	C	—	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_hello	1.0	Postgres "Hello world" extension	FEAT	MIT	C	—	6
ctidscan	1.1	Example custom scan provider for CTID range predicates.	FEAT	—	C	—	5
ftree	0.1	atree extension for postgresql	FEAT	—	C	—	5
memoryam	0.0.1	In-memory TableAM implementation	FEAT	PostgreSQL	C	—	5
pg_ladybug	1.0	Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine.	FEAT	PostgreSQL	C	17–18	5
csv_tam	0.0.1	CSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files.	FEAT	—	C	—	4

rum

1.3.15

RUM index access method

14–18

1.2

data type for jsonb inspection

14–18

1.6

Adaptive query optimization extension using execution statistics to improve cardinality estimation.

10–18

3.5.1

Generic queue for PostgreSQL

14–18

1.0.0

Sparse linear algebra and graph extension for PostgreSQL 18

18

1.0.0

C test runner for invoking all or selected Babelfish unit tests from SQL.

—

1.0

Image similarity with haar

14–18

1.5.0

Incremental Processing by Crunchy Data

16–18

0.1.4

Native PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7.

10–18

0.1

Automated execution plan tuning extension

—

12–16

0.0.1

filter statements by their execution plans.

14–18

0.1

Store Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type.

—

1.0

Inject WAIT, ERROR, FATAL, or PANIC failures into PostgreSQL operations

—

10

0.1.2

PostgreSQL index advisor

10–18

1.0.0

Play "Bad Apple!!" in the psql client.

—

—

1.0

Visual Studio Code - Development Container - PostgreSQL

—

0.1.0

All in One Graph Extension for Postgres

—

1.0.0

a forked project from dbt2, can do a standard TPC-C test.

—

—

1.0

LSM tree index access method based on PostgreSQL B-tree indexes

—

0.0.1

Experimental in-memory PostgreSQL table access method implemented as a C extension.

—

0.1

A background worker pool for executing SQL queries

—

—

—

Preload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL.

12–18

3.0.0

Automatic data expiration with TTL indexes

15–18

0.0.1

Blow things up in interesting and useful^W^W ways

—

0.0.1

Proof-of-concept shared-memory execution-plan cache for PostgreSQL

12–17

1.0

PostgreSQL base36 data type input/output support, internally a bigint.

—

—

1.1

Alternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries.

FEAT

—

0.1

UNDO storage table access method with in-place updates

—

—

0.2.0

Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery

14–18

1.2.5

Session-scoped variables with scalar, array, and record types

14–18

0.1.7

A Chess extension

—

0.1.0

Validate JSON and JSONB data against JSON Schema in PostgreSQL

14–18

1.0

Helper function and pgbench scripts for a sysbench-style OLTP benchmark.

—

—

0.1

Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.

10–18

0.6.2

Query rewriting extension that transparently rewrites queries to use lower-cost materialized views.

—

—

0.0.1

Experimental load-only planner hook that searches PostgreSQL join orders with simulated annealing as an alternative to GEQO

—

1.0

Fine-grained accelerator offload runtime that overlaps GPU, HSM, or inference work with other PostgreSQL requests.

—

1.0

PostgreSQL Extension to send multiple responses from one SQL Query using LISTEN/NOFITY API

—

0.0.1

Simple HTTP server to help build intuition for MemoryContexts in Postgres

—

1.0

data type for jsonb inspection

—

—

0.1

Simple table access method that just prints out what functions in the access methods and related functions that are called.

—

0.0.1

example extension to inject plans

—

—

0.1.0

Perturb unordered SELECT row order to expose order-dependent tests

14–18

0.0.1

Drop PostgreSQL shared buffers and the operating-system page cache for testing

—

1.0

Postgres "Hello world" extension

—

1.1

Example custom scan provider for CTID range predicates.

—

—

0.1

atree extension for postgresql

—

—

0.0.1

In-memory TableAM implementation

—

1.0

Cypher queries over PostgreSQL tables through an embedded Ladybug graph engine.

17–18

0.0.1

CSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files.

FEAT

—

C

—

4

Quick links

PostgreSQL Extension Catalogue