🗺🐘 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.

• Uncategorized
• Access Methods
• Aggregate Functions
• Data Types
• Dictionaries
• Foreign Data Wrappers
• Procedural Languages
• Spatial and Geographic Objects

Uncategorized

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

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

• 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/chanukyasds/pg_math ⭐️

  pg_math extension to support statistical distribution functions for PostgreSQL

• https://github.com/michelleliza/1nf-stppattern-psql-extension

• 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/accarniel/FESTIval

  FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices

• https://github.com/NikitOS94/MDBQT

• https://github.com/NikitOS94/MonQ

  MonQ - postgreSQL extension for MongoDB query support

• 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/Chessbrain/NORM

  Removing ORM one function at a time

• https://github.com/trlorenz/PG-recursively_delete ⭐️

  PL/pgSQL recursive deletion

• https://github.com/a5221985/PhaseZero_Scripts

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

  PostgreSQL IBAN extension that can verify International Bank Account Numbers

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

  Temporal extensions for PostgreSQL

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

    Temporal extensions for PostgreSQL

• 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/WinteryFox/PostgresSnowflake

• https://github.com/burggraf/SupaScript ⭐️

• 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/arkhipov/acl ⭐️

  Access Control Lists (ACL) PostgreSQL Extension

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

    Access Control Lists (ACL) PostgreSQL Extension

• https://github.com/satya10x/advcopy ⭐️

  Postgres extension to copy to/from s3

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

  Advanced Generalized Search - GiST as extension

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

  triple bool for postgres

• 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/petergeoghegan/amcheck ⭐️

  contrib/amcheck from Postgres v11 backported to earlier Postgres versions

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

  Remove Self Joins extension for PostgreSQL

• https://github.com/main--/append_only_heap

  PostgreSQL table access method that avoids fragmentation of variable-length append-only data

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

  Adaptive query optimization for PostgreSQL

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

  array_textsort PostgreSQL extension

• https://github.com/karpov-sv/astrocat

  Testbed PostgreSQL extension for experimenting on indexing astronomical catalogues

• 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/2ndQuadrant/audit-trigger ⭐️⭐️

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

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

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

  PostgreSQL extension installation magic

• 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/JLockerman/bench_pg_unwind

  determine how expensive it is to catch postgres exceptions in rust

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

  Background worker for monitoring PostgreSQL

• https://github.com/sany1231/binvec

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

  A baseline for PostgreSQL hooks

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

  Control replication process on postgresql interactive terminal.

• 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://gitlab.com/ongresinc/extensions/center

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

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

  Functions to check various identification numbers

• 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/cloud-sn2/cigration ⭐️

  Citus shard migration tool

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

  Distributed PostgreSQL as an extension

• 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/theory/colnames

  Lists the column names in a PostgreSQL RECORD value

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

  Complex numbers for PostgreSQL

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

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

• 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/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/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/XiaYingyin/ctidscan

  A Demo of PostgreSQL Custom Scan Provider API

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

  Example module of custom-scan interface

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

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

• 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/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/credativ/db2fce

  DB2 compatibility environment for PostgreSQL

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

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

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

  Send query from PostgreSQL to other RDBMS like contrib/dblink

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

  PostgreSQL extension that provides a API of Oracle's package dbms_sql

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

  DB Statistics Collector for PostgreSQL

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

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

• 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/liaorc/devel-master

  pg-cuda

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

  PostgreSQL disk quota extension

• 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/nmandery/dumppoints

  Clone of https://pd.if.org/git/dumppoints

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

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

  Repository for EDB Partition key Management

• 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/asotolongo/email

• 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/tvondra/empty

  empty postgresql extension

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

  Cloned from Bitbucket repo

• 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/ibarwick/extension_template

  A set of template files from which to create a PostgreSQL extension

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

  Allow access to "external files" from PostgreSQL server file systems.

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

  Extra Window Functions for PostgreSQL

• https://github.com/ehfeng/faker

• 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/ibarwick/filenode_map_inspect

  PostgreSQL extension to inspect pg_filenode.map files

• https://github.com/celian-garcia/firefly-database

  PostgreSQL extension to simplify the installation of Firefly database

• 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/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/liminghu/fuzzystrmatch

  add Damerau-Levenshtein algorithm to fuzzystrmatch in PostgreSql

• https://github.com/huseynsnmz/gbdchecks

  PostgreSQL için kullanılabilecek olan yararlı fonksiyonların bulunduğu bir eklenti

• https://github.com/mnelemans/gbuilder

  Geometry builders for PostgreSQL

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

• https://github.com/okbob/generic-scheduler

  PostgreSQL generic SQL statements scheduler without additional dependencies (requires 9.5)

• 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/parkag/geqo

  Genetic Query Optimizer isolated from PostgreSQL

• https://github.com/idrawone/get_sum

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

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

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

  PostgreSQL High Performance Distributed Database Plugin

• https://github.com/durch/google-bigtable-postgres-extension

• 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/fsalc/gprom-pgsql

• https://github.com/nicklasaven/gunzip_pg

  A small tool to gunzip directly from db-content

• https://github.com/bytesandbrains/h3-pg ⭐️

  PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system

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

  Hamming distance extension for Postgres.

• 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/IrNesterova/hierarchicalClusteringForDiploma

• https://github.com/GeoHistoricalData/historical_geocoding

  Using geohistorical objects, this postgres extensions adds geocoding and localisation for historical data

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

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

• https://github.com/Hermanverschooten/hv_date_functions

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

  Hypothetical Indexes for PostgreSQL

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

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

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

  In-Memory Columnar Store extension for PostgreSQL

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

  Similar images search for PostgreSQL

• 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/tvondra/index_analyzer

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

• 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/KiriakosGeorgiou/istoria

  istoria, PostgreSQL extension for managing table histories

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

  PostgreSQL validation domains for Italian fiscal codes

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

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

• https://github.com/uphold/json-output

  JSON decoding output plugin

• 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/postgrespro/jsonbd

  JSONB compression method for PostgreSQL

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

  jsonbx extension for PostgreSQL 9.4

• 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://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/postgrespro/jsquery ⭐️⭐️

  JsQuery – json query language with GIN indexing support

• 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/umitanuki/kmeans-postgresql ⭐️

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

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

• https://github.com/knaw-huc/lenticular-lens-postgresql

  PostgreSQL extension for Lenticular Lens

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

  X.509 certificate parsing library for PostgreSQL

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

• https://github.com/b4oshany/livewire

  Livewire: Power delivery modelling in postgresql

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

  course hacking postgresql, task 1

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

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

  login refuse extension for PostgreSQL

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

  Postgres extension to introspect postgres log files.

• https://github.com/gojuno/lostgis ⭐️

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

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

• 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/jianingy/ltree

  my changes to postgresql ltree contrib

• 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/apache/madlib ⭐️⭐️

  Mirror of Apache MADlib

• https://github.com/matlads/mapcode-postgres

  postgresql extension for mapcodes

• https://github.com/giggls/mapnik-german-l10n ⭐️

  OSM map l10n functions

• https://github.com/plotts/median

  PostgreSQL median function

• https://github.com/sgichohi/median

  Postgres median extension

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

• 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/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/leskin-in/mipt-asj

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

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

  multimaster

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

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

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

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

• 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/NaughtyDogOfSchrodinger/multicorn

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

• https://github.com/evetion/multistar

  Postgres C extension for multistars

• https://gitlab.com/ongresinc/extensions/mv_stats

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

  A custom sharding extension

• https://github.com/kornelski/mysqlcompat ⭐️

  A reimplemenation of as many MySQL functions as possible in PostgreSQL, as an aid to porting

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

  nanomsg insert data to PipelineDB Stream

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

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

• https://gitlab.com/ongresinc/extensions/noset

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

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

  A PostgreSQL extension defining custom numeric domains

• 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/rongfengliang/nvl-pg-extension

  nvl-pg-extension

• 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/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/hollobon/pagevis ⭐️

  PostgreSQL data page visualisation

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

• 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/dturon/partman_to_cstore

  PostgreSQL extension to move old pg_partman tables to columnar storage CSTORE

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

  A simple modified version of postgres passwordcheck plugin with configuration options

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

  Improved sharding for pg_pathman

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

  PERIODs and SYSTEM VERSIONING for PostgreSQL

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

  PostgreSQL extension for scalable pseudo-random permutations of sequences

• https://github.com/posix4e/petstore-jsoncdc

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

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

• 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/truthly/pg-cbor

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

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

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

• 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/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/bjeanes/pg-dataclips

  A (very much) WIP PostgreSQL extension for fetching dataclips (https://dataclips.heroku.com) for further querying

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

  a device_type extension for postgres

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

  ECDSA for PostgreSQL

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

  😍🐘 PostgreSQL emoji encode/decode extension

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

  postgresql fuzzywuzzy extension

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

  pg extesnion for gcd

• 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/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/claesjac/pg-json

  JSON stuff for postgresql

• https://github.com/choplin/pg-jsonpath

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

  Integrates libnumbertext with PostgreSQL

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

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

• 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/dalbani/pg-modeshape-bson

  PostgreSQL extension to convert ModeShape BSON to/from JSON

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

  Postgres extension for ID generation based on Instagram ID

• https://github.com/wulczer/pg-progress

  Query progress estimation for PostgreSQL

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

  Role Management Extension with some Nice Common Functions

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

  Readable and Usable Identifier

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

  Postgresql Salesforce ID plugin

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

  Full text search for PostgreSQL using BM25

• https://github.com/mgit-at/pg-semver-debian

  Debian Package for postgresql semver extension

• 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/gmr/pg-statsd ⭐️

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

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

  PG-Strom - Master development repository

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

  postgres extension to find the median in array

• 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/einhverfr/pg-trumpet

  Partial table replication for PostgreSQL

• 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/spa5k/uids-postgres ⭐️

  PostgreSQL Extension to generate various type of Universally Unique IDS

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

  🔐🐘 PostgreSQL WebAuthn Server

• https://github.com/gciolli/pg2podg

  A PostgreSQL extension for two-player open deterministic games

• https://github.com/Tostino/pgAutomator-extension

  Postgres extension for database portion of pgAutomator

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

  simple FuzzyTimeInterval for Postgresql

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

    simple FuzzyTimeInterval for Postgresql

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

  Sample PostgreSQL extension: work with ASCII-art libraries

• https://github.com/abris-platform/pg_abris

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

  postgresql accelerated engine

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

• https://github.com/kostiantyn-nemchenko/pg_algorithms

  Popular algorithms implementation on PostgreSQL side

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

  AMQP Support for Postgres

  • https://github.com/frankbv/pg_amqp

    AMQP Support for Postgres

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

  simultaneous multiple-indexing of PostgreSQL arrays

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

  postgres async listen/notify on replica (hot standby)

• 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/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/trustly/pg_badplan ⭐️

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

• 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/blkchain/pg_blkchain ⭐️⭐️

  PostgreSQL Blockchain Extension

• https://github.com/cosmic-jc/pg_block_join

  The second project for database course: similarity join and nested block join.

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

  PostgreSQL extension to block references to system catalogs.

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

  Yet another backup tool for PostgreSQL

• 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/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/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/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/snaiffer/pg_compress

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

  Limit PostgreSQL Role Connectivity without Catalog Access

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

  Utility functions for use with news management and full text search

• 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/segasai/pg_coordconvert

  Equatorial/Galactic coordinates conversion for Postgresql

• 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/postgrespro/pg_credereum ⭐️

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

• 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/adjust/pg_cryogen ⭐️

  Compressed append-only pluggable storage for PostgreSQL 12+

• 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/ossc-db/pg_dbms_stats ⭐️

  Let PostgreSQL to make execution plans using frozen statistics.

• 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/dsarafan/pg_dirty_hands

  PostgreSQL extension with dirty hacks

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

    PostgreSQL extension with dirty hacks

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

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

  Read dead but unvacuumed tuples from a PostgreSQL relation

• 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/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/kelvich/pg_dtm

  Distributed transaction manager for postgres

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

  Distributed transaction manager

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

  PostgreSQL Ed25519 tools

• 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/alexandersamoylov/pg_eyes

  PostgreSQL extension for analyze database activity

• 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/ligurio/pg_feedback

  PostgreSQL Feedback Plugin

• https://github.com/jasonmp85/pg_fiu

  Fault injection in userspace as a PostgreSQL extension

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

  PostgreSQL extension to partition tables following a foreign key

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

  foo bar parallel programing on PostgreSQL

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

  Format numbers by base

• 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/lawrencejones/pg_frozen

  Expose tuple freeze information via SQL commands

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

  The fzy function for 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/pindlebot/pg_gen_uid

• 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/sangli00/pg_get_page_tuple

  PostgreSQL extension get Relation BlockNumber Tuple.

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

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

  PostgreSQL extension for recoding workload of specific database

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

  PostgreSQL automated grants managment

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

• 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/turnstep/pg_healer ⭐️

  Repair Postgres corruption automatically

• https://github.com/segasai/pg_healpix

  Healpix functions for PostgreSQL

• 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/ossc-db/pg_hint_plan ⭐️⭐️

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

• 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/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/pasha132/pg_idm

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

  A PostgreSQL extension to analyze queries and give indexing advice.

• 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/jaiminpan/pg_jieba ⭐️⭐️

  Postgresql full-text search extension for chinese

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

  Just-in-time compilation in PostgreSQL using libFirm

• https://github.com/michelmilezzi/pg_job_queue

  A PostgreSQL job queue manager

• 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/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/MasahikoSawada/pg_keeper ⭐️

  Simplified clustering module for PostgreSQL

• 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/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/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/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/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/aquameta/pg_meta ⭐️

  PostgreSQL Extension: More friendly system catalog for PostgreSQL

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

• 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/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/RafiaSabih/pg_mon

• 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/maxoodf/pg_mystem

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

• 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/ttfkam/pg_newsfeeds

  PostgreSQL extension for gathering news

• https://github.com/roa/pg_nice

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

  PostgreSQL extension to normalize SQL statements

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

  A health checker for PostgreSQL

• 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/bdrouvot/pg_orphaned

• https://github.com/meistervonperf/pg_outrider

  A background worker for PostgreSQL that automatically extend the relation specified by the invocation parameter

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

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

• 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/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/cybertec-postgresql/pg_permission ⭐️⭐️

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

• 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/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/Timosha/pg_prewarm

  pg_prewarm - preload relation data into system buffer cache

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

  get and set the priority of PostgreSQL backends

• 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/MasahikoSawada/pg_promoter

  pg_promoter is simplified clustering module based on bgworker.

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

  Protobuf support for PostgreSQL

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

  PostgreSQL extension for partition tables management

• 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/adjust/pg_querylog

  Show queries running on PostgreSQL backends

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

  PostgreSQL extension for quotas

• https://github.com/meiyifei/pg_random_string

  生成随机字符串

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

  Precise fractional arithmetic for PostgreSQL

• 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/brettlaforge/pg_redis_pubsub ⭐️

  Redis Publish from PostgreSQL

• https://github.com/edpratomo/pg_redispub

  postgres extension for sending PUBLISH to redis

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

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

  A PostgreSQL extension for "ssh-over-postgres"

• 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/nuko-yokohama/pg_reversi

  Reversi game on PostgreSQL

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

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

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

  RoaringBitmap extension for PostgreSQL

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

  Postgres extension to sample statements or transactions to logs

• https://github.com/CartoDB/pg_schema_triggers ⭐️

  PostgreSQL 9.3+ Schema Triggers extension

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

  Postgresql full-text search extension for chinese

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

  An ORE extension for postgres

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

  PostgreSQL extension that implements mail function in C that rely on sendmail binary

• 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/sshutdownow/pg_setpriority

  set the priority of PostgreSQL process

• 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/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/erthalion/pg_simdjson ⭐️

  Postgres extension for parsing json using simdjson library

• 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/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/credativ/pg_snakeoil ⭐️

  The PostgreSQL Antivirus #pgSnakeOil

• 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/MarkAntipin/pg_sparse_vector

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

• https://github.com/maahl/pg_spi_examples

  A PostgreSQL extension containing various examples of PostgreSQL SPI usage

• 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/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/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/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/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/ossc-db/pg_store_plans ⭐️

  Store execution plans like pg_stat_statements does for queries.

• https://github.com/jmckulk/pg_string_extension

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

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

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

  Hack for natural sorts in PostgreSQL

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

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

  PostgreSQL superuser logging/blocking.

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

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

• https://github.com/magnusp/pg_ta

  (Partial) Wrapper of TA-Lib as a postgres extension

• https://github.com/laorunsen/pg_test

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

  Fast parser for text search of PostgreSQL

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

  Postgres Themis plugin

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

    Postgres Themis plugin

• https://github.com/ycui1984/pg_thrift

  Thrift support for postgreSQL

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

  Framework to extend and enhance pgtap for db unit tests

• https://github.com/TilelessMap/pg_tileless

  Tools for packing tileless maps

• 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/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_trgm_pro ⭐️

• 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/postgrespro/pg_tsparser ⭐️

  pg_tsparser - parser for text search

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

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

  Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL

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

  Postgres Unidecode extension

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

    Postgres Unidecode extension

• 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/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/MasahikoSawada/pg_visibilitymap

  The diagnostic functions for VisibilityMap

• 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/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/iCyberon/pg_xid ⭐️

  pg_xid is a globally unique id generator thought for the web

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

  Table replication for PostgreSQL nodes with Ceph and ZLog

• https://github.com/ildus/pg_zstd

• https://github.com/yonj1e/pgagent-c

  🐘 以 extension、bgworker进程方式实现pgAgent

• 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/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/johto/pgbrotli

  Brotli compression in PostgreSQL

• https://github.com/kingluo/pgcat-pgxs

  pgcat PostgreSQL extension

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

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

• 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/chet0xhenry/pgcompress

  Deflate and Gzip functions for Postgresql

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

  PL/PgSQL test coverage analysis

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

  shared buffer snapshot and prewarm extension

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

  Crockford Base32 encoding for PostgreSQL unsigned integers

• https://github.com/pandrewhk/pgcurl

  Call curl from PostgreSQL

• https://github.com/rustprooflabs/pgdd ⭐️

  PostgreSQL Data Dictionary

• https://github.com/lacanoid/pgddl ⭐️

  DDL eXtractor functions for PostgreSQL (ddlx)

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

  Decimal64 and decimal128 for PostgreSQL

• https://github.com/tlb-lab/pgeigen

  https://[email protected]/blundell/pgeigen

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

  Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL

• https://github.com/tsv2013/pgext

  Test postgres extension

• https://github.com/ycku/pgeyes

  Postgres天眼通

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

  FFT module 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/mausimag/pgflake

  A snowflake algorithm implemented as Postgres Extension.

• 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/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/dlr-eoc/pgh3 ⭐️

  PostgreSQL extension for the H3 hierarchical geospatial indexing system

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

  hamming distance fn for postgresql

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

    hamming distance fn for postgresql

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

  Stable hash functions for Postgres

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

    Stable hash functions 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/michelp/pgjwt ⭐️⭐️

  PostgreSQL implementation of JWT (JSON Web Tokens)

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

    PostgreSQL implementation of JWT (JSON Web Tokens)

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

  Transparent Logical DDL Replication

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

  PostgreSQL wrapper for libuuid

• 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/ohmu/pgmemcache ⭐️⭐️

  PostgreSQL memcache functions

• https://github.com/F28956/pgmigrations

  Postgres Database Migrations

• https://github.com/avito-tech/pgmock

  PostgreSQL 9.4+ extension for unit tests

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

  PostgreSQL Multiple Precision Arithmetic 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/johto/pgocrypto

  Simple symmetric encryption between Go and PostgreSQL (with pgcrypto)

• https://github.com/pgoracle/pgora-builtin

  Oracle Compatibility: Built in Functions

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

  PostgreSQL extension to manage partitions

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

  PCRE functions for PostgreSQL

• 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/Minoro/pgpyml

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

• 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/pgrgraphic

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

  easy creation of rollup tables in postgresql (compute count(*) queries in constant time)

• 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/pgRouting/pgrouting ⭐️⭐️

  Repository contains pgRouting library. Development branch is "develop", stable branch is "master"

• 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/CrunchyData/pgseccomp

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

  postgresql extension providing Active session history

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

• https://github.com/AbdulYadi/pgsocket ⭐️

  send bytes using PostgreSQL user defined function to TCP/IP socket

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

  Modern cryptography for PostgreSQL using libsodium.

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

  SPARQL compiler functions for PostgreSQL

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

  Small block size Speck encryption in PostgreSQL

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

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

• 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/cayetanobv/pgsql-pcg-random

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

• https://github.com/openvenues/pgsql-postal

  PostgreSQL binding for libpostal

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

  PostgreSQL binding for libpostal

• https://github.com/maternity/pgsql_rrule

  RRULE expansion in SQL

• https://github.com/AbdulYadi/pgstrtranslate

  PostgreSQL Extension for String Translation

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

  A SQL auditing extension for PostgreSQL

• 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/madebykite/pgunicoll

  PostgreSQL Unicode Collation Extension

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

  Open-source vector similarity search for Postgres

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

  version-independent hash functions for PostgreSQL

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

  Wiki for PostgreSQL

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

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

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

• 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/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/pjungwir/pjpg

  General-purpose Postgres utilities

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

  PostgreSQL extension finally providing visibility into the planning process

• 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/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/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://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/tychota/postgres-base32

  A postgres extension

• 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/Asa-Nisi-Masa/postgres-cosine-similarity

• https://github.com/dreamsxin/postgres-function

• 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/PixNyanNyan/postgres-phash-hamming

  PostgreSQL extension for pHash hamming distance

• https://github.com/mspiegel/postgres-playground

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

  Protocol Buffer extension for PostgreSQL

• https://github.com/riyazwalikar/postgres-runcmd-extension

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

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

• https://github.com/NaokiNakamichi/postgres_extension

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

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

  Vectorized executor to speed up PostgreSQL

• https://github.com/patmandu/postgresmedian

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

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

  Debian package script for pg_bigm on PostgreSQL 9.4.

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

  🐘 PostgreSQL cidr extension.

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

  a extension for postgresql refer to smlar

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

  Fast GUIDs for postgresql

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

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

  PostgreSQL extension with support for version string comparison

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

• https://github.com/drewc/postgresql-migrations

  A Postgresql Extension for Database Migrations

• 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/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/eschmar/postgresql-popcount

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

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

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

• 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/overplumbum/postgresql-zlib

  • https://github.com/Lemaf/postgresql-zlib

• https://github.com/pavilkau/postgresql_anatomy

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

  Mirror of Gitloab repo PostgreSQL Anonymizer

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

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

  Extension for tracking object renames in PostgreSQL 9.3+

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

  Postgres extension for authentication in PostgREST

• 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/dimitri/prefix ⭐️

  Prefix Range module for PostgreSQL

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

    Prefix Range module for PostgreSQL

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

  PostgreSQL prepare statements made pooling friendly

• https://github.com/kiranekbote/projectsrepo

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

• 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/postgrespro/ptrack ⭐️

  Block-level incremental backup engine for PostgreSQL

• https://github.com/rektide/putpostlogic

• https://github.com/segasai/q3c ⭐️

  PostgreSQL extension for spatial indexing on a sphere

• 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/ehfeng/random

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

  random data generator extension

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

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

  Postgres extension to merge adjacent/overlapping ranges

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

• https://github.com/hexiaoting/rasterdb

• 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://github.com/dvarrazzo/replisome

  handsomely replicate something

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

    handsomely replicate something

• 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/reshke/router

• 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/rtosm/rtosm

  A Postgresql database extension to provide the functionality of real-time simplification of spatial objects in Openstreetmap API Database.

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

  Safely cast in PostgreSQL

• 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/mohangk/sample_pg_extension

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

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

  generator of sequential UUIDs

• https://github.com/fabriziomello/session_variables

  PostgreSQL Functions to manipulate session variables

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

  PostgreSQL extension allowing privilege escalation with enhanced logging and control

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

  tf*idf ranking

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

  Extension for managing schema-based horizontal scaling

• 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/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/duckbill/sp-gist

  an extention about sp-gist

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

  Run search queries for SphinxSearch from PostgreSQL

• 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/postgrespro/sr_plan ⭐️

  Save and restore query plans in PostgreSQL

• https://github.com/zombodb/srf

  an example of writing an SRF in C for Postgres

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

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

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

  A Postgres extension for managing SSL certificates through SQL.

• 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/vibhorkum/synchronize-logical-slots

  Synchronize logical replication slot

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

  System Synchronization Client via dblink

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

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

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

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

• 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/ergo70/tanimoto

  A fast Tanimoto function for BIT VARYING in C

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

  Transparent Cell-Level Encryption for PostgreSQL

• 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/arkhipov/temporal_tables ⭐️⭐️

  Temporal Tables PostgreSQL Extension

• https://github.com/rambos22/test

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

  test_parser extension for postgresql

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

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

  PostgreSQL extension defining custom text domains

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

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

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

  Temporal foreign keys for Postgres

• 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/mweber26/timestampandtz ⭐️

• https://github.com/liguangxian/timing

  PostgreSQL,Description: Scheduled Task Extension

• 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/credativ/toastinfo

  Show storage structure of varlena datatypes in PostgreSQL

• https://github.com/alexeyklyukin/translate_isbn

  PostgreSQL extension that reimplements translate_isbn1013 function from the Evergreen ILS software in C.

• https://github.com/evetion/trianglearray

  Triangle Array data structure for storing TINs in PostgreSQL.

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

  this thing calculates a fingerprint of DB structure

• 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/postgrespro/undam ⭐️

  Undo storage implementation

• https://github.com/truthly/uniphant

  🦄🐘 PostgreSQL-centric Full Stack demo project

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

  postgresql extension to convert between different units

• https://github.com/pgexperts/unnest_ordinality

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

  url_encode, url_decode functions for PostgreSQL

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

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

• https://github.com/blueskylxb/utinyint

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

  UUID generation for PostgreSQL on FreeBSD

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

• 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/zhangh43/vectorize_engine ⭐️

• 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/vops ⭐️⭐️

• https://github.com/pgRouting/vrprouting

  Vehicle Routing Problems on the Database

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

  a postgresql extension to read wal with sql functions

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

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

  adjust's patched version of postgres ltree

• https://github.com/darthunix/x5fix

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

  Global system views for Postgres-XL/Tbase

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

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

• https://github.com/yeti-switch/yeti-pg-ext

  YETI extension for PostgreSQL

• https://github.com/bmuratshin/zcurve ⭐️

  Spatial index based on Z&Hilbert curves realized as pgsql extension.

• 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

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

  ZSON is a PostgreSQL extension for transparent JSONB compression

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

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

Access Methods

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

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

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

  OrioleDB – building a modern cloud-native storage engine

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

Data Types

• 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/lacanoid/chkpass

  Stand alone version of chkpass type for PG 11+

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

  Postges datatype for efficient OLAP indexing

• 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/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/theory/kv-pair ⭐️

  A key/value pair data type for PostgreSQL

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

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

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

  japanese compare text datatype

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

  Postgresql data type for passwords

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

  simple semantic version type for postgres

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

  A Concise Binary Object Representation data type for PostgreSQL

• 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/ratbox/pg-digest

  PostgreSQL data type for efficient storage of hash digests

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

  Postgres extension of language enumeration type

• 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/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/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/marconeperes/pgBRTypes

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

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

  PostgreSQL types based on _Decimal32 and _Decimal64 types.

• 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/nuko-yokohama/pg_fraction

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

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

  an efficient genotype representation type

• 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/rlichtenwalter/pg_nanp

  an efficient, validated, formatted NANP type

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

  an efficient, validated, formatted Canadian postal code type

• 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/zilder/pg_txn_status

  Simple 1 byte transaction status type

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

  Version data type for postgresql

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

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

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

  email address type for PostgreSQL

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

    email address type for PostgreSQL

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

  Postgresql data type extension for KNX Addresses

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

  PostgreSQL extension that makes various OpenSSL types persistable.

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

  ASN.1 OID datatype for PostgreSQL

• 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/maciekgajewski/postgres-uints

  Unsigned integer types for PostgreSQL

• 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/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/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/pgstuff/telephone

  PostgreSQL telephone data type

• 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/autodatadirect/uniqueidentifier

  Legacy uniqueidentifier data type for PostgreSQL

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

  uri is a extension to add uri data type for postgresql

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

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

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

Foreign Data Wrappers

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

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/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/plv8/pljs ⭐️⭐️

  PLJS - Javascript Language Plugin for PostreSQL

• 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/MobilityDB/MobilityDB ⭐️⭐️

  MobilityDB is a geospatial trajectory data management & analysis platform, built on PostgreSQL and PostGIS.

• https://github.com/2ndquadrant-it/brin4postgis

  A PostgreSQL extension to add BRIN indexing for PostGIS geometries

• https://github.com/mnelemans/geohash-extra

  Additional functionality for geohashing with PostGIS

• https://github.com/ahmetkucuk/pg-trajectory

  PostgreSQL/PostGIS extension for spatiotemporal data

• https://github.com/siose-innova/pg_landmetrics

  A Postgres/PostGIS extension for landscape metrics calculations.

• 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/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/AfieldTrails/s2-postgis ⭐️

  S2 Cell Id functions for PostgreSQL and PostGIS

• https://postgis.net/ ⭐️⭐️⭐️

  PostGIS spatial database extension to PostgreSQL

• https://github.com/pgpointcloud/pointcloud ⭐️⭐️

  A PostgreSQL extension for storing point cloud (LIDAR) data.