Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
1798 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| lsm | 0.1 | RocksDB foreign data wrapper for PostgreSQL | FDW | Apache-2.0 | C++ | 11–13 | 26 |
| pg_dtm | 1.0 | Pluggable distributed transaction manager using shared global snapshots | ADMIN | — | C | — | 26 |
| pg_worker_pool | 0.1 | A background worker pool for executing SQL queries | FEAT | — | C | — | 26 |
| r53db | 0.1 | r53db, the PostgreSQL Foreign Data Wrapper for the AWS Route53 Database service | FDW | BSD-2-Clause | C | — | 26 |
| range_agg | 1.2.1 | range_agg: merge adjacent or overlapping PostgreSQL range values | FUNC | MIT | C | — | 26 |
| cdb_geocoder | 0.0.2 | Archived CARTO geocoder extension for administrative, postal, IP, and named-place lookups. | GIS | — | SQL | — | 25 |
| jsonknife | 1.0 | Useful jsonb inspection and transformation functions | FUNC | — | C | 11 | 25 |
| pg_ai | 0.0.1 | PostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. | RAG | Apache-2.0 | C | — | 25 |
| pg_dphyp | — | Preload-only DPHyp hypergraph dynamic-programming join enumeration algorithm for PostgreSQL. | FEAT | MIT | C | 12–18 | 25 |
| pg_ibc_0_1 | 0.1.1 | PostgreSQL extension for decoding and handling IBC protocol data types | UTIL | — | Rust | 14–16 | 25 |
| pgchronos | 1.0.2 | SQL functions and operators for union, intersection, and difference over daterange and tstzrange arrays. | TIME | BSD-3-Clause | SQL | 10–18 | 25 |
| json_build | 1.1.0 | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. | FUNC | PostgreSQL | C | 10–18 | 24 |
| pg_meminfo | 1.0 | Backend memory and process usage inspection from SQL. | STAT | MIT | C | — | 24 |
| pg_start_sql | 1.0 | runs SQL statement at instance start | ADMIN | PostgreSQL | C | — | 24 |
| pgraft | 2.0.0 | Raft consensus, leader election, and replicated key-value state | ADMIN | MIT | C | 14–18 | 24 |
| pgsloth | 0.0.0 | Intentionally delays every query by a random 100 to 9,999 milliseconds through an executor hook. | FEAT | — | Rust | 12–17 | 24 |
| bignum | 0.8.0 | Unlimited precision integers for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 23 |
| hello-world | 0.0.1 | RLS demo extension with users and products tables | SEC | MIT | C | — | 23 |
| pgbitmap | 0.9.5 | Bitmap-type extension for PostgreSQL | TYPE | BSD-2-Clause | C | 10–18 | 23 |
| supabase | 0.0.1 | A friendly playground for building and validating Supabase Row‑Level Security (RLS) | SEC | MIT | C | — | 23 |
| time_for_keys | 0.0.1 | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. | TIME | MIT | C | — | 23 |
| aiven_extras | 1.1.20 | Aiven PostgreSQL extras for non-superuser access to selected database features. | SEC | Apache-2.0 | C | 12–18 | 22 |
| cassandra2_fdw | 2.0 | Foreign data wrapper for querying Cassandra 2.x and newer from PostgreSQL. | FDW | MIT | C | 11–15 | 22 |
| pg_kaboom | 0.0.1 | Blow things up in interesting and useful^W^W ways | FEAT | Apache-2.0 | C | — | 22 |
| pg_lz4 | 1.0 | LZ4 compression access method for a patched PostgreSQL development branch. | UTIL | — | C | — | 22 |
| pg_mustach | 2.0 | PostgreSQL implementation of Mustache templating | UTIL | MIT | C | — | 22 |
| pg_shared_plans | 0.0.1 | Proof-of-concept shared-memory execution-plan cache for PostgreSQL | FEAT | PostgreSQL | C | 12–17 | 22 |
| pg_simdjson | 0.1 | Prototype SIMD-accelerated parser that converts JSON text to jsonb | UTIL | Apache-2.0 | C++ | — | 22 |
| dblink_plus | 1.0.11 | Run SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL. | FDW | BSD-3-Clause | C | — | 21 |
| kilobase | 17.4.1 | Preloaded pgrx background worker for scheduling and refreshing PostgreSQL materialized views. | TIME | — | Rust | 17–18 | 21 |
| pg_index_stats | 0.2 | Create extended statistics on an index manually or automatically | ADMIN | MIT | C | — | 21 |
| pg_message_queue | 0.2.1 | Listen/Notify-based PostgreSQL message queue extension | FEAT | PostgreSQL | SQL | 10–18 | 21 |
| s2 | 0.0.2 | PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy | GIS | MIT | Python | — | 21 |
| timestampandtz | 1.0.0 | C data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions. | TYPE | MIT | C | 10–18 | 21 |
| bitpolar_pg | 0.3.3 | BitPolar: near-optimal vector quantization — 3-8 bit compression with zero training. 58 integrations across every major AI framework. | RAG | — | Rust | — | 20 |
| chdb | 0.1 | Execute isolated chDB queries from PostgreSQL through a helper process | OLAP | Apache-2.0 | C | 15–19 | 20 |
| chdb_hook | 0.1.1 | Headless hook for COPY and CREATE TABLE over chDB-supported URLs | ETL | Apache-2.0 | C | 15–19 | 20 |
| custom_properties | 0.0.3 | Supabase RLS helper tables and functions for managing user properties and custom claims. | SEC | — | SQL | — | 20 |
| pgbouncer_wrapper | 1.2.2 | Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw | ADMIN | MIT | SQL | — | 20 |
| mumak | 0.0.6 | Cardano CBOR parser | UTIL | Apache-2.0 | Rust | 11–16 | 19 |
| pg_backtrace | 1.0 | Show backtrace for errors and signals | STAT | PostgreSQL | C | — | 19 |
| pg_diffix | fir | Provides strong dynamic anonymization for PostgreSQL query results. | SEC | MIT | C | 13–18 | 19 |
| pg_normalize_query | 1.0 | Normalize constants in SQL statements using PostgreSQL parser logic | FUNC | BSD-3-Clause | C | 10–13 | 19 |
| pg_otel_tracer | 0.1.0 | Rust based Postgres extension that adds query lifecycle events to OTEL traces. | STAT | — | Rust | — | 19 |
| pg_stats | 1.0 | Customized statistics views | STAT | — | SQL | — | 19 |
| pg_zlog | 0.1 | Logical table replication using Ceph and ZLog | ETL | — | C | — | 19 |
| pgs2 | 0.0.1 | Postgres extension for S2 spherical geometry | GIS | Apache-2.0 | C | — | 19 |
| pgsampler | 1.0 | Experimental PostgreSQL background worker that collects time-series status and performance metrics. | STAT | PostgreSQL | C | — | 19 |
| pgsocket | 1.0 | send bytes from PostgreSQL to a TCP/IP socket | UTIL | BSD-3-Clause | C | 10 | 19 |
| adaptive_counter | 1.3.3 | Aggregation functions and data type for distinct estimation based on adaptive sampling. | FUNC | BSD-3-Clause | C | 10–18 | 18 |