Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
587 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| timeit | 1.0 | High-resolution benchmarking of PostgreSQL built-in functions and SQL expressions. | STAT | PostgreSQL | C | — | 5 |
| db_info | 0.2.0 | Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. | STAT | PostgreSQL | SQL | 11–18 | 4 |
| device_type | 0.0.2 | Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. | TYPE | PostgreSQL | C | 10–18 | 4 |
| dict_exclude | 1.0 | Full-text search dictionary that filters stop words using regular-expression rules. | FTS | PostgreSQL | C | — | 4 |
| dict_id | 1.0 | Indonesian-language full-text search stemming dictionary based on cSastrawi | FTS | PostgreSQL | C | — | 4 |
| kissfft | 0.0.1 | Fast-Fourier transformer (fft) | FUNC | PostgreSQL | C | 10–18 | 4 |
| multicdr_fdw | 1.2.2 | Foreign data wrapper for reading call-detail-record file streams as external SQL tables. | FDW | PostgreSQL | C | — | 4 |
| otp | 1.0.0 | Implementation of TOTP compatible with Google Authenticator | SEC | PostgreSQL | SQL | 10–18 | 4 |
| partman_to_cstore | 1.1.0 | Move old pg_partman partitions to cstore columnar storage. | OLAP | PostgreSQL | SQL | 10–18 | 4 |
| pg_fk_indexer | 1.0 | Automatically creates indexes for newly defined foreign-key columns. | ADMIN | PostgreSQL | C | — | 4 |
| pg_role_fkey_trigger_functions | 1.0.4 | A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. | SEC | PostgreSQL | SQL | — | 4 |
| pg_substrait | 0.1.0 | Execute Substrait protobuf or JSON query plans through PostgreSQL functions | OLAP | PostgreSQL | Rust | 13–17 | 4 |
| pg_sulog | 1.0 | PostgreSQL superuser operation logging and blocking extension | SEC | PostgreSQL | C | — | 4 |
| pg_utility_trigger_functions | 1.9.3 | Some pet trigger functions that the extension author likes to follow him through various PostgreSQL projects. | UTIL | PostgreSQL | SQL | — | 4 |
| pgelog | 1.0.2 | Extended logging via pseudo-autonomous transactions | ADMIN | PostgreSQL | SQL | 14–18 | 4 |
| pglog | 1.0 | PostgreSQL log via SQL | FDW | PostgreSQL | C | — | 4 |
| pmpp | 1.2.3 | Run manually partitioned SQL work in parallel over asynchronous libpq connections and combine the results | OLAP | PostgreSQL | C | 10 | 4 |
| repeater | 0.1 | Demonstration extension for executing serialized raw query plans on a remote PostgreSQL node. | OLAP | PostgreSQL | C | 12 | 4 |
| tce | 0.10.0-dev | Transparent column encryption for PostgreSQL using per-role envelope keys and external key-management services. | SEC | PostgreSQL | Rust | 15–18 | 4 |
| tcle | 1.0 | Experimental table access method for transparent AES-256-CBC encryption of selected column types. | SEC | PostgreSQL | C | 12–13 | 4 |
| trunklet | 0.3.3 | A templating system for Postgres. Elephants don't use templates, they use trunklets! | UTIL | PostgreSQL | SQL | — | 4 |
| unnest_ordinality | 1.0.1 | Legacy array unnest function that returns each element with its ordinal position. | FUNC | PostgreSQL | C | 10–18 | 4 |
| vihash | 1 | version-independent hash functions | FUNC | PostgreSQL | C | — | 4 |
| conninfo | 1.0 | Parse, validate, and inspect default values for PostgreSQL libpq conninfo strings | UTIL | PostgreSQL | C | 10–18 | 3 |
| jx_io | 0.1.1 | Extension to export and import json and xml from/to postgres | ETL | PostgreSQL | SQL | 10–18 | 3 |
| logging | 0.1 | Administrative C function to enable or disable logging mode on relations. | ADMIN | PostgreSQL | C | — | 3 |
| mapcode | 0.0.6 | Mapcodes in PostgreSQL | GIS | PostgreSQL | C++ | 10–18 | 3 |
| merge_ips | 1.0 | Functions to merge IP addresses, ignoring gaps | FUNC | PostgreSQL | SQL | — | 3 |
| pathman_sharding | 0.1 | Improved sharding for pg_pathman. | OLAP | PostgreSQL | C | 10 | 3 |
| pg_aa | 1.0 | ASCII art extension for PostgreSQL | FUNC | PostgreSQL | C | — | 3 |
| pg_array_multi_index | 1.0 | simultaneous multiple-indexing of PostgreSQL arrays | FUNC | PostgreSQL | C | — | 3 |
| pg_control_priority | 1.0 | Controls scheduling priorities (nice values) of PostgreSQL server processes. | ADMIN | PostgreSQL | C | 10–18 | 3 |
| pg_erlang_term | 0.0.1 | PostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. | TYPE | PostgreSQL | C | — | 3 |
| pg_llm_helper | 1.0 | Captures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. | STAT | PostgreSQL | C | 17 | 3 |
| pg_memorycontext | 1.0 | Examines PostgreSQL memory context information. | STAT | PostgreSQL | C | 10–18 | 3 |
| pg_normalize_email | 1.0.9 | Normalize email addresses in PostgreSQL | FUNC | PostgreSQL | SQL | 12–18 | 3 |
| pg_relation_sql | 0.2.2 | Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations | UTIL | PostgreSQL | PLpgSQL | 11–18 | 3 |
| pg_retry | 1.0.0 | Retry SQL statements on transient errors with exponential backoff | UTIL | PostgreSQL | C | 17–18 | 3 |
| pg_stat_backtrace | 1.0.0 | Capture or log C-level stack backtraces of PostgreSQL processes | STAT | PostgreSQL | C | 14–18 | 3 |
| pg_uuid_v8 | 1.1.0 | UUID v8 generator with embedded timestamps for PostgreSQL | FUNC | PostgreSQL | C | 14–18 | 3 |
| pglock | 1.0.0 | Lightweight distributed lock service inside PostgreSQL | UTIL | PostgreSQL | SQL | 14–18 | 3 |
| pglogical_ticker | 1.4.1 | Have an accurate view on pglogical replication delay | ETL | PostgreSQL | C | 14–18 | 3 |
| pgmb | 1.0.0 | A simple PostgreSQL Message Broker system | FEAT | PostgreSQL | SQL | 14–18 | 3 |
| qgres | 0.1.2 | Simple queue system | FEAT | PostgreSQL | SQL | — | 3 |
| salesforce_id | 1.0 | Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. | TYPE | PostgreSQL | C | — | 3 |
| scrub | 1.0 | Background worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. | ADMIN | PostgreSQL | C | — | 3 |
| session_variables | 0.0.4 | SQL functions for storing and retrieving session-scoped values through custom PostgreSQL settings. | FEAT | PostgreSQL | SQL | 10–18 | 3 |
| short_ids | 0.1.0 | PL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks. | FUNC | PostgreSQL | SQL | 10–18 | 3 |
| simple_parser | 1.0 | C full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. | FTS | PostgreSQL | C | — | 3 |
| toastinfo | 1.7 | show details on toasted datums | STAT | PostgreSQL | C | 14–18 | 3 |