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_background · Run SQL queries in the background · 2.0.2 · Time series · GPL-3.0 · C · Packagedemaj · Enables fine-grained write logging and time travel on subsets of the database. · 5.0.0 · Time series · GPL-3.0 · SQL · Packagedistoria · Table history management with non-linear undo/redo · 1.1 · Time series · GPL-3.0 · SQL · Not packagedpg_background_queue · Topic-aware background SQL task queue with concurrency limits and retries. · 1.0 · Time series · GPL-3.0 · C · Not packagedpg_cron_helper · Extension to help functionality of pg_cron · 0.3 · Time series · GPL-3.0 · SQL · Not packagedpg_landmetrics · A PostgreSQL/PostGIS extension for calculating landscape metrics. · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedfestival · FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices · 1.1.1 · Geospatial · GPL-3.0 · C · Not packagedbrin4postgis · BRIN indexes for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedpg_geohash_extra · Additional geohash functions for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · C · Not packagedsiguanet_quest · Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. · 1.0 · Geospatial · GPL-3.0 · SQL · Not packagedfirefly · PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. · 0.2.0 · Geospatial · GPL-3.0 · SQL · Not packagedpg_wui · PostgreSQL extension for wildland urban interface data analysis using SIOSE databases · 0.2 · Geospatial · GPL-3.0 · SQL · Not packagedpg_phash · Calculate Hamming distance between decimal-encoded perceptual image hashes · 1.0 · AI and vectors · GPL-3.0 · C · Not packagedtsp_semantic_headline · Phrase highlighting and improved semantics for ts_headline · 1.0 · Full-text search · GPL-3.0 · SQL · Not packagedjusquci · French tokenizer and PostgreSQL full-text-search parser. · 1.0 · Full-text search · GPL-3.0 · C · Not packagednarugn · A lightweight distributed computer · 0.3.0 · Analytics · GPL-3.0 · SQL · Not packagedpg_popyramids_datamarts · Creates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. · 1.0.0 · Analytics · GPL-3.0 · SQL · Not packagedbundle · data version control system · 0.4.0 · Features · GPL-3.0 · SQL · Not packageddocumentation · Aquameta internal documentation system · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedendpoint · endpoint extension · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedevent · pub/sub data change event tracking system · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedide · Aquameta IDE · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedsemantics · Aquameta Semantics Extension · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedwidget · Aquameta widget framework · 0.5.0 · Features · GPL-3.0 · SQL · Not packagedpgchess · A Chess extension · 0.1.7 · Features · GPL-3.0 · C · Not packagednorm · No-ORM helper extension that generates simple CRUD functions. · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedpg2podg · PostgreSQL extension for two-player open deterministic games. · 0.1.3 · Features · GPL-3.0 · SQL · Not packagedopenbarter · Multilateral agreement engine. · ’0.8.0’ · Features · GPL-3.0 · C · Not packagedpg_sakila_db · PostgreSQL extension for deploying a port of the Sakila example database. · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedpg_siose_bench · A PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc)) · 0.0.1 · Features · GPL-3.0 · SQL · Not packagedplhaskell · provide trusted and untrusted Haskell procedural languages for PostgreSQL · 5.0 · Procedural languages · GPL-3.0 · C · Not packagedpgpdf · PDF type with meta admin & Full-Text Search · 0.1.0 · Data types · GPL-3.0 · C · Packagediban · IBAN data type and validation functions for PostgreSQL · 1.1 · Data types · GPL-3.0 · C++ · Not packagedcas_codes · CAS Registry Number data type and validation support for PostgreSQL. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedelements · Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagediso_codes · ISO country code enum/data types for PostgreSQL, generated with pgrx. · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedmedia_types · Strongly typed MIME media-type data type for PostgreSQL · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedmolecular_formulas · Molecular-formula parser and strongly typed PostgreSQL data type · 0.1.0 · Data types · GPL-3.0 · Rust · Not packagedpgbdd · Provides bdd and dictionary data types. · 0.0.1 · Data types · GPL-3.0 · C · Not packagedasn1oid · asn1oid extension · 1.6 · Data types · GPL-3.0 · C · Packageddecibel · Decibel data type with pressure conversions, arithmetic operators, comparisons, and aggregates · 0.0.1 · Data types · GPL-3.0 · C · Not packagedevr · PostgreSQL extension for RPM epoch/version/release datatype parsing. · 0.0.2 · Data types · GPL-3.0 · SQL · Not packagedpg_digest · Data type for efficient storage of hash digests in PostgreSQL. · 1.0 · Data types · GPL-3.0 · C · Not packagedpg-gvm · Functions for GVMd · 22.6 · Utilities · GPL-3.0 · C · Not packagedpgcompress · Provides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb. · 1.0 · Utilities · GPL-3.0 · C · Not packagedcompress · C/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them. · 0.0.2 · Utilities · GPL-3.0 · C++ · Not packagedoxr · OpenExchangeRates API client and currency-rate cache inside PostgreSQL. · 0.1 · Utilities · GPL-3.0 · SQL · Not packagedschedoc · Cross documentation between Django and DBT projects · 0.0.1 · Utilities · GPL-3.0 · SQL · Packagedvasco · discover hidden correlations in your data with MIC · 0.1.0 · Functions and aggregates · GPL-3.0 · C · Packagedpg_math · GSL statistical functions for postgresql · 1.1.0 · Functions and aggregates · GPL-3.0 · C · Packagedpgrx_validation · Cross-target Rust validation library compiled as PostgreSQL functions through an optional pgrx feature. · 0.0.0 · Functions and aggregates · GPL-3.0 · Rust · Not packagedxicor · XI Correlation Coefficient in Postgres · 0.1.1 · Functions and aggregates · GPL-3.0 · C · Packagedmoss_uuidgen · 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 · 1.0 · Functions and aggregates · GPL-3.0 · C++ · Not packagedpg_gsl · Wraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL. · 0.0.2 · Functions and aggregates · GPL-3.0 · C · Not packagedcmath · C11 math functions exposed to PostgreSQL with C-backed implementations. · 1.2 · Functions and aggregates · GPL-3.0 · C · Not packagedqos · QoS resource governor extension for PostgreSQL sessions and queries · 1.0 · Administration · GPL-3.0 · C · Packagedddl_versioning · DDL object versioning with event triggers for tables, indexes, functions, and views. · 1.0 · Administration · GPL-3.0 · SQL · Not packagedgbdchecks · Database health-check functions and views for bloat, locks, query statistics, and privileges. · 1.1 · Administration · GPL-3.0 · SQL · Not packagedpg_adm · A PostgreSQL extension providing some administrative tools. · 0.0.1 · Administration · GPL-3.0 · SQL · Not packagedtuplock · lock tuples (rows) with a boolean attribute · 1.2.2 · Administration · GPL-3.0 · C · Not packagedpg_session_stats · Records per-session and parallel-worker CPU, process status, and I/O data into an external SQLite database. · 0.0.1 · Monitoring · GPL-3.0 · C · Not packagedloginfo · Functions and views for PostgreSQL to query the postgres log · 1.0 · Monitoring · GPL-3.0 · C · Not packagedpg_sessions · Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. · 1.3 · Monitoring · GPL-3.0 · C · Not packagedpg_credereum · Cryptographically verifiable database auditing backed by blockchain-style transaction blocks. · 0.1 · Security · GPL-3.0 · C · Not packagedlibx509pq · X.509 certificate parsing library for PostgreSQL · 1.3 · Security · GPL-3.0 · C · Not packagedlogin_hook · login_hook - hook to execute login_hook.login() at login time · 1.7 · Security · GPL-3.0 · C · Packagedveil2 · Provides the basis for a Virtual Private Database implementation. · 0.9.3 · Security · GPL-3.0 · SQL · Not packagedveil2_demo · Provides a demo database for the veil2 extension. · 0.9.3 · Security · GPL-3.0 · SQL · Not packagedveil2_minimal_demo · Provides a minimal but complete demo database for the veil2 extension. · 0.9.3 · Security · GPL-3.0 · SQL · Not packagedpassword_profile · password_profile: Advanced password security and policy enforcement · 1.0.0 · Security · GPL-3.0 · Rust · Not packagedpg_idm · Exposes PostgreSQL role and membership management through updatable views and DML-trigger functions. · 1.0 · Security · GPL-3.0 · SQL · Not packagedauth0 · Auth0 Management API client for PostgreSQL. · 0.1 · Security · GPL-3.0 · SQL · Not packagedhyperion_vault · Encrypted secrets vault for PostgreSQL with KMS envelope encryption and automatic rotation. · 0.3.0 · Security · GPL-3.0 · Rust · Not packagedfilesystem · filesystem foreign data wrapper · 0.4.0 · Foreign data wrappers · GPL-3.0 · SQL · Not packagedjson_fdw · Foreign data wrapper for local and remote JSON document access. · 1.0 · Foreign data wrappers · GPL-3.0 · C · Not packagedneo4j-fdw · Multicorn-based foreign data wrapper and Cypher functions for Neo4j. · 4.3.2-dev · Foreign data wrappers · GPL-3.0 · Python · Not packagedlevel_pivot · LevelDB FDW with support for pivoting and key templating · 1.0 · Foreign data wrappers · GPL-3.0 · C++ · Not packagedaux_mysql · MySQL Supplementary Extension · 1.5 · Compatibility · GPL-3.0 · C · Packagedsession_variable · Registration and manipulation of session variables and constants · 3.4 · Compatibility · GPL-3.0 · C · Packagedrepmgr · Replication manager for PostgreSQL · 5.5.0 · Replication and streams · GPL-3.0 · C · Packagedpipeline_kafka · Integrate PipelineDB with Kafka for background-worker consumption, production, offsets, and lag monitoring · 1.0.0 · Replication and streams · GPL-3.0 · C · Not packagedpipeline_kinesis · Consume Amazon Kinesis streams into PipelineDB streams with dynamic background workers and persisted shard positions · 0.9.0 · Replication and streams · GPL-3.0 · C++ · Not packaged

82 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pgcompress 1.0 Provides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb. UTIL GPL-3.0 C 3
asn1oid 1.6 asn1oid extension TYPE GPL-3.0 C 14–18 2
brin4postgis 0.0.1 BRIN indexes for PostGIS GIS GPL-3.0 SQL 10–18 2
pg_background_queue 1.0 Topic-aware background SQL task queue with concurrency limits and retries. TIME GPL-3.0 C 13–18 2
pg_geohash_extra 0.0.1 Additional geohash functions for PostGIS GIS GPL-3.0 C 2
pg_idm 1.0 Exposes PostgreSQL role and membership management through updatable views and DML-trigger functions. SEC GPL-3.0 SQL 10–18 2
siguanet_quest 1.0 Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. GIS GPL-3.0 SQL 10–18 2
auth0 0.1 Auth0 Management API client for PostgreSQL. SEC GPL-3.0 SQL 10–18 1
cmath 1.2 C11 math functions exposed to PostgreSQL with C-backed implementations. FUNC GPL-3.0 C 1
compress 0.0.2 C/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them. UTIL GPL-3.0 C++ 1
decibel 0.0.1 Decibel data type with pressure conversions, arithmetic operators, comparisons, and aggregates TYPE GPL-3.0 C 10–18 1
evr 0.0.2 PostgreSQL extension for RPM epoch/version/release datatype parsing. TYPE GPL-3.0 SQL 1
firefly 0.2.0 PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. GIS GPL-3.0 SQL 1
loginfo 1.0 Functions and views for PostgreSQL to query the postgres log STAT GPL-3.0 C 1
pg2podg 0.1.3 PostgreSQL extension for two-player open deterministic games. FEAT GPL-3.0 SQL 10–18 1
pg_digest 1.0 Data type for efficient storage of hash digests in PostgreSQL. TYPE GPL-3.0 C 1
pg_sessions 1.3 Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. STAT GPL-3.0 C 1
gbdchecks 1.1 Database health-check functions and views for bloat, locks, query statistics, and privileges. ADMIN GPL-3.0 SQL 11
hyperion_vault 0.3.0 Encrypted secrets vault for PostgreSQL with KMS envelope encryption and automatic rotation. SEC GPL-3.0 Rust 18
jusquci 1.0 French tokenizer and PostgreSQL full-text-search parser. FTS GPL-3.0 C 16
level_pivot 1.0 LevelDB FDW with support for pivoting and key templating FDW GPL-3.0 C++
narugn 0.3.0 A lightweight distributed computer OLAP GPL-3.0 SQL
openbarter ’0.8.0’ Multilateral agreement engine. FEAT GPL-3.0 C
oxr 0.1 OpenExchangeRates API client and currency-rate cache inside PostgreSQL. UTIL GPL-3.0 SQL 13–18
pg_adm 0.0.1 A PostgreSQL extension providing some administrative tools. ADMIN GPL-3.0 SQL 10–18
pg_cron_helper 0.3 Extension to help functionality of pg_cron TIME GPL-3.0 SQL
pg_popyramids_datamarts 1.0.0 Creates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. OLAP GPL-3.0 SQL
pg_sakila_db 0.0.1 PostgreSQL extension for deploying a port of the Sakila example database. FEAT GPL-3.0 SQL
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_wui 0.2 PostgreSQL extension for wildland urban interface data analysis using SIOSE databases GIS GPL-3.0 SQL
schedoc 0.0.1 Cross documentation between Django and DBT projects UTIL GPL-3.0 SQL 14–18
tuplock 1.2.2 lock tuples (rows) with a boolean attribute ADMIN GPL-3.0 C