Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
156 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_hashids | 1.3 | Short unique id generator for PostgreSQL, using hashids | FUNC | MIT | C | 14–18 | 324 |
| pg_blkchain | 0.0.1 | C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. | FUNC | MIT | C | — | 237 |
| eva_pg | 0.0.1 | EVA ICS pgrx extension for the EVA industrial IoT platform. | FUNC | Apache-2.0 | Rust | 13–18 | 103 |
| pg_sqids | 0.1.0 | Encode numbers as short URL-safe Sqids and decode them in PostgreSQL | FUNC | MIT | Rust | 13–18 | 102 |
| uuidv7-sql | 1.1 | Pure SQL and PL/pgSQL functions for generating, inspecting, and transforming UUID version 7 values. | FUNC | PostgreSQL | SQL | — | 100 |
| datasketches | 1.7.0 | Approximate analytics sketches and aggregates for PostgreSQL | FUNC | Apache-2.0 | C++ | 14–18 | 96 |
| snowflake | 2.5.0 | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL | FUNC | PostgreSQL | C | 15–18 | 95 |
| uids | 0.0.1 | PostgreSQL extension to generate various types of universally unique IDs | FUNC | — | Rust | 11–16 | 74 |
| pg_ulid | 0.0.4 | Generate ULID strings in PostgreSQL with a C function. | FUNC | — | C | — | 61 |
| permuteseq | 1.2.2 | Pseudo-randomly permute sequences with a format-preserving encryption on elements | FUNC | PostgreSQL | C | 14–18 | 39 |
| pgflake | 0.0.1 | Extension for fdw memory | FUNC | Apache-2.0 | C | 11–18 | 37 |
| 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 |
| 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 |
| 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 |
| 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 |
| loglog_counter | 1.2.4 | Aggregation functions and data type for distinct estimation based on LogLog. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| acoustid | 1.0 | PostgreSQL extension for working with AcoustID fingerprints | FUNC | — | C | — | 15 |
| 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 |
| pg_rowalesce | 0.1.12 | rowalesce() is like coalesce(), but for rows and other composite types. | FUNC | PostgreSQL | SQL | — | 8 |
| popcount | 1.0.0 | provide population-count functions for PostgreSQL bit(n) values | FUNC | MIT | C | 10–18 | 7 |
| 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 |