Skip to content

Instantly share code, notes, and snippets.

@joelonsql

joelonsql/PostgreSQL-EXTENSIONs.md

Last active January 23, 2026 02:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 to your computer and use it in GitHub Desktop.
Download ZIP
1000+ PostgreSQL EXTENSIONs
Raw
PostgreSQL-EXTENSIONs.md

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

  • 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

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

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

Aggregate Functions

Data Types

Dictionaries

Foreign Data Wrappers

Procedural Languages

Spatial and Geographic Objects

@siilike
Copy link

siilike commented Feb 11, 2022

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

@joelonsql
Copy link
Author

joelonsql commented Feb 11, 2022

@siilike Thanks, added.

@ImreSamu
Copy link

ImreSamu commented Feb 11, 2022 •
edited
Loading

https://github.com/MobilityDB/MobilityDB CREATE EXTENSION MobilityDB
https://github.com/CartoDB/cartodb-postgresql CREATE EXTENSION cartodb
https://github.com/apache/madlib "Apache MADlib: Big Data Machine Learning in SQL" / pgxn install madlib
https://github.com/citusdata/citus CREATE EXTENSION citus;
https://github.com/pgRouting/pgrouting CREATE EXTENSION pgrouting

some extension from "gitlab"

EDIT1:

EDIT2:

EDIT3:

@joelonsql
Copy link
Author

joelonsql commented Feb 13, 2022

@ImreSamu Thanks, added.

@ImreSamu
Copy link

ImreSamu commented Feb 24, 2022

https://github.com/orioledb/orioledb

@yamatattsu
Copy link

yamatattsu commented Sep 11, 2022 •
edited
Loading

Hi Joel,

I'd like you to know that 16 repositories are "not found".
See below:

$ curl -s https://github.com/craigbranscom/pg-biguint     |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_logging        |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_shardman       |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/panwenhang/pgtools   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/johto/postgres_numeric_trim  |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/danielbulger/postgresql-wilson-ext   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/gilt/role_manager    |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/x4m/clickhouse_fdw   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/craigbranscom/pg-biguint     |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_logging        |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/funbringer/pg_shardman       |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/panwenhang/pgtools   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/johto/postgres_numeric_trim  |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/danielbulger/postgresql-wilson-ext   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/gilt/role_manager    |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>
$ curl -s https://github.com/x4m/clickhouse_fdw   |grep "<title>.*</title>"
  <title>Page not found ・ GitHub ・ GitHub</title>

@chanukyasds
Copy link

chanukyasds commented May 31, 2023

Hi joel,

This pg_math extension supports PostgreSQL to compute several statistical distribution methods.

https://github.com/chanukyasds/pg_math

Thanks,
Chanukya

@jbiz805
Copy link

jbiz805 commented Jun 29, 2023

Hi Joel,

The graph database extension for PostgreSQL official name is Apache AGE and its official repo is https://github.com/apache/age

Thanks,
Joe

@aozturkoda
Copy link

aozturkoda commented Aug 16, 2023

Hi Joel,

Here some links i found not working anymore in your list.

Thanks.

@JerrySievert
Copy link

JerrySievert commented Jan 4, 2024

it looks like your javascript extensions are out of date and appear to be abandoned.

https://github.com/plv8/plv8 is the canonical one, and is still active. https://github.com/plv8/pljs is the lightweight alternative, still in alpha.

@joelonsql
Copy link
Author

joelonsql commented Jan 4, 2024

Thanks @JerrySievert @aozturkoda @jbiz805 @chanukyasds @yamatattsu @ImreSamu, updated.

@JSchmidt63
Copy link

JSchmidt63 commented Feb 18, 2024

is missing: pgMemento

@joelonsql
Copy link
Author

joelonsql commented Aug 19, 2024

Thanks @JSchmidt63, updated.

@rebasedming
Copy link

rebasedming commented Aug 20, 2024 •
edited
Loading

pg_search (5K+ stars)
CREATE EXTENSION pg_search

@joelonsql
Copy link
Author

joelonsql commented Aug 20, 2024

Thanks @rebasedming, updated.

@AlexRMU
Copy link

AlexRMU commented Aug 31, 2024

🖐
https://github.com/spa5k/uids-postgres

@joelonsql
Copy link
Author

joelonsql commented Oct 24, 2024

Thanks @AlexRMU, added.

@SuperPauly
Copy link

SuperPauly commented Feb 20, 2025

I believe Supabase uses Postgres. It gives it nice fancy GUI.

@yrashk
Copy link

yrashk commented Mar 12, 2025

We have 30+ plus extensions here https://github.com/omnigres/omnigres

(https://docs.omnigres.org/)

@joelonsql
Copy link
Author

joelonsql commented Mar 13, 2025

We have 30+ plus extensions here https://github.com/omnigres/omnigres

(https://docs.omnigres.org/)

It seems like many of the extensions have empty READMEs?

@nikelborm
Copy link

nikelborm commented Mar 24, 2025 •
edited
Loading

Here are also a few amazing extensions:

  1. https://github.com/timescale/pgai
  2. https://github.com/CrunchyData/pg_parquet
  3. https://github.com/hydradatabase/columnar
  4. https://github.com/duckdb/pg_duckdb
  5. https://gitlab.com/postgres-ai/postgres-checkup
  6. https://github.com/neondatabase-labs/pgrag

@schmidni
Copy link

schmidni commented Aug 28, 2025 •
edited
Loading

weighted statistics with focus quantiles

https://github.com/schmidni/pg_weighted_statistics

@CodeWorld-1
Copy link

CodeWorld-1 commented Dec 22, 2025

Hi Joel, here's a new index access method: https://github.com/CrystallineCore/Biscuit

@joelonsql
Copy link
Author

joelonsql commented Dec 22, 2025

Thanks @CodeWorld-1, added

@alice-viola
Copy link

alice-viola commented Jan 7, 2026

We have made the core of QueenMQ (our open source message queue) available directly as PG extension: pg_qpubsub

Allows for having Kafka semantics (produce,consume,commit with consuer group) directly inside PG.

@joelonsql
Copy link
Author

joelonsql commented Jan 7, 2026

Thanks @alice-viola , added

@davesharpe13
Copy link

davesharpe13 commented Jan 15, 2026 •
edited
Loading

Hi Joel, this extension adds direct comparisons from numerical (float4, float8, numeric) to integral (int2, int4, int8) types, for better plans and (mathematically) "correct" results: pg_num2int_direct_comp.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment