Get Trunk
cargo install pg-trunk
Trunk is an open-source package installer and registry for PostgreSQL extensions.
Featured
Analytics
Auditing / Logging
Change Data Capture
Connectors
Data / Transformations
Debugging
Index / Table Optimizations
Machine Learning
Metrics
Orchestration
Procedural Languages
Query Optimizations
Search
Security
Tooling / Admin
auto_explain
The auto_explain module provides a means for logging execution plans of slow statements automatical...
pgmq
A lightweight message queue. Like AWS SQS and RSMQ, on Postgres.
pg_partman
Extension to manage partitioned tables by time or ID.
pg_prewarm
The pg_prewarm module provides a convenient way to load relation data into either the operating sys...
pg_stat_statements
The pg_stat_statements module provides a means for tracking planning and execution statistics of al...
pgvector
Open-source vector similarity search for Postgres
postgis
PostGIS geometry and geography spatial types and functions.
adminpack
adminpack serves as an auxilliary support to administrative management tools, such as pgAdmin. This...
age
Leverage a graph database on top of the existing relational database.
aggs_for_vecs
aggs_for_vecs introduces analtical functions that deal with aggreates, such as min, max, average, a...
amcheck
The amcheck module provides functions that allow you to verify the logical consistency of the struc...
argm
Argm postgresql extension: argmax/argmin and anyold aggregate functions.
auth_delay
auth_delay causes the server to pause briefly before reporting authentication failure, to make brut...
autoinc
Functions for Autoincrementing Fields.
basebackup_to_shell
basebackup_to_shell adds a custom basebackup target called shell.
basic_archive
This module copies completed WAL segment files to the specified directory.
bloom
bloom provides an index access method based on Bloom filters.
bool_plperl
transform between bool and plperl/plperlu
bool_plperlu
transform between bool and plperlu
btree_gin
btree_gin provides sample GIN operator classes that implement B-tree equivalent behavior.
btree_gist
btree_gist provides sample GIST operator classes that implement B-tree equivalent behavior.
chkpass
Stand alone version of chkpass type for PG 11+.
citext
The citext module provides a case-insensitive character string type, citext.
citus
Distributed PostgreSQL as an extension.
clerk_fdw
Foreign Data wrapper for clerk
clickhouse_fdw
ClickHouse FDW for PostgreSQL.
count_distinct
An extension with alternative to COUNT(DISTINCT ...) aggregate in PostgreSQL.
credcheck
PostgreSQL plain credential checker
cube
Data type cube for representing multidimensional cubes.
dblink
Executes a query in a remote database.
db_migrator
Functions for migrating databases from other data sources to PostgreSQL.
dict_int
Dictionary to control the indexing of integers (signed and unsigned).
dict_xsyn
This dictionary type replaces words with groups of their synonyms.
duckdb_fdw
This PostgreSQL extension implements a Foreign Data Wrapper (FDW) for DuckDB.
earthdistance
The earthdistance module provides two different approaches to calculating great circle distances on...
emaj
Fine-grained write logging and time travel on subsets of the DB
envvar
The envvar extension provides a function that returns the value of an environment variable set on t...
extra_window_functions
Extra Window Functions for PostgreSQL.
file_fdw
Access data files in the server's file system.
fuzzystrmatch
The fuzzystrmatch module provides several functions to determine similarities and distance between ...
h3_pg
PostgreSQL bindings for H3.
hstore
hstore data type for storing sets of key/value pairs within a single PostgreSQL value.
hstore_plperl
Transforms the hstore type for the PL/Perl language.
hstore_plperlu
Transforms the hstore type for the PL/Perlu language.
hstore_plpython3u
Transforms the hstore type for the PL/Python language.
hydra_columnar
Columnar storage for Postgres
hypopg
Hypothetical Indexes for PostgreSQL.
icu_ext
Access ICU functions.
index_advisor
A PostgreSQL extension for recommending indexes to improve query performance.
insert_username
Functions for Tracking Who Changed a Table.
intagg
The intagg module provides an integer aggregator and an enumerator.
intarray
The intarray module provides a number of useful functions and operators for manipulating null-free ...
ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL.
isn
The isn module provides data types for the following international product numbering standards: EAN...
jdbc_fdw
PostgreSQL Foreign Data Wrapper for JDBC.
jsonb_plperl
Transforms the jsonb type for the PL/Perl language.
jsonb_plperlu
Transforms the jsonb type for the PL/Perlu language.
jsonb_plpython3u
Transforms the jsonb type for the PL/Python language.
jsonschema
The jsonschema extension provides JSON Schema validation functions supporting drafts 2020-12, 2019-...
kafka_fdw
Kafka foreign database wrapper for postresql.
lo
The lo module provides support for managing Large Objects.
lower_quantile
Provides lower_quantile aggregate function.
ltree
This module implements a data type ltree for representing labels of data stored in a hierarchical t...
ltree_plpython3u
Transforms the ltree type for the PL/Python language.
meta
Normalized, friendlier system catalog for PostgreSQL.
meta_triggers
PostgreSQL Extension: Insert, update and delete triggers that make the meta extension writable.
mobilitydb
Geospatial trajectory data management.
moddatetime
Functions for Tracking Last Modification Time.
multicorn
Multicorn is a PostgreSQL extension that allows you to create foreign data wrappers in Python.
mysql_fdw
This PostgreSQL extension implements a Foreign Data Wrapper (FDW) for MySQL.
old_snapshot
The old_snapshot module allows inspection of the server state that is used to implement old_snapsho...
oracle_fdw
PostgreSQL Foreign Data Wrapper for Oracle.
orafce
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS.
ora_migrator
Tools for Oracle to PostgreSQL migration.
orb_fdw
Foreign Data wrapper for orb
pageinspect
The pageinspect module provides functions that allow you to inspect the contents of database pages ...
parquet_s3_fdw
Foreign data wrapper for Parquet files stored on S3.
passwordcheck
The passwordcheck module checks users' passwords whenever they are set with CREATE ROLE or ALTER RO...
periods
This extension recreates the behavior defined in SQL:2016 (originally in SQL:2011) around periods a...
permuteseq
Pseudo-randomly permute sequences with a format-preserving encryption on elements.
pg_analytics
pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres
pg_anonymize
PostgreSQL dynamic data anonymization.
pgaudit
The PostgreSQL Audit Extension (pgAudit) provides detailed session and/or object audit logging via ...
pg_auto_dw
An auto data warehouse extension for Postgres.
pg_base36
base36 encoding and decoding
pg_base62
base62 encoding and decoding
pg_bigm
This module allows a user to create 2-gram (bigram) index for faster full text search.
pg_bm25
Full text search over SQL tables using the state-of-the-art BM25 algorithm
pgbouncer_fdw
PostgreSQL Foreign Data Wrapper to Connect to pgbouncer.
pg_buffercache
The pg_buffercache module provides a means for examining what's happening in the shared buffer cach...
pgcozy
Extension for pre-warming shared buffers according to previous pg_buffercache snapshots for Postgre...
pg_cron
Job scheduler for PostgreSQL.
pgcrypto
The pgcrypto module provides cryptographic functions for PostgreSQL.
pg_currency
1 Byte Currency ISO type for PostgreSQL.
pg_dbms_job
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL.
pg_dirtyread
Read dead but unvacuumed tuples from a PostgreSQL relation.
pgemailaddr
Email address type for PostgreSQL
pg_embedding
The pg_embedding extension enables the use of the Hierarchical Navigable Small World (HNSW) algorit...
pg_extra_time
Additional date time functions.
pgfaceting
Faceted query acceleration for PostgreSQL using roaring bitmap.
pg_failover_slots
PG Failover Slots avoids the need for you to reseed your logical replication tables when a new stan...
pg_financial
PostgreSQL extension with functions and aggregates for financial calculations.
pgfincore
Use mincore to explore linux (or BSD) cache memory.
pg_freespacemap
The pg_freespacemap module provides a means for examining the free space map (FSM).
pg_graphql
pg_graphql adds GraphQL support to your PostgreSQL database.
pg_hashids
Hashids is a small open-source library that generates short, unique, non-sequential ids from number...
pg_hint_plan
pg_hint_plan makes it possible to tweak PostgreSQL execution plans.
pg_hint_plan16
pg_html5_email_address
PostgreSQL email validation that is consistent with the HTML5 spec.
pghydro
Provide drainage network analysis functionality to PostGIS.
pg_ivm
IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
pg_jsonschema
pg_jsonschema is a PostgreSQL extension adding support for JSON schema validation on json and jsonb...
pgjwt
PostgreSQL implementation of JWT (JSON Web Tokens).
pg_lakehouse
An analytical query engine for Postgres, similar to DuckDB
pg_later
Execute SQL statements now and check the results later.
pgl_ddl_deploy
Transparent Logical DDL Replication.
pglogical
PostgreSQL Logical Replication.
pglogical_ticker
Time-based replication delay for pglogical.
pg_mon
PostgreSQL extension to enhance query monitoring.
pg_net
A PostgreSQL extension providing an async networking interface accessible via SQL using a backgroun...
pg_orphaned
Functions relating to orphaned files.
pg_permissions
A simple set of views to see ALL permissions in a PostgreSQL database.
pg_proctab
Access operating system process table.
pgq
Generic Queue for PostgreSQL.
pg_quack
PostgreSQL but it's really DuckDB
pg_qualstats
pg_qualstats is a PostgreSQL extension keeping statistics on predicates found in WHERE statements a...
pg_rational
Precise fractional arithmetic for PostgreSQL.
pg_repack
pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and option...
pg_roaringbitmap
Support for Roaring Bitmaps.
pgrouting
pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functi...
pgrowlocks
The pgrowlocks module provides a function to show row locking information for a specified table.
pg_savior
pg_savior is a PostgreSQL extension designed to prevent accidental data loss due to non-parameteriz...
pg_search
Full text search over heap tables using the BM25 algorithm.
pg_semver
A semantic version data type for PostgreSQL.
pg_show_plans
Show query plans of all currently running SQL statements.
pg_similarity
Support similarity queries.
pg_smtp_client
PostgreSQL extension to send email using SMTP
pgsodium
Modern cryptography for PostgreSQL using libsodium.
pg_sparse
Sparse Vector Similarity Search Inside Postgres
pgsql_http
HTTP client for PostgreSQL, retrieve a web page from inside the database.
pgsql_ogr_fdw
PostgreSQL foreign data wrapper for OGR.
pg_squeeze
A PostgreSQL extension for automatic bloat cleanup.
pg_stat_kcache
Gathers statistics about real reads and writes done by the filesystem layer.
pg_stat_monitor
Query Performance Monitoring Tool for PostgreSQL.
pgstattuple
The pgstattuple module provides various functions to obtain tuple-level statistics.
pg_store_plans
Track plan statistics of all SQL statements executed.
pg_surgery
The pg_surgery module provides various functions to perform surgery on a damaged relation.
pgtap
Unit testing for PostgreSQL.
pgtelemetry
Useful monitoring views for PostgreSQL. Monitors replication, disk usage, sources of concurrent que...
pg_text_semver
PostgreSQL semantic versioning extension, with comparison functions and operators.
pg_tier
Open source s3 tiering extension for Postgres.
pg_timeit
PostgreSQL extension that provides high-accuracy timing of SQL expressions.
pg_timeseries
Open source timeseries extension for Postgres.
pg_tle
Framework for building trusted language extensions for PostgreSQL.
pg_track_settings
Keep track of postgresql settings modification.
pg_trgm
Text similarity measurement and index searching based on trigrams.
pgtt
Extension to add Global Temporary Tables feature to PostgreSQL.
pguri
uri type for PostgreSQL.
pg_uuidv7
Create valid version 7 UUIDs in Postgres.
pg_visibility
The pg_visibility module provides a means for examining the visibility map (VM) and page-level visi...
pg_wait_sampling
Sampling based statistics of wait events.
pg_walinspect
Provides SQL functions that allow you to inspect the contents of write-ahead log of a running Postg...
plcoffee
PL/CoffeeScript (v8) trusted procedural language
pljava
Java Procedural Language for PostgreSQL
plperl
The PL/Perl procedural language for PostgreSQL.
plperlu
Th PL/Perlu procedural language for PostgreSQL.
plpgsql
The PL/Pgsql procedural language for PostgreSQL.
plpgsql_check
Linter tool for the PostgreSQL language plpgsql.
plprofiler
The plprofiler is an extension for the PostgreSQL database system to create performance profiles of...
plproxy
PL/Proxy development.
plpython2u
Th PL/Python untrusted procedural language for PostgreSQL.
plpython3u
Th PL/Python3U untrusted procedural language for PostgreSQL.
plpythonu
plr
R Procedural Language for PostgreSQL
plrust
A Rust procedural language handler for PostgreSQL.
plsh
PL/sh is a procedural language handler for PostgreSQL that allows you to write stored procedures in...
pltcl
The PL/Tcl procedural language for PostgreSQL.
pltclu
The PL/Tclu procedural language for PostgreSQL.
plv8
A procedural language in JavaScript powered by V8
pointcloud
A PostgreSQL extension for storing point cloud (LIDAR) data.
postgresbson
This PostgreSQL extension realizes the BSON data type, together with functions to create and inspec...
postgres_decoderbufs
A PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers.
postgres_fdw
Foreign-data wrapper postgres_fdw, which can be used to access data stored in external PostgreSQL s...
postgresml
PostgresML is a machine learning extension to PostgreSQL that enables you to perform training and i...
postgresql_anonymizer
Anonymization & Data Masking for PostgreSQL.
postgresql_hll
HyperLogLog data structures as a native data type.
postgresql_logfdw
Foreign-data wrapper for Postgres log file access.
postgresql_topn
TopN is an open source PostgreSQL extension that returns the top values in a database according to ...
powa
PostgreSQL Workload Analyser-core.
prefix
Prefix Range module for PostgreSQL.
prometheus_fdw
Foreign Data wrapper for prometheus
quantile
This extension provides three simple aggregate functions to compute quantiles.
random
Random data generator extension.
redis_fdw
A PostgreSQL foreign data wrapper for Redis.
refint
Functions for Implementing Referential Integrity
rum
The rum module provides an access method to work with a RUM index.
seg
Data type seg for representing line segments, or floating point intervals.
sepgsql
sepgsql is a loadable module that supports label-based mandatory access control (MAC) based on SELi...
sequential_uuids
Generator of sequential UUIDs.
set_user
PostgreSQL extension allowing privilege escalation with enhanced logging and control.
smlar
PostgreSQL extension for an effective similarity search
sslinfo
The sslinfo module provides information about the SSL certificate that the current client provided ...
sslutils
A Postgres extension for managing SSL certificates through SQL.
supautils
PostgreSQL extension that prevents doing ALTER/DROP/GRANT on a set of reserved roles.
system_stats
Expose system metrics such as CPU, memory and disk information.
tablefunc
The tablefunc module includes various functions that return tables (that is, multiple rows).
tcn
The tcn module provides a trigger function that notifies listeners of changes to any table on which...
tdigest
PostgreSQL extension for estimating percentiles using t-digest.
tds_fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server).
tembo_ivm
IVM (Incremental View Maintenance) implementation with Partitioned Support
temporal_tables
Temporal Tables PostgreSQL Extension.
test_decoding
test_decoding receives WAL through the logical decoding mechanism and decodes it into text represen...
timescaledb
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as ...
tsm_system_rows
The tsm_system_rows module provides the table sampling method SYSTEM_ROWS.
tsm_system_time
The tsm_system_time module provides the table sampling method SYSTEM_TIME.
unaccent
unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes.
uuid_ossp
The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using on...
vectorize
The simplest way to orchestrate vector search on Postgres.
vectorscale
A complement to pgvector for high performance, cost efficient vector search on large workloads.
wal2json
wal2json is an output plugin for logical decoding.
wrappers
Postgres Foreign Data Wrapper development framework in Rust.
xml2
The xml2 module provides XPath querying and XSLT functionality.
zhparser
zhparser is a PostgreSQL extension for full-text search of Chinese language
zson
An extension for transparent JSONB compression