Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
70 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| uuidv7-sql | 1.1 | Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. | FUNC | PostgreSQL | SQL | — | 100 |
| snowflake | 2.5.0 | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL | FUNC | PostgreSQL | C | 15–18 | 95 |
| permuteseq | 1.2.2 | Pseudo-randomly permute sequences with a format-preserving encryption on elements | FUNC | PostgreSQL | C | 14–18 | 39 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| pg_rowalesce | 0.1.12 | rowalesce() is like coalesce(), but for rows and other composite types. | FUNC | PostgreSQL | SQL | — | 8 |
| psl | 1.0.0 | Returns the registrable domain for a hostname using a compiled-in Public Suffix List. | FUNC | PostgreSQL | C | 11–15 | 6 |
| uuid-freebsd | 2.0 | UUID generation functions for PostgreSQL on FreeBSD. | FUNC | PostgreSQL | C | 10–18 | 6 |
| pg_accumulator | 1.1.3 | Accumulation registers for balance and turnover tracking in PostgreSQL | FUNC | PostgreSQL | C | 14–18 | 5 |
| kissfft | 0.0.1 | Fast-Fourier transformer (fft) | FUNC | PostgreSQL | C | 10–18 | 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 |
| merge_ips | 1.0 | Functions to merge IP addresses, ignoring gaps | FUNC | PostgreSQL | SQL | — | 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_normalize_email | 1.0.9 | Normalize email addresses in PostgreSQL | FUNC | PostgreSQL | SQL | 12–18 | 3 |
| pg_uuid_v8 | 1.1.0 | UUID v8 generator with embedded timestamps for PostgreSQL | FUNC | PostgreSQL | C | 14–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 |
| weighted_statistics | 1.0.0 | High-performance weighted statistics functions for sparse data | FUNC | PostgreSQL | C | 14–18 | 3 |
| ddsketch | 1.0.1 | Provides ddsketch aggregate function | FUNC | PostgreSQL | C | 14–18 | 2 |
| fast_guid | 0.1 | Fast GUID generator function for PostgreSQL. | FUNC | PostgreSQL | C | — | 2 |
| generate_date_series | 1.0.0 | generate_series()-style set-returning function for date ranges with integer day steps. | FUNC | PostgreSQL | C | 10–18 | 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 |
| libuuid | 1.0 | Generate UUIDs through the system libuuid library | FUNC | PostgreSQL | C | 10–12 | 2 |
| pg_sample_ext | 1.0.2 | A Sample PostgreSQL extension | FUNC | PostgreSQL | SQL | — | 2 |
| validadores | 0.0.2 | Brazilian CPF check-digit validator, operator, and domain | FUNC | PostgreSQL | SQL | — | 2 |
| get_column | 1.0.0 | Fetch a column value from a record by name | FUNC | PostgreSQL | C | — | 1 |
| pg_py_ext | 1.0.0 | A PostgreSQL extension using PL/Python3U to add numbers | FUNC | PostgreSQL | SQL | — | 1 |
| pg_rand_ext | 1.0 | Functions that generate random values for PostgreSQL | FUNC | PostgreSQL | C | — | 1 |
| pg_variant_functions | 1.0 | Variant summary and allele-frequency functions over TINYINT[] genotype arrays | FUNC | PostgreSQL | C | 10–18 | 1 |
| random | 2.0.0 | random data generator | FUNC | PostgreSQL | C | 14–18 | 1 |
| stringtheory | 1.0.2 | C++ extension providing SIMD-optimized exact equality and substring-search functions for PostgreSQL text values. | FUNC | PostgreSQL | C++ | 14–16 | 1 |
| weighted_stats | 1.0.0 | Weighted aggregate functions | FUNC | PostgreSQL | C | — | 1 |
| auto_counters | 1.0 | PostgreSQL extension for automatic contextual numbering | FUNC | PostgreSQL | C | — | |
| autoinc | 1.0 | functions for autoincrementing fields | FUNC | PostgreSQL | C | 14–18 | |
| bgvalidators | 1.0 | Validation functions for IBAN, Bulgarian EGN personal IDs, BULSTAT VAT numbers, and LNCh foreigner IDs. | FUNC | PostgreSQL | SQL | — | |
| btree_gin | 1.3 | support for indexing common datatypes in GIN | FUNC | PostgreSQL | C | 14–18 |