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 · Packagedcedarling_pg · PostgreSQL integration for Cedarling authorization decisions, including JWT-aware checks and RLS-oriented helpers. · 0.1.0 · Security · Apache-2.0 · Rust · Not packagedanon · PostgreSQL Anonymizer (anon) extension · 3.2.2 · Security · PostgreSQL · Rust · Packagedpg_jobmon · Extension for logging and monitoring functions in PostgreSQL · 1.4.1 · Security · PostgreSQL · SQL · 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 · Packagedcredcheck · credcheck - postgresql plain text credential checker · 5.0 · Security · MIT · C · Packagedpg_enquo · PostgreSQL extension for encrypted query operations · 0.0 · Security · MIT · Rust · Not packagedset_user · similar to SET ROLE but with added logging · 4.2.0 · Security · PostgreSQL · C · Packagedkeyhippo · RLS-compatible API keys for PostgreSQL · 1.2.5 · Security · MIT · SQL · Not packagedlibx509pq · X.509 certificate parsing library for PostgreSQL · 1.3 · Security · GPL-3.0 · C · Not packagedpg-audit-json · Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. · 1.0.2 · Security · PostgreSQL · SQL · Not packagedpg_roast · Opinionated PostgreSQL database auditor · 1.0 · Security · PostgreSQL · C · Packagedpg_oidc_validator · OAuth and OIDC token validator for PostgreSQL 18 · 1.1.0 · Security · Apache-2.0 · C++ · Packagedpg_themis · PostgreSQL encryption and decryption functions backed by the Themis cryptographic library. · 1.0 · Security · Apache-2.0 · C · Not packagedeql · Encrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data. · 2.2.1 · Security · MIT · SQL · Not packagedcheck_access · Functions and views to facilitate PostgreSQL object access inspection · 0.1 · Security · PostgreSQL · SQL · Not 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 · 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 packagedpg_fhe · Microsoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL. · 0.1 · Security · Unknown · C++ · Not packagedpgzan · Proof-of-concept pgrx extension for evaluating Zanzibar-style authorization inside PostgreSQL row-level security policies. · 0.0.0 · Security · Unknown · Rust · Not packagedpgsmcrypto · PostgreSQL SM Algorithm Extension · 0.1.1 · Security · MIT · Rust · 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 packagedwebauthn · Pure-SQL PostgreSQL implementation of WebAuthn credential registration and assertion verification. · 1.6 · Security · MIT · SQL · Not packagedsslutils · A Postgres extension for managing SSL certificates through SQL · 1.4 · Security · PostgreSQL · C · Packagedpg_enigma · Encrypted postgres data type · 0.5.0 · Security · MIT · Rust · Packagedpg_audit · An extension for creating audit tables · 0.1.3 · Security · BSD-2-Clause · SQL · Not packagedpg_cel · A pure PostgreSQL implementation of the Google Zanzibar / OpenFGA authorization model. · 0.1.0 · Security · Apache-2.0 · Rust · Not packagedpgjwt_rs · JWT verification for RS256 and Ed25519 tokens inside PostgreSQL · 0.1.2 · Security · MIT · Rust · Not packageddrop_role_helper · Generates SQL to revoke all privileges held by a role in the current database. · 1.0 · Security · PostgreSQL · SQL · Not packagedpg_pii_vault · PostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine. · 0.0.0 · Security · MIT · Rust · Not 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 packagedroleman · Parameterized role and privilege management functions for PostgreSQL. · 0.3.0 · Security · PostgreSQL · SQL · Not packagedaccumulo_access_pg · PostgreSQL extension for parsing and evaluating Accumulo Access Expressions. · 0.1.5 · Security · MIT · Rust · Not packagedblake2b · PostgreSQL extension for fast secure hashing · 1.0 · Security · MIT · C · Not packagedoidc_validator · PostgreSQL 18 OIDC bearer-token validator plugin written in Rust · 0.1.0 · Security · Unknown · Rust · Packageduniphant · PostgreSQL-centric authentication and authorization demo integrating WebAuthn, PostgREST, and role-based access control. · 1.5 · Security · MIT · SQL · Not packagedac · Access Control Postgres extension (with dev environment) · 0.0.1 · Security · Unknown · SQL · Not packagedotp · Implementation of TOTP compatible with Google Authenticator · 1.0.0 · Security · PostgreSQL · SQL · Not 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_role_fkey_trigger_functions · A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. · 1.0.4 · Security · PostgreSQL · SQL · Not packagedpg_sulog · PostgreSQL superuser operation logging and blocking extension · 1.0 · Security · PostgreSQL · C · Not packagedtce · Transparent column encryption for PostgreSQL using per-role envelope keys and external key-management services. · 0.10.0-dev · Security · PostgreSQL · Rust · Not packagedtcle · Experimental table access method for transparent AES-256-CBC encryption of selected column types. · 1.0 · Security · PostgreSQL · C · Not packagedpg_dbo_timestamp · PostgreSQL extension for storing time and author of database structure modification. · 1.0.1 · Security · Unknown · SQL · Not packagedpg_multitenant · Multi-tenant shared-schema helpers using PostgreSQL row-level security · 1.0 · Security · MIT · Rust · Not packageded25519 · PostgreSQL extension for a modern and secure digital signature algorithm based on performance-optimized elliptic curves · 1.0 · Security · MIT · C · Not packagedpasswordpolicy · Dynamically configurable PostgreSQL password complexity checks. · 2.0.5 · Security · PostgreSQL · C · Packagedpg_idm · Exposes PostgreSQL role and membership management through updatable views and DML-trigger functions. · 1.0 · Security · GPL-3.0 · SQL · Not 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 packagedpgfga · Experimental ReBAC/Zanzibar-style fine-grained authorization functions for PostgreSQL. · 0.1.0 · Security · MIT · Rust · Not packagedpgocrypto · encrypt data between Go and PG · 1.0 · Security · Unknown · SQL · Not packagedpgpm-defaults · PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. · 0.15.5 · Security · MIT · C · Not packagedsupasession · Advanced session management for Supabase. · 0.1.2 · Security · PostgreSQL · SQL · Not packagedauth0 · Auth0 Management API client for PostgreSQL. · 0.1 · Security · GPL-3.0 · SQL · 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 packagedeidos_oauth · OAuth 2.0 JWT validator for PostgreSQL 18 using the OAuth validator API. · 0.2.0 · Security · Matroid · Rust · Not packagedgdpr_anatomizer · Prototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers. · 0.0.1 · Security · Unknown · Python · Not packagedopenssl · PostgreSQL extension for cryptographic functions and types provided by OpenSSL · 0.0.1 · Security · PostgreSQL · C · Not packagedpg_command_fw · DDL and utility command firewall for PostgreSQL · 0.1.0 · Security · BSD-3-Clause · Rust · 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 packagedpgauthz · Provide Zanzibar-style relationship-based authorization inside PostgreSQL · 0.3.0 · Security · Apache-2.0 · Rust · Not packagedpgintegrity · Trigger-based row integrity watermark checker for PostgreSQL tables · 0.0.1 · Security · Unknown · C · Not packageduser_info · Provides user-related information including owned objects and granted roles. · 0.0.1 · Security · BSD-2-Clause · SQL · Not packagedaclexplode · A backport of aclexplode function for PostgreSQL 8.4 and below · 1.0.3 · Security · PostgreSQL · C · Not packagedaudit · Audits insert, update, and delete operations on PostgreSQL tables. · 1.0.0 · Security · GPL-2.0 · SQL · Not packagedaudit_stream · Postgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for the Kinetic Gain Protocol Suite. · 0.1.0 · Security · MIT · Python · Not packagedauditoria · PostgreSQL auditing extension. · 0.0.1 · Security · Unknown · SQL · Not packagedauth_delay · pause briefly before reporting authentication failure · - · Security · PostgreSQL · C · Packagedcrunchy_pooler · Crunchy Bridge helper extension that lets PgBouncer authenticate users through PostgreSQL. · Security · Unknown · SQL · Not packagedcyanaudit · Cyan Audit core extension · 2.2.0 · Security · PostgreSQL · SQL · Not packagedencdb · Alibaba Cloud RDS extension that provides Always Confidential Database features for PostgreSQL. · 1.1.14 · Security · Unknown · C · Not packagedhessra_authz · Biscuit-token authorization helpers plus key and service-chain management inside PostgreSQL. · 0.3.2 · Security · Apache-2.0 · Rust · Not packagedhyperion_vault · Encrypted secrets vault for PostgreSQL with KMS envelope encryption and automatic rotation. · 0.3.0 · Security · GPL-3.0 · Rust · Not packagedletter · letter: role-based access control for PostgreSQL · 0.1 · Security · MIT · 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_audit_tools · PostgreSQL extension for audit tables management · 0.1 · Security · MIT · SQL · 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_ecdsa_verify · ECDSA signature verification functions for PostgreSQL · 1.2.4 · Security · MIT · Rust · Not packagedpg_policy · Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls · 0.1.0 · Security · PostgreSQL · SQL · Packagedpg_seal · Tamper-evident audit log for PostgreSQL 🦭 · 1.0.0 · Security · BSD-3-Clause · Rust · 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 packagedpgho_permissions · Hierarchical RBAC and ABAC authorization for PostgreSQL and Supabase, designed for use in row-level-security policies. · 0.0.18 · Security · Unknown · SQL · 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_tde_utils · Alibaba Cloud RDS extension for batch TDE encryption and decryption of tables and indexes. · 1.1 · Security · Unknown · SQL · 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 packaged

108 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pgaudit 18.0 provides auditing functionality SEC PostgreSQL C 14–18 1.7k
cedarling_pg 0.1.0 PostgreSQL integration for Cedarling authorization decisions, including JWT-aware checks and RLS-oriented helpers. SEC Apache-2.0 Rust 646
anon 3.2.2 PostgreSQL Anonymizer (anon) extension SEC PostgreSQL Rust 14–19 295
pg_jobmon 1.4.1 Extension for logging and monitoring functions in PostgreSQL SEC PostgreSQL SQL 14–18 203
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
credcheck 5.0 credcheck - postgresql plain text credential checker SEC MIT C 14–18 86
pg_enquo 0.0 PostgreSQL extension for encrypted query operations SEC MIT Rust 12–17 79
set_user 4.2.0 similar to SET ROLE but with added logging SEC PostgreSQL C 14–18 78
keyhippo 1.2.5 RLS-compatible API keys for PostgreSQL SEC MIT SQL 15 59
libx509pq 1.3 X.509 certificate parsing library for PostgreSQL SEC GPL-3.0 C 12–18 54
pg-audit-json 1.0.2 Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. SEC PostgreSQL SQL 10–18 47
pg_roast 1.0 Opinionated PostgreSQL database auditor SEC PostgreSQL C 14–18 40
pg_oidc_validator 1.1.0 OAuth and OIDC token validator for PostgreSQL 18 SEC Apache-2.0 C++ 18 35
pg_themis 1.0 PostgreSQL encryption and decryption functions backed by the Themis cryptographic library. SEC Apache-2.0 C 33
eql 2.2.1 Encrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data. SEC MIT SQL 14–17 29
check_access 0.1 Functions and views to facilitate PostgreSQL object access inspection SEC PostgreSQL SQL 10–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
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
pg_fhe 0.1 Microsoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL. SEC C++ 18
pgzan 0.0.0 Proof-of-concept pgrx extension for evaluating Zanzibar-style authorization inside PostgreSQL row-level security policies. SEC Rust 11–15 18
pgsmcrypto 0.1.1 PostgreSQL SM Algorithm Extension SEC MIT Rust 14–18 16
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
webauthn 1.6 Pure-SQL PostgreSQL implementation of WebAuthn credential registration and assertion verification. SEC MIT SQL 14
sslutils 1.4 A Postgres extension for managing SSL certificates through SQL SEC PostgreSQL C 14–18 13
pg_enigma 0.5.0 Encrypted postgres data type SEC MIT Rust 14–18 11
pg_audit 0.1.3 An extension for creating audit tables SEC BSD-2-Clause SQL 10–18 10
pg_cel 0.1.0 A pure PostgreSQL implementation of the Google Zanzibar / OpenFGA authorization model. SEC Apache-2.0 Rust 10
pgjwt_rs 0.1.2 JWT verification for RS256 and Ed25519 tokens inside PostgreSQL SEC MIT Rust 13–18 8
drop_role_helper 1.0 Generates SQL to revoke all privileges held by a role in the current database. SEC PostgreSQL SQL 7
pg_pii_vault 0.0.0 PostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine. SEC MIT Rust 13–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
roleman 0.3.0 Parameterized role and privilege management functions for PostgreSQL. SEC PostgreSQL SQL 10–18 6
accumulo_access_pg 0.1.5 PostgreSQL extension for parsing and evaluating Accumulo Access Expressions. SEC MIT Rust 15 5
blake2b 1.0 PostgreSQL extension for fast secure hashing SEC MIT C 5
oidc_validator 0.1.0 PostgreSQL 18 OIDC bearer-token validator plugin written in Rust SEC Rust 18 5
uniphant 1.5 PostgreSQL-centric authentication and authorization demo integrating WebAuthn, PostgREST, and role-based access control. SEC MIT SQL 13 5
ac 0.0.1 Access Control Postgres extension (with dev environment) SEC SQL 4
otp 1.0.0 Implementation of TOTP compatible with Google Authenticator SEC PostgreSQL SQL 10–18 4
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_role_fkey_trigger_functions 1.0.4 A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. SEC PostgreSQL SQL 4
pg_sulog 1.0 PostgreSQL superuser operation logging and blocking extension SEC PostgreSQL C 4
tce 0.10.0-dev Transparent column encryption for PostgreSQL using per-role envelope keys and external key-management services. SEC PostgreSQL Rust 15–18 4
tcle 1.0 Experimental table access method for transparent AES-256-CBC encryption of selected column types. SEC PostgreSQL C 12–13 4