Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
277 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| 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 |
| pg_url | 0.1.0 | Implements URL handling methods as postgres extension | FUNC | MIT | Rust | — | 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 |
| slugify | 0.0.1 | PostgreSQL Extension to generate various variant of Slugs from a string. | FUNC | MIT | Rust | — | 11 |
| pg_testgen | 1.0 | Generate random integers, strings, and test-data rows for PostgreSQL development | FUNC | — | C | — | 10 |
| pgrx_validation | 0.0.0 | Cross-target Rust validation library compiled as PostgreSQL functions through an optional pgrx feature. | FUNC | GPL-3.0 | Rust | 13–17 | 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 |
| json_accessors | 1.3.6 | JSON accessor functions | FUNC | PostgreSQL | C | — | 9 |
| json_query | 0.9 | Generate PostgreSQL WHERE clause predicates from JSONB filter objects. | FUNC | PostgreSQL | SQL | 10–18 | 9 |
| pgaut | 1.0.0 | Auto Update Timestamp for PostgreSQL | FUNC | PostgreSQL | SQL | 10–11 | 9 |
| trimmed_aggregates | 2.0.0-dev | C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. | FUNC | BSD-2-Clause | C | 10–18 | 9 |
| pg_bitcount | 0.0.3 | Bit-count scalar and aggregate functions for integers and bit strings. | FUNC | MIT | C | 11–13 | 8 |
| pg_rowalesce | 0.1.12 | rowalesce() is like coalesce(), but for rows and other composite types. | FUNC | PostgreSQL | SQL | — | 8 |
| unique_id | 1.0 | Time-based K-sorted unique identifier generators inspired by Instagram and Sonyflake designs. | FUNC | BSD-3-Clause | C | — | 8 |
| yeti | 1.14.1 | helper functions for YETI project | FUNC | — | C | 16–18 | 8 |
| cms_topn | 1.0.0 | Count-min sketch data type and aggregates for approximate frequency and top-N queries | FUNC | — | C | — | 7 |
| popcount | 1.0.0 | provide population-count functions for PostgreSQL bit(n) values | FUNC | MIT | C | 10–18 | 7 |
| array_textsort | 1.1 | C functions for sorting and de-duplicating one-dimensional text arrays. | FUNC | BSD-4-Clause | C | — | 6 |
| format_x | 0.0.1 | Polymorphic variadic string formatting with named lookups into composite, JSONB, and HSTORE values. | FUNC | MIT | C | 10–18 | 6 |
| pg_ta | 1.0 | TA-Lib technical-analysis functions exposed as PostgreSQL functions | FUNC | BSD-2-Clause | C | — | 6 |
| psl | 1.0.0 | Returns the registrable domain for a hostname using a compiled-in Public Suffix List. | FUNC | PostgreSQL | C | 11–15 | 6 |
| shbf | 1.0.0 | C extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions. | FUNC | — | C | — | 6 |
| uuid-freebsd | 2.0 | UUID generation functions for PostgreSQL on FreeBSD. | FUNC | PostgreSQL | C | 10–18 | 6 |
| fnvhash | 1.0 | FNV hash functions for PostgreSQL. | FUNC | — | C | — | 5 |
| launchql-inflection | 0.0.2 | inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL | FUNC | MIT | C | — | 5 |
| natord_pg | 0.0.0 | Natural-order comparison operators and btree operator class for PostgreSQL text values. | FUNC | MIT | Rust | 13–17 | 5 |
| pg_accumulator | 1.1.3 | Accumulation registers for balance and turnover tracking in PostgreSQL | FUNC | PostgreSQL | C | 14–18 | 5 |
| pg_hist | 1.0.0 | Compute fast weighted or unweighted histograms in one or more dimensions. | FUNC | GPL-2.0 | C | 10–12 | 5 |
| pgfaker | 0.0.3 | Generates fake company, person, internet, and phone data in PostgreSQL for tests, performance testing, and demos. | FUNC | MIT | Rust | 14–18 | 5 |
| pltoolbox | 1.0.3 | provide C utility functions for PostgreSQL stored procedures | FUNC | BSD-2-Clause | C | — | 5 |
| xicor | 0.1.1 | XI Correlation Coefficient in Postgres | FUNC | GPL-3.0 | C | 14–18 | 5 |
| binvec | 0.1 | C helper for summing integer bit values into arrays | FUNC | — | C | — | 4 |
| calculate_markup | 1.0 | C function that calculates a price markup percentage by linear interpolation over a numeric price/markup array. | FUNC | — | C | — | 4 |
| cidr | 1.0 | Transform an IPv4 or IPv6 address range into the minimal set of CIDR blocks | FUNC | MIT | SQL | — | 4 |
| format | 0.0.1 | A string formatting function which takes named parameters | FUNC | MIT | C | — | 4 |
| jsonb_extend | 1.0 | Merge two or more jsonb values | FUNC | MIT | C | 10–18 | 4 |
| kissfft | 0.0.1 | Fast-Fourier transformer (fft) | FUNC | PostgreSQL | C | 10–18 | 4 |
| pg_ethopic | 0.0.1 | Format Ethiopic dates and numbers in PostgreSQL. | FUNC | MIT | Rust | 13–17 | 4 |
| pg_uuid | 1.0.0 | generator of new UUID versions | FUNC | MIT | C | — | 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 |
| base62 | 0.0.1 | Base62 extension for PostgreSQL | FUNC | MIT | C | 14–18 | 3 |
| convert | 0.1.0 | conversion functions for spatial, routing and other specialized uses | FUNC | MIT | Rust | 14–18 | 3 |