Extensions

Enables scalable inserts and complex queries for time-series data

Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities

Convenience API for time series stack

Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING

temporal tables

Enables fine-grained write logging and time travel on subsets of the database.

PostgreSQL table versioning extension

Job scheduler for PostgreSQL

execute any sql command at any specific time at background

Run queries now and get results later

Asynchronous SQL dispatcher built on pg_cron

Run SQL queries in the background

Natural language time parsing for PostgreSQL

Time series analysis functions for PostgreSQL

Parse cron expressions and compute previous or next trigger times

PostGIS geometry and geography spatial types and functions

PostGIS topology spatial types and functions

PostGIS raster types and functions

PostGIS SFCGAL functions

PostGIS tiger geocoder and reverse geocoder

Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

Address Standardizer US dataset example

pgRouting Extension

data type for lidar point clouds

integration for pointcloud LIDAR data and PostGIS geometry data

H3 bindings for PostgreSQL

H3 PostGIS integration

q3c sky indexing plugin

foreign-data wrapper for GIS data access

IP-based geolocation query

Fast Google Encoded Polyline encoding & decoding for postgres

Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform

Handle geohash based functionality for spatial coordinates

Drainage network analysis core for PostgreSQL and PostGIS

Raster hydrology extension for PgHydro

Hydrogeomorphological analysis extension for PgHydro

Output and reporting objects for PgHydro

Australian English output pack for PgHydro

Brazilian Portuguese output pack for PgHydro

Pfafstetter consistency checks for PgHydro

MobilityDB geospatial trajectory data management & analysis platform

MobilityDB random data generator functions

Fast lookup timezone name by GPS coordinates

calculate great-circle distances on the surface of the Earth

Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.

Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.

vector data type and ivfflat and hnsw access methods

Vector database plugin for Postgres, written in Rust

Advanced indexing for vector data with DiskANN

The simplest way to do vector search on Postgres

support similarity queries

Reciprocal rank fusion functions for hybrid search

Effective similarity search

Text Summarization using LLMs. Built using pgrx

tiktoken tokenizer for use with OpenAI models in postgres

Fast tiktoken BPE tokenizer for PostgreSQL implemented in C

Machine learning framework for PostgreSQL

Run AL/ML workloads with SQL interface

Single-plan multimodal agent memory for PostgreSQL

Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.

Optional pgvector compatibility bridge for pgcontext HNSW indexes.

TurboQuant-compressed vector type and ANN index access method for PostgreSQL.

Full text search for PostgreSQL using BM25

Use Groonga as index, fast full text search platform for all languages!

PGroonga database management module

create 2-gram (bigram) index for faster full text search.

a parser for full-text search of Chinese

Generate BM25 sparse vector inside PostgreSQL

A postgresql extension for bm25 ranking algorithm

Tokenizers for full-text search

IAM-LIKE pattern matching with bitmap indexing

Full-text search with BM25 ranking

Pinyin romanization and search helpers for PostgreSQL

Kazakh full-text search extension for PostgreSQL

PostgreSQL extension for BM25-family lexical retrieval

Full-text search with BM25 and BM25F ranking

CJK bigram parser derived from PostgreSQL full-text search

Chinese full-text search parser based on cppjieba

Czech Hunspell Dictionary

German Hunspell Dictionary

en_US Hunspell Dictionary

French Hunspell Dictionary

Nepali Hunspell Dictionary

Dutch Hunspell Dictionary

Norwegian (norsk) Hunspell Dictionary

Portuguese Hunspell Dictionary

Russian Hunspell Dictionary

Russian Hunspell Dictionary (from AOT.ru group)

determine similarities and distance between strings

text similarity measurement and index searching based on trigrams

Distributed PostgreSQL as an extension

Citus columnar storage engine

Hydra Columnar extension

DuckDB Embedded in Postgres

Columnstore Table in Postgres

colcompress and rowcompress Table Access Methods with vectorized execution

Interfaces to query ClickHouse databases from PostgreSQL

DuckDB Foreign Data Wrapper

copy data between Postgres and Parquet

DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet

Table partitioning by foreign key utility

Extension to manage partitioned tables by time or ID

Database partitioning implemented as procedural language

PG-Strom - big-data processing acceleration using GPU and NVME

ORCA query optimizer as a PostgreSQL extension

Sorted heap table AM with zone map scan pruning and built-in vector search

Data lake extension by Snowflake

Extension development kit by Snowflake

Automatic extension updater

Map type for PostgreSQL, bundled as a required pg_lake component.

Query engine for data lake queries

Iceberg implementation in Postgres

Data lake tables and Iceberg tables

Copy to/from data lake files

functions that manipulate whole tables, including crosstab

AGE graph database extension

Liquid-inspired Datalog graph query extension for PostgreSQL

Sparse linear algebra and graph extension for PostgreSQL 18

Graph database capabilities for PostgreSQL

RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL

Generic queue for PostgreSQL

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

A simple PostgreSQL Message Broker system

Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery

Finite state machine toolkit for PostgreSQL

type for storing hyperloglog data

RUM index access method

AI-powered SQL query generation for PostgreSQL

Automatic data expiration with TTL indexes

Add in-database GraphQL support

PostgreSQL extension providing JSON Schema validation

JSON Schema validation functions for PostgreSQL

data type for jsonb inspection

Give PostgreSQL ability to manually force some decisions in execution plans.

Hypothetical indexes for PostgreSQL

Query index advisor

filter statements by their execution plans.

Session-scoped variables with scalar, array, and record types

Image similarity with haar

incremental view maintenance on PostgreSQL

Incremental Processing by Crunchy Data

Streaming tables and differential view maintenance for PostgreSQL 18

Durable SQL functions for PostgreSQL

Perturb unordered SELECT row order to expose order-dependent tests

Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads

Semiring provenance and probability management for PostgreSQL

OrioleDB, the next generation transactional engine

A suite of Cardano-related tools

Cheminformatics functionality for PostgreSQL.

Advanced adapter for Postgres extensions

Basic session management

Amazon Web Services APIs (S3)

CloudEvents support

Docker container management

Application credential management

CSV toolkit

Dataset provisioning

E-mail framework

Basic HTTP types

HTTP client

HTTP server

Identity types

JSON toolkit

Kubernetes (k8s) integration

Financial ledger

Package installation manifests

MIME types

Operating system integration

Postgres API polyfills

First-class Python support

PCRE-compatible regular expressions

REST API toolkit (with PostgREST support)

Advanced schema management tooling

Distributed integer sequences

Service management

Session management

Shared Memory Management

Programmatic SQL manipulation

Embedded SQLite

Testing framework

Transaction management

Advanced types

Scoped variables

Virtual File System

Virtual File System types (v1)

Common web stack primitives

Generalized worker pool

XML toolkit

YAML toolkit

Datomic-compatible data model and Datalog query engine inside PostgreSQL

bloom access method - signature file based index

Trusted Language Extensions for PostgreSQL

PL/JavaScript (v8) trusted procedural language

PL/JS trusted procedural language

Lua as a procedural language

Hstore transform for Lua

Lua as an untrusted procedural language

Hstore transform for untrusted Lua

Use PRQL in PostgreSQL - Pipelined Relational Query Language

server-side support for debugging PL/pgSQL functions

Additional validation, profiling, and diagnostics for PL/pgSQL functions

server-side support for profiling PL/pgSQL functions

PL/sh procedural language

PL/Java procedural language

load R interpreter and execute R script from within a database

XSLT procedural language for PostgreSQL

Create mockable wrappers for PostgreSQL functions in tests

Mocking and faking helpers for PostgreSQL unit tests

Transpile multiple procedural dialects to PL/pgSQL

Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions.

Embed MRI Ruby as an untrusted PostgreSQL procedural language

Transform between jsonb and native Ruby data for PL/Ruby

Transform between hstore and Ruby Hashes for PL/Ruby

Transform between ltree and Ruby Arrays for PL/Ruby

Unit testing for PostgreSQL

Wrapper for the Faker Python library

OSDL-DBT-2 test kit

Trust pg_class statistics for planning instead of physical relation size

PL/Tcl procedural language

PL/TclU untrusted procedural language

PL/Perl procedural language

transform between bool and plperl

transform between hstore and plperl

transform between jsonb and plperl

PL/PerlU untrusted procedural language

transform between bool and plperlu

transform between jsonb and plperlu

transform between hstore and plperlu

PL/pgSQL procedural language

PL/Python3U untrusted procedural language

transform between jsonb and plpython3u

transform between ltree and plpython3u

transform between hstore and plpython3u

Prefix Range module for PostgreSQL

Semantic version data type

Semantic version domain and comparison operators for PostgreSQL

SI units extension

PDF type with meta admin & Full-Text Search

Embed an SQLite database in your PostgreSQL table

type for storing 128-bit binary data inline

asn1oid extension

support for Roaring Bitmaps

fast faceting queries using an inverted index

spherical objects with useful functions, operators and index support

Country data type, ISO 3166-1

More than the bare necessities for PostgreSQL i18n and l10n.

PostgreSQL l10n toolbox

Custom PostgreSQL currency type in 1Byte

Memory optimized data type to be used inside of plpglsql func

Multiple Precision Arithmetic extension

numeral datatypes extension

bigint fractions

unsigned integer types

Native uint128 type

sha1, md5 and other data types for PostgreSQL

Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.

IPv4/v6 and IPv4/v6 range index type for PostgreSQL

URI Data type for PostgreSQL

Email address type for PostgreSQL

ACL Data type

Debian version number data type

data type for representing durations

Bikram Sambat date type and AD/BS conversion functions

RRULE field type for PostgreSQL

Recurring calendar, schedule, and exception management for PostgreSQL

timestamp nanosecond resolution

BSON data type and accessor functions for PostgreSQL

data type for auto-encrypted passwords

data types for international product numbering standards

data type for representing line segments or floating-point intervals

data type for multidimensional cubes

data type for hierarchical tree-like structures

data type for storing sets of (key, value) pairs

data type for case-insensitive character strings

XPath querying and XSLT

gzip and gunzip functions.

Bzip compression and decompression

Zstandard compression algorithm implementation in PostgreSQL

HTTP client for PostgreSQL, allows web page retrieval inside the database.

Async HTTP Requests

Run curl actions for data transfer in URL syntax

Retry SQL statements on transient errors with exponential backoff

Recursive SQL template engine with JSONB-driven execution

Protobuf support for PostgreSQL

Native Protobuf parsing, mutation, indexing, and JSON conversion support

Lightweight distributed lock service inside PostgreSQL

Use jq in Postgres

JSON Web Token API for Postgresql

PostgreSQL extension to send email using SMTP

PostgreSQL email validation that is consistent with the HTML5 spec

url_encode, url_decode functions

Some functions and views for daily usage

Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations

Some date time functions and operators that,

Perl Compatible Regular Expression functions

ClickHouse-compatible regex functions using RE2

Access ICU functions

QR Code generator from PostgreSQL

Fetch the value of an environment variable

Detect MIME types and file formats from PostgreSQL bytea values

Simple file storage for arrays of floats

Access external server-side files through PostgreSQL functions

Render HTML in SQL

Generate a Markdown README from PostgreSQL COMMENT objects

Fixture extension used to test pg_readme document generation

Historize the ddl changes inside PostgreSQL database

PLPGSQL Script to historize data in partitionned table

Cross documentation between Django and DBT projects

Query-based data integrity management and soft alerting for PostgreSQL

Report a query’s parameters and result columns without executing it

Stable hash functions for Postgres

xxhash functions for PostgreSQL

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Encryption functions for int and bigint values

uECC bindings for Postgres

Query SPARQL datasource with SQL

multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

ulid type and methods

Create UUIDv7 values in postgres

UUID v8 generator with embedded timestamps for PostgreSQL

Pseudo-randomly permute sequences with a format-preserving encryption on elements

Short unique id generator for PostgreSQL, using hashids

Generate cryptographically secure timestamp-based slugs

generator of sequential UUIDs

Allows to use TypeIDs in Postgres natively

Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL

type for top-n JSONB

Quantile aggregation function

Lower quantile aggregate function

An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

data structure for on-line agg of data into approximate sketch

Provides ddsketch aggregate function

discover hidden correlations in your data with MIC

XI Correlation Coefficient in Postgres

High-performance weighted statistics functions for sparse data

Approximate analytics sketches and aggregates for PostgreSQL

Closure-preserving formula-based statistical modeling in SQL

Provides tdigest aggregate function.

first() and last() aggregate functions

Extra Window Functions for PostgreSQL

Math for vectors (arrays) of numbers

Aggregate functions for array inputs

Various functions for computing statistics on arrays of numbers

argmax, argmin, and anyold aggregate functions

Flexible CSV processing for Postgres

Array math and operators that work element by element on the contents of arrays

GSL statistical functions for postgresql

random data generator

Integer Base36 types

Base62 extension for PostgreSQL

Base58 Encoder/Decoder Extension for PostgreSQL

Financial aggregate functions

Accumulation registers for balance and turnover tracking in PostgreSQL

conversion functions for spatial, routing and other specialized uses

GIN index operator class and partial-match operators for text arrays

functions for implementing referential integrity (obsolete)

functions for autoincrementing fields

functions for tracking who changed a table

functions for tracking last modification time

TABLESAMPLE method which accepts time in milliseconds as a limit

text search dictionary template for extended synonym processing

TABLESAMPLE method which accepts number of rows as a limit

Triggered change notifications

generate universally unique identifiers (UUIDs)

support for indexing common datatypes in GiST

support for indexing common datatypes in GIN

functions, operators, and index support for 1-D arrays of integers

integer aggregator and enumerator (obsolete)

text search dictionary template for integers

text search dictionary that removes accents

Reorganize tables in PostgreSQL databases with minimal locks

Tool allows read write to the table during the rewriting

Rewrite SQL statements with a PostgreSQL ProcessUtility hook

A tool to remove unused space from a relation.

Read dead but unvacuumed rows from table

examine and manage the os buffer cache

remove buffered pages for specific relations

DDL eXtractor functions

PostgreSQL Linting and Analysis Extension

get and set the priority of PostgreSQL backends

Activate/deactivate/verify checksums in offline Postgres clusters

cluster database read only

Introspect pg data dictionary via standard SQL

view object permissions and compare them with the desired state

pg_auto_failover

Diagnosing system catalog corruption

Pre Prepare your Statement server side

Detect Useless UPDATE

Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.

Deal with orphaned files

Send random signals to random processes

Provides cheat (but useful) functions

PostgreSQL File I/O Functions

QoS resource governor extension for PostgreSQL sessions and queries

Validate planner Path trees for freed or corrupt memory

Disable selected SQLSTATE error codes from PostgreSQL server logging.

Suggest missing indexes and extended statistics online

Enforce optimal column alignment to minimize row padding

Tools for interfacing with the PostgreSQL catalog

Postgres extension to save OOPS mistakes

Require criteria for UPDATE and DELETE

Prevent dangerous UPDATE and DELETE without WHERE clause

logs transaction ids of drop table, drop column, drop materialized view statements

record table modification logs and PITR for table/row

Extended logging via pseudo-autonomous transactions

A PostgreSQL job scheduler

prewarm relation data

Administrative functions for pgPool

recovery functions for pgpool-II for V4.3

replacement for regclass

Large Object maintenance

an example of an archive module

adds a custom basebackup target called shell

utilities in support of old_snapshot_threshold

administrative functions for PostgreSQL

functions for verifying relation integrity

extension to perform surgery on a damaged relation

PostgreSQL load profile repository and report builder

Distributed Tracing for PostgreSQL

Export PostgreSQL query telemetry to ClickHouse

Capture or log C-level stack backtraces of PostgreSQL processes

Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.

Track per-plan call counts, execution times, and example EXPLAIN texts.

Server-side PostgreSQL performance flight recorder

Reporting and analysis functions for pgfr_record

Collector-friendly metric views and background refresh worker

Capture PostgreSQL statistics snapshots for time-series analysis and visualization

show query plans of all currently running SQL statements

Kernel statistics gathering

The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.

An extension collecting statistics about quals

track plan statistics of all SQL statements executed

Track settings changes

Track planning decisions in comparison with execution reality

sampling based statistics of wait events

Observability and activity monitoring extension for PostgreSQL

active session history

EnterpriseDB system statistics for PostgreSQL

Normalized, friendlier system catalog for PostgreSQL

Capture node OS metrics via SQL queries

PostgreSQL extension to access the OS process table

Provide SQL interface to logs

Small PostgreSQL background worker to report whether a node is a replication master or standby

show memory usage

show details on toasted datums

easily jump into a visual plan UI for any SQL query

Log all the queries that reference a particular column

Visualise database pages in ascii code

PostgreSQL Workload Analyser-core

Allow EXPLAIN to dump even more details

Logical decoding components inspection

inspect the contents of database pages at a low level

show row-level locking information

information about SSL certificates

examine the shared buffer cache

functions to inspect contents of PostgreSQL Write-Ahead Log

examine the free space map (FSM)

examine the visibility map (VM) and page-level visibility info

show tuple-level statistics

Provides a means for logging execution plans of slow statements automatically

track planning and execution statistics of all SQL statements executed

Strengthen PostgreSQL user password checks with cracklib

Extension that secures a cluster on a cloud environment

Postgres extension for libsodium functions

Transparent column-level encryption with encrypted_text and encrypted_bytea types

Dynamically configurable PostgreSQL password complexity checks.

Supabase Vault Extension

Manage authentication sessions using JWTs

PostgreSQL Anonymizer (anon) extension

PostgreSQL SM Algorithm Extension

Encrypted postgres data type

provides auditing functionality

pgAudit addon to redirect audit log to an independent file

Opinionated PostgreSQL database auditor

Audit data changes and provide flashback ability

Function for collecting statistics about messages in logfile

monitor connection attempts per user

Extension for logging and monitoring functions in PostgreSQL

OAuth and OIDC token validator for PostgreSQL 18

PostgreSQL 18 OIDC bearer-token validator plugin written in Rust

Transaction-based audit trail with schema versioning

credcheck - postgresql plain text credential checker

cryptographic key management

Advanced password hashing methods for PostgreSQL

login_hook - hook to execute login_hook.login() at login time

similar to SET ROLE but with added logging

The PostgreSQL Antivirus

PostgreSQL Extension Whitelisting

DDL and utility command firewall for PostgreSQL

A Postgres extension for managing SSL certificates through SQL

Module for blocking SET variables for non-super users.

Block COPY commands via a configurable ProcessUtility hook

Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls

Reject full partition scans that omit the partition key

Percona pg_tde access method

Transparent Data Encryption for PostgreSQL through custom table and index access methods

label-based mandatory access control (MAC) based on SELinux security policy.

pause briefly before reporting authentication failure

cryptographic functions

checks user passwords and reject weak password

Foreign data wrappers developed by Supabase

Fetch foreign data in Python in your PostgreSQL server.

Foreign data wrapper for accessing remote databases using ODBC

foreign-data wrapper for remote servers available over JDBC

foreign-data wrapper for remote PGSpider servers

Foreign data wrapper for querying a MySQL server

foreign data wrapper for Oracle access

Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)

foreign data wrapper for DB2 access

SQLite Foreign Data Wrapper

Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions

Foreign data wrapper for etcd

Foreign data wrapper for Informix access

Nominatim Foreign Data Wrapper for PostgreSQL

foreign data wrapper for MongoDB access

Foreign data wrapper for querying a Redis server

Send redis pub/sub messages to Redis from PostgreSQL Directly

kafka Foreign Data Wrapper for CSV formatted messages

foreign-data wrapper for remote hdfs servers

Foreign data wrapper for Firebird

Foreign data wrapper for RDF triplestores over SPARQL endpoints

aws_s3 postgres extension to import/export data from/to s3

foreign-data wrapper for Postgres log file access

connect to other PostgreSQL databases from within a database

foreign-data wrapper for flat file access

foreign-data wrapper for remote PostgreSQL servers

API surface for DocumentDB for PostgreSQL

Core API surface for DocumentDB on PostgreSQL

Multi-Node API surface for DocumentDB

DocumentDB Extended RUM index access method

MongoDB-like read projections for JSONB in PostgreSQL

Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

Extension to add Global Temporary Tables feature to PostgreSQL

Registration and manipulation of session variables and constants

Server side rollback at statement level for PostgreSQL like Oracle or DB2

Oracle Compatible extension on Postgres Database

Support for indexing oracle datatypes in GIN

Support for oracle indexing common datatypes in GiST

Get function’s definition

PL/iSQL procedural language

Support GB18030-2022 and UTF-8 conversion

DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.

Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.

Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL

Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL

Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.

Oracle UTL_SMTP compatibility extension for PostgreSQL

SQL Server Transact SQL Datatype Support

SQL Server Transact SQL compatibility

SQL Server TDS protocol extension

SQL Server Money Data Type

memcached interface

MySQL Supplementary Extension

PostgreSQL Logical Replication

Dummy extension for compatibility when upgrading from Postgres 9.4

Have an accurate view on pglogical replication delay

automated ddl deployment using pglogical

Replicate supported DDL changes over PostgreSQL logical replication

PG Failover Slots extension

Tools to migrate other databases to PostgreSQL

Active-Active Replication Extension for PostgreSQL

Multi-master logical replication extension for PostgreSQL

Logical-replication-friendly replacement for PostgreSQL large objects

Clone PostgreSQL databases, schemas, tables, and functions across environments

CDC-to-MQTT broker for PostgreSQL

Changing data capture in JSON format

PostgreSQL logical decoding output plugin for MongoDB

Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format

Output plugin for logical replication in Raw SQL format

Extension for specialized, per-table replication between PostgreSQL instances

Replication manager for PostgreSQL

build fact tables with Postgres

pg_bulkload is a high speed data loading utility for PostgreSQL

SQL-based test/example module for WAL logical decoding

Logical Replication output plugin