select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_column_tetris · Enforce optimal column alignment to minimize row padding · 0.1.0 · Administration · MIT · SQL · Packagedpgdd · Introspect pg data dictionary via standard SQL · 0.6.1 · Administration · MIT · Rust · Packagedrecursively_delete · Recursively delete rows and their foreign-key dependents · 0.1.5 · Administration · MIT · SQL · Not packagedpg_pgbouncer · Runs and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. · 0.0.0 · Administration · MIT · Rust · Not packagedpgraft · Raft consensus, leader election, and replicated key-value state · 2.0.0 · Administration · MIT · C · Not packagedpg_index_stats · Create extended statistics on an index manually or automatically · 0.2 · Administration · MIT · C · Not packagedpgbouncer_wrapper · Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw · 1.2.2 · Administration · MIT · SQL · Not packagedpg_strict · Prevent dangerous UPDATE and DELETE without WHERE clause · 1.0.5 · Administration · MIT · Rust · Packagedpgextmgr · pgrx extension manager and hook framework for registering, ordering, enabling, and disabling PostgreSQL extension plugins. · 0.0.0 · Administration · MIT · Rust · Not packagedpgx_show_hooks · Lists the in-process addresses of PostgreSQL hook functions and PL/pgSQL hook callbacks. · 0.0.3 · Administration · MIT · Rust · Not packagedpg_pathcheck · Validate planner Path trees for freed or corrupt memory · 0.9.1 · Administration · MIT · C · Packagedpggit · Git-like version control for PostgreSQL schemas · 0.1.3 · Administration · MIT · SQL · Not packagedpg_mentor · pg_mentor - manage query parameters · 0.1 · Administration · MIT · C · Not packagedcat_tools · Tools for interfacing with the PostgreSQL catalog · 0.3.0 · Administration · MIT · SQL · Packagedconstr_name_unif · Uniforms the names of constraints on base tables. · 1.0.1 · Administration · MIT · SQL · Not packagedconstraint_uniform · This is an extension for uniforming the names of base table constraints. · 1.0.0 · Administration · MIT · SQL · Not packagedpg_data_retention · PostgreSQL background-worker extension that applies table data retention policies. · 0.0.0 · Administration · MIT · Rust · Not packagedpg_recyclebin · Intercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. · 0.1.0 · Administration · MIT · Rust · Not packagedpg_sats · Per-role query metering and optional enforcement using satoshi-denominated balances. · 0.1.0 · Administration · MIT · C · Not packagedalohadb_pool · AlohaDB Built-in Connection Pooling · 1.0 · Administration · MIT · C · Not packagedalohadb_scale · AlohaDB Scale - scale-to-zero management · 1.0 · Administration · MIT · C · Not packagedhypostats · Dump and load pg_statistic rows as JSON for statistics experiments. · 0.0.0 · Administration · MIT · Rust · Not packagedmacavity · Deterministic session-local fault injection for PostgreSQL test clusters · 0.1.0 · Administration · MIT · C · Packagedpg_isolate · Assign PostgreSQL backends to Linux cgroups for resource isolation · 1.0 · Administration · MIT · C · Not packagedpg_nice · Lower the I/O scheduling priority of the current PostgreSQL backend with Linux ionice · 0.0.1 · Administration · MIT · C · Not packagedpg_table_bloat · PostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required · 0.1.0 · Administration · MIT · Rust · Not packagedpg_wal_recovery · pg recovery is an educational PostgreSQL extension for database recovery · 1.0 · Administration · MIT · C · Not packagedpgeyes · PL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table. · 0.0.2 · Administration · MIT · SQL · Not packagedprobackup_ctl · Inspect and operate pg_probackup catalogs, including filesystem, SFTP, and S3 storage. · 1.0 · Administration · MIT · C · Not packagedskitch-extension-verify · PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. · 0.0.7 · Administration · MIT · SQL · Not packaged

30 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_column_tetris 0.1.0 Enforce optimal column alignment to minimize row padding ADMIN MIT SQL 14–18 100
pgdd 0.6.1 Introspect pg data dictionary via standard SQL ADMIN MIT Rust 14–18 56
recursively_delete 0.1.5 Recursively delete rows and their foreign-key dependents ADMIN MIT SQL 10–13 29
pg_pgbouncer 0.0.0 Runs and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. ADMIN MIT Rust 16 28
pgraft 2.0.0 Raft consensus, leader election, and replicated key-value state ADMIN MIT C 14–18 24
pg_index_stats 0.2 Create extended statistics on an index manually or automatically ADMIN MIT C 21
pgbouncer_wrapper 1.2.2 Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw ADMIN MIT SQL 20
pg_strict 1.0.5 Prevent dangerous UPDATE and DELETE without WHERE clause ADMIN MIT Rust 14–18 19
pgextmgr 0.0.0 pgrx extension manager and hook framework for registering, ordering, enabling, and disabling PostgreSQL extension plugins. ADMIN MIT Rust 15 15
pgx_show_hooks 0.0.3 Lists the in-process addresses of PostgreSQL hook functions and PL/pgSQL hook callbacks. ADMIN MIT Rust 15 15
pg_pathcheck 0.9.1 Validate planner Path trees for freed or corrupt memory ADMIN MIT C 17–18 13
pggit 0.1.3 Git-like version control for PostgreSQL schemas ADMIN MIT SQL 9
pg_mentor 0.1 pg_mentor - manage query parameters ADMIN MIT C 8
cat_tools 0.3.0 Tools for interfacing with the PostgreSQL catalog ADMIN MIT SQL 14–18 3
constr_name_unif 1.0.1 Uniforms the names of constraints on base tables. ADMIN MIT SQL 10–18 1
constraint_uniform 1.0.0 This is an extension for uniforming the names of base table constraints. ADMIN MIT SQL 1
pg_data_retention 0.0.0 PostgreSQL background-worker extension that applies table data retention policies. ADMIN MIT Rust 13–18 1
pg_recyclebin 0.1.0 Intercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. ADMIN MIT Rust 14–18 1
pg_sats 0.1.0 Per-role query metering and optional enforcement using satoshi-denominated balances. ADMIN MIT C 14–18 1
alohadb_pool 1.0 AlohaDB Built-in Connection Pooling ADMIN MIT C
alohadb_scale 1.0 AlohaDB Scale - scale-to-zero management ADMIN MIT C
hypostats 0.0.0 Dump and load pg_statistic rows as JSON for statistics experiments. ADMIN MIT Rust 12–17
macavity 0.1.0 Deterministic session-local fault injection for PostgreSQL test clusters ADMIN MIT C 16–18
pg_isolate 1.0 Assign PostgreSQL backends to Linux cgroups for resource isolation ADMIN MIT C
pg_nice 0.0.1 Lower the I/O scheduling priority of the current PostgreSQL backend with Linux ionice ADMIN MIT C
pg_table_bloat 0.1.0 PostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required ADMIN MIT Rust
pg_wal_recovery 1.0 pg recovery is an educational PostgreSQL extension for database recovery ADMIN MIT C
pgeyes 0.0.2 PL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table. ADMIN MIT SQL 10–18
probackup_ctl 1.0 Inspect and operate pg_probackup catalogs, including filesystem, SFTP, and S3 storage. ADMIN MIT C
skitch-extension-verify 0.0.7 PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. ADMIN MIT SQL