Vote for Postgres extensions

[kiwicopple]

This issue is for tracking requests/demand for Postgres Extensions. Give a thumbs up if you want an extension added.

Please refrain from adding comments unless you are adding an extension which isn't already listed.

We will be sorting by Top here, so please upvote the extension, the emojis don't count as upvotes. Don't create duplicate requests, so that the votes aren't split.

[kiwicopple]

plv8 - https://github.com/plv8/plv8

[kiwicopple]

released 🚢

[ozum]

@kiwicopple, could you please hide messages when a requested extension is added, so we can easily see the remaining ones?

[skamensky]

Removed 😞

[kiwicopple]

PL Python

edit: this cannot be supported on Supabase because it is an untrusted extension. See here for more details
https://github.com/orgs/supabase/discussions/2239

[skwaugh]

Was support for this recently dropped? Can't find it in a new pg13 supabase project...which means it is not enabled during initial build. Is this temporary or the norm going forward?

[chrichrichri]

Any news on the plpython extension we would really love to use this in our project.

[burggraf]

@inian Any word on this python extension?

[inian]

#2239 (comment)

[shah]

PL Java would be great - https://github.com/tada/pljava.

Also, ARG based build which would enable/disable certain plugins might also be helpful.

Great work by the way, love the Dockerfile.

[kenahrens]

Timescale - https://github.com/timescale/timescaledb

[georgewritescode]

Following up to also note that timescaledb_toolkit would be very helpful given it has many of the functions required to use timscaledb. Also referenced here: https://github.com/orgs/supabase/discussions/17108

[encima]

Timescale-toolkit is under the TSL License and cannot be offered by Supabase (or any Database-as-a-service)

[riderx]

Timescale is useless in supabase environments…
That why I made a PR to have a columnar db alternative:
https://github.com/orgs/supabase/discussions/679#discussioncomment-7791898
please have a look and if that fit your use case upvote it

[bitnom]

IMO some alternative to timescale should have been used. The licensing is bad, and the version you can use in supabase cloud is not good.

[riderx]

The official alternative has been announced today: https://supabase.com/blog/analytics-buckets

[shah]

plpgsql_check for linting and validating SQL code quality.

[kiwicopple]

Added 👍

[felixyz]

wal2json

[dragarcia]

Added via Supabase Postgres v13.3.0.

[Takashiidobe]

I would like to see pg_cron on here, although I don't know about the licenses.

[kiwicopple]

Added 👍

[psolymos]

PL/R would be great! https://github.com/postgres-plr/plr and https://access.crunchydata.com/documentation/plr/8.3.0.18/

[Vadorequest]

https://github.com/furstenheim/is_jsonb_valid seems useful for enforcing JSON schemas in columns using the JSON type.

It's not in the Database > Extensions yet, I suggest it is added.

It seems to be more performant than its https://github.com/gavinwahl/postgres-json-schema counterpart. (from the author)

[chipilov]

FYI, since the https://github.com/gavinwahl/postgres-json-schema extension is implemented in PL/pgSQL, you can enable it manually in your instance by running its script against your db: https://github.com/gavinwahl/postgres-json-schema/blob/master/postgres-json-schema--0.1.1.sql (you just need to remove/replace the references to @extschema@, since that's only available for extensions).

[cananda]

https://github.com/supabase/pg_jsonschema :)

[diversoft]

temporal_tables Temporal Tables PostgreSQL Extension
https://github.com/arkhipov/temporal_tables

[riderx]

pg_duckdb
https://motherduck.com/blog/pgduckdb-beta-release-duckdb-postgres/

[itsezc]

pg-webauthn for WebAuthn integration (integration for pg_graphql would be a bonus)

[theodufort]

pgai from timescale

[riderx]

Licence of this will again probably make it useless…

[lookevink]

postgis_raster

It's available in extensions, but GDAL drivers are disabled. Attempted enabling per session to no avail, and unable to enable globally due to permissions. raised an issue here

[wenerme]

pg_mooncake
https://github.com/Mooncake-Labs/pg_mooncake

best perf in pg only benchmark

[haschu]

VectorChord
Like pgvector, but faster and without filtering limitations.

[MuellerHF]

This would be awesome

[DavidMelnychuk]

+1, please add vchord, it improves on a lot of pgvector limitations

[mh-chaoyidu]

pg_anon
https://github.com/TantorLabs/pg_anon
An easy way to anonymize the stored data for compliance purposes.

[quantpioneer]

pgvectorscale

[andreasfranzen]

I'm also in need of this as pgvector's hnsw is problematic with filters.

[krystian-dev548]

keccak
Useful for saving hash on blockchain

[AlexandreSi]

pg_rational
Useful to store position of a row in an array

[Lqm1]

pg_bigm
Easier to handle, like pg_trgm, and better for full text searching in Japanese.
PGroonga is too complex. If you use Prisma ORM together, it won't work properly.

[Wobbel26]

I could really use mysql_fdw for multiple migrations trajects.

https://github.com/EnterpriseDB/mysql_fdw

[DerekBBell]

Ability to use PostgreSQL 18 UUIDv7, both to set as the default UUID method and implemented as a function - uuid_generate_v7().

[peekknuf]

We got analytics in the ability to connect to DuckDB

But the beautiful thing is that you can already have it within your regular Postgres with pg_duckdb
Having to connect to an external engine is tedious, while having just SET duckdb.force_execution = true; to run your 5 CTEs 7 joins analytical query is just so nice.
I've ran the benchmarks and it's pretty much equivalent to the speed of the binary, but even if it were just half as performant the convenience of one liner to run analytics is unmatched.

Now with the release of pg_lake (it's shiny but almost too new, i've yet to test it, but on paper sounds fantastic) there is an opportunity to make Supabase "the everything Postgres" platform.

This in particular sounds almost too good

pg_lake introduces a new Iceberg table type where Postgres itself acts as the catalog.

But at this point i'm curious how it would work with Analytical Buckets that are being developed right now