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.

pgaudit · provides auditing functionality · 18.0 · Security · PostgreSQL · C · Packagedpgsodium · Postgres extension for libsodium functions · 3.1.11 · Security · BSD-3-Clause · C · Packagedsupabase_vault · Supabase Vault Extension · 0.3.1 · Security · Apache-2.0 · C · Packagedpg_tde · Percona pg_tde access method · 2.2.1 · Security · MIT · C · Packagedsql_firewall · Cluster-wide query allowlist firewall with learning, enforcing, permissive, and disabled modes keyed by user and parse-tree fingerprint. · 0.8 · Security · PostgreSQL · C · Not packagedlaunchql-base32 · RFC6238 TOTP implementation in pure PostgreSQL plpgsql · 0.0.3 · Security · MIT · C · Not packagedpgextwlist · PostgreSQL Extension Whitelisting · 1.20 · Security · PostgreSQL · C · Packagedsupautils · Extension that secures a cluster on a cloud environment · 3.2.1 · Security · Apache-2.0 · C · Packagedcredcheck · credcheck - postgresql plain text credential checker · 5.0 · Security · MIT · C · Packagedset_user · similar to SET ROLE but with added logging · 4.2.0 · Security · PostgreSQL · C · 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 packagedpg_roast · Opinionated PostgreSQL database auditor · 1.0 · Security · PostgreSQL · C · Packagedlogerrors · Function for collecting statistics about messages in logfile · 2.1.5 · Security · BSD-3-Clause · C · Packagedlogin_hook · login_hook - hook to execute login_hook.login() at login time · 1.7 · Security · GPL-3.0 · C · Packagedpg_themis · PostgreSQL encryption and decryption functions backed by the Themis cryptographic library. · 1.0 · Security · Apache-2.0 · C · Not packagedpg_auth_mon · monitor connection attempts per user · 3.0 · Security · MIT · C · Packagedpg_snakeoil · The PostgreSQL Antivirus · 1.4 · Security · PostgreSQL · C · Packagedpgauditlogtofile · pgAudit addon to redirect audit log to an independent file · 1.8.5 · Security · PostgreSQL · C · Packagedhello-world · RLS demo extension with users and products tables · 0.0.1 · Security · MIT · C · Not packagedsupabase · A friendly playground for building and validating Supabase Row‑Level Security (RLS) · 0.0.1 · Security · MIT · C · Not packagedaiven_extras · Aiven PostgreSQL extras for non-superuser access to selected database features. · 1.1.20 · Security · Apache-2.0 · C · Not packagedcolumn_encrypt · Transparent column-level encryption with encrypted_text and encrypted_bytea types · 4.0 · Security · PostgreSQL · C · Packagedpg_diffix · Provides strong dynamic anonymization for PostgreSQL query results. · fir · Security · MIT · C · Not packagedpgspeck · Encrypt and decrypt 32-bit and 48-bit integer blocks with the Speck symmetric cipher · 1.0 · Security · MIT · C · Not packagedopen_pg_tde · Transparent data encryption for upstream PostgreSQL using the tde_heap access method, including tables, indexes, TOAST, WAL, and temporary files. · 2.4.0 · Security · PostgreSQL · C · Not packagedpgpm-jwt-claims · Agentic DB - Give your agent a brain · 0.15.5 · Security · MIT · C · Not packagedsslutils · A Postgres extension for managing SSL certificates through SQL · 1.4 · Security · PostgreSQL · C · Packagednoddl · Cluster-wide DDL blocker with role and database exceptions. · 1.0 · Security · MIT · C · Not packagednoset · Module for blocking SET variables for non-super users. · 0.3.0 · Security · AGPL-3.0 · C · Packagedpg_vault_tde · Transparent Data Encryption for PostgreSQL through custom table and index access methods · 1.7.1 · Security · PostgreSQL · C · Packagedpgseccomp · provide seccomp syscall filtering for PostgreSQL · 1.0 · Security · PostgreSQL · C · Not packagedblake2b · PostgreSQL extension for fast secure hashing · 1.0 · Security · MIT · C · Not packagedpg_kpart · Reject full partition scans that omit the partition key · 1.0 · Security · ISC · C · Packagedpasswordcheck_cracklib · Strengthen PostgreSQL user password checks with cracklib · 3.1.0 · Security · LGPL-2.1 · C · Packagedpg_ed25519 · Ed25519 signing and signature-verification functions for PostgreSQL · 0.2 · Security · MIT · C · Not packagedpg_sulog · PostgreSQL superuser operation logging and blocking extension · 1.0 · Security · PostgreSQL · C · Not packagedtcle · Experimental table access method for transparent AES-256-CBC encryption of selected column types. · 1.0 · Security · PostgreSQL · C · Not packageded25519 · PostgreSQL extension for a modern and secure digital signature algorithm based on performance-optimized elliptic curves · 1.0 · Security · MIT · C · Not packagedlogin_refuse · Authentication hook that temporarily refuses logins after repeated failures · 0.1 · Security · Unknown · C · Not packagedpasswordpolicy · Dynamically configurable PostgreSQL password complexity checks. · 2.0.5 · Security · PostgreSQL · C · Packagedpg_pwhash · Advanced password hashing methods for PostgreSQL · 1.0 · Security · MIT · C · Packagedpg_ssl · Create base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL · 1.0 · Security · MIT · C · Not packagedpgpm-defaults · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.15.5 · Security · MIT · C · Not packagedpgsqlauditengine · SQL policy checks with an embedded rule and audit REST API · 1.0 · Security · GPL-3.0-only · C · Not packagedtable_guard · Configurable protection against DROP, TRUNCATE, and unqualified whole-table DELETE. · 1.0 · Security · Unknown · C · Not packagedcheck_chapmd5_password · Function for verifying CHAP-MD5 authentication responses. · 0.0.1 · Security · Apache-2.0 · C · Not packageddatafly_anon · Datafly anonymizer · 1.25 · Security · PostgreSQL · C · Not packagededb_block_commands · Restricts EDB Advanced Server superusers from utility, DML, and SELECT commands using whitelist GUCs. · 1.0 · Security · Unknown · C · Not packagedopenssl · PostgreSQL extension for cryptographic functions and types provided by OpenSSL · 0.0.1 · Security · PostgreSQL · C · Not packagedpg_dctp · Preload-only module that blocks clear-text passwords in role DDL · 0.0.1 · Security · PostgreSQL · C · Not packagedpg_injection · PostgreSQL injection · 1.0.0 · Security · MIT · C · Not packagedpg_neon_sudo · Provides Neon-specific trusted sudo wrappers that run PostgreSQL Anonymizer dynamic-masking start and stop operations as the bootstrap superuser. · 0.0.1 · Security · Unknown · C · Not packagedpg_set_acl · SET command access control list · 0.0.1 · Security · PostgreSQL · C · Not packagedpgintegrity · Trigger-based row integrity watermark checker for PostgreSQL tables · 0.0.1 · Security · Unknown · C · Not packagedpgsword · enforce Qunar SQL auditing and database object rules · 1.0 · Security · Unknown · C · Not packagedsm2 · SM2 elliptic curve cryptography functions (Chinese National Standard GB/T 32918) · 1.0 · Security · Unknown · C · Not packagedsm4 · SM4 encryption/decryption functions (Chinese National Standard) · 1.0 · Security · Unknown · C · Not packagedaclexplode · A backport of aclexplode function for PostgreSQL 8.4 and below · 1.0.3 · Security · PostgreSQL · C · Not packagedauth_delay · pause briefly before reporting authentication failure · - · Security · PostgreSQL · C · Packagedencdb · Alibaba Cloud RDS extension that provides Always Confidential Database features for PostgreSQL. · 1.1.14 · Security · Unknown · C · Not packagedencdb_btree · Alibaba Cloud RDS extension that accelerates ciphertext index queries for Always Confidential Databases. · 1.0.0 · Security · Unknown · C · Not packagedext3 · ClientAuthentication hook example that logs authentication start and end events. · 1.0 · Security · Unknown · C · Not packagedlaunchql-totp · 🛠. basic pg utils · 0.4.5 · Security · MIT · C · Not packagedletter · letter: role-based access control for PostgreSQL · 0.1 · Security · MIT · C · Not packagedlog_entries · Row trigger that records who changed a row and when · 1.0 · Security · Unknown · C · Not packagedopentde · Open Transparent Data Encryption for PostgreSQL. · 1.0 · Security · Unknown · C · Not packagedorgpasscheck · Password policy enforcement extension for PostgreSQL 16+ · 5.0 · Security · Unknown · C · Not packagedpasswordcheck · checks user passwords and reject weak password · - · Security · PostgreSQL · C · Packagedpg_ad_mapping · Maps Active Directory security groups to database roles on Aurora PostgreSQL. · 1.0 · Security · Unknown · C · Not packagedpg_argon2id · PostgreSQL extension for Argon2id password hashing functions · 1.0 · Security · MIT · C · Not packagedpg_block_systemcatalog · PostgreSQL extension to block references to system catalogs. · 1.0 · Security · PostgreSQL · C · Not packagedpg_columnmask · Amazon Aurora PostgreSQL extension for role-based dynamic column masking without changing stored data. · 1.1.0 · Security · Unknown · C · Not packagedpg_login_guard · Fail2ban-style role lockout after repeated authentication failures. · 1.0 · Security · MIT · C · Not packagedpg_mask · A tiny data mask utility written in C · 1.0.0 · Security · MIT · C · Not packagedpg_secret · Defines order-revealing encrypted domains, comparison operators, and a B-tree operator class. · 0.5 · Security · Unknown · C · Not packagedpgaudix · A native PostgreSQL extension for automatic table auditing. It mirrors table columns into audit tables and automatically keeps them in sync when the source table structure changes. · 0.2.0 · Security · Unknown · C · Not packagedpgcrypsi · C Crypsi (https://github.com/telkomdev/c-crypsi) PostgreSQL Extension · 0.0.1 · Security · MIT · C · Not packagedpgcrypto · cryptographic functions · 1.3 · Security · PostgreSQL · C · Packagedpgcryptokey · cryptographic key management · 0.85 · Security · PostgreSQL · C · Packagedpgedge_safesession · Enforce read-only sessions for specified PostgreSQL roles. · 1.0-alpha1 · Security · PostgreSQL · C · Not packagedpostfga · A preload PostgreSQL extension integrating OpenFGA authorization through an FDW, C functions, gRPC background work and shared-memory caching. · 1.0.0 · Security · Unknown · C · Not packagedrds_activity_stream · Amazon Aurora PostgreSQL database activity streams · 1.7 · Security · Unknown · C · Not packagedrds_encdb · Alibaba Cloud RDS sensitive-column result encryption extension · 1.0 · Security · Unknown · C · Not packagedsepgsql · label-based mandatory access control (MAC) based on SELinux security policy. · - · Security · PostgreSQL · C · Packagedskitch-extension-defaults · default roles · 0.0.7 · Security · MIT · C · Not packagedtencentdb_pwdcheck · TencentDB password-policy extension loaded at server startup to enforce strong passwords. · 1.0 · Security · Unknown · C · Not packagedtencentdb_superuser · TencentDB administration extension that supplies the managed pg_tencentdb_superuser role and privileges. · 1.1 · Security · Unknown · C · Not packaged

88 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pgaudit 18.0 provides auditing functionality SEC PostgreSQL C 14–18 1.7k
pgsodium 3.1.11 Postgres extension for libsodium functions SEC BSD-3-Clause C 14–18 611
supabase_vault 0.3.1 Supabase Vault Extension SEC Apache-2.0 C 14–18 234
pg_tde 2.2.1 Percona pg_tde access method SEC MIT C 18 224
sql_firewall 0.8 Cluster-wide query allowlist firewall with learning, enforcing, permissive, and disabled modes keyed by user and parse-tree fingerprint. SEC PostgreSQL C 176
launchql-base32 0.0.3 RFC6238 TOTP implementation in pure PostgreSQL plpgsql SEC MIT C 118
pgextwlist 1.20 PostgreSQL Extension Whitelisting SEC PostgreSQL C 14–18 102
supautils 3.2.1 Extension that secures a cluster on a cloud environment SEC Apache-2.0 C 14–18 88
credcheck 5.0 credcheck - postgresql plain text credential checker SEC MIT C 14–18 86
set_user 4.2.0 similar to SET ROLE but with added logging SEC PostgreSQL C 14–18 78
pg_credereum 0.1 Cryptographically verifiable database auditing backed by blockchain-style transaction blocks. SEC GPL-3.0 C 10 62
libx509pq 1.3 X.509 certificate parsing library for PostgreSQL SEC GPL-3.0 C 12–18 54
pg_roast 1.0 Opinionated PostgreSQL database auditor SEC PostgreSQL C 14–18 40
logerrors 2.1.5 Function for collecting statistics about messages in logfile SEC BSD-3-Clause C 14–18 37
login_hook 1.7 login_hook - hook to execute login_hook.login() at login time SEC GPL-3.0 C 14–18 33
pg_themis 1.0 PostgreSQL encryption and decryption functions backed by the Themis cryptographic library. SEC Apache-2.0 C 33
pg_auth_mon 3.0 monitor connection attempts per user SEC MIT C 14–18 28
pg_snakeoil 1.4 The PostgreSQL Antivirus SEC PostgreSQL C 14–18 25
pgauditlogtofile 1.8.5 pgAudit addon to redirect audit log to an independent file SEC PostgreSQL C 14–18 24
hello-world 0.0.1 RLS demo extension with users and products tables SEC MIT C 23
supabase 0.0.1 A friendly playground for building and validating Supabase Row‑Level Security (RLS) SEC MIT C 23
aiven_extras 1.1.20 Aiven PostgreSQL extras for non-superuser access to selected database features. SEC Apache-2.0 C 12–18 22
column_encrypt 4.0 Transparent column-level encryption with encrypted_text and encrypted_bytea types SEC PostgreSQL C 14–18 21
pg_diffix fir Provides strong dynamic anonymization for PostgreSQL query results. SEC MIT C 13–18 19
pgspeck 1.0 Encrypt and decrypt 32-bit and 48-bit integer blocks with the Speck symmetric cipher SEC MIT C 10–18 17
open_pg_tde 2.4.0 Transparent data encryption for upstream PostgreSQL using the tde_heap access method, including tables, indexes, TOAST, WAL, and temporary files. SEC PostgreSQL C 16–18 14
pgpm-jwt-claims 0.15.5 Agentic DB - Give your agent a brain SEC MIT C 14
sslutils 1.4 A Postgres extension for managing SSL certificates through SQL SEC PostgreSQL C 14–18 13
noddl 1.0 Cluster-wide DDL blocker with role and database exceptions. SEC MIT C 7
noset 0.3.0 Module for blocking SET variables for non-super users. SEC AGPL-3.0 C 14–18 6
pg_vault_tde 1.7.1 Transparent Data Encryption for PostgreSQL through custom table and index access methods SEC PostgreSQL C 17–18 6
pgseccomp 1.0 provide seccomp syscall filtering for PostgreSQL SEC PostgreSQL C 6
blake2b 1.0 PostgreSQL extension for fast secure hashing SEC MIT C 5
pg_kpart 1.0 Reject full partition scans that omit the partition key SEC ISC C 14–18 5
passwordcheck_cracklib 3.1.0 Strengthen PostgreSQL user password checks with cracklib SEC LGPL-2.1 C 14–18 4
pg_ed25519 0.2 Ed25519 signing and signature-verification functions for PostgreSQL SEC MIT C 10–18 4
pg_sulog 1.0 PostgreSQL superuser operation logging and blocking extension SEC PostgreSQL C 4
tcle 1.0 Experimental table access method for transparent AES-256-CBC encryption of selected column types. SEC PostgreSQL C 12–13 4
ed25519 1.0 PostgreSQL extension for a modern and secure digital signature algorithm based on performance-optimized elliptic curves SEC MIT C 2
login_refuse 0.1 Authentication hook that temporarily refuses logins after repeated failures SEC C 2
passwordpolicy 2.0.5 Dynamically configurable PostgreSQL password complexity checks. SEC PostgreSQL C 14–18 2
pg_pwhash 1.0 Advanced password hashing methods for PostgreSQL SEC MIT C 14–18 2
pg_ssl 1.0 Create base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL SEC MIT C 2
pgpm-defaults 0.15.5 PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. SEC MIT C 2
pgsqlauditengine 1.0 SQL policy checks with an embedded rule and audit REST API SEC GPL-3.0-only C 11–18 2
table_guard 1.0 Configurable protection against DROP, TRUNCATE, and unqualified whole-table DELETE. SEC C 14–18 2
check_chapmd5_password 0.0.1 Function for verifying CHAP-MD5 authentication responses. SEC Apache-2.0 C 1
datafly_anon 1.25 Datafly anonymizer SEC PostgreSQL C 1
edb_block_commands 1.0 Restricts EDB Advanced Server superusers from utility, DML, and SELECT commands using whitelist GUCs. SEC C 10–18 1
openssl 0.0.1 PostgreSQL extension for cryptographic functions and types provided by OpenSSL SEC PostgreSQL C 10–18 1