License: PostgreSQL
251 extensions
-
timeseries
Convenience API for time series stack
-
periods
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
-
pg_cron
Job scheduler for PostgreSQL
-
pg_later
Run queries now and get results later
-
pg_dispatch
Asynchronous SQL dispatcher built on pg_cron
-
pg_stl
Time series analysis functions for PostgreSQL
-
mobilitydb
MobilityDB geospatial trajectory data management & analysis platform
-
mobilitydb_datagen
MobilityDB random data generator functions
-
earthdistance
calculate great-circle distances on the surface of the Earth
-
vector
vector data type and ivfflat and hnsw access methods
-
vectorscale
Advanced indexing for vector data with DiskANN
-
vectorize
The simplest way to do vector search on Postgres
-
pgroonga
Use Groonga as index, fast full text search platform for all languages!
-
pgroonga_database
PGroonga database management module
-
pg_bigm
create 2-gram (bigram) index for faster full text search.
-
zhparser
a parser for full-text search of Chinese
-
pg_textsearch
Full-text search with BM25 ranking
-
pg_fts
Full-text search with BM25 and BM25F ranking
-
pg_cjk_parser
CJK bigram parser derived from PostgreSQL full-text search
-
hunspell_cs_cz
Czech Hunspell Dictionary
-
hunspell_de_de
German Hunspell Dictionary
-
hunspell_en_us
en_US Hunspell Dictionary
-
hunspell_fr
French Hunspell Dictionary
-
hunspell_ne_np
Nepali Hunspell Dictionary
-
hunspell_nl_nl
Dutch Hunspell Dictionary
-
hunspell_nn_no
Norwegian (norsk) Hunspell Dictionary
-
hunspell_pt_pt
Portuguese Hunspell Dictionary
-
hunspell_ru_ru
Russian Hunspell Dictionary
-
hunspell_ru_ru_aot
Russian Hunspell Dictionary (from AOT.ru group)
-
fuzzystrmatch
determine similarities and distance between strings
-
pg_trgm
text similarity measurement and index searching based on trigrams
-
pg_analytics
Postgres for analytics, powered by DuckDB
-
pg_parquet
copy data between Postgres and Parquet
-
pg_partman
Extension to manage partitioned tables by time or ID
-
pg_strom
PG-Strom - big-data processing acceleration using GPU and NVME
-
pg_sorted_heap
Sorted heap table AM with zone map scan pruning and built-in vector search
-
tablefunc
functions that manipulate whole tables, including crosstab
-
pgmq
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
-
pgmb
A simple PostgreSQL Message Broker system
-
rum
RUM index access method
-
pg_ttl_index
Automatic data expiration with TTL indexes
-
jsquery
data type for jsonb inspection
-
hypopg
Hypothetical indexes for PostgreSQL
-
index_advisor
Query index advisor
-
plan_filter
filter statements by their execution plans.
-
pg_variables
Session-scoped variables with scalar, array, and record types
-
imgsmlr
Image similarity with haar
-
pg_ivm
incremental view maintenance on PostgreSQL
-
pg_incremental
Incremental Processing by Crunchy Data
-
pg_durable
Durable SQL functions for PostgreSQL
-
pg_disorder
Perturb unordered SELECT row order to expose order-dependent tests
-
orioledb
OrioleDB, the next generation transactional engine
-
bloom
bloom access method - signature file based index
-
plv8
PL/JavaScript (v8) trusted procedural language
-
pljs
PL/JS trusted procedural language
-
plxslt
XSLT procedural language for PostgreSQL
-
pg_mockable
Create mockable wrappers for PostgreSQL functions in tests
-
pgsqlmock
Mocking and faking helpers for PostgreSQL unit tests
-
pgtap
Unit testing for PostgreSQL
-
faker
Wrapper for the Faker Python library
-
pltcl
PL/Tcl procedural language
-
pltclu
PL/TclU untrusted procedural language
-
plperl
PL/Perl procedural language
-
bool_plperl
transform between bool and plperl
-
hstore_plperl
transform between hstore and plperl
-
jsonb_plperl
transform between jsonb and plperl
-
plperlu
PL/PerlU untrusted procedural language
-
bool_plperlu
transform between bool and plperlu
-
jsonb_plperlu
transform between jsonb and plperlu
-
hstore_plperlu
transform between hstore and plperlu
-
plpgsql
PL/pgSQL procedural language
-
plpython3u
PL/Python3U untrusted procedural language
-
jsonb_plpython3u
transform between jsonb and plpython3u
-
ltree_plpython3u
transform between ltree and plpython3u
-
hstore_plpython3u
transform between hstore and plpython3u
-
prefix
Prefix Range module for PostgreSQL
-
semver
Semantic version data type
-
pg_text_semver
Semantic version domain and comparison operators for PostgreSQL
-
country
Country data type, ISO 3166-1
-
pg_xenophile
More than the bare necessities for PostgreSQL i18n and l10n.
-
l10n_table_dependent_extension
PostgreSQL l10n toolbox
-
uint
unsigned integer types
-
uint128
Native uint128 type
-
hashtypes
sha1, md5 and other data types for PostgreSQL
-
postbis
Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.
-
ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
-
uri
URI Data type for PostgreSQL
-
debversion
Debian version number data type
-
pg_bikram_sambat
Bikram Sambat date type and AD/BS conversion functions
-
chkpass
data type for auto-encrypted passwords
-
isn
data types for international product numbering standards
-
seg
data type for representing line segments or floating-point intervals
-
cube
data type for multidimensional cubes
-
ltree
data type for hierarchical tree-like structures
-
hstore
data type for storing sets of (key, value) pairs
-
citext
data type for case-insensitive character strings
-
xml2
XPath querying and XSLT
-
pg_retry
Retry SQL statements on transient errors with exponential backoff
-
pg_fsql
Recursive SQL template engine with JSONB-driven execution
-
pgproto
Native Protobuf parsing, mutation, indexing, and JSON conversion support
-
pglock
Lightweight distributed lock service inside PostgreSQL
-
pg_html5_email_address
PostgreSQL email validation that is consistent with the HTML5 spec
-
url_encode
url_encode, url_decode functions
-
pgsql_tweaks
Some functions and views for daily usage
-
pg_relation_sql
Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations
-
pg_extra_time
Some date time functions and operators that,
-
pgpcre
Perl Compatible Regular Expression functions
-
re2
ClickHouse-compatible regex functions using RE2
-
icu_ext
Access ICU functions
-
envvar
Fetch the value of an environment variable
-
external_file
Access external server-side files through PostgreSQL functions
-
pg_readme
Generate a Markdown README from PostgreSQL COMMENT objects
-
pg_readme_test_extension
Fixture extension used to test pg_readme document generation
-
data_historization
PLPGSQL Script to historize data in partitionned table
-
hashlib
Stable hash functions for Postgres
-
shacrypt
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
-
cryptint
Encryption functions for int and bigint values
-
pg_uuid_v8
UUID v8 generator with embedded timestamps for PostgreSQL
-
permuteseq
Pseudo-randomly permute sequences with a format-preserving encryption on elements
-
snowflake
Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
-
omnisketch
data structure for on-line agg of data into approximate sketch
-
ddsketch
Provides ddsketch aggregate function
-
weighted_statistics
High-performance weighted statistics functions for sparse data
-
first_last_agg
first() and last() aggregate functions
-
extra_window_functions
Extra Window Functions for PostgreSQL
-
argm
argmax, argmin, and anyold aggregate functions
-
random
random data generator
-
financial
Financial aggregate functions
-
pg_accumulator
Accumulation registers for balance and turnover tracking in PostgreSQL
-
parray_gin
GIN index operator class and partial-match operators for text arrays
-
refint
functions for implementing referential integrity (obsolete)
-
autoinc
functions for autoincrementing fields
-
insert_username
functions for tracking who changed a table
-
moddatetime
functions for tracking last modification time
-
tsm_system_time
TABLESAMPLE method which accepts time in milliseconds as a limit
-
dict_xsyn
text search dictionary template for extended synonym processing
-
tsm_system_rows
TABLESAMPLE method which accepts number of rows as a limit
-
tcn
Triggered change notifications
-
uuid-ossp
generate universally unique identifiers (UUIDs)
-
btree_gist
support for indexing common datatypes in GiST
-
btree_gin
support for indexing common datatypes in GIN
-
intarray
functions, operators, and index support for 1-D arrays of integers
-
intagg
integer aggregator and enumerator (obsolete)
-
dict_int
text search dictionary template for integers
-
unaccent
text search dictionary that removes accents
-
pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
-
pg_query_rewrite
Rewrite SQL statements with a PostgreSQL ProcessUtility hook
-
ddlx
DDL eXtractor functions
-
pglinter
PostgreSQL Linting and Analysis Extension
-
prioritize
get and set the priority of PostgreSQL backends
-
pg_readonly
cluster database read only
-
pgautofailover
pg_auto_failover
-
pre_prepare
Pre Prepare your Statement server side
-
pg_upless
Detect Useless UPDATE
-
pgcozy
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
-
pg_orphaned
Deal with orphaned files
-
pg_cheat_funcs
Provides cheat (but useful) functions
-
pgdisablelogerror
Disable selected SQLSTATE error codes from PostgreSQL server logging.
-
online_advisor
Suggest missing indexes and extended statistics online
-
pg_drop_events
logs transaction ids of drop table, drop column, drop materialized view statements
-
table_log
record table modification logs and PITR for table/row
-
pgelog
Extended logging via pseudo-autonomous transactions
-
pgagent
A PostgreSQL job scheduler
-
pg_prewarm
prewarm relation data
-
pgpool_adm
Administrative functions for pgPool
-
pgpool_recovery
recovery functions for pgpool-II for V4.3
-
pgpool_regclass
replacement for regclass
-
lo
Large Object maintenance
-
basic_archive
an example of an archive module
-
basebackup_to_shell
adds a custom basebackup target called shell
-
old_snapshot
utilities in support of old_snapshot_threshold
-
adminpack
administrative functions for PostgreSQL
-
amcheck
functions for verifying relation integrity
-
pg_surgery
extension to perform surgery on a damaged relation
-
pg_stat_backtrace
Capture or log C-level stack backtraces of PostgreSQL processes
-
pg_stat_log
Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
-
pg_stat_plans
Track per-plan call counts, execution times, and example EXPLAIN texts.
-
pg_statviz
Capture PostgreSQL statistics snapshots for time-series analysis and visualization
-
pg_show_plans
show query plans of all currently running SQL statements
-
pg_track_settings
Track settings changes
-
pg_wait_sampling
sampling based statistics of wait events
-
pgsentinel
active session history
-
system_stats
EnterpriseDB system statistics for PostgreSQL
-
bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
-
toastinfo
show details on toasted datums
-
pg_relusage
Log all the queries that reference a particular column
-
powa
PostgreSQL Workload Analyser-core
-
pg_overexplain
Allow EXPLAIN to dump even more details
-
pg_logicalinspect
Logical decoding components inspection
-
pageinspect
inspect the contents of database pages at a low level
-
pgrowlocks
show row-level locking information
-
sslinfo
information about SSL certificates
-
pg_buffercache
examine the shared buffer cache
-
pg_walinspect
functions to inspect contents of PostgreSQL Write-Ahead Log
-
pg_freespacemap
examine the free space map (FSM)
-
pg_visibility
examine the visibility map (VM) and page-level visibility info
-
pgstattuple
show tuple-level statistics
-
auto_explain
Provides a means for logging execution plans of slow statements automatically
-
pg_stat_statements
track planning and execution statistics of all SQL statements executed
-
column_encrypt
Transparent column-level encryption with encrypted_text and encrypted_bytea types
-
passwordpolicy
Dynamically configurable PostgreSQL password complexity checks.
-
anon
PostgreSQL Anonymizer (anon) extension
-
pgaudit
provides auditing functionality
-
pgauditlogtofile
pgAudit addon to redirect audit log to an independent file
-
pg_roast
Opinionated PostgreSQL database auditor
-
pg_jobmon
Extension for logging and monitoring functions in PostgreSQL
-
pgcryptokey
cryptographic key management
-
set_user
similar to SET ROLE but with added logging
-
pg_snakeoil
The PostgreSQL Antivirus
-
pgextwlist
PostgreSQL Extension Whitelisting
-
sslutils
A Postgres extension for managing SSL certificates through SQL
-
pg_policy
Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls
-
pg_vault_tde
Transparent Data Encryption for PostgreSQL through custom table and index access methods
-
sepgsql
label-based mandatory access control (MAC) based on SELinux security policy.
-
auth_delay
pause briefly before reporting authentication failure
-
pgcrypto
cryptographic functions
-
passwordcheck
checks user passwords and reject weak password
-
multicorn
Fetch foreign data in Python in your PostgreSQL server.
-
odbc_fdw
Foreign data wrapper for accessing remote databases using ODBC
-
jdbc_fdw
foreign-data wrapper for remote servers available over JDBC
-
pgspider_ext
foreign-data wrapper for remote PGSpider servers
-
oracle_fdw
foreign data wrapper for Oracle access
-
tds_fdw
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
-
db2_fdw
foreign data wrapper for DB2 access
-
sqlite_fdw
SQLite Foreign Data Wrapper
-
pgbouncer_fdw
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
-
informix_fdw
Foreign data wrapper for Informix access
-
redis_fdw
Foreign data wrapper for querying a Redis server
-
kafka_fdw
kafka Foreign Data Wrapper for CSV formatted messages
-
hdfs_fdw
foreign-data wrapper for remote hdfs servers
-
firebird_fdw
Foreign data wrapper for Firebird
-
dblink
connect to other PostgreSQL databases from within a database
-
file_fdw
foreign-data wrapper for flat file access
-
postgres_fdw
foreign-data wrapper for remote PostgreSQL servers
-
db2fce
DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
-
plpgsql_wrap
Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
-
pg_dbms_metadata
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
-
pg_dbms_lock
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
-
pg_dbms_job
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
-
pg_utl_smtp
Oracle UTL_SMTP compatibility extension for PostgreSQL
-
pglogical
PostgreSQL Logical Replication
-
pglogical_origin
Dummy extension for compatibility when upgrading from Postgres 9.4
-
pglogical_ticker
Have an accurate view on pglogical replication delay
-
pg_failover_slots
PG Failover Slots extension
-
spock
Multi-master logical replication extension for PostgreSQL
-
lolor
Logical-replication-friendly replacement for PostgreSQL large objects
-
pgclone
Clone PostgreSQL databases, schemas, tables, and functions across environments
-
decoder_raw
Output plugin for logical replication in Raw SQL format
-
mimeo
Extension for specialized, per-table replication between PostgreSQL instances
-
test_decoding
SQL-based test/example module for WAL logical decoding
-
pgoutput
Logical Replication output plugin