Repository: PIGSTY

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.

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

EDTF validation, normalization, date bounds, and temporal relations

Time series analysis functions for PostgreSQL

Parse cron expressions and compute previous or next trigger times

H3 bindings for PostgreSQL

H3 PostGIS integration

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

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 database plugin for Postgres, written in Rust

Advanced indexing for vector data with DiskANN

The simplest way to do vector search on Postgres

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

Catalog-derived grammars and approved grammar drift checks

Natural-language row filtering, ranking and classification through a Jev-compatible API

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.

Approximate vector search with PRISM indexes and RaBitQ quantization

Full text search for PostgreSQL using BM25

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

Recovery helper for removing a damaged PGroonga internal database

Variable-length gram GIN indexes and statistics for LIKE/ILIKE 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

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

Compiled Aho-Corasick double-array machines for exact multi-pattern matching and replacement in PostgreSQL

Address-aware text search dictionaries and configurations

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)

Multilingual full text search with ICU segmentation, normalization and n-gram matching

Full text search parser using ICU boundary analysis

TIN-compatible text search for development and testing

Experimental TINQL text search with BM25 and segmented indexes

Native PostgreSQL index access method for approximate regular-expression matching

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

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

Planning-time partition pruning by per-partition data ranges, including non-key columns.

Incremental multidimensional models and formula functions over PostgreSQL tables.

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

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

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

Native JSONB validation against JSON Schema drafts 4 and 7

Query index advisor

Cooperative statement and transaction guards based on estimated plan cost

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

SQL-native durable orchestrations for PostgreSQL

Perturb unordered SELECT row order to expose order-dependent tests

Transaction-aware shared-memory cache serving PostgreSQL primary-key rows over RESP2 MGET

Shared-memory key/value cache, token-bucket rate limits and sorted sets.

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

Trusted Language Extensions for PostgreSQL

PL/JavaScript (v8) 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

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

Embed PHP 8 as an untrusted PostgreSQL procedural language

Trust pg_class statistics for planning instead of physical relation size

Semantic version domain and comparison operators for PostgreSQL

Lexicographic position type for inserting and reordering list items

Hierarchical classification code types with validation and revision tracking

PDF type with meta admin & Full-Text Search

Embed an SQLite database in your PostgreSQL table

type for storing 128-bit binary data inline

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

Exact currency-aware monetary types, arithmetic, and allocation

Associative-array data types for high-performance PL/pgSQL workflows

Integer key/value types with arithmetic, aggregation, and GIN indexing

Multiple Precision Arithmetic extension

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.

URI Data type for PostgreSQL

Email address type for PostgreSQL

ACL Data type

data type for representing durations

Bikram Sambat date type and AD/BS conversion functions

Nanosecond timestamp and fixed-duration interval types

Recurring calendar, schedule, and exception management for PostgreSQL

BSON data type and accessor functions for PostgreSQL

data type for auto-encrypted passwords

Bzip compression and decompression

Zstandard compression algorithm implementation in PostgreSQL

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

SQL leases with TTL expiry and monotonically increasing fencing epochs

Use jq in Postgres

JSONB diff, JSON Patch, and JSON Merge Patch functions

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,

ClickHouse-compatible regex functions using RE2

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

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

Return column names of a record or composite value

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

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

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

Descriptive statistics and clinical effect-size functions over arrays

Approximate analytics sketches and aggregates for PostgreSQL

Closure-preserving formula-based statistical modeling in SQL

HDR histogram type, percentile queries and mergeable aggregation.

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

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

Text conversion with NULL or a typed fallback on conversion errors.

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

Tool allows read write to the table during the rewriting

Rewrite SQL statements with a PostgreSQL ProcessUtility hook

Read dead but unvacuumed rows from table

remove buffered pages for specific relations

DDL eXtractor functions

PostgreSQL Linting and Analysis Extension

Introspect pg data dictionary via standard SQL

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

Deterministic session-local fault injection for PostgreSQL test clusters

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

Suggest missing indexes and extended statistics online

Enforce optimal column alignment to minimize row padding

Tools for interfacing with the PostgreSQL catalog

Executable SQL checks with verdict dates and assertion history

Postgres extension to save OOPS mistakes

Runtime observation, warnings and blocking for dangerous SQL statements

Prevent dangerous UPDATE and DELETE without WHERE clause

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

Extended logging via pseudo-autonomous transactions

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

Server-side PostgreSQL performance flight recorder

Reporting and analysis functions for pgfr_record

Collector-friendly metric views and background refresh worker

SQL monitoring views for database activity, WAL, replication, and storage

Measure backend CPU usage between explicit reset and print calls

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.

Track planning decisions in comparison with execution reality

sampling based statistics of wait events

Observability and activity monitoring extension for PostgreSQL

Normalized, friendlier system catalog for PostgreSQL

Capture node OS metrics via SQL queries

PostgreSQL extension to access the OS process table

Server filesystem capacity and inode statistics through statvfs

Provide SQL interface to logs

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

Strengthen PostgreSQL user password checks with cracklib

Extension that secures a cluster on a cloud environment

Transparent column-level encryption with encrypted_text and encrypted_bytea types

Experimental encrypted text search using AEAD ciphers and keyed blind indexes

Supabase Vault Extension

Manage authentication sessions using JWTs

PostgreSQL Anonymizer (anon) extension

PostgreSQL SM Algorithm Extension

Encrypted postgres data type

Opinionated PostgreSQL database auditor

Audit data changes and provide flashback ability

PostgreSQL 18 OIDC bearer-token validator plugin written in Rust

Transaction-based audit trail with schema versioning

DDL and utility command firewall for PostgreSQL

A Postgres extension for managing SSL certificates through SQL

X.509 certificate parsing and inspection through OpenSSL

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

Foreign data wrappers developed by Supabase

foreign-data wrapper for remote servers available over JDBC

Foreign data wrapper for etcd

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 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

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

Registration and manipulation of session variables and constants

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

Table and view aliases synchronized with target DDL.

SQL Server Transact SQL Datatype Support

SQL Server Transact SQL compatibility

SQL Server TDS protocol extension

SQL Server Money Data Type

MySQL Supplementary Extension

S3-compatible object storage endpoint implemented inside PostgreSQL

Kafka protocol broker embedded in PostgreSQL

Replicate supported DDL changes over PostgreSQL logical replication

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

PostgreSQL logical decoding output plugin for MongoDB

Output plugin for logical replication in Raw SQL format

pg_bulkload is a high speed data loading utility for PostgreSQL