Skip to content

Instantly share code, notes, and snippets.

@joelonsql

joelonsql/PostgreSQL-EXTENSIONs.md

Last active March 29, 2026 06:38
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.

Access Methods

Data Types

Aggregate Functions

Full-Text Search & Linguistics

Dictionaries

Search & AI/ML

Analytics & Columnar Storage

Query Optimization & Planning

Monitoring & Observability

Auditing, Security & Encryption

Distributed Systems & Replication

Backup, Recovery & WAL

Foreign Data Wrappers

External Integrations & Messaging

Procedural Languages

Spatial and Geographic Objects

Uncategorized

@chanukyasds
Copy link
Copy Markdown

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

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

aozturkoda commented Aug 16, 2023

Hi Joel,

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

Thanks.

@JerrySievert
Copy link
Copy Markdown

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
Copy Markdown
Author

joelonsql commented Jan 4, 2024

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

@JSchmidt63
Copy link
Copy Markdown

JSchmidt63 commented Feb 18, 2024

is missing: pgMemento

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Aug 19, 2024

Thanks @JSchmidt63, updated.

@rebasedming
Copy link
Copy Markdown

rebasedming commented Aug 20, 2024 •
edited
Loading

pg_search (5K+ stars)
CREATE EXTENSION pg_search

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Aug 20, 2024

Thanks @rebasedming, updated.

@AlexRMU
Copy link
Copy Markdown

AlexRMU commented Aug 31, 2024

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

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Oct 24, 2024

Thanks @AlexRMU, added.

@SuperPauly
Copy link
Copy Markdown

SuperPauly commented Feb 20, 2025

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

@yrashk
Copy link
Copy Markdown

yrashk commented Mar 12, 2025

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

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

@joelonsql
Copy link
Copy Markdown
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
Copy Markdown

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

schmidni commented Aug 28, 2025 •
edited
Loading

weighted statistics with focus quantiles

https://github.com/schmidni/pg_weighted_statistics

@CodeWorld-1
Copy link
Copy Markdown

CodeWorld-1 commented Dec 22, 2025

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

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Dec 22, 2025

Thanks @CodeWorld-1, added

@alice-viola
Copy link
Copy Markdown

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
Copy Markdown
Author

joelonsql commented Jan 7, 2026

Thanks @alice-viola , added

@davesharpe13
Copy link
Copy Markdown

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.

@AyoubKaz07
Copy link
Copy Markdown

AyoubKaz07 commented Jan 26, 2026

Hello Joel, this is one to add too, some hackers might use it if useful. pg_microbench

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Mar 13, 2026

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

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

@yrashk: I added an entry for omnigres as a collection of extensions

@joelonsql
Copy link
Copy Markdown
Author

joelonsql commented Mar 13, 2026

Hello Joel, this is one to add too, some hackers might use it if useful. pg_microbench

Thanks @AyoubKaz07, added

@migueldeblas
Copy link
Copy Markdown

migueldeblas commented Mar 23, 2026

pg_repack ?

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