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.

repmgr · Replication manager for PostgreSQL · 5.5.0 · Replication and streams · GPL-3.0 · C · Packagedwal2json · Changing data capture in JSON format · 2.6 · Replication and streams · BSD-3-Clause · C · Packagedpglogical · PostgreSQL Logical Replication · 2.4.8 · Replication and streams · PostgreSQL · C · Packagedpglogical_origin · Dummy extension for compatibility when upgrading from Postgres 9.4 · 2.4.7 · Replication and streams · PostgreSQL · C · Packagedpgactive · Active-Active Replication Extension for PostgreSQL · 2.1.7 · Replication and streams · Apache-2.0 · C · Packagedspock · Multi-master logical replication extension for PostgreSQL · 5.0.10 · Replication and streams · PostgreSQL · C · Packagedpg_bulkload · pg_bulkload is a high speed data loading utility for PostgreSQL · 3.1.23 · Replication and streams · BSD-3-Clause · C · Packageddecoder_raw · Output plugin for logical replication in Raw SQL format · 1.0 · Replication and streams · PostgreSQL · C · Packagedpg_paxos · Paxos distributed consensus functions and table replication for PostgreSQL · 0.2 · Replication and streams · PostgreSQL · C · Not packagedpgcapture · A scalable Netflix DBLog implementation for PostgreSQL · 0.1 · Replication and streams · Apache-2.0 · Go · Not packageddecoderbufs · Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format · 3.6.0 · Replication and streams · MIT · C · Packagedamqp · Publish messages to AMQP brokers from PostgreSQL · 0.4.2 · Replication and streams · BSD-3-Clause · C · Not packagedgfs · GFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally · 0.0.1 · Replication and streams · MIT · Rust · Not packagedora_migrator · Tools to migrate Oracle databases to PostgreSQL · 1.1.0 · Replication and streams · PostgreSQL · SQL · Not packagedkafka · Produce messages to Apache Kafka from PostgreSQL · 0.0.1 · Replication and streams · MIT · C · Not packagedsynchdb · Mixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagedpg_failover_slots · PG Failover Slots extension · 1.2.1 · Replication and streams · PostgreSQL · C · Packagedmetagration · Migrate Postgres with Postgres · 1.0.4 · Replication and streams · PostgreSQL · SQL · Not packagedpgl_ddl_deploy · automated ddl deployment using pglogical · 2.2.1 · Replication and streams · MIT · C · Packagedmimeo · Extension for specialized, per-table replication between PostgreSQL instances · 1.5.1 · Replication and streams · PostgreSQL · SQL · Packagedpg_turso · Postgres output plugin for replicating data to Turso. · 1.0 · Replication and streams · MIT · Zig · Not packagedpg_duckpipe · CDC synchronization from heap tables to DuckLake columnar tables · 1.0.0 · Replication and streams · MIT · Rust · Not packagedjsoncdc · JSON logical decoding output plugin · 0.1.0 · Replication and streams · Apache-2.0 · Rust · Not 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 packagedpg_tm_aux · Transfer manager auxiliary functions · 1.1.1 · Replication and streams · Unknown · C · Not packagedlolor · Logical-replication-friendly replacement for PostgreSQL large objects · 1.2.2 · Replication and streams · PostgreSQL · C · Packagedpgclone · Clone PostgreSQL databases, schemas, tables, and functions across environments · 4.4.2 · Replication and streams · PostgreSQL · C · Packagedpgnats · NATS messaging integration with publish, subscribe, JetStream, key-value, and object store SQL APIs · 1.1.0 · Replication and streams · MIT · Rust · Not packagedcigration · Online migration and rebalancing of colocated Citus shards for cluster expansion, contraction, and worker replacement. · 1.1 · Replication and streams · Apache-2.0 · SQL · Not packageddb_migrator · Tools to migrate other databases to PostgreSQL · 1.0.0 · Replication and streams · BSD-3-Clause · SQL · Packagedchdb_hook · Headless hook for COPY and CREATE TABLE over chDB-supported URLs · 0.1.1 · Replication and streams · Apache-2.0 · C · Not packagedpg_zlog · Logical table replication using Ceph and ZLog · 0.1 · Replication and streams · Unknown · C · Not packagedwal2mongo · PostgreSQL logical decoding output plugin for MongoDB · 1.0.7 · Replication and streams · Apache-2.0 · C · Packagedpg_migrate · Migrates a PostgreSQL table avoiding long locks · 0.1.1 · Replication and streams · BSD-3-Clause · C · Not packagedadvcopy · PL/Python PostgreSQL extension for copying data to and from S3. · 0.0.2 · Replication and streams · Unknown · Python · 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 packagedlogical_ddl · Replicate supported DDL changes over PostgreSQL logical replication · 0.1.0 · Replication and streams · MIT · C · Packagedpg_fact_loader · build fact tables with Postgres · 2.0.1 · Replication and streams · MIT · C · Packagedpg_fasttransfer · Postgresql Extension for FastTransfer · 1.0 · Replication and streams · MIT · 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 packageddata2pg · Migration framework for discovering, copying, and comparing non-PostgreSQL database content through foreign data wrappers. · 0.7 · Replication and streams · Unknown · SQL · 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 packagedpg_chainsync · Access blockchain blocks, events, and tasks directly inside PostgreSQL using background workers. · 0.0.0 · Replication and streams · MIT · Rust · Not packagedpg_pageprep · Prepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise. · 0.1 · Replication and streams · PostgreSQL · C · Not packagedbwcontrol · Bottledwater control extension · 1.0 · Replication and streams · PostgreSQL · C · Not packagedpg_kafka_events · Publishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagednanomsgtopdb · Receive nanomsg messages into a PipelineDB stream. · 1.0 · Replication and streams · Unknown · C · Not packagedmysql_migrator · Tools for MySQL to PostgreSQL migration · 0.3.0 · Replication and streams · PostgreSQL · SQL · Not packagedpanda_post · Python Pandas data in Postgres · 0.2.1 · Replication and streams · BSD-2-Clause · Python · Not packagedpandapost · Python Pandas data in Postgres · 0.2.0 · Replication and streams · BSD-2-Clause · Python · Not packagedpgcat · Enhanced logical replication extension for per-table subscriptions, table mapping, and replica-identity tracking. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagedpgmqtt · CDC-to-MQTT broker for PostgreSQL · 0.4.1 · Replication and streams · Elastic-2.0 · Rust · Packagedpg_redispub · Publish channel messages from PostgreSQL to a local Redis server · 1.0 · Replication and streams · MIT · C · Not packagedpgq_node · Coordinate nodes, subscribers, consumers, and watermarks for cascaded PgQ queueing · 3.5 · Replication and streams · ISC · SQL · Not packagedrppd · Trigger-based PostgreSQL event dispatcher that sends row changes over gRPC to a clustered Rust/Python execution service. · 0.2.2 · Replication and streams · AGPL-3.0 · Rust · Not packagedjx_io · Extension to export and import json and xml from/to postgres · 0.1.1 · Replication and streams · PostgreSQL · SQL · Not packagedpglogical_ticker · Have an accurate view on pglogical replication delay · 1.4.1 · Replication and streams · PostgreSQL · C · Packagedpg_follower · Educational logical-replication extension that captures and applies database changes · 1.0 · Replication and streams · Unknown · C · Not packagedpg_repeater · Replicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw. · 0.1 · Replication and streams · PostgreSQL · C · Not packagedpg_wal_ext · Read WAL files and possibly generate the SQL · 1.0 · Replication and streams · MIT · C · Not packagedpigiaminja · PostgreSQL extension to export using Jinja templates · 0.1.0 · Replication and streams · PostgreSQL · Rust · Not packagedsynchronize_logical_slots · Synchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers. · 1.0 · Replication and streams · Unknown · C · Not packagedcdc_webhook · Change Data Capture webhook extension · 1.0 · Replication and streams · Unknown · Python · Not packagedcheck_orapg · Validate Oracle-to-PostgreSQL or EDB migrations by comparing database objects, privileges, attributes, comments, and row counts. · 3.0 · Replication and streams · Unknown · SQL · Not packagedcopy_parquet · PoC to support PostgreSQL COPY with Apache Parquet · 0.0.1 · Replication and streams · Apache-2.0 · C++ · Not packagedddl_repl · Replicate DDL and DCL commands across PostgreSQL instances by means of a utility hook · 1.0 · Replication and streams · Unknown · C · Not packagedgsheets · Read and write Google Sheets from PostgreSQL. · 0.1.0 · Replication and streams · MIT · C · Not packagedly2pg · Import LilyPond files into PostgreSQL · 0.1 · Replication and streams · Unknown · SQL · Not packagedmigration · Database Migrations: Configure and Run · 0.0.1 · Replication and streams · Unknown · SQL · Not packagedpg_delta · Delta Lake streaming integration for PostgreSQL · 0.2.0 · Replication and streams · Unknown · Rust · Not packagedpg_streaming · Declarative stream processing engine inside PostgreSQL · 0.2.0 · Replication and streams · Matroid · Rust · Not packagedpglogical_output_nzhooks · Example pglogical output-plugin row-filter hook that keeps only changes for a hard-coded relation name · 1.0 · Replication and streams · Unknown · C · Not packagedpgscraper · Postgresql extension for scraping data from web · 1.0 · Replication and streams · Unknown · Rust · Not packagedpostgres_redis · synchronize selected PostgreSQL table values to Redis with hooks and a background worker · 0.0.0 · Replication and streams · MIT · Rust · Not packagedrep_fdw · Replicate table changes to another PostgreSQL server through postgres_fdw · 0.1.0 · Replication and streams · PostgreSQL · SQL · Not packagedsys_syn_dblink · PL/pgSQL synchronization processor that pulls sys_syn queues over named dblink connections, transforms batches, writes local tables, and returns processing status to the source database. · 0.0.1 · Replication and streams · PostgreSQL · SQL · Not packagedtcn_json · C trigger function that sends primary-key change notifications through LISTEN/NOTIFY. · 1.1 · Replication and streams · Unknown · C · Not packagedazure_storage · Azure Database for PostgreSQL extension for importing from and exporting to Azure Storage blobs from SQL. · 1.9 · Replication and streams · Unknown · C · Not packagedbdr · Active-active logical replication and distributed consistency for PGD. · 6.5 · Replication and streams · Proprietary · Unknown · Not packagedcopy_data · some small postgresql extensions for beginners · 1.0 · Replication and streams · Unknown · C · Not packagedlondiste · Londiste replication support code · 3.8 · Replication and streams · ISC · SQL · Not packagedpboutput · Binary logical-decoding output plugin that encodes PostgreSQL changes as Protocol Buffers. · 0.0.0 · Replication and streams · Unknown · Rust · Not packagedpg_logical_ddl · Experimental DDL replication implementation for PostgreSQL · 1.0 · Replication and streams · Unknown · C · Not packagedpg_transport · Amazon RDS extension for transportable PostgreSQL database workflows. · 1 · Replication and streams · Unknown · C · Not packagedpgl_validate · Cross-node data validation for pglogical and PostgreSQL logical replication — lag-correct, contract-aware row-count and checksum verification with sound (zero-false-positive) divergence detection. · 0.1.0 · Replication and streams · MIT · Rust · Not packagedpgoutput · Logical Replication output plugin · - · Replication and streams · PostgreSQL · C · Packagedputpostlogic · Unreleased logical decoding output-plugin prototype that emits JSON changes through PostgreSQL, Kafka, or Nanomsg. · 0.1.0 · Replication and streams · Unknown · C · Not packagedrds_hwdrs_ddl · Huawei Cloud RDS incremental DDL synchronization helper extension · 1 · Replication and streams · Unknown · C · Not packagedrds_online_ddl · Alibaba Cloud RDS online column type migration extension · 1.0 · Replication and streams · Unknown · C · Not packagedrds_online_migrate · Alibaba Cloud RDS online table partitioning extension · 1.0 · Replication and streams · Unknown · C · Not packagedsynchro_pg · Database-side offline-first synchronization with scoped change capture · 0.3.0 · Replication and streams · MIT · Rust · Not packagedtencentdb_failover_slot · TencentDB proprietary kernel extension that synchronizes logical replication-slot state to standby nodes so subscriptions can continue across primary/standby failover. · 1.0 · Replication and streams · Unknown · C · Not packagedtest_decoding · SQL-based test/example module for WAL logical decoding · - · Replication and streams · PostgreSQL · C · Packaged

93 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
repmgr 5.5.0 Replication manager for PostgreSQL ETL GPL-3.0 C 14–18 1.7k
wal2json 2.6 Changing data capture in JSON format ETL BSD-3-Clause C 14–18 1.5k
pglogical 2.4.8 PostgreSQL Logical Replication ETL PostgreSQL C 14–18 1.2k
pglogical_origin 2.4.7 Dummy extension for compatibility when upgrading from Postgres 9.4 ETL PostgreSQL C 14–18 1.2k
pgactive 2.1.7 Active-Active Replication Extension for PostgreSQL ETL Apache-2.0 C 14–18 1.1k
spock 5.0.10 Multi-master logical replication extension for PostgreSQL ETL PostgreSQL C 15–18 744
pg_bulkload 3.1.23 pg_bulkload is a high speed data loading utility for PostgreSQL ETL BSD-3-Clause C 14–18 496
decoder_raw 1.0 Output plugin for logical replication in Raw SQL format ETL PostgreSQL C 14–18 349
pg_paxos 0.2 Paxos distributed consensus functions and table replication for PostgreSQL ETL PostgreSQL C 309
pgcapture 0.1 A scalable Netflix DBLog implementation for PostgreSQL ETL Apache-2.0 Go 285
decoderbufs 3.6.0 Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format ETL MIT C 14–18 260
amqp 0.4.2 Publish messages to AMQP brokers from PostgreSQL ETL BSD-3-Clause C 10–18 214
gfs 0.0.1 GFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally ETL MIT Rust 156
ora_migrator 1.1.0 Tools to migrate Oracle databases to PostgreSQL ETL PostgreSQL SQL 10–18 121
kafka 0.0.1 Produce messages to Apache Kafka from PostgreSQL ETL MIT C 10–18 112
synchdb 1.0 Mixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources. ETL Apache-2.0 C 16–18 111
pg_failover_slots 1.2.1 PG Failover Slots extension ETL PostgreSQL C 14–18 106
metagration 1.0.4 Migrate Postgres with Postgres ETL PostgreSQL SQL 102
pgl_ddl_deploy 2.2.1 automated ddl deployment using pglogical ETL MIT C 14–18 99
mimeo 1.5.1 Extension for specialized, per-table replication between PostgreSQL instances ETL PostgreSQL SQL 14–18 79
pg_turso 1.0 Postgres output plugin for replicating data to Turso. ETL MIT Zig 75
pg_duckpipe 1.0.0 CDC synchronization from heap tables to DuckLake columnar tables ETL MIT Rust 17–18 69
jsoncdc 0.1.0 JSON logical decoding output plugin ETL Apache-2.0 Rust 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
pg_tm_aux 1.1.1 Transfer manager auxiliary functions ETL C 50
lolor 1.2.2 Logical-replication-friendly replacement for PostgreSQL large objects ETL PostgreSQL C 15–18 48
pgclone 4.4.2 Clone PostgreSQL databases, schemas, tables, and functions across environments ETL PostgreSQL C 14–18 44
pgnats 1.1.0 NATS messaging integration with publish, subscribe, JetStream, key-value, and object store SQL APIs ETL MIT Rust 14–18 37
cigration 1.1 Online migration and rebalancing of colocated Citus shards for cluster expansion, contraction, and worker replacement. ETL Apache-2.0 SQL 10–13 28
db_migrator 1.0.0 Tools to migrate other databases to PostgreSQL ETL BSD-3-Clause SQL 14–18 28
chdb_hook 0.1.1 Headless hook for COPY and CREATE TABLE over chDB-supported URLs ETL Apache-2.0 C 15–19 20
pg_zlog 0.1 Logical table replication using Ceph and ZLog ETL C 19
wal2mongo 1.0.7 PostgreSQL logical decoding output plugin for MongoDB ETL Apache-2.0 C 14–18 18
pg_migrate 0.1.1 Migrates a PostgreSQL table avoiding long locks ETL BSD-3-Clause C 16
advcopy 0.0.2 PL/Python PostgreSQL extension for copying data to and from S3. ETL Python 12
pgcmp 3.1 Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. ETL BSD-3-Clause C 12
logical_ddl 0.1.0 Replicate supported DDL changes over PostgreSQL logical replication ETL MIT C 14–18 11
pg_fact_loader 2.0.1 build fact tables with Postgres ETL MIT C 14–18 11
pg_fasttransfer 1.0 Postgresql Extension for FastTransfer ETL MIT C 15–18 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
data2pg 0.7 Migration framework for discovering, copying, and comparing non-PostgreSQL database content through foreign data wrappers. ETL SQL 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
pg_chainsync 0.0.0 Access blockchain blocks, events, and tasks directly inside PostgreSQL using background workers. ETL MIT Rust 17 8
pg_pageprep 0.1 Prepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise. ETL PostgreSQL C 10–11 8
bwcontrol 1.0 Bottledwater control extension ETL PostgreSQL C 10–18 7
pg_kafka_events 1.0 Publishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. ETL Apache-2.0 C 7
nanomsgtopdb 1.0 Receive nanomsg messages into a PipelineDB stream. ETL C 6
mysql_migrator 0.3.0 Tools for MySQL to PostgreSQL migration ETL PostgreSQL SQL 5
panda_post 0.2.1 Python Pandas data in Postgres ETL BSD-2-Clause Python 5
pandapost 0.2.0 Python Pandas data in Postgres ETL BSD-2-Clause Python 5