Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
223 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| db_assist | 0.0.0 | Minimal pgrx training extension exposing a hello_db_assist function. | FUNC | — | Rust | — | 387 |
| pg_blkchain | 0.0.1 | C extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. | FUNC | MIT | C | — | 237 |
| tagext | 1.0 | Tag Programming Example Extension | FUNC | MIT | Shell | — | 160 |
| tuid | 0.3.0 | tuid datatype | FUNC | MIT | C | — | 114 |
| 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 |
| 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 |
| xataid_extension | 0.0.0 | Generate Xata-style rec_ identifiers with a 20-character lowercase alphanumeric suffix. | FUNC | MPL-2.0 | Rust | — | 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 |
| jsonbx | 1.0 | Jsonb extension functions for PostgreSQL 9.4 | FUNC | PostgreSQL | C | — | 34 |
| pg_xid | 1.0 | PostgreSQL extension exposing xid generation functions | FUNC | MIT | C | — | 31 |
| 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 |
| 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 |
| 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 |
| 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 |