Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
1476 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| tsvector2 | 1.0 | Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. | FTS | PostgreSQL | C | 10–13 | 27 |
| jsonschema | 0.1.10 | JSON Schema validation functions for PostgreSQL | FEAT | MIT | Rust | 13–18 | 26 |
| log_fdw | 1.5 | foreign-data wrapper for Postgres log file access | FDW | Apache-2.0 | C | 14–18 | 26 |
| lsm | 0.1 | RocksDB foreign data wrapper for PostgreSQL | FDW | Apache-2.0 | C++ | 11–13 | 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 |
| 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 |
| pg_kazsearch | 2.3.0 | Kazakh full-text search extension for PostgreSQL | FTS | LGPL-3.0 | Rust | 16–18 | 25 |
| pg_snakeoil | 1.4 | The PostgreSQL Antivirus | SEC | PostgreSQL | C | 14–18 | 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 |
| faker | 0.5.3 | Wrapper for the Faker Python library | LANG | PostgreSQL | Python | 14–18 | 24 |
| json_build | 1.1.0 | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. | FUNC | PostgreSQL | C | 10–18 | 24 |
| meta | 0.4.0 | Normalized, friendlier system catalog for PostgreSQL | STAT | BSD-2-Clause | SQL | 14–18 | 24 |
| parray_gin | 1.5.0 | GIN index operator class and partial-match operators for text arrays | FUNC | PostgreSQL | C | 14–18 | 24 |
| pg_orphaned | 1.0 | Deal with orphaned files | ADMIN | PostgreSQL | C | 14–18 | 24 |
| pg_query_rewrite | 0.0.5 | Rewrite SQL statements with a PostgreSQL ProcessUtility hook | ADMIN | PostgreSQL | C | 14–18 | 24 |
| pg_start_sql | 1.0 | runs SQL statement at instance start | ADMIN | PostgreSQL | C | — | 24 |
| pg_ttl_index | 3.0.0 | Automatic data expiration with TTL indexes | FEAT | PostgreSQL | C | 15–18 | 24 |
| pgauditlogtofile | 1.8.5 | pgAudit addon to redirect audit log to an independent file | SEC | PostgreSQL | C | 14–18 | 24 |
| bignum | 0.8.0 | Unlimited precision integers for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 23 |
| pgbitmap | 0.9.5 | Bitmap-type extension for PostgreSQL | TYPE | BSD-2-Clause | C | 10–18 | 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_relusage | 0.0.1 | Log all the queries that reference a particular column | STAT | PostgreSQL | C | 14–18 | 22 |
| pg_shared_plans | 0.0.1 | Proof-of-concept shared-memory execution-plan cache for PostgreSQL | FEAT | PostgreSQL | C | 12–17 | 22 |
| prioritize | 1.0.4 | get and set the priority of PostgreSQL backends | ADMIN | PostgreSQL | C | 14–18 | 22 |
| column_encrypt | 4.0 | Transparent column-level encryption with encrypted_text and encrypted_bytea types | SEC | PostgreSQL | C | 14–18 | 21 |
| 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_message_queue | 0.2.1 | Listen/Notify-based PostgreSQL message queue extension | FEAT | PostgreSQL | SQL | 10–18 | 21 |
| chdb | 0.1 | Execute isolated chDB queries from PostgreSQL through a helper process | OLAP | Apache-2.0 | C | 15–19 | 20 |
| currency | 0.0.3 | Custom PostgreSQL currency type in 1Byte | TYPE | MIT | C | 14–18 | 20 |
| plxslt | 0.20140221 | XSLT procedural language for PostgreSQL | LANG | PostgreSQL | C | 14–18 | 20 |
| kafgres | 0.1.0 | Kafka protocol broker embedded in PostgreSQL | SIM | Elastic-2.0 | Rust | 16 | 19 |
| mumak | 0.0.6 | Cardano CBOR parser | UTIL | Apache-2.0 | Rust | 11–16 | 19 |
| online_advisor | 1.0 | Suggest missing indexes and extended statistics online | ADMIN | PostgreSQL | C | 14–18 | 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_math | 1.1.0 | GSL statistical functions for postgresql | FUNC | GPL-3.0 | C | 14–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_readonly | 1.0.6 | cluster database read only | ADMIN | PostgreSQL | C | 14–18 | 19 |
| pg_stats | 1.0 | Customized statistics views | STAT | — | SQL | — | 19 |