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.

table_version · PostgreSQL table versioning extension · 1.11.1 · Time series · BSD-3-Clause · SQL · Packagedpgchronos · SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. · 1.0.2 · Time series · BSD-3-Clause · SQL · Not packagedschedulerx · Prototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs. · 1.0 · Time series · BSD-3-Clause · C · Not packagedcalendars · calendar conversion routines · 1.0 · Time series · BSD-3-Clause · C · Not packagedpointcloud · data type for lidar point clouds · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedpointcloud_postgis · integration for pointcloud LIDAR data and PostGIS geometry data · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedcartodb · Archived PostgreSQL extension for turning a database into a CartoDB user database. · 0.37.1 · Geospatial · BSD-3-Clause · Python · Not packagedcrankshaft · Archived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. · 0.9.0 · Geospatial · BSD-3-Clause · Python · Not packagedlostgis · LostGIS spatial helper functions and types · 1.0.2 · Geospatial · BSD-3-Clause · SQL · Not packagedhexgrid · Configurable hex grid on abstract surface · 1.0.3 · Geospatial · BSD-3-Clause · C · Not packagedpg_similarity · support similarity queries · 1.0 · AI and vectors · BSD-3-Clause · C · Packagedpg_gist_hamming · support for indexing common datatypes in GiST · 1.0 · AI and vectors · BSD-3-Clause · C · Not packagedvptree · VP-tree implementation · 1.0 · AI and vectors · BSD-3-Clause · C · Not packagedpg_jieba · Chinese full-text search parser based on cppjieba · 1.1.0 · Full-text search · BSD-3-Clause · C++ · Packagedpg_scws · a parser for full-text search of Chinese · 1.0 · Full-text search · BSD-3-Clause · C · Not packagedhunspell_xal · Kalmyk Hunspell dictionary for PostgreSQL full-text search · 0.1 · Full-text search · BSD-3-Clause · SQL · Not packagedpgparts · SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers · 0.0.15 · Analytics · BSD-3-Clause · SQL · Not packagedrdkit · Cheminformatics functionality for PostgreSQL. · 202503.6 · Features · BSD-3-Clause · C++ · Packagedpg_hint_plan · Give PostgreSQL ability to manually force some decisions in execution plans. · 1.8.0 · Features · BSD-3-Clause · C · Packagedoptpaths · Planner hook extension for adding paths and removing self joins · 0.1 · Features · BSD-3-Clause · C · Not packagedsimple · postgresql simple demo extension · 1.0 · Features · BSD-3-Clause · C · Not packagedobject_reference · Provides immutable references to Postgres objects. · 0.1.0 · Features · BSD-3-Clause · SQL · Not packagedpg_py_plan_forwarding · Forward PostgreSQL planner and executor data to embedded Python callbacks · 0.1 · Features · BSD-3-Clause · C · Not packagedribollita · Se non è zuppa, è pan bagnato. · 0.0 · Features · BSD-3-Clause · C++ · Not packagedpljava · PL/Java procedural language · 1.6.10 · Procedural languages · BSD-3-Clause · Java · Packagedpgprolog · PostgreSQL procedural language handler for Prolog, embedding Scryer Prolog. · 0.0.0 · Procedural languages · BSD-3-Clause · Rust · Not packagedpljvm · A PostgreSQL procedural language that sends function calls over RPC to code running in an external JVM process. · 1.0.0 · Procedural languages · BSD-3-Clause · C · Not packagedpgwasm · Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions. · 0.1.0 · Procedural languages · BSD-3-Clause · Rust · Packagedpllisp · PL/Lisp toy extension · 0.1.0 · Procedural languages · BSD-3-Clause · C · Not packagedpgfaceting · fast faceting queries using an inverted index · 0.2.0 · Data types · BSD-3-Clause · SQL · Packagedpg_sphere · spherical objects with useful functions, operators and index support · 1.5.2 · Data types · BSD-3-Clause · C · Packagedpg_toolkit_brazil · Brazilian CPF and CNPJ types, validation, formatting, casts, and operators. · 0.1 · Data types · BSD-3-Clause · C · Not packagedurl · SQL and PL/pgSQL types and helper functions for URL parsing, encoding, decoding, and query-string key/value handling. · 1.0 · Data types · BSD-3-Clause · SQL · Not packageditalian_codes · Validation domains for Italian fiscal and VAT codes · 1.0 · Data types · BSD-3-Clause · SQL · Not packagedknx · data types for KNX Addresses · 1.0 · Data types · BSD-3-Clause · C · Not packageddaterangex · Date range type whose displayed upper bound is inclusive, with casts and operators. · 1.1 · Data types · BSD-3-Clause · C · Not packagedpgsocket · send bytes from PostgreSQL to a TCP/IP socket · 1.0 · Utilities · BSD-3-Clause · C · Not packagedpgqr · QR Code generator from PostgreSQL · 1.0 · Utilities · BSD-3-Clause · C · Packagedpg_normalize_query · Normalize constants in SQL statements using PostgreSQL parser logic · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not packagedadaptive_counter · Aggregation functions and data type for distinct estimation based on adaptive sampling. · 1.3.3 · Functions and aggregates · BSD-3-Clause · C · Not packagedbitmap_counter · Aggregation functions and data type for distinct estimation based on s-bitmap. · 1.3.5 · Functions and aggregates · BSD-3-Clause · C · Not packagedsuperloglog_counter · C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. · 1.2.3 · Functions and aggregates · BSD-3-Clause · C · Not packagedunique_id · Time-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs. · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not packagedpg_libnumbertext · Converts numbers to words in multiple languages through libnumbertext. · 0.1.0 · Functions and aggregates · BSD-3-Clause · C++ · Not packagedgodel_logic · Provides operators to evaluate fuzzy logic expressions according to Gödel logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · Not packagedlukasiewicz_logic · Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · Not packagedpg_etag · Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. · 1.0 · Functions and aggregates · BSD-3-Clause · C · Not packagedproduct_logic · Provides operators to evaluate fuzzy logic expressions according to product logic. · 1.1.0 · Functions and aggregates · BSD-3-Clause · SQL · Not packagedpg_dirtyread · Read dead but unvacuumed rows from table · 2.8 · Administration · BSD-3-Clause · C · Packagedpgfincore · examine and manage the os buffer cache · 1.4.0 · Administration · BSD-3-Clause · C · Packagedpg_catcheck · Diagnosing system catalog corruption · 1.6.0 · Administration · BSD-3-Clause · C · Packagedpg_check · Provides basic integrity checks for data files. · 0.1.0 · Administration · BSD-3-Clause · C · Not packagedpg_rewrite · Tool allows read write to the table during the rewriting · 2.2 · Administration · BSD-3-Clause · C · Packagedpg_crash · Send random signals to random processes · 1.0 · Administration · BSD-3-Clause · C · Packagedfio · PostgreSQL File I/O Functions · 1.0 · Administration · BSD-3-Clause · C · Packagedpg_dbms_stats · Statistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. · 14.0 · Administration · BSD-3-Clause · C · Not packageddbpatch · PostgreSQL database patch change management extension · 1.3.0 · Administration · BSD-3-Clause · SQL · Not packagedpgmoneta_ext · Server-side block and delta-backup helpers for pgmoneta. · 0.1.1 · Administration · BSD-3-Clause · C · Not packagedpg_catalog_get_defs · Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. · 0.1.0 · Administration · BSD-3-Clause · SQL · Not packagedpg_pageinspect_plus · Decode heap tuple data obtained with PostgreSQL pageinspect helpers · 1.0 · Administration · BSD-3-Clause · C · Not packagedpg_rlimit · setrlimit/getrlimit functions · 1.0 · Administration · BSD-3-Clause · C · Not packagedpg_stat_monitor · The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information. · 2.4.0 · Monitoring · BSD-3-Clause · C · Packagedpg_qualstats · An extension collecting statistics about quals · 2.1.4 · Monitoring · BSD-3-Clause · C · Packagedpg_stat_kcache · Kernel statistics gathering · 2.3.2 · Monitoring · BSD-3-Clause · C · Packagedpg_store_plans · track plan statistics of all SQL statements executed · 1.10 · Monitoring · BSD-3-Clause · C · Packagedpg_proctab · PostgreSQL extension to access the OS process table · 2.0.1 · Monitoring · BSD-3-Clause · C · Packagedpg_datasentinel · Observability and activity monitoring extension for PostgreSQL · 1.0 · Monitoring · BSD-3-Clause · C · Packagedstatsd · C client functions for sending counters, gauges, and timings to StatsD over UDP. · 0.2.0 · Monitoring · BSD-3-Clause · C · Not packagedexplanation · EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. · 0.3.0 · Monitoring · BSD-3-Clause · SQL · Not packagedpg_plan_tree_dot · Graphviz DOT rendering of PostgreSQL execution-plan trees. · 1.1 · Monitoring · BSD-3-Clause · C · Not packagedpgexporter_ext · Expose additional operating-system and host metrics for pgexporter. · 0.3.1 · Monitoring · BSD-3-Clause · C · Not packagedpg_sqlog · Provide SQL interface to logs · 1.6 · Monitoring · BSD-3-Clause · SQL · Packagedpg_inet_addr · Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces. · 1.0 · Monitoring · BSD-3-Clause · C · Not packagedpgsodium · Postgres extension for libsodium functions · 3.1.11 · Security · BSD-3-Clause · C · Packagedlogerrors · Function for collecting statistics about messages in logfile · 2.1.5 · Security · BSD-3-Clause · C · Packagedpg_auditor · Audit data changes and provide flashback ability · 0.2 · Security · BSD-3-Clause · SQL · Packagedblock_copy_command · Block COPY commands via a configurable ProcessUtility hook · 0.1.5 · Security · BSD-3-Clause · Rust · Packagedpg_command_fw · DDL and utility command firewall for PostgreSQL · 0.1.0 · Security · BSD-3-Clause · Rust · Packagedpg_seal · Tamper-evident audit log for PostgreSQL 🦭 · 1.0.0 · Security · BSD-3-Clause · Rust · Not packagedmysql_fdw · Foreign data wrapper for querying a MySQL server · 2.9.3 · Foreign data wrappers · BSD-3-Clause · C · Packageddump_fdw · Foreign data wrapper for querying rows directly from PostgreSQL custom-format dump files · 1.0 · Foreign data wrappers · BSD-3-Clause · C · Not packageddblink_plus · Run SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL. · 1.0.11 · Foreign data wrappers · BSD-3-Clause · C · Not packagedhba_fdw · Work-in-progress foreign data wrapper scaffold intended to expose pg_hba.conf through SQL. · 1.0 · Foreign data wrappers · BSD-3-Clause · C · Not packagediif · Adds iif function compatibility · 0.0.1 · Compatibility · BSD-3-Clause · C · Not packagedwal2json · Changing data capture in JSON format · 2.6 · Replication and streams · BSD-3-Clause · C · Packagedpg_bulkload · pg_bulkload is a high speed data loading utility for PostgreSQL · 3.1.23 · Replication and streams · BSD-3-Clause · C · Packagedamqp · Publish messages to AMQP brokers from PostgreSQL · 0.4.2 · Replication and streams · BSD-3-Clause · C · Not packageddb_migrator · Tools to migrate other databases to PostgreSQL · 1.0.0 · Replication and streams · BSD-3-Clause · SQL · Packagedpg_migrate · Migrates a PostgreSQL table avoiding long locks · 0.1.1 · Replication and streams · BSD-3-Clause · C · Not packagedpgcmp · Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. · 3.1 · Replication and streams · BSD-3-Clause · C · Not packagedreplisome · Logical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON. · 0.1 · Replication and streams · BSD-3-Clause · C · Not packaged

91 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
explanation 0.3.0 EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. STAT BSD-3-Clause SQL 10–14 13
pg_plan_tree_dot 1.1 Graphviz DOT rendering of PostgreSQL execution-plan trees. STAT BSD-3-Clause C 10–12 13
pgexporter_ext 0.3.1 Expose additional operating-system and host metrics for pgexporter. STAT BSD-3-Clause C 13–18 13
pgcmp 3.1 Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. ETL BSD-3-Clause C 12
pg_auditor 0.2 Audit data changes and provide flashback ability SEC BSD-3-Clause SQL 14–18 9
replisome 0.1 Logical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON. ETL BSD-3-Clause C 9
unique_id 1.0 Time-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs. FUNC BSD-3-Clause C 8
pg_sqlog 1.6 Provide SQL interface to logs STAT BSD-3-Clause SQL 14–18 7
schedulerx 1.0 Prototype background-worker scheduler for periodic, one-shot, and NOTIFY-triggered SQL jobs. TIME BSD-3-Clause C 7
dbpatch 1.3.0 PostgreSQL database patch change management extension ADMIN BSD-3-Clause SQL 6
hba_fdw 1.0 Work-in-progress foreign data wrapper scaffold intended to expose pg_hba.conf through SQL. FDW BSD-3-Clause C 5
pgmoneta_ext 0.1.1 Server-side block and delta-backup helpers for pgmoneta. ADMIN BSD-3-Clause C 14 5
hexgrid 1.0.3 Configurable hex grid on abstract surface GIS BSD-3-Clause C 4
pljvm 1.0.0 A PostgreSQL procedural language that sends function calls over RPC to code running in an external JVM process. LANG BSD-3-Clause C 4
block_copy_command 0.1.5 Block COPY commands via a configurable ProcessUtility hook SEC BSD-3-Clause Rust 14–18 3
optpaths 0.1 Planner hook extension for adding paths and removing self joins FEAT BSD-3-Clause C 3
pg_libnumbertext 0.1.0 Converts numbers to words in multiple languages through libnumbertext. FUNC BSD-3-Clause C++ 3
calendars 1.0 calendar conversion routines TIME BSD-3-Clause C 2
godel_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to Gödel logic. FUNC BSD-3-Clause SQL 2
hunspell_xal 0.1 Kalmyk Hunspell dictionary for PostgreSQL full-text search FTS BSD-3-Clause SQL 2
lukasiewicz_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. FUNC BSD-3-Clause SQL 2
pg_catalog_get_defs 0.1.0 Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. ADMIN BSD-3-Clause SQL 2
pg_etag 1.0 Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. FUNC BSD-3-Clause C 2
pg_inet_addr 1.0 Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces. STAT BSD-3-Clause C 10–18 2
pg_pageinspect_plus 1.0 Decode heap tuple data obtained with PostgreSQL pageinspect helpers ADMIN BSD-3-Clause C 10–18 2
pgparts 0.0.15 SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers OLAP BSD-3-Clause SQL 2
product_logic 1.1.0 Provides operators to evaluate fuzzy logic expressions according to product logic. FUNC BSD-3-Clause SQL 2
url 1.0 SQL and PL/pgSQL types and helper functions for URL parsing, encoding, decoding, and query-string key/value handling. TYPE BSD-3-Clause SQL 2
italian_codes 1.0 Validation domains for Italian fiscal and VAT codes TYPE BSD-3-Clause SQL 1
knx 1.0 data types for KNX Addresses TYPE BSD-3-Clause C 1
pg_command_fw 0.1.0 DDL and utility command firewall for PostgreSQL SEC BSD-3-Clause Rust 15–18 1
pg_rlimit 1.0 setrlimit/getrlimit functions ADMIN BSD-3-Clause C 10–18 1
pgwasm 0.1.0 Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions. LANG BSD-3-Clause Rust 14–18 1
pllisp 0.1.0 PL/Lisp toy extension LANG BSD-3-Clause C 1
simple 1.0 postgresql simple demo extension FEAT BSD-3-Clause C 1
daterangex 1.1 Date range type whose displayed upper bound is inclusive, with casts and operators. TYPE BSD-3-Clause C
iif 0.0.1 Adds iif function compatibility SIM BSD-3-Clause C
object_reference 0.1.0 Provides immutable references to Postgres objects. FEAT BSD-3-Clause SQL
pg_py_plan_forwarding 0.1 Forward PostgreSQL planner and executor data to embedded Python callbacks FEAT BSD-3-Clause C
pg_seal 1.0.0 Tamper-evident audit log for PostgreSQL 🦭 SEC BSD-3-Clause Rust
ribollita 0.0 Se non è zuppa, è pan bagnato. FEAT BSD-3-Clause C++