Explore 2400 PostgreSQL extensions from PGEXT, maintained by Pigsty.
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| hive_fdw | 4.0 | Foreign data wrapper for querying Apache Hive from PostgreSQL. | FDW | — | C | 13 | 2 |
| hsearch | 0.4.1 | Tantivy-backed BM25 index access method with WAL-logged storage. | FTS | AGPL-3.0-only | Rust | 18 | 2 |
| hunspell_xal | 0.1 | Kalmyk Hunspell dictionary for PostgreSQL full-text search | FTS | BSD-3-Clause | SQL | — | 2 |
| job_queue | 1.0 | Proof-of-concept database-side asynchronous job queue using dynamic PostgreSQL background workers. | FEAT | — | C | — | 2 |
| json_utils | 0.1 | JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. | FUNC | PostgreSQL | SQL | 10–18 | 2 |
| jsonb_set_lax | 1.0.0 | Backport of PostgreSQL 13 jsonb_set_lax for PostgreSQL 9.5 through 12 | FUNC | PostgreSQL | C | 10–12 | 2 |
| language | 0.0.4 | Custom PostgreSQL language enumeration type | TYPE | PostgreSQL | C | 10–18 | 2 |
| libuuid | 1.0 | Generate UUIDs through the system libuuid library | FUNC | PostgreSQL | C | 10–12 | 2 |
| lispg | 1.0 | Lisp-like expression type and evaluator for PostgreSQL | LANG | — | C | — | 2 |
| livewire | 0.2.0 | power delivery modeling | GIS | — | SQL | 10 | 2 |
| login_refuse | 0.1 | Authentication hook that temporarily refuses logins after repeated failures | SEC | — | C | — | 2 |
| lua_fdw | 0.0.1 | Lua Foreign Data Wrapper | FDW | PostgreSQL | C | — | 2 |
| lukasiewicz_logic | 1.1.0 | Provides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. | FUNC | BSD-3-Clause | SQL | — | 2 |
| mv_stats | 0.3.0 | Tracks creation, alteration, refresh, and reset statistics for materialized views. | STAT | — | SQL | 10–18 | 2 |
| my_extension | 1.1.0 | A Basic PostgreSQL Extension | FEAT | PostgreSQL | SQL | — | 2 |
| nabla | 0.1.0 | Asynchronous incremental materialized views with delta subscriptions | FEAT | AGPL-3.0-or-later | Rust | 17 | 2 |
| nostr_filter | 1.0 | Nostr event types, insertion helpers, and JSON filter evaluation inside PostgreSQL. | FEAT | — | C | — | 2 |
| npm | 0.0.1 | Schema and tables for tracking npm package metadata and daily download counts. | FEAT | MIT | C | — | 2 |
| numeric_domains | 1.0 | Custom numeric domains for PostgreSQL | TYPE | MIT | SQL | 10 | 2 |
| numpy_plpython2u | 1.0 | transform between numpy and plpython2u | LANG | MIT | C | — | 2 |
| numpy_plpython3u | 1.0 | transform between numpy and plpython3u | LANG | MIT | C | — | 2 |
| numpy_plpythonu | 1.0 | transform between numpy and plpythonu | LANG | MIT | C | — | 2 |
| op_log | 1.0.0 | Trigger-based row change history recorded after transaction commit. | SEC | Apache-2.0 | SQL | — | 2 |
| openapi_fdw | 0.4.1 | Read/write foreign data wrapper for OpenAPI and JSON HTTP services. | FDW | WTFPL | Rust | 14–18 | 2 |
| pargres | 0.1 | Prototype parallel query execution module for shared-nothing PostgreSQL clusters | OLAP | PostgreSQL | C | — | 2 |
| password | 0.0.1 | PostgreSQL data type for passwords | TYPE | PostgreSQL | C | 10–18 | 2 |
| passwordpolicy | 2.0.5 | Dynamically configurable PostgreSQL password complexity checks. | SEC | PostgreSQL | C | 14–18 | 2 |
| pcg_random | 0.0.1 | PCG pseudo-random number generator functions for PostgreSQL. | FUNC | Apache-2.0 | C | — | 2 |
| percona_pg_telemetry | 1.2 | Percona telemetry extension for PostgreSQL | STAT | MIT | Shell | — | 2 |
| pg_acl | 0.1.3 | Utilities for handling aclitems. | TYPE | BSD-2-Clause | SQL | — | 2 |
| pg_background_queue | 1.0 | Topic-aware background SQL task queue with concurrency limits and retries. | TIME | GPL-3.0 | C | 13–18 | 2 |
| pg_base58 | 0.0.1 | Base58 Encoder/Decoder Extension for PostgreSQL | FUNC | MIT | Rust | 14–18 | 2 |
| pg_bitcoin_address | 2.1 | Bitcoin address types plus Base58Check and Bech32/Bech32m codecs. | TYPE | WTFPL | C | — | 2 |
| pg_block_if_slow | 1.0 | Abort queries that are taking too long based on EXPLAIN estimates. | ADMIN | — | C | — | 2 |
| pg_cardano | 1.2.0 | A suite of Cardano-related tools | FEAT | MIT | Rust | 15–18 | 2 |
| pg_catalog_get_defs | 0.1.0 | Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. | ADMIN | BSD-3-Clause | SQL | — | 2 |
| pg_change_point_detection | 1.0 | A Postgres extension to detect change points in time series data | TIME | — | C | — | 2 |
| pg_checkdestroy | 1.0 | check sql drop&delete&truncate table | ADMIN | — | C | — | 2 |
| pg_cld2 | 1.0.0 | Detects likely human language and script in PostgreSQL using CLD2. | FTS | MIT | C++ | 10–18 | 2 |
| pg_connlimit | 1.0 | Limits per-role connection counts from filesystem configuration without catalog access. | ADMIN | BSD-2-Clause | C | — | 2 |
| pg_consul | 0.1.0 | C++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs. | UTIL | PostgreSQL | C++ | 10–18 | 2 |
| pg_contextdump | 1.0 | Reports allocated-memory statistics for PostgreSQL memory contexts. | STAT | — | C | 11 | 2 |
| pg_cooldown | 0.1 | remove buffered pages for specific relations | ADMIN | Apache-2.0 | C | 14–18 | 2 |
| pg_coredump | 1.0 | Easier core dump collection for PostgreSQL | ADMIN | — | C | — | 2 |
| pg_crypto | 0.1.0 | Rust cryptography with pgcrypto-compatible and modern primitives | SEC | MIT | Rust | 14–18 | 2 |
| pg_dbwa | 0.3.1 | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. | STAT | MIT | SQL | — | 2 |
| pg_delta_am | 0.1.0 | Delta table access method skeleton | OLAP | Apache-2.0 | Rust | — | 2 |
| pg_dirty_hands | 1.0 | Provides functions to freeze individual heap tuples, including an unlogged variant. | ADMIN | — | C | — | 2 |
| pg_eddy | 0.6.0 | A Postgres extension for labeled property graphs with index-free adjacency and built-in materialized views. | FEAT | Apache-2.0 | Rust | — | 2 |
| pg_etag | 1.0 | Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. | FUNC | BSD-3-Clause | C | — | 2 |