Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
180 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_uuidv7 | 1.7.0 | Create UUIDv7 values in postgres | FUNC | MPL-2.0 | C | 14–18 | 430 |
| pg_hashids | 1.3 | Short unique id generator for PostgreSQL, using hashids | FUNC | MIT | C | 14–18 | 324 |
| sequential_uuids | 1.0.3 | generator of sequential UUIDs | FUNC | MIT | C | 14–18 | 310 |
| topn | 2.7.1 | type for top-n JSONB | FUNC | AGPL-3.0 | C | 14–18 | 249 |
| pg_blkchain | 0.0.1 | C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. | FUNC | MIT | C | — | 237 |
| tuid | 0.3.0 | tuid datatype | FUNC | MIT | C | — | 114 |
| tdigest | 1.4.6 | Provides tdigest aggregate function. | FUNC | Apache-2.0 | C | 14–18 | 98 |
| snowflake | 2.5.0 | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL | FUNC | PostgreSQL | C | 15–18 | 95 |
| count_distinct | 3.0.2 | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate | FUNC | BSD-2-Clause | C | 14–18 | 80 |
| pg_ulid | 0.0.4 | Generate ULID strings in PostgreSQL with a C function. | FUNC | — | C | — | 61 |
| aggs_for_arrays | 1.3.3 | Various functions for computing statistics on arrays of numbers | FUNC | MIT | C | 14–18 | 50 |
| permuteseq | 1.2.2 | Pseudo-randomly permute sequences with a format-preserving encryption on elements | FUNC | PostgreSQL | C | 14–18 | 39 |
| quantile | 1.1.8 | Quantile aggregation function | FUNC | BSD-2-Clause | C | 14–18 | 39 |
| aggs_for_vecs | 1.4.1 | Aggregate functions for array inputs | FUNC | MIT | C | 14–18 | 38 |
| pgflake | 0.0.1 | Extension for fdw memory | FUNC | Apache-2.0 | C | 11–18 | 37 |
| random_bytea | 1.0 | scrap code and various bug test cases for linking from bugtrackers | FUNC | — | C | — | 35 |
| vasco | 0.1.0 | discover hidden correlations in your data with MIC | FUNC | GPL-3.0 | C | 14–18 | 35 |
| first_last_agg | 0.1.4 | first() and last() aggregate functions | FUNC | PostgreSQL | C | 14–18 | 34 |
| jsonbx | 1.0 | Jsonb extension functions for PostgreSQL 9.4 | FUNC | PostgreSQL | C | — | 34 |
| extra_window_functions | 1.0 | Extra Window Functions for PostgreSQL | FUNC | PostgreSQL | C | 14–18 | 31 |
| pg_xid | 1.0 | PostgreSQL extension exposing xid generation functions | FUNC | MIT | C | — | 31 |
| pg_csv | 1.0.2 | Flexible CSV processing for Postgres | FUNC | MIT | C | 14–18 | 30 |
| financial | 1.0.1 | Financial aggregate functions | FUNC | PostgreSQL | C | 14–18 | 29 |
| argm | 1.1.1 | argmax, argmin, and anyold aggregate functions | FUNC | PostgreSQL | C | 14–18 | 27 |
| jsonb_deep_sum | 0.0.2 | Recursively sum numeric fields in JSONB objects | FUNC | MIT | C | 10–18 | 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 |
| json_build | 1.1.0 | C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. | FUNC | PostgreSQL | C | 10–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_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 |
| 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 |
| bitmap_counter | 1.3.5 | Aggregation functions and data type for distinct estimation based on s-bitmap. | FUNC | BSD-3-Clause | C | 10–18 | 18 |
| hyperloglog_counter | 1.2.6 | Aggregation functions and data type for distinct estimation based on HyperLogLog. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| loglog_counter | 1.2.4 | Aggregation functions and data type for distinct estimation based on LogLog. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| pcsa_counter | 1.3.3 | Aggregation functions and data type for distinct estimation based on PCSA. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| pg_slug_gen | 1.0.0 | Generate cryptographically secure timestamp-based slugs | FUNC | MIT | C | 15–18 | 18 |
| probabilistic_counter | 1.3.3 | A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| superloglog_counter | 1.2.3 | C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. | FUNC | BSD-3-Clause | C | 10–18 | 18 |
| arraymath | 1.1 | Array math and operators that work element by element on the contents of arrays | FUNC | MIT | C | 14–18 | 17 |
| base36 | 1.0.0 | Integer Base36 types | FUNC | MIT | C | 14–18 | 17 |
| floatvec | 1.1.1 | Math for vectors (arrays) of numbers | FUNC | MIT | C | 14–18 | 16 |
| acoustid | 1.0 | PostgreSQL extension for working with AcoustID fingerprints | FUNC | — | C | — | 15 |
| pg_uuid_next | 1.0 | Implementation of UUID v7 and v8 IETF drafts | FUNC | — | C | — | 15 |
| pg_natural_sort_order | 1.0.1 | Natural sort ordering support through a C normalization function usable with indexes. | FUNC | MIT | C | 10–18 | 12 |
| weighted_mean | 1.0.1 | Weighted average aggregate function for PostgreSQL numeric values. | FUNC | PostgreSQL | C | 10–18 | 12 |
| colors | 0.0.1 | C functions for perceptual color-distance calculations in the CIE L*a*b* color space | FUNC | PostgreSQL | C | 10–18 | 11 |
| pg_testgen | 1.0 | Generate random integers, strings, and test-data rows for PostgreSQL development | FUNC | — | C | — | 10 |
| colnames | 1.7.0 | Lists the column names in a PostgreSQL RECORD value | FUNC | PostgreSQL | C | 10–18 | 9 |
| hash64 | 0.1.0 | Stable 64-bit hash function whose results do not change across PostgreSQL major versions. | FUNC | PostgreSQL | C | — | 9 |