🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

If some repo is missing, please write a comment with the url.

• Access Methods
• Data Types
• Aggregate Functions
• Full-Text Search & Linguistics
• Dictionaries
• Search & AI/ML
• Analytics & Columnar Storage
• Query Optimization & Planning
• Monitoring & Observability
• Auditing, Security & Encryption
• Distributed Systems & Replication
• Backup, Recovery & WAL
• Foreign Data Wrappers
• External Integrations & Messaging
• Procedural Languages
• Spatial and Geographic Objects
• Uncategorized

Access Methods

• https://github.com/CrystallineCore/Biscuit ⭐️⭐️

  Biscuit is a specialized PostgreSQL index access method (IAM) designed for blazing-fast pattern matching on LIKE queries, with native support for multi-column searches. It eliminates the recheck overhead of trigram indexes while delivering significant performance improvements on wildcard-heavy queries.

• https://github.com/orioledb/orioledb ⭐️⭐️⭐️

  OrioleDB – building a modern cloud-native storage engine

• https://github.com/postgrespro/rum ⭐️⭐️

  RUM access method - inverted index with additional information in posting lists

Data Types

• https://github.com/adjust/ajbool

  triple bool for postgres

• https://github.com/2ndQuadrant/array_textsort

  array_textsort PostgreSQL extension

• https://github.com/lizardoluis/ast_postgis ⭐️

  PostgreSQL extension to support advanced spatial data types and integrity constraints.

  • https://github.com/lab-csx-ufmg/ast_postgis

    PostgreSQL extension to support advanced spatial data types and integrity constraints.

• https://github.com/pgstuff/base32_4b

  PostgreSQL base32 data type stored in 4 bytes

• https://github.com/ozum/boolean_cascaded

  PostgreSQL Extension of data type, trigger and operators to store cascaded status for parent-children records.

• https://github.com/philopon/cas

  postgresql cas register number data type

• https://github.com/tvondra/ccnumber ⭐️

  experimental PostgreSQL data type with encryption off-loaded to a trusted component

• https://github.com/olshevskiy87/check_digits

  Functions to check various identification numbers

• https://github.com/lacanoid/chkpass

  Stand alone version of chkpass type for PG 11+

• https://github.com/theory/colnames

  Lists the column names in a PostgreSQL RECORD value

• https://github.com/semenikhind/complex_contrib

  Complex numbers for PostgreSQL

• https://github.com/kelvich/cube

• https://github.com/fusiongyro/damm

• https://github.com/Octonica/data_rig

  Postges datatype for efficient OLAP indexing

• https://github.com/niquola/fhir_jsonb

• https://github.com/niquola/fhirbase

• https://github.com/wanghaisheng/fhirbase

  Relational Storage for FHIR

• https://github.com/niquola/fhirpath-pg

• https://github.com/japinli/fibonacci

  Fibonacci extension for PostgreSQL.

• https://github.com/2ndQuadrant/fixeddecimal ⭐️

  PostgreSQL data type for efficient storage of monetary values. Much faster performance than NUMERIC. Works with Postgres-XL also.

• https://github.com/pjungwir/floatfile

  Postgres extension for fast select & append of float arrays.

• https://github.com/pjungwir/floatvec ⭐️

  Postgres functions for arithmetic on numeric arrays

• https://github.com/benchub/flux

  temporal table changes in postgres

• https://github.com/amutu/fnvhash

  fnv hash function for PostgreSQL

• https://github.com/corlogic-code/generate_date_series

• https://github.com/zeromax007/gpdb-roaringbitmap ⭐️⭐️

  RoaringBitmap extension for greenplum-db

  • https://github.com/YangJunzhou/gpdb-roaringbitmap

    RoaringBitmap extension for greenplum-db

• https://github.com/pandrewhk/hashtypes ⭐️

  sha1, md5 and other data types for PostgreSQL

  • https://github.com/adjust/hashtypes

    sha1, md5 and other data types for PostgreSQL

• https://github.com/postgrespro/hstore_ops ⭐️

  Better operator class for hstore: smaller index and faster @> queries.

• https://github.com/pjungwir/inetrange

  Postgres extension to define ranges of IP addresses

• https://github.com/RhodiumToad/ip4r ⭐️⭐️

  ip4r current and new development

• https://github.com/furstenheim/is_jsonb_valid ⭐️⭐️

  Native PostgreSQL extension to validate jsonb

• https://github.com/adjust/istore ⭐️

  development repo for integer hstore replacement in postgres

• https://github.com/dvarrazzo/italian_codes

  PostgreSQL validation domains for Italian fiscal codes

• https://github.com/postgrespro/jsonbd

  JSONB compression method for PostgreSQL

• https://github.com/postgrespro/jsquery ⭐️⭐️

  JsQuery – json query language with GIN indexing support

• https://github.com/theory/kv-pair ⭐️

  A key/value pair data type for PostgreSQL

• https://github.com/mediait/lpathtree

  PostgreSQL 9.3.5 ltree module fork with / (forward slash) delimiter and no ltxtquery support

• https://github.com/jianingy/ltree

  my changes to postgresql ltree contrib

• https://github.com/tvondra/md5hash

  A custom data type for storing MD5 hashes (instead of the native TEXT varlena type).

• https://github.com/postgrespro/monq ⭐️

  MonQ - PostgreSQL extension for MongoDB-like queries to jsonb data

• https://github.com/stereobooster/natural_sort-pgxn

• https://github.com/nuko-yokohama/ntext

  japanese compare text datatype

• https://github.com/cahutton/numeric_domains

  A PostgreSQL extension defining custom numeric domains

• https://github.com/asio/password

  Postgresql data type for passwords

• https://github.com/xocolatl/periods ⭐️⭐️

  PERIODs and SYSTEM VERSIONING for PostgreSQL

• https://github.com/adjust/pg-ajversion

  simple semantic version type for postgres

• https://github.com/adjust/pg-base36

  a base36 extension for postgres

• https://github.com/beargiles/pg-bignum ⭐️

  PostgreSQL extension for unlimited precision integers.

  • https://github.com/EvanCarroll/pg-bignum

    PostgreSQL extension for unlimited precision integers.

• https://github.com/paroga/pg-cbor

  A Concise Binary Object Representation data type for PostgreSQL

• https://github.com/truthly/pg-cbor

  🧬🐘 The Concise Binary Object Representation (CBOR) data format (RFC 7049) implemented in pure SQL.

• https://github.com/zejn/pg-colors

  PostgreSQL C implementation of Delta E CIE color distance functions.

• https://github.com/beargiles/pg-complex

  PostgreSQL extension for complex numbers. For educational purposes only.

• https://github.com/adjust/pg-country

  country type for postgres

• https://github.com/adjust/pg-currency ⭐️

  1 Byte Currency ISO type for PostgreSQL

• https://github.com/adjust/pg-device_type

  a device_type extension for postgres

• https://github.com/ratbox/pg-digest

  PostgreSQL data type for efficient storage of hash digests

• https://github.com/truthly/pg-emoji ⭐️

  😍🐘 PostgreSQL emoji encode/decode extension

• https://github.com/theory/pg-hash64

  Generate 64-bit hash integers from PostgreSQL strings

• https://github.com/theory/pg-hostname

  Function to get the PostgreSQL server host name

• https://github.com/adjust/pg-language

  Postgres extension of language enumeration type

• https://github.com/blm768/pg-libphonenumber ⭐️

  A (partially implemented!) PostgreSQL extension that provides access to Google's libphonenumber

• https://github.com/wellmart/pg-nextid

  Postgres extension for ID generation based on Instagram ID

• https://github.com/adjust/pg-numhstore

  a postgres extension to support inthstore and floathstore types

• https://github.com/beargiles/pg-openssl

  PostgreSQL extension for cryptographic functions and types provided by OpenSSL.

• https://github.com/sbertrang/pg-ruid

  Readable and Usable Identifier

• https://github.com/sylvainv/pg-salesforce-id

  Postgresql Salesforce ID plugin

• https://github.com/theory/pg-semver ⭐️

  A semantic version data type for PostgreSQL

• https://github.com/arunchaganty/pg-span

  A document text span data type for postgres

• https://github.com/scottjustin5000/pg-sum-array

  postgres extension to find the median in array

• https://github.com/edoceo/pg-ulid ⭐️

  ULID Functions for PostgreSQL

• https://github.com/ancoron/pg-uuid-ext

  Extended functions for UUID's in PostgreSQL

• https://github.com/ancoron/pg-uuid-int32

  PostgreSQL UUID data type stored as 32-bit integers

• https://github.com/ancoron/pg-uuid-int64

  PostgreSQL UUID data type stored as 64-bit integers

• https://github.com/blkchain/pg_blkchain ⭐️⭐️

  PostgreSQL Blockchain Extension

• https://github.com/byucesoy/pg_color

  Color data type for PostgreSQL

  • https://github.com/onderkalaci/pg_color

    Color data type for PostgreSQL

• https://github.com/ozum/pg_datatype_password

  PostgreSQL data type for storing blowfish encrypted and salted passwords which can be queried against clear text.

• https://github.com/min-mwei/pg_digests

  sketch data types for pg

• https://github.com/ttfkam/pg_formatbase

  Format numbers by base

• https://github.com/nuko-yokohama/pg_fraction

  It is an extension to make fraction type available in PostgreSQL.

• https://github.com/pindlebot/pg_gen_uid

• https://github.com/rlichtenwalter/pg_genotype

  an efficient genotype representation type

• https://github.com/ferndalehall/pg_gsl

  Postgresql wrapper functions for the GNU Scientific Libraray

• https://github.com/iCyberon/pg_hashids ⭐️⭐️

  Short unique id generator for PostgreSQL, using hashids

• https://github.com/rlichtenwalter/pg_imputed_genotype

  an efficient, packed probability tuple suited for imputed genotypes

• https://github.com/sycobuny/pg_markdown

  A Markdown datatype for PostgreSQL

• https://github.com/chanukyasds/pg_math ⭐️

  pg_math extension to support statistical distribution functions for PostgreSQL

• https://github.com/rlichtenwalter/pg_nanp

  an efficient, validated, formatted NANP type

• https://github.com/Zeleo/pg_natural_sort_order

  Implements Natural Sort Order as an ANSI C PostgreSQL extension.

  • https://github.com/Fenoman/pg_natural_sort_order

    Implements Natural Sort Order as an ANSI C PostgreSQL extension.

• https://github.com/rlichtenwalter/pg_postal_code_ca

  an efficient, validated, formatted Canadian postal code type

• https://github.com/afiskon/pg_protobuf ⭐️

  Protobuf support for PostgreSQL

• https://github.com/begriffs/pg_rational ⭐️⭐️

  Precise fractional arithmetic for PostgreSQL

• https://github.com/ChenHuajun/pg_roaringbitmap ⭐️⭐️

  RoaringBitmap extension for PostgreSQL

• https://github.com/petropavel13/pg_rrule ⭐️⭐️

  RRULE data type for PostgreSQL

• https://github.com/eendroroy/pg_semver

  Version(SEMVER) data type for postgresql

• https://github.com/erthalion/pg_simdjson ⭐️

  Postgres extension for parsing json using simdjson library

• https://github.com/singularita/pg_strverscmp

  Hack for natural sorts in PostgreSQL

• https://github.com/2ndQuadrant/pg_sysdatetime

  PostgreSQL SYSDATETIME() functions with support for high-precision timer capture on Windows

• https://github.com/zilder/pg_txn_status

  Simple 1 byte transaction status type

• https://github.com/iCyberon/pg_ulid ⭐️

  Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL

• https://github.com/shurizzle/pg_url

  PostgreSQL 9.4 library to handle URLs

• https://github.com/postgrespro/pg_variables ⭐️

  Session wide variables for PostgreSQL

• https://github.com/eendroroy/pg_vercomp

  Version data type for postgresql

• https://github.com/iCyberon/pg_xid ⭐️

  pg_xid is a globally unique id generator thought for the web

• https://github.com/marconeperes/pgBRTypes

  A simple implementation of some brazilians data types as CNPJ and CPF to PostgreSQL

• https://github.com/worden341/pgchronos ⭐️

  PostgreSQL extension for operating on sets of date and timestamp ranges.

• https://github.com/grzm/pgcrockford

  Crockford Base32 encoding for PostgreSQL unsigned integers

• https://github.com/macenv/pgdecibel

  decibel data type to display data in decibels while storing and managing in pascals

• https://github.com/okbob/pgDecimal

  PostgreSQL types based on _Decimal32 and _Decimal64 types.

• https://github.com/vitesse-ftian/pgdecimal

  Decimal64 and decimal128 for PostgreSQL

• https://github.com/petere/pgemailaddr ⭐️

  email address type for PostgreSQL

  • https://github.com/pvh/pgemailaddr

    email address type for PostgreSQL

• https://github.com/pme/pgfft

  FFT module for Postgresql

• https://github.com/mausimag/pgflake

  A snowflake algorithm implemented as Postgres Extension.

• https://github.com/markokr/pghashlib ⭐️

  Stable hash functions for Postgres

  • https://github.com/RelateIQ-chef/pghashlib

    Stable hash functions for Postgres

• https://github.com/mike-kfed/pgknx

  Postgresql data type extension for KNX Addresses

• https://github.com/petere/pglibuuid

  PostgreSQL wrapper for libuuid

• https://github.com/dvarrazzo/pgmp ⭐️

  PostgreSQL Multiple Precision Arithmetic extension

• https://github.com/beargiles/pgopenssltypes

  PostgreSQL extension that makes various OpenSSL types persistable.

• https://github.com/petere/pgpcre ⭐️

  PCRE functions for PostgreSQL

• https://github.com/pramsey/pgsql-arraymath ⭐️

  Functions and operators for element-by-element math and logic on arrays

• https://github.com/df7cb/pgsql-asn1oid

  ASN.1 OID datatype for PostgreSQL

• https://github.com/cayetanobv/pgsql-pcg-random

  PostgreSQL Extension to compute pseudo random numbers with PCG Random Number Generation library.

• https://github.com/petere/pguint ⭐️⭐️

  unsigned integer types extension for PostgreSQL

• https://github.com/dylex/pguri

  Simple PostgreSQL URI type for indexing and searching URI

• https://github.com/petere/pguri ⭐️⭐️

  uri type for PostgreSQL

  • https://github.com/lacanoid/pguri

    uri type for PostgreSQL

• https://github.com/patchsoft/postcode

  Postgres extension type for UK postcodes

• https://github.com/tychota/postgres-base32

  A postgres extension

• https://github.com/gavinwahl/postgres-json-schema ⭐️⭐️

  JSON Schema validation for PostgreSQL

  • https://github.com/darioielardi/postgres-json-schema

    JSON Schema validation for PostgreSQL

• https://github.com/mpartel/postgres-protobuf ⭐️

  Protocol Buffer extension for PostgreSQL

• https://github.com/maciekgajewski/postgres-uints

  Unsigned integer types for PostgreSQL

• https://github.com/ntkme/postgresql-cidr

  🐘 PostgreSQL cidr extension.

• https://github.com/nad2000/postgresql-contrib-uint

  PostgreSQL unsigned integer type extension

• https://github.com/Katello/postgresql-evr

  A postgresql extension for RPM epoch/version/release type

• https://github.com/dyninc/postgresql-fast-guid

  Fast GUIDs for postgresql

• https://github.com/df7cb/postgresql-hamradio

  Ham radio data types, functions, and tables for PostgreSQL

• https://github.com/citusdata/postgresql-hll ⭐️⭐️

  PostgreSQL extension adding HyperLogLog data structures as a native data type

• https://github.com/SourceNote/postgresql-hll

• https://github.com/yorickdewid/PostgreSQL-IBAN

  PostgreSQL IBAN extension that can verify International Bank Account Numbers

• https://github.com/repology/postgresql-libversion

  PostgreSQL extension with support for version string comparison

• https://github.com/df7cb/postgresql-number

  Variable-width integer datatype for PostgreSQL

  • https://github.com/zr40/postgresql-number

    Variable-width integer datatype for PostgreSQL (fork with marginal space savings just for fun)

• https://github.com/df7cb/postgresql-numeral

  Textual numeric datatypes for PostgreSQL

• https://github.com/eschmar/postgresql-popcount

  PostgreSQL Extension introducing popcount|32|64|Asm|Asm64|256.

• https://github.com/jeff-davis/PostgreSQL-Temporal ⭐️

  Temporal extensions for PostgreSQL

  • https://github.com/fromz/PostgreSQL-Temporal

    Temporal extensions for PostgreSQL

• https://github.com/citusdata/postgresql-topn ⭐️⭐️

  TopN is an open source PostgreSQL extension that returns the top values in a database according to some criteria

• https://github.com/df7cb/postgresql-unit ⭐️⭐️

  SI Units for PostgreSQL

• https://github.com/siilike/postgresql-vpack

  VelocyPack support for PostgreSQL

• https://github.com/WinteryFox/PostgresSnowflake

• https://github.com/dimitri/prefix ⭐️

  Prefix Range module for PostgreSQL

  • https://github.com/RekGRpth/prefix

    Prefix Range module for PostgreSQL

• https://github.com/pjungwir/range_agg ⭐️

  Postgres extension to merge adjacent/overlapping ranges

• https://github.com/DanielJDufour/safecast

  Safely cast in PostgreSQL

• https://github.com/tvondra/sequential-uuids ⭐️⭐️

  generator of sequential UUIDs

• https://github.com/ergo70/tanimoto

  A fast Tanimoto function for BIT VARYING in C

• https://github.com/pgstuff/telephone

  PostgreSQL telephone data type

• https://github.com/arkhipov/temporal_tables ⭐️⭐️

  Temporal Tables PostgreSQL Extension

• https://github.com/cahutton/text_domains

  PostgreSQL extension defining custom text domains

• https://github.com/pjungwir/time_for_keys ⭐️

  Temporal foreign keys for Postgres

• https://github.com/mweber26/timestampandtz ⭐️

• https://github.com/umitanuki/tinyint-postgresql ⭐️

  A tiny int implementation as a data type of PostgreSQL

  • https://github.com/k-gun/tinyint-postgresql

    A tiny int implementation as a data type of PostgreSQL

• https://github.com/spa5k/uids-postgres ⭐️

  PostgreSQL Extension to generate various type of Universally Unique IDS

• https://github.com/autodatadirect/uniqueidentifier

  Legacy uniqueidentifier data type for PostgreSQL

• https://github.com/freevryheid/units

  postgresql extension to convert between different units

• https://github.com/darold/uri

  uri is a extension to add uri data type for postgresql

• https://github.com/okbob/url_encode ⭐️

  url_encode, url_decode functions for PostgreSQL

• https://github.com/RhodiumToad/uuid-freebsd

  UUID generation for PostgreSQL on FreeBSD

• https://github.com/guedes/validadores

  Extensão para Postgres que contém funções para facilitar o uso de validadores de CNPJ, CPF utilizados no Brasil

  • https://github.com/sebastianwebber/validadores

    Extensão para Postgres que contém funções para facilitar o uso de validadores de CNPJ, CPF utilizados no Brasil

• https://github.com/BlueTreble/variant

  variant data type for Postgres that allows storing any other type.

• https://github.com/adjust/wltree ⭐️

  adjust's patched version of postgres ltree

• https://github.com/postgrespro/zson ⭐️⭐️

  ZSON is a PostgreSQL extension for transparent JSONB compression

Aggregate Functions

• https://github.com/furkansahin/Aggregate-Average

  Aggregate Function to find averages in any numeric type for PostgreSQL

• https://github.com/pjungwir/aggs_for_arrays ⭐️

  A Postgres extension in C with various functions that compute statistics on arrays of numbers

• https://github.com/pjungwir/aggs_for_vecs ⭐️

  Postgres C extension with aggregate functions for array inputs

• https://github.com/bashtanov/argm ⭐️

  Argm postgresql extension: argmax/argmin and anyold aggregate functions

• https://github.com/tvondra/count_distinct ⭐️

  An extension with alternative to COUNT(DISTINCT ...) aggregate in PostgreSQL.

  • https://github.com/BrandwatchLtd/count_distinct

    A hash-table based alternative to COUNT(DISTINCT ...) aggregate in PostgreSQL.

• https://github.com/tvondra/distinct_estimators ⭐️

  distinct counters and aggregate functions for distinct estimation in PostgreSQL

  • https://github.com/conversant/postgres_hyperloglog ⭐️

    distinct counters and aggregate functions for distinct estimation in PostgreSQL

• https://github.com/xocolatl/extra_window_functions ⭐️

  Extra Window Functions for PostgreSQL

• https://github.com/nbonnotte/first_last

  PostgreSQL Aggregates to return first or last values/rows

• https://github.com/wulczer/first_last_agg ⭐️

  PostgreSQL extension providing first and last aggregate functions.

  • https://github.com/adjust/first_last_agg

    PostgreSQL extension providing first and last aggregate functions.

• https://github.com/jyosoman/median_aggregate

• https://github.com/scottjustin5000/pg-median

  pg-extention for median aggregate

• https://github.com/jwdeitch/pg_agg_sample

  Takes an aggregation sample for postgres

• https://github.com/tomhebbron/pg_bitstring_helpers

  PostgreSQL extension with a few useful functions and aggregates for handling 'bit varying' data.

• https://github.com/intgr/pg_financial

  PostgreSQL extension with functions and aggregates for financial calculations

• https://github.com/za-arthur/pg_median

  Provides an aggregate function that calculates the median over an input set

• https://github.com/sveljko/pgmedian

  Median aggregate for PostgreSQL

• https://github.com/shobhanav/postgres-median

  Postgresql aggregate extension for median calculation

• https://github.com/ccstolley/postgres_median

  A C implementation of a median aggregate function for PostgresSQL

• https://github.com/JLockerman/postgres_median_aggregate

• https://github.com/clime/postgresql-median

  PostgreSQL median aggregate extension

• https://github.com/tvondra/quantile ⭐️

  an aggregation function for PostgreSQL

• https://github.com/labgeo/siguanet_quest

  PostgreSQL extension for SIGUANET databases providing functions which return aggregate data based on spatial criteria

• https://github.com/tvondra/trimmed_aggregates

  provides trimmed aggregates for PostgreSQL (average, variance, stddev)

• https://github.com/cybertec-postgresql/vectoragg

  Array aggregation functions

• https://github.com/Kozea/weighted_mean ⭐️

  A simple weighted mean aggregate function for postgresql

  • https://github.com/davidfetter/weighted_stats

    Simple weighted mean and average aggregates for PostgreSQL

Full-Text Search & Linguistics

• https://github.com/adjust/all_substrings_tokenizer

  C Postgres extension for extracting all substrings of a string

  • https://github.com/chochkov/all_substrings_tokenizer

    C Postgres extension for extracting all substrings of a string

• https://github.com/mikeizbicki/chajda

• https://github.com/liminghu/fuzzystrmatch

  add Damerau-Levenshtein algorithm to fuzzystrmatch in PostgreSql

• https://github.com/dverite/icu_ext ⭐️

  PostgreSQL extension (in C) to expose functionality from the ICU library

• https://github.com/seanlong/jieba_parser

  PostgreSQL FTS parser extension based on Jieba(https://github.com/fxsjy/jieba)

• https://github.com/pgbigm/ludia_funcs

  Mirror of the official ludia_funcs GIT repository. Note that this is just a mirror - we don't work with pull requests on github. To contribute, please see https://ludiafuncs.osdn.jp/index.html

• https://github.com/leskin-in/mipt-asj

  Tao-Deng-Stonebraker algorithm of approximate string JOINs with abbreviations

• https://github.com/paradedb/paradedb/tree/dev/pg_search ⭐️⭐️⭐️

  Full text search for PostgreSQL using BM25

• https://github.com/hooopo/pg-fuzzywuzzy ⭐️

  postgresql fuzzywuzzy extension

• https://github.com/blm768/pg-libnumbertext

  Integrates libnumbertext with PostgreSQL

• https://github.com/andy128k/pg-sphinx ⭐️

  PostgreSQL module to link to SphinxSearch

  • https://github.com/capomafiosoken/pg-sphinx

    PostgreSQL module to link to SphinxSearch

• https://github.com/MasahikoSawada/pg_bigm

  pg-bigm is a 2-gram based full text search module for PostgreSQL.

• https://github.com/kou/pg_bigm

• https://github.com/pgbigm/pg_bigm

  Mirror of the official pg_bigm GIT repository. Note that this is just a mirror - we don't work with pull requests on github. To contribute, please see https://pgbigm.osdn.jp/index_en.html

• https://github.com/aotake/pg_bigm-masahiko

  pg_bigm is full text search module

• https://github.com/huangjimmy/pg_cjk_parser

  Postgres CJK Parser pg_cjk_parser is a fts (full text search) parser derived from the default parser in PostgreSQL 11. When a postgres database uses utf-8 encoding, this parser supports all the featur...

  • https://github.com/freewizard/pg_cjk_parser

    Postgres CJK Parser pg_cjk_parser is a fts (full text search) parser derived from the default parser in PostgreSQL 11. When a postgres database uses utf-8 encoding, this parser supports all the featur...

• https://github.com/ccutrer/pg_collkey

  Unofficial mirror

• https://github.com/ttfkam/pg_content_utils

  Utility functions for use with news management and full text search

• https://github.com/romgrk/pg_fzy

  The fzy function for PostgreSQL

• https://github.com/jaiminpan/pg_jieba ⭐️⭐️

  Postgresql full-text search extension for chinese

• https://github.com/maxoodf/pg_mystem

  pg_mystem - расширение PostgreSQL для лемматизации (морфологической нормализации) текстов на русском языке. PostgreSQL extension for Yandex Mystem

• https://github.com/jaiminpan/pg_scws ⭐️

  Postgresql full-text search extension for chinese

• https://github.com/eulerto/pg_similarity ⭐️⭐️

  set of functions and operators for executing similarity queries

• https://github.com/fairingrey/pg_simple_parser

  Simple postgres parser for full-text search

• https://github.com/za-arthur/pg_textparser

  Fast parser for text search of PostgreSQL

• https://github.com/postgrespro/pg_trgm_pro ⭐️

• https://github.com/postgrespro/pg_tsparser ⭐️

  pg_tsparser - parser for text search

• https://github.com/alexkuz/pg_unidecode

  Postgres Unidecode extension

  • https://github.com/gnarvaja/pg_unidecode

    Postgres Unidecode extension

• https://github.com/pgroonga/pgroonga ⭐️⭐️

  PGroonga is a PostgreSQL extension to use Groonga as index. PGroonga makes PostgreSQL fast full text search platform for all languages!

• https://github.com/OnroerendErfgoed/pgSFTI

  simple FuzzyTimeInterval for Postgresql

  • https://github.com/soduco/pgSFTI

    simple FuzzyTimeInterval for Postgresql

• https://github.com/madebykite/pgunicoll

  PostgreSQL Unicode Collation Extension

• https://github.com/oknj/postgresql-9.4-pg-bigm

  Debian package script for pg_bigm on PostgreSQL 9.4.

• https://github.com/jjw12345/postgresql-extension

  a extension for postgresql refer to smlar

• https://github.com/metabrainz/postgresql-musicbrainz-collate

  MusicBrainz collation routines for PostgreSQL

• https://github.com/metabrainz/postgresql-musicbrainz-unaccent

  MusicBrainz unaccenting routines for PostgreSQL

• https://github.com/urbic/postgresql-similarity

  PostgreSQL extension package which provides functions that calculate the similarity between two strings

• https://github.com/obartunov/setrank

  tf*idf ranking

• https://github.com/SZabirov/smlar

• https://github.com/bruce-shi/smlar

• https://github.com/jirutka/smlar ⭐️

  PostgreSQL extension for an effective similarity search || mirror of git://sigaev.ru/smlar.git || see https://www.pgcon.org/2012/schedule/track/Hacking/443.en.html

• https://github.com/poppingtonic/smlar

  Clone of git://sigaev.ru/smlar.git

• https://github.com/x4m/smlar

• https://github.com/dimv36/sphinxlink

  Run search queries for SphinxSearch from PostgreSQL

• https://github.com/r888888888/test_parser

  test_parser extension for postgresql

• https://github.com/oknj/textsearch_ja

  形態素解析を使用した日本語全文検索の、PostgreSQL組み込み型モジュール。

• https://github.com/zulip/tsearch_extras

• https://github.com/postgrespro/tsexact ⭐️

  PostgreSQL fulltext search addon

  • https://github.com/ArturFormella/tsexample

    Whitespace separator - Postgresql full text search parser

• https://github.com/postgrespro/tsvector2 ⭐️

  Extended tsvector type for PostgreSQL

• https://github.com/3manuek/twitter_parser

  A very minimalistic hashtag and mention parser for Postgres Full Text Search

• https://github.com/akorotkov/vgram

  Prototype of V-gram indexing for PostgreSQL

  • https://github.com/sech9446/vgram

    Prototype of V-gram indexing for PostgreSQL

• https://github.com/nuko-yokohama/vmatch

• https://github.com/postgrespro/wildspeed

• https://github.com/amutu/zhparser ⭐️⭐️

  zhparser is a PostgreSQL extension for full-text search of Chinese language

• https://github.com/zombodb/zombodb ⭐️⭐️⭐️

  Making Postgres and Elasticsearch work together like it's 2021

Dictionaries

• https://github.com/no0p/dict_exclude

  postgresql dictionary to exclude on regexps

• https://github.com/mohangk/dict_id

  Bahasa Indonesia stemmer postgres dictionary

• https://github.com/obartunov/dict_regex

• https://github.com/postgrespro/dict_regex

• https://github.com/obartunov/dict_roman

  Dictionary for roman-arabic conversion

• https://github.com/za-arthur/dict_translate

  Text search dictionary template for translation

• https://github.com/Houston-Inc/dict_voikko ⭐️

  PostgreSQL full text search dictionary utilizing the Finnish dictionary Voikko.

  • https://github.com/MattiL/dict_voikko

    PostgreSQL full text search dictionary utilizing the Finnish dictionary Voikko.

• https://github.com/vpikulik/hunspell_de_compounds

  Hunspell german dictionary with support of compound words

• https://github.com/ontaev/kalmyk-hunspell

  Kalmyk language (https://en.wikipedia.org/wiki/Kalmyk_Oirat) Hunspell dictionary

• https://github.com/grahamedgecombe/pgflate

  PostgreSQL module for raw DEFLATE compression/decompression with preset dictionary support

  • https://github.com/timurgarif/pgflate

    PostgreSQL module for raw DEFLATE compression/decompression with preset dictionary support

• https://github.com/pramsey/pgsql-addressing-dictionary ⭐️

  TSearch dictionaries for addresses

• https://github.com/grahamedgecombe/pgzstd ⭐️

  Postgres module for Zstandard compression/decompression with preset dictionary support

• https://github.com/postgrespro/rusmorph

  Russian morphological dictionary (rusmorph) for Postgres based on libmorph library: https://github.com/big-keva/libmorph

• https://github.com/tvondra/shared_ispell ⭐️

  Shared ispell dictionary (stored in shared segment, used by multiple connections)

  • https://github.com/postgrespro/shared_ispell ⭐️

    Shared ispell dictionary (stored in shared segment, used by multiple connections)

• https://github.com/postgrespro/snowball_ext

  The Snowball dictionary template extension for PostgreSQL

• https://github.com/postgrespro/tsexample ⭐️

  Example of custom postgresql full text search parser, dictionaries and configuration

Search & AI/ML

• https://github.com/palestamp/hamming_distance

  Hamming distance extension for Postgres.

• https://github.com/IrNesterova/hierarchicalClusteringForDiploma

• https://github.com/postgrespro/imgsmlr ⭐️⭐️

  Similar images search for PostgreSQL

• https://github.com/umitanuki/kmeans-postgresql ⭐️

  K-means function as a user-defined window function in PostgreSQL

• https://github.com/apache/madlib ⭐️⭐️

  Mirror of Apache MADlib

• https://github.com/tarkmeper/numpgsql

  Fundamental scientific computing library based on the popular Python Numpy library for Posgres PG/SQL Array types.

• https://github.com/MarkAntipin/pg_sparse_vector

  PostgreSQL extension. It adds support for sparse vector object and allowing to perform operations on them

• https://github.com/timescale/pgai ⭐️⭐️⭐️

  A suite of tools to develop RAG, semantic search, and other AI applications more easily with PostgreSQL

• https://github.com/michelp/pggraphblas ⭐️⭐️

  High Performance Graph Processing with Postgres and GraphBLAS

  • https://github.com/szarnyasg/pggraphblas

    High Performance Graph Processing with Postgres and GraphBLAS

• https://github.com/deepfryed/pghammer ⭐️

  hamming distance fn for postgresql

  • https://github.com/overplumbum/pghammer

    hamming distance fn for postgresql

• https://github.com/Minoro/pgpyml

  An in-database machine learning solution, that allows you to use your models written in Python inside Postgresql.

• https://github.com/neondatabase-labs/pgrag ⭐️

  Postgres extensions to support end-to-end Retrieval-Augmented Generation (RAG) pipelines

• https://github.com/ankane/pgvector ⭐️⭐️

  Open-source vector similarity search for Postgres

• https://github.com/Asa-Nisi-Masa/postgres-cosine-similarity

• https://github.com/PixNyanNyan/postgres-phash-hamming

  PostgreSQL extension for pHash hamming distance

• https://github.com/yieldsfalsehood/postgresml

Analytics & Columnar Storage

• https://github.com/hydradatabase/columnar ⭐️⭐️⭐️

  Postgres-native columnar storage extension

• https://github.com/apache/datasketches-postgresql ⭐️

  PostgreSQL extension providing approximate algorithms based on apache/datasketches-cpp

  • https://github.com/mmusnjak/datasketches-postgresql

    PostgreSQL module with approximate algorithms based on DataSketches/sketches-core-cpp

• https://github.com/liaorc/devel-master

  pg-cuda

• https://github.com/knizhnik/imcs ⭐️⭐️

  In-Memory Columnar Store extension for PostgreSQL

• https://github.com/sangli00/nanomsgtopdb

  nanomsg insert data to PipelineDB Stream

• https://github.com/heterodb/pg-strom ⭐️⭐️⭐️

  PG-Strom - Master development repository

• https://github.com/papercompute/pg_acce

  postgresql accelerated engine

• https://github.com/adjust/pg_cryogen ⭐️

  Compressed append-only pluggable storage for PostgreSQL 12+

• https://github.com/duckdb/pg_duckdb ⭐️⭐️⭐️

  DuckDB-powered Postgres for high performance apps & analytics

• https://github.com/CrunchyData/pg_parquet ⭐️⭐️

  Copy to/from Parquet in S3, Azure Blob Storage, Google Cloud Storage, http(s) stores, local files or standard inout stream from within PostgreSQL

• https://github.com/kaigai/pg_strom ⭐️⭐️

  FDW module of PostgreSQL using GPU for Asynchronous Super-Parallel Query Execution

• https://github.com/pipelinedb/pipeline_kafka ⭐️

  PipelineDB extension for Kafka support

  • https://github.com/weburnit/pipeline_kafka

    PipelineDB extension for Kafka support

• https://github.com/yexiaoxin1992/pipeline_kafka

• https://github.com/pipelinedb/pipeline_kinesis

  PipelineDB extension for Amazon Kinesis support

• https://github.com/pipelinedb/pipeline_odbc

  PipelineDB ODBC extension

• https://github.com/pipelinedb/pipelinedb ⭐️⭐️⭐️

  High-performance time-series aggregation for PostgreSQL

• https://github.com/qingqibing/pipelinedb

• https://github.com/citusdata/postgres_vectorization_test ⭐️⭐️

  Vectorized executor to speed up PostgreSQL

• https://github.com/timescale/promscale_extension ⭐️

• https://github.com/Veera28/timescale

• https://github.com/cosmicrocks/timescaledb

• https://github.com/timescale/timescaledb ⭐️⭐️⭐️

  An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

• https://github.com/zhangh43/vectorize_engine ⭐️

• https://github.com/postgrespro/vops ⭐️⭐️

Query Optimization & Planning

• https://github.com/x4m/ags

  Advanced Generalized Search - GiST as extension

• https://github.com/danolivo/anotherSelfJoin

  Remove Self Joins extension for PostgreSQL

• https://github.com/postgrespro/aqo ⭐️⭐️

  Adaptive query optimization for PostgreSQL

• https://github.com/XiaYingyin/ctidscan

  A Demo of PostgreSQL Custom Scan Provider API

• https://github.com/kaigai/ctidscan

  Example module of custom-scan interface

• https://github.com/danolivo/execplan

  PostgreSQL Extension for raw query plan execution

• https://github.com/theory/explanation

  Turn an explain plan into a table organized as a proximity tree

• https://github.com/parkag/geqo

  Genetic Query Optimizer isolated from PostgreSQL

• https://github.com/x4m/gevel

• https://github.com/hoangpham96/gist-isax

• https://github.com/HypoPG/hypopg ⭐️⭐️

  Hypothetical Indexes for PostgreSQL

• https://github.com/tvondra/index_analyzer

  Analyzes existing indexes in a PostgreSQL database and suggests which of them to drop.

• https://github.com/danolivo/pargres

  [Prototype] [WIP] Extension on PostgreSQL for parallel query execution

• https://github.com/theirix/parray_gin ⭐️

  PostgreSQL GIN support for arrays with partial match

• https://github.com/rlichtenwalter/pg_array_multi_index

  simultaneous multiple-indexing of PostgreSQL arrays

• https://github.com/trustly/pg_badplan ⭐️

  A PostgreSQL extension for logging queries where the expected/actual rows ratio exceeds a defined value

• https://github.com/ossc-db/pg_dbms_stats ⭐️

  Let PostgreSQL to make execution plans using frozen statistics.

• https://github.com/pgsentinel/pg_get_queryid

• https://github.com/ossc-db/pg_hint_plan ⭐️⭐️

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

• https://github.com/cohenjo/pg_idx_advisor ⭐️

  A PostgreSQL extension to analyze queries and give indexing advice.

• https://github.com/philwinn/pg_jit

  Just-in-time compilation in PostgreSQL using libFirm

• https://github.com/fabriziomello/pg_normalize_query ⭐️

  PostgreSQL extension to normalize SQL statements

• https://github.com/ossc-db/pg_plan_advsr ⭐️

  PostgreSQL extension for automated execution plan tuning

• https://github.com/nminoru/pg_plan_tree_dot

  PostgreSQL extension which visualizes a plan tree using Graphviz

• https://github.com/powa-team/pg_qualstats ⭐️⭐️

  A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing

• https://github.com/postgrespro/pg_query_state ⭐️⭐️

  Tool for query progress monitoring in PostgreSQL

• https://github.com/rjuju/pg_queryid

  External query fingerprinting for PostgreSQL

• https://github.com/rjuju/pg_shared_plans

  Shared cache plans for PostgreSQL

• https://github.com/cybertec-postgresql/pg_show_plans ⭐️

  Show query plans of all currently running SQL statements

• https://github.com/legrandlegrand/pg_stat_sql_plans

  pg_stat_sql_plans is a PostgreSQL extension created from pg_stat_statements, pg_store_plans and auto_explain adding a planid and many other features.

• https://github.com/ossc-db/pg_store_plans ⭐️

  Store execution plans like pg_stat_statements does for queries.

• https://github.com/mejedi/planscape-postgresql-module

  PostgreSQL extension finally providing visibility into the planning process

• https://github.com/thinkprojectgroup/query_cache

• https://github.com/tvondra/query_histogram

  provides a simple query execution time histogram for PostgreSQL

• https://github.com/tvondra/query_recorder

  an extension for recording all executed queries (so that you may replay them later)

• https://github.com/wulczer/saio

  PostgreSQL join optimisation with Simulated Annealing

  • https://github.com/parkag/saio

    PostgreSQL join optimisation with Simulated Annealing

• https://github.com/duckbill/sp-gist

  an extention about sp-gist

• https://github.com/postgrespro/sr_plan ⭐️

  Save and restore query plans in PostgreSQL

Monitoring & Observability

• https://github.com/okbob/autoreindex

• https://github.com/gleu/autovacuum_informations

  This PostgreSQL extension adds two functions, which gives more informations on the autovacuum processes.

• https://github.com/CyberDem0n/bg_mon ⭐️

  Background worker for monitoring PostgreSQL

• https://github.com/ibarwick/config_log

  PostgreSQL custom background worker (BGW) for monitoring configuration log changes

• https://github.com/asotolongo/db_info

• https://github.com/spd010273/dbstat

  DB Statistics Collector for PostgreSQL

• https://github.com/greenplum-db/diskquota ⭐️

  PostgreSQL disk quota extension

• https://github.com/ibarwick/filenode_map_inspect

  PostgreSQL extension to inspect pg_filenode.map files

• https://github.com/Houdini/log_entries

  course hacking postgresql, task 1

• https://github.com/munakoiso/logerrors ⭐️

• https://github.com/sroeschus/loginfo

  Postgres extension to introspect postgres log files.

• https://github.com/postgrespro/memstat

• https://github.com/frost242/monitoring_role

  Provide an easy way to use a non-privileged monitoring role

• https://github.com/hollobon/pagevis ⭐️

  PostgreSQL data page visualisation

• https://github.com/tvondra/palloc_bench

• https://github.com/gmr/pg-statsd ⭐️

  pg_statsd is a set of PostgreSQL user-defined functions that provide and interface to statsd.

• https://github.com/adjust/pg-telemetry ⭐️

  Useful monitoring views for PostgreSQL, packaged as an extension

• https://github.com/RhodiumToad/pg-toastutils

  TOAST inspection utils for postgres

• https://github.com/MasaoFujii/pg_cheat_funcs ⭐️

  This extension provides cheat (but useful) functions on PostgreSQL.

• https://github.com/hlinnaka/pg_check

  a tool to verify integrity of PostgreSQL data files

• https://github.com/tvondra/pg_check ⭐️

  a tool to verify integrity of PostgreSQL data files

• https://github.com/pgcodekeeper/pg_dbo_timestamp

  PostgreSQL extension that gathers object DDL modification timestamps and other information

• https://github.com/japinli/pg_dbsm

  Database size monitor for PostgreSQL

• https://github.com/alexandersamoylov/pg_dbwa

  PostgreSQL Database workload analizer

• https://github.com/frost242/pg_decode_infomask

  Set of functions to decode infomask values

• https://github.com/alexandersamoylov/pg_eyes

  PostgreSQL extension for analyze database activity

• https://github.com/lawrencejones/pg_frozen

  Expose tuple freeze information via SQL commands

• https://github.com/sangli00/pg_get_page_tuple

  PostgreSQL extension get Relation BlockNumber Tuple.

• https://github.com/postgrespro/pg_grab_statement ⭐️

  PostgreSQL extension for recoding workload of specific database

• https://github.com/turnstep/pg_healer ⭐️

  Repair Postgres corruption automatically

• https://github.com/pierreforstmann/pg_log_statements

  PostgreSQL extension to log SQL statements for specific server processes.

• https://github.com/logplex/pg_logfebe

  Uses Postgres FEBE to Frame Postgres Logs

  • https://github.com/heroku/pg_logfebe

    Uses Postgres FEBE to frame Postgres Logs

• https://github.com/logplex/pg_logfebe-debian

  Debian packaging for pg_logfebe

  • https://github.com/heroku/pg_logfebe-debian

    Debian packaging for pg_logfebe

• https://github.com/postgrespro/pg_logging ⭐️

  PostgreSQL logging interface

• https://github.com/pierreforstmann/pg_logqueryid

  PostgreSQL extension to display pg_stat_statements queryid with auto_explain

• https://github.com/topharley/pg_mem_counters

  This is a small extension for keeping total and rpm named counters in shared memory of PostgreSQL server.

• https://github.com/jackgo73/pg_memorycontext

  Memory Context extension for PostgreSQL

• https://github.com/jatobadb/pg_memorydump

• https://github.com/johto/pg_metrics

  Collect custom metrics from PostgreSQL backends

• https://github.com/nvorobev/pg_metricus_c

  Sending metrics in the socket (Brubeck, Graphite, etc.) from pl/pgsql code

  • https://github.com/avito-tech/pg_metricus_c ⭐️

    Sending metrics in the socket (Brubeck, Graphite, etc.) from pl/pgsql code

• https://github.com/AyoubKaz07/pg_microbench

  Measure hardware-level performance counters (CPU cycles, cache misses, branch mispredictions) for queries

• https://github.com/RafiaSabih/pg_mon

• https://github.com/citusdata/pg_octopus

  A health checker for PostgreSQL

• https://github.com/bdrouvot/pg_orphaned

• https://github.com/harukat/pg_pageinspect_plus

  A PostgreSQL Extension which helps page inspection with the contrib/pageinspect.

• https://github.com/markwkm/pg_proctab ⭐️

  Mirror of https://gitlab.com/pg_top/pg_proctab

• https://github.com/zubkov-andrei/pg_profile ⭐️

  Postgres historic workload reports

• https://github.com/akatruk/pg_profile_old

• https://github.com/timescale/pg_prometheus ⭐️⭐️

  PostgreSQL extension for Prometheus data

• https://github.com/adjust/pg_querylog

  Show queries running on PostgreSQL backends

• https://github.com/hlinnaka/pg_quota

  PostgreSQL extension for quotas

• https://github.com/anayrat/pg_sampletolog ⭐️

  Postgres extension to sample statements or transactions to logs

• https://github.com/RyanMarcus/pg_session_stats

  Track PostgreSQL resource usage across a session, including parallelism.

• https://github.com/menardorama/pg_sessions

  Postgresql active session history including pid and timestamp

• https://github.com/the4thdoctor/pg_snapshot_too_old

  Extension for enabling a snapshot too old in PostgreSQL

  • https://github.com/matthewfranglen/pg_snapshot_too_old

    Extension for enabling a snapshot too old in PostgreSQL

• https://github.com/powa-team/pg_sortstats ⭐️

  A PostgreSQL extension for collecting statistics about sorts, helping tuning work_mem

• https://github.com/kouber/pg_sqlog

  Provide SQL interface to PostgreSQL logs

• https://github.com/cybertec-postgresql/pg_squeeze ⭐️⭐️

  A PostgreSQL extension for automatic bloat cleanup

• https://github.com/powa-team/pg_stat_kcache ⭐️⭐️

  Gather statistics about physical disk access and CPU consumption done by backends.

• https://github.com/percona/pg_stat_monitor ⭐️⭐️

  PostgreSQL Statistics Collector

• https://github.com/ysn-source/pg_stat_sql

  (WIP) Study case on pg_stat_statements extension : Benefits and Performance behavior

• https://github.com/uptimejp/pg_stat_statements2

  pg_stat_statements2

• https://github.com/ibrarahmad/pg_stat_statments

• https://github.com/mpihlak/pg_stat_usage

• https://github.com/s-hironobu/pg_stats

  An extension of PostgreSQL which contains some customized statistics views.

• https://github.com/bdrouvot/pg_subtrans_infos

• https://github.com/rjuju/pg_track_settings ⭐️

  Small extension to keep track of postgresql settings modification

• https://github.com/julmon/pg_track_slow_queries

  PostgreSQL extension for slow queries tracking

• https://github.com/postgrespro/pg_wait_sampling ⭐️

  Sampling based statistics of wait events

  • https://github.com/RekGRpth/pg_wait_sampling

    Sampling based statistics of wait events

• https://github.com/johto/pgcov

  PL/PgSQL test coverage analysis

• https://github.com/vventirozos/pgcozy

  shared buffer snapshot and prewarm extension

• https://github.com/CrunchyData/pgnodemx ⭐️

  A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.

• https://github.com/no0p/pgsampler ⭐️

  Experimental Postgresql background worker for collecting status and performance metrics

  • https://github.com/i0seph/pgsampler

    Experimental Postgresql background worker for collecting status and performance metrics

• https://github.com/pgsentinel/pgsentinel ⭐️⭐️

  postgresql extension providing Active session history

• https://github.com/einhverfr/pgxn-postgres_monitoring

  Extension for monitoring functions, so various monitoring packages can have a common API

• https://github.com/bigsql/plprofiler ⭐️

  • https://github.com/arvidma/plprofiler

• https://github.com/glynastill/plprofiler

  Forked from https://bitbucket.org/openscg/plprofiler.git see:

• https://github.com/pinkonio/plprofiler

• https://github.com/hollobon/postgresql_track_renames

  Extension for tracking object renames in PostgreSQL 9.3+

• https://github.com/powa-team/powa ⭐️⭐️

  PostgreSQL Workload Analyzer

  • https://github.com/frost242/powa

    PostgreSQL Workload Analyzer

• https://github.com/powa-team/powa-archivist ⭐️

  powa-archivist: the powa PostgreSQL extension

• https://github.com/asotolongo/resources

  This PostgreSQL extension implements tables and views to get information about server resources : CPU, RAM, partitions, SO, etc

• https://github.com/frost242/ssi_failures

  This project offers a view to monitor serialization failures occuring in a PostgreSQL database

• https://github.com/asotolongo/stat_record_old

  PostgreSQL extension implements record stats about database server and can show some reports about stats like : connection, size, cache, table and index use, querys, etc

• https://github.com/slardiere/streaminglag

  PostgreSQL Utils Functions to show lag between Master and Standby

• https://github.com/EnterpriseDB/system_stats ⭐️

  A Postgres extension for exposing system metrics such as CPU, memory and disk information

• https://github.com/credativ/toastinfo

  Show storage structure of varlena datatypes in PostgreSQL

• https://github.com/tvondra/user_info

  Extension for listing various user-related info (granted roles, owned objects, ...)

Auditing, Security & Encryption

• https://github.com/arkhipov/acl ⭐️

  Access Control Lists (ACL) PostgreSQL Extension

  • https://github.com/bookvik/acl

    Access Control Lists (ACL) PostgreSQL Extension

• https://github.com/2ndQuadrant/audit-trigger ⭐️⭐️

  Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.

• https://github.com/tvondra/connection_limits ⭐️

  a PostgreSQL extension that allows you to set quotas on connections (per user, database or IP)

• https://github.com/CrunchyData/crunchy_check_access ⭐️

  Functions and views to facilitate PostgreSQL object access inspection

• https://github.com/dverite/cryptint

  PostgreSQL extension implementing Skip32 and XTEA encryption for int and bigint types

• https://github.com/s-hironobu/dont_drop_db

• https://github.com/cybertec-postgresql/drop_role_helper

  Generate SQL to revoke all privileges of a role in the current database

• https://github.com/KiriakosGeorgiou/istoria

  istoria, PostgreSQL extension for managing table histories

• https://github.com/crtsh/libx509pq ⭐️

  X.509 certificate parsing library for PostgreSQL

• https://github.com/liang7878/login_refuse

  login refuse extension for PostgreSQL

• https://github.com/ekayim/non_truncate

• https://github.com/rogerioacp/oblivpg_ftw

  Oblivious Foreign table wrapper. This project creates a postgres table wrapper for an indexed table managed by a trusted hardware with ORAM accesses.

• https://github.com/eendroroy/passwordpolicy

  A simple modified version of postgres passwordcheck plugin with configuration options

• https://github.com/dverite/permuteseq ⭐️

  PostgreSQL extension for scalable pseudo-random permutations of sequences

• https://github.com/m-martinez/pg-audit-json ⭐️

  Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.

• https://github.com/beargiles/pg-cert

  PostgreSQL extension for X509 digital certificates. This extension uses the OpenSSL library

• https://github.com/ameensol/pg-ecdsa

  ECDSA for PostgreSQL

• https://github.com/adjust/pg-roleman

  Role Management Extension with some Nice Common Functions

• https://github.com/eradman/pg-safeupdate ⭐️⭐️

  A simple extension to PostgreSQL that requires criteria for UPDATE and DELETE

• https://github.com/truthly/pg-webauthn

  🔐🐘 PostgreSQL WebAuthn Server

• https://github.com/disqus/pg_audit

  Audit PostgreSQL tables in an automated fashion.

  • https://github.com/davidfetter/pg_audit

    Audit PostgreSQL tables in an automated fashion.

• https://github.com/ttfkam/pg_audit

  Audit insert, update, and delete on tables in PostgreSQL

• https://github.com/alexandersamoylov/pg_audit_tools

  PostgreSQL extension for audit tables management

• https://github.com/kouber/pg_auditor

  PostgreSQL extension to log each DML statement and flashback transactions

• https://github.com/RafiaSabih/pg_auth_mon ⭐️

  Postgres extension for monitoring client authentication attempts

• https://github.com/nuko-yokohama/pg_block_systemcatalog

  PostgreSQL extension to block references to system catalogs.

• https://github.com/sshutdownow/pg_check-chap-md5

  postgres extension to check CHAP (rfc1994) MD5

• https://github.com/sangli00/pg_checkdestroy

  Use Hook check SQL DROP&TRUNCATE&DELETE

• https://github.com/fdr/pg_connlimit

  Limit PostgreSQL Role Connectivity without Catalog Access

• https://github.com/MasaoFujii/pg_control_priority

  This extension provides the ability to control the scheduling priority ("nice") of PostgreSQL server process.

• https://github.com/postgrespro/pg_credereum ⭐️

  Prototype of PostgreSQL extension bringing some properties of blockchain to the relational DBMS

• https://github.com/k0001/pg_ed25519

  PostgreSQL Ed25519 tools

• https://github.com/ligurio/pg_feedback

  PostgreSQL Feedback Plugin

• https://github.com/shereshevsky/pg_grants_manager

  PostgreSQL automated grants managment

• https://github.com/cybertec-postgresql/pg_permission ⭐️⭐️

  A simple set of views to see ALL permissions in a PostgreSQL database

• https://github.com/schmiddy/pg_prioritize ⭐️

  get and set the priority of PostgreSQL backends

• https://github.com/pierreforstmann/pg_readonly

  PostgreSQL extension to set all cluster databases read only.

• https://github.com/mreithub/pg_recall ⭐️

  Simple PostgreSQL extension that keeps track of changes to certain tables

• https://github.com/katsuragi-y/pg_reject_truncate

• https://github.com/harukat/pg_rlimit

  PostgreSQL extension that provides interfaces for setrlimit(2)/getrlimit(2) instead of ulimit command

• https://github.com/TypedLambda/pg_secret

  An ORE extension for postgres

• https://github.com/sshutdownow/pg_setpriority

  set the priority of PostgreSQL process

• https://github.com/credativ/pg_snakeoil ⭐️

  The PostgreSQL Antivirus #pgSnakeOil

• https://github.com/RekGRpth/pg_ssl

  postgres ssl pkcs7 sign

• https://github.com/mhagander/pg_sslstatus ⭐️

  Simple PostgreSQL extension to give the administrator a view of how SSL is used in the installation

• https://github.com/nuko-yokohama/pg_sulog

  PostgreSQL superuser logging/blocking.

• https://github.com/cossacklabs/pg_themis ⭐️

  Postgres Themis plugin

  • https://github.com/mnaza/pg_themis

    Postgres Themis plugin

• https://github.com/MasahikoSawada/pg_visibilitymap

  The diagnostic functions for VisibilityMap

• https://github.com/dvarrazzo/pgaudit ⭐️

  Simple PostgreSQL extension for tables auditing

• https://github.com/godouxm/pgaudit

  • https://github.com/jonranes/pgaudit

    Fork of pgaudit to provide Graylog Gelf output

• https://github.com/pgaudit/pgaudit ⭐️⭐️

  PostgreSQL Audit Extension

• https://github.com/fmbiete/pgauditlogtofile

  pgAudit Log to File is an addon for pgAudit to redirect audit logs to an independent file

• https://github.com/michelp/pgjwt ⭐️⭐️

  PostgreSQL implementation of JWT (JSON Web Tokens)

  • https://github.com/RekGRpth/pgjwt

    PostgreSQL implementation of JWT (JSON Web Tokens)

• https://github.com/pgMemento/pgMemento ⭐️⭐️

  Audit trail with schema versioning for PostgreSQL using transaction-based logging

• https://github.com/johto/pgocrypto

  Simple symmetric encryption between Go and PostgreSQL (with pgcrypto)

• https://github.com/CrunchyData/pgseccomp

• https://github.com/michelp/pgsodium ⭐️⭐️

  Modern cryptography for PostgreSQL using libsodium.

• https://github.com/johto/pgspeck ⭐️

  Small block size Speck encryption in PostgreSQL

• https://github.com/MIuserX/pgsword

  A SQL auditing extension for PostgreSQL

• https://github.com/dverite/postgres-shacrypt

  PostgreSQL extension to generate SHA256-CRYPT and SHA512-CRYPT password hashes

• https://github.com/MasaoFujii/postgres_security

• https://github.com/webysther/postgresql_anonymizer

  Mirror of Gitloab repo PostgreSQL Anonymizer

• https://gitlab.com/dalibo/postgresql_anonymizer

• https://github.com/monacoremo/postgrest-auth

  Postgres extension for authentication in PostgREST

• https://github.com/pgaudit/set_user ⭐️

  PostgreSQL extension allowing privilege escalation with enhanced logging and control

• https://github.com/uptimejp/sql_firewall ⭐️⭐️

  SQL Firewall Extension for PostgreSQL

  • https://github.com/arnegrim/sql_firewall

    SQL Firewall Extension for PostgreSQL

• https://github.com/EnterpriseDB/sslutils

  A Postgres extension for managing SSL certificates through SQL.

• https://github.com/psoo/table_log

  Fork of the old table_log module, supporting PostgreSQL 9.1+

  • https://github.com/credativ/table_log

    Fork of the old table_log module, supporting PostgreSQL 9.1+

• https://github.com/glynastill/table_log_pl

  pl/pgsql drop-in replacement for the dated PostgreSQL table_log C auditing extension

• https://github.com/snaga/tablelog

  A PostgreSQL extension for capturing table modifications with table trigger

• https://github.com/julmon/tcle

  Transparent Cell-Level Encryption for PostgreSQL

Distributed Systems & Replication

• https://github.com/gfphoenix78/autofailover

• https://github.com/kayform/bwcontrol

  Control replication process on postgresql interactive terminal.

• https://github.com/cloud-sn2/cigration ⭐️

  Citus shard migration tool

• https://github.com/citusdata/citus ⭐️⭐️⭐️

  Distributed PostgreSQL as an extension

• https://github.com/vibhorkum/edb_foreignkeyconstraintmanager

  Repository for EDB Partition key Management

• https://github.com/hangzhou-cstech/gogudb

  PostgreSQL High Performance Distributed Database Plugin

• https://github.com/omniti-labs/mimeo ⭐️

  Extension for specialized, per-table replication between PostgreSQL instances

  • https://github.com/payals/mimeo

    Extension for specialized replication between PostgreSQL instances

• https://github.com/postgrespro/mmts ⭐️

  multimaster

• https://github.com/tongxin/mypg_sharding

  A custom sharding extension

• https://github.com/dturon/partman_to_cstore

  PostgreSQL extension to move old pg_partman tables to columnar storage CSTORE

• https://github.com/funbringer/pathman_sharding

  Improved sharding for pg_pathman

• https://github.com/einhverfr/pg-trumpet

  Partial table replication for PostgreSQL

• https://github.com/kelvich/pg_dtm

  Distributed transaction manager for postgres

• https://github.com/postgrespro/pg_dtm ⭐️

  Distributed transaction manager

• https://github.com/lemoineat/pg_fkpart

  PostgreSQL extension to partition tables following a foreign key

• https://github.com/MasahikoSawada/pg_keeper ⭐️

  Simplified clustering module for PostgreSQL

• https://github.com/uptimejp/pg_part ⭐️

  PostgreSQL Table Partitioning Utility

• https://github.com/funbringer/pg_particulous

  Instant migration from vanilla PostgreSQL to pg_pathman and vice versa

• https://github.com/disqus/pg_partition

  Partition management for PostgreSQL

• https://github.com/alytics/pg_partman

• https://github.com/pgpartman/pg_partman ⭐️⭐️⭐️

  Partition management extension for PostgreSQL

• https://github.com/denishpatel/pg_partman_v2RC1

• https://github.com/postgrespro/pg_pathman ⭐️⭐️

  Partitioning tool for PostgreSQL

• https://github.com/citusdata/pg_paxos ⭐️⭐️

  Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes

• https://github.com/MasahikoSawada/pg_promoter

  pg_promoter is simplified clustering module based on bgworker.

• https://github.com/alexandersamoylov/pg_prttn_tools

  PostgreSQL extension for partition tables management

• https://github.com/danolivo/pg_repeater

  Repeat all queries at remote instance

• https://github.com/realyota/pg_repl

  pg_repl is PostgreSQL database extension for keeping DDL/DCL code consistency between each instance of a database in PostgreSQL cluster.

• https://github.com/citusdata/pg_shard ⭐️⭐️⭐️

  ATTENTION: pg_shard is superseded by Citus, its more powerful replacement

• https://github.com/kelvich/pg_shard

  PostgreSQL extension to scale out real-time reads and writes. Check out the mailing list at https://groups.google.com/group/pg_shard-users

  • https://github.com/nagyist/pg_shard

    PostgreSQL extension to scale out real-time reads and writes. Check out the mailing list at https://groups.google.com/group/pg_shard-users

• https://github.com/citusdata/pg_shard-old

  Repo used for pg_shard development before release.

• https://github.com/vibhorkum/pg_shard_ppas

  patched version of pg_shard for PPAS.

• https://github.com/kotsachin/pg_shardman

  PostgreSQL sharding built on pg_pathman, postgres_fdw and logical replication

  • https://github.com/isgasho/pg_shardman

    PostgreSQL sharding built on partitioning, postgres_fdw and logical replication

  • https://github.com/zhdk123456/pg_shardman

    PostgreSQL sharding built on partitioning, postgres_fdw and logical replication

• https://github.com/kelvich/pg_tsdtm

  • https://github.com/Vereschak/pg_tsdtm
  • https://github.com/cuulee/pg_tsdtm
  • https://github.com/gridl/pg_tsdtm
  • https://github.com/postgrespro/pg_tsdtm ⭐️
  • https://github.com/quinndiggity/pg_tsdtm

• https://github.com/cruzdb/pg_zlog ⭐️

  Table replication for PostgreSQL nodes with Ceph and ZLog

• https://github.com/enova/pgl_ddl_deploy ⭐️

  Transparent Logical DDL Replication

• https://github.com/2ndQuadrant/pglogical ⭐️⭐️

  Logical Replication extension for PostgreSQL 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

• https://github.com/vibhorkum/pglogical

  pglogical repository for EDBAS

• https://github.com/unotech001/pglogical-2.0

  pglogical

• https://github.com/enova/pglogical_ticker

  Time-based replication delay for pglogical

  • https://github.com/credativ/pglogical_ticker

    Time-based replication delay for pglogical

• https://github.com/citusdata/pgmasq

  Transparently forward transactions from a hot standby to a primary in PostgreSQL (failed experiment)

• https://github.com/storm-db/pgxc_dns

• https://github.com/hipay/postgresql-partition-manager

  Set of tables and functions wrote to help the management of partitionning tables in PostgreSQL databases.

  • https://github.com/slardiere/PartMgr

    manage PostgreSQL Table Partitionning

• https://github.com/yazun/range_partitioning

• https://github.com/dvarrazzo/replisome

  handsomely replicate something

  • https://github.com/Zeto-Ltd/replisome

    handsomely replicate something

• https://github.com/reshke/router

• https://github.com/bonesmoses/shard_manager

  Extension for managing schema-based horizontal scaling

• https://github.com/vibhorkum/synchronize-logical-slots

  Synchronize logical replication slot

• https://github.com/pgstuff/sys_syn_dblink

  System Synchronization Client via dblink

• https://github.com/peak6/tab_tier

  PostgreSQL extension for managing date-based job-driven table partitions

• https://github.com/yazun/xl_global_views

  Global system views for Postgres-XL/Tbase

Backup, Recovery & WAL

• https://github.com/Kozea/emaj

  E-Maj Postgresql extension.

• https://github.com/dalibo/emaj ⭐️

  E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities

• https://github.com/s-hironobu/pg_bman

  Yet another backup tool for PostgreSQL

• https://github.com/VladimirMikhailov/pg_dirtyread

• https://github.com/df7cb/pg_dirtyread ⭐️

  Read dead but unvacuumed tuples from a PostgreSQL relation

• https://github.com/rjuju/pg_dropbuffers

  Toy extension to drop buffers from shared_buffers without needing to restart the cluster.

• https://github.com/zilder/pg_dropcache ⭐️

  pg_dropcache is a PostgreSQL extension that invalidates shared_buffers cache

• https://github.com/postgrespro/pg_pageprep

  PostgreSQL extension which helps to prepare heap pages for migration to 64bit XID page format (PostgresPro Enterprise)

• https://github.com/zilder/pg_pageprep

  PostgreSQL extension which helps to prepare heap pages for migration to 64bit XID page format (PostgresPro Enterprise)

• https://github.com/Timosha/pg_prewarm

  pg_prewarm - preload relation data into system buffer cache

• https://github.com/2ndquadrant-it/pgespresso ⭐️

  Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL

• https://github.com/klando/pgfincore ⭐️

  Mirror of http://git.postgresql.org/gitweb/?p=pgfincore.git;a=summary

• https://github.com/pgfincore/pgfincore

• https://github.com/postgrespro/ptrack ⭐️

  Block-level incremental backup engine for PostgreSQL

• https://github.com/moritetu/walreader

  a postgresql extension to read wal with sql functions

• https://github.com/snaga/xlogging

  an experimental function to enable/disable xlog on tables and indexes.

Foreign Data Wrappers

• https://github.com/sanglijunfengDev/aerospike_fdw

  PostgreSQL extension that Foreign Data Wrapper for AEROSPACE_FDW.

• https://bitbucket.org/adunstan/blackhole_fdw

  • https://github.com/chenquanzhao/blackhole_fdw

• https://github.com/jaiminpan/cassandra2_fdw ⭐️

  fdw for cassandra2

• https://github.com/QuantamHD/cassandra_fdw

• https://github.com/The-Alchemist/cassandra_fdw

  Import from https://bitbucket.org/openscg/cassandra_fdw

• https://github.com/fedesilva/cassandra_fdw

• https://github.com/pgsql-io/cassandra_fdw

• https://github.com/messagebird/clickhouse-postgres-fdw ⭐️

  This project provides federated access to Clickhouse cluster from Postgres, with the ability to write FDW API functions in GO.

• https://github.com/Percona-Lab/clickhousedb_fdw ⭐️⭐️

  PostgreSQL's Foreign Data Wrapper For ClickHouse

• https://github.com/ZhengYang/couchdb_fdw ⭐️

  PostgreSQL SQL/MED FDW for CouchDB

  • https://github.com/golgauth/couchdb_fdw

    PostgreSQL SQL/MED FDW for CouchDB (PostgreSQL 9.2+)

• https://github.com/citusdata/cstore_fdw ⭐️⭐️⭐️

  Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.

  • https://github.com/renevdzee/cstore_fdw

    Columnar store for analytics with Postgres, developed by Citus Data. Check out the mailing list at https://groups.google.com/forum/#!forum/cstore-users or join our slack channel at https://slack.citus...

• https://github.com/dotnwat/cstore_fdw

  Fast columnar store for analytics with PostgreSQL

• https://github.com/wanghongxiang2018/cstore_fdw

• https://github.com/wolfgangbrandl/db2_fdw ⭐️

  PostgreSQL DB2 Data Wrapper

• https://github.com/stanislawbartkowski/db2odbc_fdw

• https://github.com/ZhengYang/dc_fdw

  PostgreSQL - Document Collection Foreign-data Wrapper (works with 9.1 to 9.3)

• https://github.com/sebschrader/debian-pkg-postgresql-mysql-fdw

• https://github.com/xiaowing/douban_fdw

  A PostgreSQL's Foreign Data Wrapper (FDW) for retrieving the movie ranking data via the public API of douban.com

• https://github.com/alitrack/duckdb_fdw ⭐️

  DuckDB Foreign Data Wrapper for PostgreSQL

• https://github.com/slaught/dummy_fdw

  A readable, null foreign data wrapper for Postgresql 9.3+

• https://github.com/MeetMe/dump_fdw ⭐️

  Foreign Data Wrapper for Postgres Dump Files

• https://github.com/lianhuiwang/file_fdw

  Extends the original file_fdw for Citus / Hadoop integration

  • https://github.com/geezer-workshop/file_fdw

    Extends the original file_fdw for Citus / Hadoop integration

  • https://github.com/nubiofs/file_fdw

    Extends the original file_fdw for Citus / Hadoop integration

• https://github.com/corlogic-code/file_fdw_program

• https://github.com/adunstan/file_fixed_length_record_fdw ⭐️

  PostgreSQL File Fixed Length FDW

• https://github.com/adunstan/file_text_array_fdw ⭐️

  PostgreSQL File Text Array FDW

• https://github.com/ibarwick/firebird_fdw ⭐️

  A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.2.3 (2022-02-20)

• https://github.com/franckverrot/git_fdw ⭐️

  PostgreSQL Git Foreign Data Wrapper

• https://github.com/dennwc/go-fdw ⭐️

  Go project template for Foreign Data Wrappers for PostgreSQL

• https://github.com/durch/google-bigtable-postgres-fdw ⭐️

  Google Bigtable Postgres FDW in Rust

• https://github.com/luxms/greenplum-fdw

  Clone of postgres-fdw, to query Greenplum DB from PostgreSQL. See master branch README!

• https://github.com/pgspider/griddb_fdw ⭐️

  GridDB Foreign Data Wrapper for PostgreSQL

• https://github.com/danolivo/gtables_fdw

  Demo PostgreSQL extension on global tables over FDW

• https://github.com/sangli00/hash_fdw

  PostgreSQL extension that provides a Foreign Data Wrapper for hash tables.

• https://github.com/fabriziomello/hba_fdw

  Manage your pg_hba.conf file using SQL

• https://github.com/troels/hbase_fdw

  HBase FDW

• https://github.com/EnterpriseDB/hdfs_fdw ⭐️⭐️

  PostgreSQL foreign data wrapper for HDFS

• https://github.com/wikrsh/hello_fdw ⭐️

  Hello world example for PostgreSQL's foreign data wrapper(FDW)

• https://github.com/bigsql/hive_fdw

  Hive Queries to Presto & Amazon Athena

• https://github.com/pgsql-io/hive_fdw

  Hive Foreign Data Wrapper

• https://github.com/franckverrot/holycorn ⭐️⭐️

  Community version of the PostgreSQL multi-purpose Ruby Foreign Data Wrapper

  • https://github.com/abrandoned/holycorn

    Community version of the PostgreSQL multi-purpose Ruby Foreign Data Wrapper

• https://github.com/pgspider/influxdb_fdw ⭐️

  InfluxDB Foreign Data Wrapper for PostgreSQL.

• https://github.com/credativ/informix_fdw ⭐️

  Foreign Data Wrapper for Informix Databases

• https://github.com/heimir-sverrisson/jdbc2_fdw ⭐️

  JDBC Foreign Data Wrapper for PostgreSQL

  • https://github.com/numerigraphe/jdbc2_fdw

    JDBC Foreign Data Wrapper for PostgreSQL

• https://github.com/atris/JDBC_FDW ⭐️

  FDW that wraps JDBC for PostgreSQL.It can be used to connect and fetch data from any data source that supports JDBC

• https://github.com/nkhorman/json_fdw ⭐️⭐️

  PostgreSQL extension which implements a Foreign Data Wrapper (FDW) for JSON files.

• https://github.com/BrandwatchLtd/kafka_fdw

• https://github.com/adjust/kafka_fdw ⭐️

  kafka foreign database wrapper for postresql

• https://github.com/cohenjo/kafka_fdw

  kafka foreign-data wrapper for PostgreSQL

• https://github.com/cloudflarearchive/kt_fdw ⭐️

  Kyoto Tycoon FDW for PostgreSQL

  • https://github.com/webcore-no/kt_fdw

    Kyoto Tycoon FDW for PostgreSQL

• https://github.com/guedes/ldap_fdw ⭐️

  A LDAP Foreign Data Wrapper for PostgreSQL

• https://github.com/vibhorkum/ldapfdw

• https://github.com/seanpringle/lua_fdw

  Lua Foreign Data Wrapper for PostgreSQL

• https://github.com/snaga/monetdb_fdw ⭐️

  monetdb_fdw - PostgreSQL Foreign Data Wrapper for MonetDB

  • https://github.com/ray2501/monetdb_fdw

    monetdb_fdw - PostgreSQL Foreign Data Wrapper for MonetDB

• https://github.com/RelateIQ-chef/mongo_fdw

• https://github.com/citusdata/mongo_fdw ⭐️⭐️

  DEPRECATED, moved to

  • https://github.com/EnterpriseDB/mongo_fdw ⭐️⭐️

    PostgreSQL foreign data wrapper for MongoDB

• https://github.com/digoal/mongo_fdw

  fork and modified by citusdb's mongo_fdw to support unix sock connection.

• https://github.com/EnterpriseDB/mysql_fdw ⭐️⭐️

  PostgreSQL foreign data wrapper for MySQL

• https://github.com/sim51/neo4j-fdw ⭐️

  Neo4j foreign data wrapper for Postgresql

• https://github.com/nuko-yokohama/neo4j_fdw ⭐️

  Graph Database Foreign Data Wrapper for PostgreSQL

• https://github.com/sgsfak/ocgeo_fdw

  A PostgreSQL Foreign Data Mapper for accessing the OpenCageData API

• https://github.com/ZhengYang/odbc_fdw ⭐️

  PostgreSQL Foreign-data Wrapper for ODBC

  • https://github.com/CartoDB/odbc_fdw ⭐️

    PostgreSQL Foreign-data Wrapper for ODBC

• https://github.com/hangzhou-cstech/odbc_fdw

• https://github.com/ibrarahmad/oracle_fdw

  PostgreSQL extension that provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions as well as comprehensive EXPLAIN and ANALYZE support...

• https://github.com/laurenz/oracle_fdw ⭐️⭐️

  PostgreSQL Foreign Data Wrapper for Oracle

  • https://github.com/RekGRpth/oracle_fdw

    PostgreSQL Foreign Data Wrapper for Oracle

• https://github.com/HighgoSoftware/orc_fdw

  A foreign data wrapper for PostgreSQL allowing easy accessing of Apache ORC formatted data files.

• https://github.com/gokhankici/orc_fdw ⭐️

  PostgreSQL extension which implements a Foreign Data Wrapper (FDW) for ORC files.

• https://github.com/adjust/parquet_fdw ⭐️⭐️

  Parquet foreign data wrapper for PostgreSQL

• https://github.com/tai/parquet_fdw

• https://github.com/beargiles/passwd-fdw

  PostgreSQL foreign data wrapper (FDW) for linux/unix password and group files.

• https://github.com/pborne/pg-file-fdw-gds

• https://github.com/akira-tech/pg_ext_JiraRestClient

  Postgresql extension to query Atlassian Jira using REST API using foreign data wrappers

• https://github.com/d-e-n-t-y/pg_fdw_mv_rewrite

• https://github.com/CrunchyData/pgbouncer_fdw ⭐️

  PostgreSQL Foreign Data Wrapper to Connect to pgbouncer

• https://github.com/fengttt/pgc_fdw

  • https://github.com/cktan/pgc_fdw

• https://github.com/2ndQuadrant/pglog

  PostgreSQL logger foreign data wrapper

• https://github.com/vidardb/pgrocks-fdw ⭐️

  Bring RocksDB to PostgreSQL as an extension. It is the first foreign data wrapper (FDW) that introduces LSM-tree into PostgreSQL. The underneath storage engine can be RocksDB. The FDW also serves for ...

• https://github.com/pramsey/pgsql-ogr-fdw ⭐️⭐️

  PostgreSQL foreign data wrapper for OGR

• https://github.com/commandprompt/postgres_fdw

  A read-only Postgres FDW for 9.2.

• https://github.com/MasaoFujii/postgres_fdw_plus

  postgres_fdw_plus is a fork of postgres_fdw contrib module included in PostgreSQL, and supports global transaction feature.

• https://github.com/vpikulik/postgres_osm_pbf_fdw ⭐️

  OSM PBF Foreign Data Wrapper

• https://github.com/jsc0218/PostgresForeignDataWrapper ⭐️

  has been moved to https://github.com/vidardb/PostgresForeignDataWrapper. It is the first foreign data wrapper introducing LSM-tree into PostgreSQL.

• https://github.com/scarbrofair/ppg_fdw

  distributed parallel query engine, based on fdw and hooks of PG

• https://github.com/slamdata/quasar-fdw ⭐️

  A module that connects any BI tool to any Quasar-supported backend.

• https://github.com/yanatan16/quasar_fdw

  Postgres Foreign Data Wrapper for Quasar

• https://github.com/Daleys/redis_fdw

• https://github.com/dpage/redis_fdw ⭐️

  A PostgreSQL foreign data wrapper for Redis

  • https://github.com/pg-redis-fdw/redis_fdw ⭐️⭐️

    A PostgreSQL foreign data wrapper for Redis

• https://github.com/pgexperts/redis_fdw-dev

  development branch of redis_fdw for writable tables

• https://github.com/qingqibing/redis_fdw-dev

• https://github.com/asotolongo/rep_fdw

• https://bitbucket.org/adunstan/rotfang-fdw

  FDW to generate random data

• https://github.com/nahanni/rw_redis_fdw ⭐️

  • https://github.com/gsiz007/rw_redis_fdw

• https://github.com/umitanuki/s3_fdw ⭐️

  foreign-data wrapper for Amazon S3

  • https://github.com/eligoenergy/s3_fdw

    foreign-data wrapper for Amazon S3

• https://github.com/cjqhenry14/server_orc_fdw

  fdw for orc file (not in hdfs). Selecting certain columns and skip stripes are not supported now. Based on orc c++ library, cstore_fdw, gokhankici/orc_fdw

• https://github.com/aganatramoat/sqlite_fdw

• https://github.com/gleu/sqlite_fdw ⭐️

  Foreign Data Wrapper for sqlite

• https://github.com/pgspider/sqlite_fdw ⭐️

  SQLite Foreign Data Wrapper for PostgreSQL

• https://github.com/raitech/sybase_fdw

  Sybase FDW for PostgreSQL

  • https://github.com/leandrohm/sybase_fdw

    Sybase FDW for PostgreSQL

• https://github.com/beargiles/tarfile-fdw

• https://github.com/tds-fdw/tds_fdw ⭐️⭐️

  A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

• https://github.com/okbob/template_fdw

  PostgreSQL data wrapper for template tables - any DML and SELECT operations are disallowed

• https://github.com/komamitsu/treasuredata_fdw

  PostgreSQL Foreign Data Wrapper for Treasure Data

• https://github.com/komamitsu/treasuredata_fdw_test

• https://github.com/goldenhelix/tsf-fdw

  A PostgreSQL FDW for reading one or more TSF files

• https://github.com/zilder/tuple_fdw

  Very simple proof of concept for the compressed binary file storage foreign data wrapper

• https://github.com/umitanuki/twitter_fdw ⭐️

• https://github.com/kentik/wdb_fdw

• https://github.com/cyga/www_fdw ⭐️⭐️

  fdw extension for postgres

• https://github.com/beargiles/zipfile-fdw

External Integrations & Messaging

• https://github.com/satya10x/advcopy ⭐️

  Postgres extension to copy to/from s3

• https://github.com/darold/datalink

  PostgreSQL extension for SQL/MED external file access also named Datalink in others RDBMS

• https://github.com/lacanoid/datalink

  SQL/MED DATALINK for PostgreSQL

• https://github.com/ossc-db/dblink_plus ⭐️

  Send query from PostgreSQL to other RDBMS like contrib/dblink

• https://github.com/xstevens/decoderbufs ⭐️⭐️

  INACTIVE: A PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers

  • https://github.com/Naros/postgres-decoderbufs

    A PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers, used by Debezium (http://debezium.io). Please log issues in our JIRA at https://issues.jboss.org/projects/DBZ/issues

• https://github.com/asotolongo/email

• https://github.com/darold/external_file

  Allow access to "external files" from PostgreSQL server file systems.

• https://github.com/okbob/generic-scheduler

  PostgreSQL generic SQL statements scheduler without additional dependencies (requires 9.5)

• https://github.com/durch/google-bigtable-postgres-extension

• https://github.com/nicklasaven/gunzip_pg

  A small tool to gunzip directly from db-content

• https://github.com/uphold/json-output

  JSON decoding output plugin

• https://github.com/posix4e/jsoncdc ⭐️

  JSONCDC is now maintained at,

  • https://github.com/instructure/jsoncdc ⭐️

    Takes a logical decoding stream from postgresql and outputs it in a pluggable and safe way

  • https://github.com/ponimas/jsoncdc

    Takes a logical decoding stream from postgresql and outputs it in a pluggable and safe way

• https://github.com/asotolongo/jx_io

  Extension to export and import json and xml from/to postgres

• https://github.com/arenadata/kafka-adb-os

• https://github.com/Jacob-Kroeze/pg-message-queue

  Automatically exported from code.google.com/p/pg-message-queue

• https://github.com/rodolfodpk/pg-message-queue

  Automatically exported from code.google.com/p/pg-message-queue

• https://github.com/rpdelaney/pg-message-queue ⭐️

  Fork of pg_message_queue by Chris Travers

• https://github.com/omniti-labs/pg_amqp ⭐️⭐️

  AMQP Support for Postgres

  • https://github.com/frankbv/pg_amqp

    AMQP Support for Postgres

• https://github.com/snaiffer/pg_compress

• https://github.com/citusdata/pg_cron ⭐️⭐️⭐️

  Run periodic jobs in PostgreSQL

• https://github.com/samber/pg_cron

  ⏰ PostgreSQL extension for running periodic jobs

• https://github.com/RekGRpth/pg_curl ⭐️

  PostgreSQL curl allows most curl actions, including data transfer with URL syntax via HTTP, HTTPS, FTP, FTPS, GOPHER, TFTP, SCP, SFTP, SMB, TELNET, DICT, LDAP, LDAPS, FILE, IMAP, SMTP, POP3, RTSP and ...

• https://github.com/adauhr/pg_frapi

  Une collection de fonctions pl/pgsql permettant d'appeler des API web de l'administration française. (Version alpha!)

• https://github.com/RekGRpth/pg_grpc

• https://github.com/RekGRpth/pg_htmldoc

  PostgreSQL implementation of HTMLDOC conversion software. It is a program that reads HTML and Markdown source files or web pages and generates corresponding EPUB, HTML, PostScript, or PDF files with a...

• https://github.com/michelmilezzi/pg_job_queue

  A PostgreSQL job queue manager

• https://github.com/slardiere/pg_jsonpatch

  Load JSON Patch as extension in PostgreSQL

• https://github.com/xstevens/pg_kafka ⭐️⭐️

  INACTIVE: A PostgreSQL extension to produce messages to Apache Kafka.

  • https://github.com/maparent/pg_kafka

    INACTIVE: A PostgreSQL extension to produce messages to Apache Kafka.

• https://github.com/alaisi/pg_kafka_events

  PostgreSQL extension for publishing data changes to Apache Kafka

• https://github.com/bishtgayatri/pg_logs_kafka

  A Postgres extension to send log messages to Apache Kafka.

• https://github.com/zilder/pg_lz4 ⭐️

  lz4 compression for PostgreSQL 12+ (dev)

• https://github.com/choplin/pg_msgpack

• https://github.com/RekGRpth/pg_mupdf

  postgres mupdf

• https://github.com/RekGRpth/pg_mustach

  PostgreSQL implementation of mustache templating

• https://github.com/brettlaforge/pg_redis_pubsub ⭐️

  Redis Publish from PostgreSQL

• https://github.com/edpratomo/pg_redispub

  postgres extension for sending PUBLISH to redis

• https://github.com/cybertec-postgresql/pg_remote_exec

  A PostgreSQL extension for "ssh-over-postgres"

• https://github.com/sshutdownow/pg_sendmail

  PostgreSQL extension that implements mail function in C that rely on sendmail binary

• https://github.com/ycui1984/pg_thrift

  Thrift support for postgreSQL

• https://github.com/le0pard/pg_web

  PostgreSQL extension which provide web interface for database

• https://github.com/RekGRpth/pg_wkhtmltopdf

  PostgreSQL implementation of Convert HTML to PDF using Webkit (QtWebKit).

• https://github.com/RekGRpth/pg_wthtmltopdf

  PostgreSQL HTML to PDF

• https://github.com/yonj1e/pgagent-c

  🐘 以 extension、bgworker进程方式实现pgAgent

• https://github.com/Tostino/pgAutomator-extension

  Postgres extension for database portion of pgAutomator

• https://github.com/johto/pgbrotli

  Brotli compression in PostgreSQL

• https://github.com/chet0xhenry/pgcompress

  Deflate and Gzip functions for Postgresql

• https://github.com/pandrewhk/pgcurl

  Call curl from PostgreSQL

• https://github.com/ohmu/pgmemcache ⭐️⭐️

  PostgreSQL memcache functions

• https://github.com/RekGRpth/pgqbw

  postgres queue backgound worker

• https://github.com/AbdulYadi/pgqr

  PostgreSQL extension to generate QR code

  • https://github.com/Fenoman/pgqr

    PostgreSQL extension to generate QR code

• https://github.com/scttnlsn/pgque

  PostgreSQL job queue extension using advisory locks

• https://github.com/AbdulYadi/pgreadfile

  A PostgreSQL extension to read binary file

• https://github.com/asotolongo/pgsmtp

• https://github.com/AbdulYadi/pgsocket ⭐️

  send bytes using PostgreSQL user defined function to TCP/IP socket

• https://github.com/csimsek/pgsql-fio ⭐️

  PostgreSQL File I/O Functions

• https://github.com/pramsey/pgsql-gzip ⭐️

  Gzip compress and decompress for PostgreSQL

• https://github.com/pramsey/pgsql-http ⭐️⭐️

  HTTP client for PostgreSQL, retrieve a web page from inside the database.

  • https://github.com/RekGRpth/pgsql-http

    HTTP client for PostgreSQL, retrieve a web page from inside the database.

• https://github.com/reignmaker/pgsql-http

  HTTP client for PostgreSQL, retrieve a web page from inside the database.

• https://github.com/chimpler/postgres-aws-s3 ⭐️

  aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)

• https://github.com/smartpricing/queen/tree/master/pg_qpubsub

  PostgreSQL extension wrapper for Queen MQ - a simplified Kafka-style API for pub/sub message queuing directly in PostgreSQL.

• https://github.com/liguangxian/timing

  PostgreSQL,Description: Scheduled Task Extension

Procedural Languages

• https://github.com/nextgres/oss-pgtsql

  T-SQL (Transact-SQL) Procedural Language for PostgreSQL from OpenSCG

• https://github.com/pgoracle/pgora-osql

  PostgreSQL Procedural Language with Oracle PLSQL Compatibility

• https://github.com/bigsql/pgtsql

  Transact-SQL Compatibility for PostgreSQL. Not just for Sybase & SQL Server anymore.

• https://github.com/EnterpriseDB/pldebugger ⭐️

  Procedural Language Debugger Plugin for PostgreSQL and EDB Postgres Advanced Server

  • https://github.com/RekGRpth/pldebugger

    Procedural Language Debugger Plugin for PostgreSQL and EDB Postgres Advanced Server

• https://github.com/Brick-Abode/pldotnet ⭐️

  PL/.NET a.k.a (pldotnet) adds Microsoft's .NET framework to PostgreSQL by introducing both the C# and F# as loadable procedural language.

• https://github.com/plv8/pljs ⭐️⭐️

  PLJS - Javascript Language Plugin for PostreSQL

• https://github.com/pljulia/pljulia ⭐️

• https://github.com/davecramer/pljvm

  JVM procedural language. Execute code in any JVM from PostgreSQL

• https://github.com/gyepisam/pllua

  Implementation of Lua as a loadable procedural language for PostgreSQL - updated to work with Postgresql 9.2

• https://github.com/mauzo/pllua

• https://github.com/mweber26/pllua

• https://github.com/pllua/pllua-deprecated ⭐️⭐️

  [DEPRECATED] This repository is no longer maintained. Please follow https://github.com/pllua/pllua

• https://github.com/eugwne/pllua_unstable

• https://github.com/okbob/plpgsql_check ⭐️⭐️

  plpgsql_check is linter tool for language PL/pgSQL (native language for PostgreSQL store procedures).

  • https://github.com/RekGRpth/plpgsql_check

    plpgsql_check is next generation of plpgsql_lint. It allows to check source code by explicit call plpgsql_check_function.

• https://github.com/pykello/plpythont

  Trusted plpython

• https://github.com/jconway/plr ⭐️

  PL/R - R Procedural Language for PostgreSQL

  • https://github.com/postgres-plr/plr ⭐️

    PL/R - R Procedural Language for PostgreSQL

• https://github.com/godfat/plruby

• https://github.com/petere/plsh ⭐️⭐️

  PL/sh is a procedural language handler for PostgreSQL that allows you to write stored procedures in a shell of your choice.

  • https://github.com/RekGRpth/plsh

    PL/sh is a procedural language handler for PostgreSQL that allows you to write stored procedures in a shell of your choice.

• https://github.com/drforr/plsix

  Perl 6 embedded in PostgreSQL

• https://github.com/salva/plswipl

  PL/SWI-Prolog - SWI-Prolog as a PostgreSQL Procedural Language

• https://github.com/plv8/plv8 ⭐️⭐️⭐️

  V8 Engine Javascript Procedural Language add-on for PostgreSQL

• https://github.com/Geodan/plv8_geo ⭐️

  PLV8 functions for geospatial data

• https://github.com/petere/plxslt ⭐️

  XSLT procedural language for PostgreSQL

Spatial and Geographic Objects

• https://github.com/karpov-sv/astrocat

  Testbed PostgreSQL extension for experimenting on indexing astronomical catalogues

• https://github.com/2ndquadrant-it/brin4postgis

  A PostgreSQL extension to add BRIN indexing for PostGIS geometries

• https://github.com/nmandery/dumppoints

  Clone of https://pd.if.org/git/dumppoints

• https://github.com/accarniel/FESTIval

  FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices

• https://github.com/mnelemans/gbuilder

  Geometry builders for PostgreSQL

• https://github.com/mnelemans/geohash-extra

  Additional functionality for geohashing with PostGIS

• https://github.com/GeoHistoricalData/geohistorical_objects

  A postgres extension for simple, efficient, clean, future proof handling of geographical & historical objects

• https://github.com/tvondra/geoip ⭐️

  an extension for GeoIP geolocation

• https://github.com/bytesandbrains/h3-pg ⭐️

  PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system

• https://github.com/GeoHistoricalData/historical_geocoding

  Using geohistorical objects, this postgres extensions adds geocoding and localisation for historical data

• https://github.com/gojuno/lostgis ⭐️

• https://github.com/matlads/mapcode-postgres

  postgresql extension for mapcodes

• https://github.com/giggls/mapnik-german-l10n ⭐️

  OSM map l10n functions

• https://github.com/MobilityDB/MobilityDB ⭐️⭐️

  MobilityDB is a geospatial trajectory data management & analysis platform, built on PostgreSQL and PostGIS.

• https://github.com/adjust/pg-geoip2lookup

  A PL/Perl based extension for PostgreSQL for lookup in data in geoip2 dos for PostgreSQL

• https://github.com/ahmetkucuk/pg-trajectory

  PostgreSQL/PostGIS extension for spatiotemporal data

• https://github.com/segasai/pg_coordconvert

  Equatorial/Galactic coordinates conversion for Postgresql

• https://github.com/jistok/pg_geohash ⭐️

  Geohashing library for HAWQ, Greenplum DB, PostgreSQL

• https://github.com/siose-innova/pg_geohash_extra

• https://github.com/ttfkam/pg_geoip

  PostgreSQL extension for geolocation using MaxMind geoip files

• https://github.com/segasai/pg_healpix

  Healpix functions for PostgreSQL

• https://github.com/siose-innova/pg_landmetrics

  A Postgres/PostGIS extension for landscape metrics calculations.

• https://github.com/TilelessMap/pg_tileless

  Tools for packing tileless maps

• https://github.com/jkeifer/pg_tms

  Tile Map Service tiling in postgis. So cool.

• https://github.com/nicklasaven/pg_twkb

  Some additional twkb tools not in PostGIS

• https://github.com/dlr-eoc/pgh3 ⭐️

  PostgreSQL extension for the H3 hierarchical geospatial indexing system

• https://github.com/pgRouting/pgrouting ⭐️⭐️

  Repository contains pgRouting library. Development branch is "develop", stable branch is "master"

• https://github.com/openvenues/pgsql-postal

  PostgreSQL binding for libpostal

• https://github.com/pramsey/pgsql-postal ⭐️⭐️

  PostgreSQL binding for libpostal

• https://github.com/pgpointcloud/pointcloud ⭐️⭐️

  A PostgreSQL extension for storing point cloud (LIDAR) data.

• https://postgis.net/ ⭐️⭐️⭐️

  PostGIS spatial database extension to PostgreSQL

• https://github.com/cahutton/postgis_domains

  A PostgreSQL extension defining custom PostGIS domains

• https://github.com/robe2/postgis_letters

  Extension to allow converting letters to PostGIS geometries

• https://github.com/segasai/q3c ⭐️

  PostgreSQL extension for spatial indexing on a sphere

• https://github.com/hexiaoting/rasterdb

• https://github.com/rtosm/rtosm

  A Postgresql database extension to provide the functionality of real-time simplification of spatial objects in Openstreetmap API Database.

• https://github.com/AfieldTrails/s2-postgis ⭐️

  S2 Cell Id functions for PostgreSQL and PostGIS

• https://github.com/evetion/trianglearray

  Triangle Array data structure for storing TINs in PostgreSQL.

• https://github.com/accarniel/VagueGeometry

  The VagueGeometry is a PostgreSQL extension for handling vague spatial data based on the VASA (Vague Spatial Algebra).

• https://github.com/pgRouting/vrprouting

  Vehicle Routing Problems on the Database

• https://github.com/bmuratshin/zcurve ⭐️

  Spatial index based on Z&Hilbert curves realized as pgsql extension.

Uncategorized

• https://github.com/michelleliza/1nf-stppattern-psql-extension

• https://github.com/apache/age ⭐️⭐️⭐️

  Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.

• https://github.com/bitnine-oss/AgensGraph-Extension ⭐️⭐️

  A graph database extension for PostgreSQL

  • https://github.com/mintduck/AgensGraph-Extension

    A graph database extension for PostgreSQL

• https://github.com/petergeoghegan/amcheck ⭐️

  contrib/amcheck from Postgres v11 backported to earlier Postgres versions

• https://github.com/main--/append_only_heap

  PostgreSQL table access method that avoids fragmentation of variable-length append-only data

• https://github.com/ArturFormella/async_response

  PostgreSQL - Multiple asynchronous responses in one query

• https://github.com/XiaYingyin/atree

  atree extension for postgresql

• https://github.com/petere/autopex

  PostgreSQL extension installation magic

• https://github.com/JLockerman/bench_pg_unwind

  determine how expensive it is to catch postgres exceptions in rust

• https://github.com/sany1231/binvec

• https://github.com/davidfetter/blackhole_hook

  A baseline for PostgreSQL hooks

• https://github.com/postgrespro/bztree

• https://github.com/chobostar/calculate_markup

  example of PostgreSQL extension with function for linear interpolation

• https://github.com/macdice/calendars

  Example of how to start an extension

• https://github.com/johto/call_graph

  A PostgreSQL extension for automatically creating function call graphs

  • https://github.com/klando/call_graph

    A PostgreSQL extension for automatically creating function call graphs

• https://github.com/CartoDB/cartodb-postgresql ⭐️⭐️

  PostgreSQL extension for CartoDB

• https://github.com/yanliu8/cbtree

• https://github.com/rafatower/cdb_extension_fw

  An experimental framework for pg extensions

• https://github.com/yvazquezo/check_orapg

  Extension for validate objects migration from Oracle to PostgreSQL

• https://github.com/nate1001/chess_index

  PostgresSQL extension for storing games and chess positions

• https://github.com/ozturkosu/cms_topn

  PostgreSQL extension to use count-min sketch top-n algorithm.

  • https://github.com/oudalab/mms

    PostgreSQL extension to use count-min sketch top-n algorithm.

• https://github.com/remzicanaksoy/cms_topn

• https://github.com/ibarwick/conninfo

  A PostgreSQL extentsion providing utility functions for working with conninfo strings

• https://github.com/katrinaibast/constr_name_unif

• https://github.com/postgres-ci/core

  PL/pgSQL backend

• https://github.com/credativ/db2fce

  DB2 compatibility environment for PostgreSQL

• https://github.com/cybertec-postgresql/db_migrator ⭐️

• https://github.com/okbob/dbms_sql

  PostgreSQL extension that provides a API of Oracle's package dbms_sql

• https://github.com/asotolongo/ddla

• https://github.com/MasahikoSawada/debug_funcs

• https://github.com/vibhorkum/edb_block_commands

• https://github.com/vibhorkum/edb_pgpool_adm

  pgpool_adm for EDB Postgres Advanced Server

• https://github.com/vibhorkum/efm_extension

  EFM extension for EPAS

• https://github.com/tvondra/empty

  empty postgresql extension

• https://github.com/spd010273/event_manager

  Cloned from Bitbucket repo

• https://github.com/ibarwick/extension_template

  A set of template files from which to create a PostgreSQL extension

• https://gitlab.com/ongresinc/extensions/center

• https://gitlab.com/ongresinc/extensions/mv_stats

• https://gitlab.com/ongresinc/extensions/noset

• https://github.com/ehfeng/faker

• https://github.com/celian-garcia/firefly-database

  PostgreSQL extension to simplify the installation of Firefly database

• https://github.com/komamitsu/foreign_table_exposer ⭐️

  Expose foreign tables as a regular table. This is useful when using some BI tools that don't support foreign tables.

• https://github.com/melanieplageman/format

  PostgreSQL extension for string interpolation allowing named format parameters

• https://github.com/melanieplageman/format_x

  A polymorphic, variadic string formatting function which supports key-based lookups for composite parameters.

  • https://github.com/cybertec-postgresql/format_x

    A polymorphic, variadic string formatting function which supports key-based lookups for composite parameters.

• https://github.com/rongfengliang/fpm-pg-extension-package-generate-demo

  fpm-pg-extension-package-generate-demo

• https://github.com/huseynsnmz/gbdchecks

  PostgreSQL için kullanılabilecek olan yararlı fonksiyonların bulunduğu bir eklenti

• https://github.com/idrawone/get_sum

• https://github.com/fsalc/gprom-pgsql

• https://github.com/timbira/hba_sql

  LiveCoding: Manipulando seu pg_hba.conf com SQL

• https://github.com/vadv/hide_statements_in_log

  Hide statements in PostgreSQL log

• https://github.com/Hermanverschooten/hv_date_functions

• https://github.com/apache/incubator-age ⭐️⭐️

  Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.

• https://github.com/theirix/json_accessors

  PostgreSQL JSON accessors

• https://github.com/pgexperts/json_build ⭐️

  Functions to help build JSON objects in PostgreSQL

• https://github.com/koctep/jsonb-extend

  PostgreSQL jsonb_extend function

  • https://github.com/pavel-xa/jsonb-extend

    PostgreSQL jsonb_extend function

• https://github.com/glynastill/jsonb_delete

  Hstore style delete - operator for jsonb in PostgreSQL

• https://github.com/mhagander/jsonb_delete_array

  Quick hack for implementing a jsonb_delete operator for arrays

• https://github.com/erthalion/jsonb_explorer

• https://github.com/niquola/jsonb_extra

  postgresql jsonb extra functions

• https://github.com/postgrespro/jsonb_schema

  Store jsonb schema separately from data

• https://github.com/adunstan/jsonb_set_lax

  extension to backport jsonb_set_lax

• https://github.com/erthalion/jsonbx ⭐️

  jsonbx extension for PostgreSQL 9.4

• https://bitbucket.org/adunstan/jsoncmp

  Comparison ops for JSON

• https://github.com/everilae/jsonfun

  Additional JSON functions PostgreSQL extension

• https://github.com/niquola/jsonknife ⭐️

  useful functions for jsonb in postgresql

• https://github.com/nuko-yokohama/ksj

• https://github.com/knaw-huc/lenticular-lens-postgresql

  PostgreSQL extension for Lenticular Lens

• https://github.com/niquola/lispg

• https://github.com/b4oshany/livewire

  Livewire: Power delivery modelling in postgresql

• https://github.com/postgrespro/lsm ⭐️

  RocksDB FDW for PostgreSQL

• https://github.com/postgrespro/lsm3 ⭐️

  LSM tree implementation based on standard B-Tree

• https://github.com/topretejal/lsm_idx

  Implementing LSM Index in PostGreSQL using Extension

• https://github.com/NikitOS94/MDBQT

• https://github.com/plotts/median

  PostgreSQL median function

• https://github.com/sgichohi/median

  Postgres median extension

• https://github.com/cybertec-postgresql/merge_ips

• https://github.com/aquametalabs/meta_triggers

  PostgreSQL Extension: Insert, update and delete triggers that make the meta extension writable

• https://github.com/NikitOS94/MonQ

  MonQ - postgreSQL extension for MongoDB query support

• https://github.com/asotolongo/msmov

• https://github.com/zhongjn/mtree

  A metric-space index for PostgreSQL base on GiST (still in progress)

• https://github.com/AndrewFribush/Multicorn

  A small multicorn implementation with C/python for postgresql

• https://github.com/Segfault-Inc/Multicorn ⭐️⭐️

  Data Access Library

  • https://github.com/splitgraph/Multicorn

    Data Access Library

• https://github.com/NaughtyDogOfSchrodinger/multicorn

• https://github.com/olshevskiy87/multicorn

• https://github.com/evetion/multistar

  Postgres C extension for multistars

• https://github.com/kornelski/mysqlcompat ⭐️

  A reimplemenation of as many MySQL functions as possible in PostgreSQL, as an aid to porting

• https://github.com/Chessbrain/NORM

  Removing ORM one function at a time

• https://github.com/ergo70/nseq

• https://github.com/rongfengliang/nvl-pg-extension

  nvl-pg-extension

• https://github.com/omnigres/omnigres ⭐️⭐️⭐️

  The All-in-One Database — a collection of PostgreSQL extensions

• https://github.com/cybertec-postgresql/ora_migrator ⭐️

  Tools for Oracle to PostgreSQL migration

• https://github.com/orafce/orafce ⭐️⭐️

  The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is use...

• https://github.com/asio/otp

  • https://github.com/zitsen/otp

• https://github.com/posix4e/petstore-jsoncdc

• https://github.com/NCarson/pg-chessboard

  PostgresSQL extension for storing chess positions

• https://bitbucket.org/adunstan/pg-closed-ranges

  Closed forms of discrete builtin ranges

• https://github.com/bjeanes/pg-dataclips

  A (very much) WIP PostgreSQL extension for fetching dataclips (https://dataclips.heroku.com) for further querying

• https://github.com/scottjustin5000/pg-gcd

  pg extesnion for gcd

• https://github.com/claesjac/pg-json

  JSON stuff for postgresql

• https://github.com/choplin/pg-jsonpath

• https://github.com/dalbani/pg-modeshape-bson

  PostgreSQL extension to convert ModeShape BSON to/from JSON

• https://github.com/wulczer/pg-progress

  Query progress estimation for PostgreSQL

• https://github.com/trlorenz/PG-recursively_delete ⭐️

  PL/pgSQL recursive deletion

• https://github.com/mgit-at/pg-semver-debian

  Debian Package for postgresql semver extension

• https://github.com/gciolli/pg2podg

  A PostgreSQL extension for two-player open deterministic games

• https://github.com/akorotkov/pg_aa

  Sample PostgreSQL extension: work with ASCII-art libraries

• https://github.com/abris-platform/pg_abris

• https://github.com/mikeizbicki/pg_agg

• https://github.com/kostiantyn-nemchenko/pg_algorithms

  Popular algorithms implementation on PostgreSQL side

• https://github.com/RekGRpth/pg_async

  postgres async listen/notify on replica (hot standby)

• https://github.com/adunstan/pg_b64enc_rust

• https://github.com/vibhorkum/pg_background ⭐️

  pg_background

• https://github.com/postgrespro/pg_backtrace ⭐️

  Show backtrace for errors and signals

• https://github.com/cosmic-jc/pg_block_join

  The second project for database course: similarity join and nested block join.

• https://github.com/rdunklau/pg_bofh

• https://github.com/nmandery/pg_byteamagic

  PostgreSQL extension to determinate the filetypes of bytea BLOBs

• https://github.com/ozum/pg_cache_tree

  PostgreSQL trigger to cache recursive parents and children of a record in an array field.

• https://github.com/itarient/pg_calcpi

  The Computation of digits of PI number in the PostgreSQL

• https://github.com/aquametalabs/pg_catalog_get_defs

  PostgreSQL Extension providing the not-yet-implemented pg_catalog.get_*def functions

• https://github.com/MasahikoSawada/pg_cgroup

  A PostgreSQL extension to manage cgroup (Control Group)

• https://github.com/cybertec-postgresql/pg_crash ⭐️

  "Chaos Monkey" Extension for PostgreSQL databases

• https://github.com/s-hironobu/pg_crash

  pg_crash provides a function to crash the PostgreSQL server.

• https://github.com/davidcrawford/pg_crasher

  PostgreSQL extension which crashes the backend. For testing client error handling.

• https://github.com/dsarafan/pg_dirty_hands

  PostgreSQL extension with dirty hacks

  • https://github.com/x4m/pg_dirty_hands

    PostgreSQL extension with dirty hacks

• https://github.com/abris-platform/pg_dms

• https://github.com/keithf4/pg_doc_store ⭐️

• https://github.com/robconery/pg_docs_api ⭐️

  A simple abstraction for working with PostgreSQL as a Document Database

• https://github.com/gerdansantos/pg_elephant

  Elephants never forget

• https://github.com/ergo70/pg_etag

  Fast ETag generation for rows and result sets with BLAKE2 hashes.

• https://github.com/enova/pg_fact_loader

  Build fact tables asynchronously with Postgres

• https://github.com/MasaoFujii/pg_fallback_utf8_to_euc_jp

  Yet another encoding conversion from UTF-8 to EUC_JP

• https://github.com/jasonmp85/pg_fiu

  Fault injection in userspace as a PostgreSQL extension

• https://github.com/MasahikoSawada/pg_foobar

  foo bar parallel programing on PostgreSQL

• https://github.com/ttfkam/pg_geekspeak

  The GeekSpeak podcast database schema

• https://github.com/ttfkam/pg_geekspeak_calendar

  iCal integration for Geek Speak episodes

• https://github.com/magnusp/pg_hello

  Postgres "Hello world" extension

• https://github.com/mrnugget/pg_hello_world

  pg_hello_world - A small example extension for PostgreSQL, written in C

• https://github.com/segasai/pg_hist

  Fast uni-variate and multivariate histograms in PostgreSQL

• https://github.com/eugwne/pg_hook_lj

  PostgreSQL hooks with LuaJIT FFI

• https://github.com/pasha132/pg_idm

• https://github.com/dbaston/pg_implicit_schema

  Make Postgres implicity create schemas

• https://github.com/eulerto/pg_inet_addr

  PostgreSQL function that lists interface addresses

• https://github.com/citusdata/pg_intpair

• https://github.com/omniti-labs/pg_jobmon ⭐️⭐️

  PostgreSQL extension which provides persistent logging within transactions and functions.

• https://github.com/dgillis/pg_json_query

  Use JSON objects to generate PostgreSQL WHERE clause expressions.

• https://github.com/asotolongo/pg_json_utils

• https://github.com/glynastill/pg_jsonb_opx

  Hstore style delete and concatenate C functions and operators for jsonb in PostgreSQL 9.4

• https://github.com/kmblack1/pg_kmcb

  PostgreSQL 插件pg_kmcb

• https://github.com/RhodiumToad/pg_lextest

  tiny module for lexer benchmarking

• https://github.com/funbringer/pg_linegazer

  Transparent code coverage for PL/pgSQL

• https://github.com/adjust/pg_lock_pool

  A postgres Extension to wait on a lock pool

• https://github.com/semenikhind/pg_map

  Python-like map for PostgreSQL

• https://github.com/kalman5/pg_median

• https://github.com/greenape/pg_median_utils

  Median utility functions for postgres

• https://github.com/aquameta/pg_meta ⭐️

  PostgreSQL Extension: More friendly system catalog for PostgreSQL

• https://github.com/theory/pg_meta

• https://github.com/lithp/pg_micromanage

  Boss postgres around, tell it exactly what to do

• https://github.com/moritetu/pg_mod_sample

  Template for postgresql extension

• https://github.com/ttfkam/pg_newsfeeds

  PostgreSQL extension for gathering news

• https://github.com/roa/pg_nice

• https://github.com/postgrespro/pg_oltp_bench ⭐️

  Extension and scripts to run analogue of sysbench OLTP test using pgbench

  • https://github.com/jad21/pg_oltp_bench

    test pgbench

• https://github.com/PostgreSQL-Migration-Toolkit/pg_oracle

  PostgreSQL Extension to provide Oracle compatible functions.

• https://github.com/meistervonperf/pg_outrider

  A background worker for PostgreSQL that automatically extend the relation specified by the invocation parameter

• https://github.com/KLIEBHAN/pg_plsql_graphs

  PostgreSQL contrib extension for creating flow and dependence graphs for plpgsql functions in dot format

• https://github.com/torrespri/pg_popyramids_datamarts

  A PostgreSQL extension for creating a data marts schema in a popyramids database

• https://github.com/meiyifei/pg_random_string

  生成随机字符串

• https://github.com/nuko-yokohama/pg_reversi

  Reversi game on PostgreSQL

• https://github.com/CartoDB/pg_schema_triggers ⭐️

  PostgreSQL 9.3+ Schema Triggers extension

• https://github.com/MasahikoSawada/pg_simula ⭐️

  A database system failure simulation tool for PostgreSQL

• https://github.com/labgeo/pg_siose_bench

• https://github.com/siose-innova/pg_siose_bench

  A PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc))

• https://github.com/quentusrex/pg_sip

  PostgreSQL extension for SIP processing using libre

• https://github.com/samber/pg_sleep

  Adding 2 Postgresql functions: pg_sleep(seconds) and pg_usleep(microseconds)

• https://github.com/pindlebot/pg_slugify

• https://github.com/maahl/pg_spi_examples

  A PostgreSQL extension containing various examples of PostgreSQL SPI usage

• https://github.com/jmckulk/pg_string_extension

• https://github.com/magnusp/pg_ta

  (Partial) Wrapper of TA-Lib as a postgres extension

• https://github.com/laorunsen/pg_test

• https://github.com/BlueTreble/pg_thud

  Framework to extend and enhance pgtap for db unit tests

• https://github.com/rjuju/pg_timelord

• https://github.com/pierreforstmann/pg_timeout

  PostgreSQL extension to manage idle session timeout

• https://github.com/x4m/pg_tm_aux ⭐️

  Transfer manager auxiliary functions

• https://github.com/zilder/pg_udp

• https://github.com/shurizzle/pg_variables

• https://github.com/rlichtenwalter/pg_variant_functions

  efficient functions for variant analyses over TINYINT[] genotype representations

• https://github.com/dgillis/pg_vartype

• https://github.com/schmidni/pg_weighted_statistics

  Weighted statistics for PostgreSQL

• https://github.com/ildus/pg_zstd

• https://github.com/redraiment/pgaut

  a PostgreSQL extension which implements MySQL on update current_timestamp

• https://github.com/davidfetter/pgbouncer_wrapper ⭐️

  SQL wrapper around pgbouncer's console

• https://github.com/kingluo/pgcat-pgxs

  pgcat PostgreSQL extension

• https://github.com/AbdulYadi/pgcodec7

  Encode byte array into ascii character by 7 bits grouping which is less bytes than hexadecimal 4-bits-encoding.

• https://github.com/rustprooflabs/pgdd ⭐️

  PostgreSQL Data Dictionary

• https://github.com/lacanoid/pgddl ⭐️

  DDL eXtractor functions for PostgreSQL (ddlx)

• https://github.com/tlb-lab/pgeigen

  https://a-r-j@bitbucket.org/blundell/pgeigen

• https://github.com/tsv2013/pgext

  Test postgres extension

• https://github.com/ycku/pgeyes

  Postgres天眼通

• https://github.com/michelp/pgfsm ⭐️

  Simple SQL finite state machine for Postgres

  • https://github.com/dejan-stankovic/sqlfsm

    Simple SQL finite state machine for Postgres

• https://github.com/zxdvd/pghelper

• https://github.com/baverman/pghll

  PostgreSql extension compatible with HyperLogLog implementation from java stream-lib

• https://github.com/troels/pghooks

  Small example of pghooks

• https://github.com/liang7878/pgintegrity

  pgintegrity

• https://github.com/F28956/pgmigrations

  Postgres Database Migrations

• https://github.com/avito-tech/pgmock

  PostgreSQL 9.4+ extension for unit tests

• https://github.com/pgoracle/pgora-builtin

  Oracle Compatibility: Built in Functions

• https://github.com/dvarrazzo/pgparts

  PostgreSQL extension to manage partitions

• https://github.com/dalibo/pgpool_adm

  A PostgreSQL extension to control pgpool using its pcp protocol

• https://github.com/wttw/pgpsl

  Public Suffix List support for PostgreSQL

• https://github.com/asotolongo/pgrgraphic

• https://github.com/mikeizbicki/pgrollup

  easy creation of rollup tables in postgresql (compute count(*) queries in constant time)

• https://github.com/lacanoid/pgsparql

  SPARQL compiler functions for PostgreSQL

• https://github.com/maternity/pgsql_rrule

  RRULE expansion in SQL

• https://github.com/AbdulYadi/pgstrtranslate

  PostgreSQL Extension for String Translation

• https://github.com/jconway/pgsynck

  Run SQL text through the PostgreSQL parser and return syntax error information for each contained statement.

• https://github.com/theory/pgtap ⭐️⭐️

  PostgreSQL Unit Testing Suite

• https://github.com/gavioto/pgtsql

  pgtsql clone https://bitbucket.org/openscg/pgtsql

• https://github.com/darold/pgtt ⭐️

  PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables and the others RDBMS

• https://github.com/darold/pgtt-rsl

  pgtt is a PostgreSQL extension to create and manage Oracle-style Global Temporary Tables based on Row Security Level

• https://github.com/petere/pgvihash

  version-independent hash functions for PostgreSQL

• https://github.com/lacanoid/pgwiki

  Wiki for PostgreSQL

• https://github.com/ycku/pgxn_hello_world

  PostgreSQL extension of Hello World

• https://github.com/johto/pgxsd

  PostgreSQL XSD validation -- work very much in progress

• https://github.com/davidbeauchamp/pgzint

  PostgreSQL extension for the Zint Barcode library

• https://github.com/a5221985/PhaseZero_Scripts

• https://github.com/pjungwir/pjpg

  General-purpose Postgres utilities

• https://github.com/greenplum-db/plcontainer ⭐️

  PL/Container - GPDB execution sandboxing for Python and R

• https://github.com/andywicht/pldebugger

• https://github.com/soycacan/pldebugger

• https://github.com/bigsql/pldebugger2

• https://github.com/rongfengliang/plgo-rpm

  plgo-rpm

• https://github.com/beargiles/pljava-udt-type-extension

  PL/Java example of user-defined types.

• https://github.com/niquola/pljq

  jq extension fo pg

• https://github.com/JerrySievert/pljs

  quick proof of concept

• https://github.com/choplin/plmruby

• https://github.com/no0p/plotpg

  Plotting postgresql result sets

• https://github.com/OmniDB/plpgsql_debugger

  PostgreSQL extension for enabling PL/pgSQL debugger in OmniDB

• https://github.com/93Alliance/plproxy

  修复plproxy错误仓库

• https://github.com/ksedgwic/plproxy

  Fork of plproxy to add dtrace

• https://github.com/nad2000/plproxy

  fork of git://git.postgresql.org/git/plproxy.git

• https://github.com/plproxy/plproxy ⭐️⭐️

  PL/Proxy development

• https://github.com/singular-labs/plproxy

  Fork of official plproxy repository with Apsalar modifications.

• https://github.com/greenplum-db/plr

  plr

• https://github.com/credativ/plsh-mtb

  PostgreSQL multi-tenant backup based on PL/SH and Korn Shell

• https://github.com/okbob/pltoolbox

  set of functions for usage from PostgreSQL stored procedures

• https://github.com/javisantana/pmpp

  PMPP for PostgreSQL

  • https://github.com/coreyhuinker/pmpp

    PMPP for PostgreSQL

  • https://github.com/razielleizar/pmpp

    PMPP for PostgreSQL

• https://github.com/cristianprice/polycrack

  Postgres data wrapper attempt.

• https://github.com/no0p/postbis

  A copy of postbis

• https://gitlab.com/postgres-ai/postgres-checkup

  Automated PostgreSQL health checks

• https://github.com/JoanneBogart/postgres-cmath

  Adapted from version written by Sogo Mineo for HSC for use with LSST DC2 data

• https://github.com/LSSTDESC/postgres-cmath

  PostgreSQL extension making c math library available. Identical to HSC version

• https://github.com/dreamsxin/postgres-function

• https://github.com/mspiegel/postgres-playground

• https://github.com/riyazwalikar/postgres-runcmd-extension

• https://github.com/NaokiNakamichi/postgres_extension

• https://github.com/patmandu/postgresmedian

• https://github.com/juaristi/postgresql-median

• https://github.com/drewc/postgresql-migrations

  A Postgresql Extension for Database Migrations

• https://github.com/overplumbum/postgresql-zlib

  • https://github.com/Lemaf/postgresql-zlib

• https://github.com/pavilkau/postgresql_anatomy

• https://github.com/postgresqlf/PostgreSQL_f ⭐️

  Interrogation de PostgreSQL par des requêtes prenant compte de conditions fondées sur les ensembles flous

• https://github.com/dimitri/preprepare ⭐️

  PostgreSQL prepare statements made pooling friendly

• https://github.com/kiranekbote/projectsrepo

• https://github.com/osnatairy/provSQL

  provSQL by Pierre Senellart

• https://github.com/PierreSenellart/provsql ⭐️

  Adding support for provenance and uncertainty management to PostgreSQL databases

• https://github.com/MasahikoSawada/pscan

  Test tool for parallel heap scan of PostgreSQL

• https://github.com/rektide/putpostlogic

• https://github.com/ehfeng/random

• https://github.com/tvondra/random

  random data generator extension

• https://github.com/tvondra/randomstring

• https://github.com/fkfk000/redis_link

  PostgreSQL's FDW to redis

• https://bitbucket.org/adunstan/redis_wrapper

  A thin layer over the Redis API

• https://github.com/heisice/redis_wrapper

• https://github.com/okbob/replace_empty_string

  PostgreSQL generic C trigger used for replace empty strings by NULLs

• https://bitbucket.org/adunstan/row_to_csv

  Generate a CSV line from a row

• https://github.com/ryapric/rpg

  PostgreSQL extension to add data manipulation functions such as what's available in the R language

• https://github.com/durch/rpg_base36

  Toy extension demonstrating PostgreSQL extensions in Rust

• https://github.com/mohangk/sample_pg_extension

• https://github.com/tvondra/scrub

• https://github.com/fabriziomello/session_variables

  PostgreSQL Functions to manipulate session variables

• https://github.com/sdsmart/shifting-bloom-filter

  PostgreSQL implementation of the Shifting Bloom Filter Framework described in http://www.vldb.org/pvldb/vol9/p408-yang.pdf

• https://github.com/zombodb/srf

  an example of writing an SRF in C for Postgres

• https://github.com/burggraf/SupaScript ⭐️

• https://github.com/ArturFormella/tcn_json

  Modified version of Postgresql tcn extension

• https://github.com/tvondra/tdigest ⭐️

  PostgreSQL extension for estimating percentiles using t-digest

• https://github.com/rambos22/test

• https://github.com/x4m/test_pglz

• https://github.com/trimark-jp/tm-postgres-basics

  postgres basic functions

• https://github.com/trimark-jp/tm-updated-date

  PostgreSQL extension for updated date

• https://github.com/alexeyklyukin/translate_isbn

  PostgreSQL extension that reimplements translate_isbn1013 function from the Evergreen ILS software in C.

• https://github.com/BrandwatchLtd/trunkfingerprint

  this thing calculates a fingerprint of DB structure

• https://github.com/postgrespro/undam ⭐️

  Undo storage implementation

• https://github.com/truthly/uniphant

  🦄🐘 PostgreSQL-centric Full Stack demo project

• https://github.com/pgexperts/unnest_ordinality

• https://github.com/blueskylxb/utinyint

• https://github.com/asotolongo/vacuum_utils

• https://github.com/darthunix/x5fix

• https://github.com/yeti-switch/yeti-pg-ext

  YETI extension for PostgreSQL