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
repmgr 5.5.0 Replication manager for PostgreSQL ETL GPL-3.0 C 14–18 1.7k
bundle 0.4.0 data version control system FEAT GPL-3.0 SQL 1.1k
documentation 0.5.0 Aquameta internal documentation system FEAT GPL-3.0 SQL 1.1k
endpoint 0.5.0 endpoint extension FEAT GPL-3.0 SQL 1.1k
event 0.5.0 pub/sub data change event tracking system FEAT GPL-3.0 SQL 1.1k
filesystem 0.4.0 filesystem foreign data wrapper FDW GPL-3.0 SQL 1.1k
ide 0.5.0 Aquameta IDE FEAT GPL-3.0 SQL 1.1k
semantics 0.5.0 Aquameta Semantics Extension FEAT GPL-3.0 SQL 1.1k
widget 0.5.0 Aquameta widget framework FEAT GPL-3.0 SQL 1.1k
aux_mysql 1.5 MySQL Supplementary Extension SIM GPL-3.0 C 14 420
pg_background 2.0.2 Run SQL queries in the background TIME GPL-3.0 C 14–18 254
pgpdf 0.1.0 PDF type with meta admin & Full-Text Search TYPE GPL-3.0 C 14–18 226
plhaskell 5.0 provide trusted and untrusted Haskell procedural languages for PostgreSQL LANG GPL-3.0 C 147
json_fdw 1.0 Foreign data wrapper for local and remote JSON document access. FDW GPL-3.0 C 110
emaj 5.0.0 Enables fine-grained write logging and time travel on subsets of the database. TIME GPL-3.0 SQL 14–18 92
qos 1.0 QoS resource governor extension for PostgreSQL sessions and queries ADMIN GPL-3.0 C 15–18 63
pg_credereum 0.1 Cryptographically verifiable database auditing backed by blockchain-style transaction blocks. SEC GPL-3.0 C 10 62
pipeline_kafka 1.0.0 Integrate PipelineDB with Kafka for background-worker consumption, production, offsets, and lag monitoring ETL GPL-3.0 C 62
neo4j-fdw 4.3.2-dev Multicorn-based foreign data wrapper and Cypher functions for Neo4j. FDW GPL-3.0 Python 10–12 58
libx509pq 1.3 X.509 certificate parsing library for PostgreSQL SEC GPL-3.0 C 12–18 54
vasco 0.1.0 discover hidden correlations in your data with MIC FUNC GPL-3.0 C 14–18 35
login_hook 1.7 login_hook - hook to execute login_hook.login() at login time SEC GPL-3.0 C 14–18 33
pg_math 1.1.0 GSL statistical functions for postgresql FUNC GPL-3.0 C 14–18 19
pg-gvm 22.6 Functions for GVMd UTIL GPL-3.0 C 10–18 16
pgchess 0.1.7 A Chess extension FEAT GPL-3.0 C 13
session_variable 3.4 Registration and manipulation of session variables and constants SIM GPL-3.0 C 14–18 13
veil2 0.9.3 Provides the basis for a Virtual Private Database implementation. SEC GPL-3.0 SQL 12
veil2_demo 0.9.3 Provides a demo database for the veil2 extension. SEC GPL-3.0 SQL 12
veil2_minimal_demo 0.9.3 Provides a minimal but complete demo database for the veil2 extension. SEC GPL-3.0 SQL 12
iban 1.1 IBAN data type and validation functions for PostgreSQL TYPE GPL-3.0 C++ 14 11
tsp_semantic_headline 1.0 Phrase highlighting and improved semantics for ts_headline FTS GPL-3.0 SQL 14–18 11
cas_codes 0.1.0 CAS Registry Number data type and validation support for PostgreSQL. TYPE GPL-3.0 Rust 13–17 10
elements 0.1.0 Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. TYPE GPL-3.0 Rust 13–17 10
iso_codes 0.1.0 ISO country code enum/data types for PostgreSQL, generated with pgrx. TYPE GPL-3.0 Rust 13–17 10
media_types 0.1.0 Strongly typed MIME media-type data type for PostgreSQL TYPE GPL-3.0 Rust 13–17 10
molecular_formulas 0.1.0 Molecular-formula parser and strongly typed PostgreSQL data type TYPE GPL-3.0 Rust 13–17 10
pg_phash 1.0 Calculate Hamming distance between decimal-encoded perceptual image hashes RAG GPL-3.0 C 10
pgrx_validation 0.0.0 Cross-target Rust validation library compiled as PostgreSQL functions through an optional pgrx feature. FUNC GPL-3.0 Rust 13–17 10
pipeline_kinesis 0.9.0 Consume Amazon Kinesis streams into PipelineDB streams with dynamic background workers and persisted shard positions ETL GPL-3.0 C++ 10
norm 0.0.1 No-ORM helper extension that generates simple CRUD functions. FEAT GPL-3.0 SQL 7
pg_landmetrics 0.0.1 A PostgreSQL/PostGIS extension for calculating landscape metrics. GIS GPL-3.0 SQL 7
pg_session_stats 0.0.1 Records per-session and parallel-worker CPU, process status, and I/O data into an external SQLite database. STAT GPL-3.0 C 12 7
festival 1.1.1 FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices GIS GPL-3.0 C 6
ddl_versioning 1.0 DDL object versioning with event triggers for tables, indexes, functions, and views. ADMIN GPL-3.0 SQL 13–18 5
password_profile 1.0.0 password_profile: Advanced password security and policy enforcement SEC GPL-3.0 Rust 5
xicor 0.1.1 XI Correlation Coefficient in Postgres FUNC GPL-3.0 C 14–18 5
istoria 1.1 Table history management with non-linear undo/redo TIME GPL-3.0 SQL 4
moss_uuidgen 1.0 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 FUNC GPL-3.0 C++ 3
pg_gsl 0.0.2 Wraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL. FUNC GPL-3.0 C 3
pgbdd 0.0.1 Provides bdd and dictionary data types. TYPE GPL-3.0 C 3