Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
51 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pglite_fusion | 0.0.6 | Embed an SQLite database in your PostgreSQL table | TYPE | MIT | Rust | 14–18 | 832 |
| uuid47 | 1.0 | UUIDv7 storage with keyed UUIDv4-looking façade I/O | TYPE | MIT | C | 17 | 749 |
| zson | 1.1 | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. | TYPE | MIT | C | — | 568 |
| pg_rational | 0.0.3 | bigint fractions | TYPE | MIT | C | 14–18 | 257 |
| pg_rrule | 0.3.0 | RRULE field type for PostgreSQL | TYPE | MIT | C | 14–18 | 175 |
| pgcalendar | 1.1.0 | Recurring calendar, schedule, and exception management for PostgreSQL | TYPE | MIT | SQL | 14–18 | 141 |
| pgbson | 2.1.0 | BSON data type and accessor functions for PostgreSQL | TYPE | MIT | C | 14–18 | 104 |
| timestamp9 | 1.4.0 | timestamp nanosecond resolution | TYPE | MIT | C | 14–18 | 95 |
| upid_pg | 0.0.0 | Prefixed, sortable 128-bit identifier type and generator | TYPE | MIT | Rust | 18 | 71 |
| pg_ferroid | 2.0.0 | PostgreSQL ULID type and generation functions backed by ferroid | TYPE | MIT | Rust | 13–18 | 44 |
| istore | 0.1.12 | Integer-to-integer key/value store for analytic workloads. | TYPE | MIT | C | 10–16 | 35 |
| postgres_web3 | 1.0 | Optimized PostgreSQL types and operators for 128/256-bit signed and unsigned integers plus 160/256-bit hexadecimal web3 values. | TYPE | MIT | C | 15 | 33 |
| timestampandtz | 1.0.0 | C data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions. | TYPE | MIT | C | 10–18 | 21 |
| currency | 0.0.3 | Custom PostgreSQL currency type in 1Byte | TYPE | MIT | C | 14–18 | 20 |
| wltree | 2.0 | data type for hierarchical tree-like structures with wide character support | TYPE | MIT | C | 10–17 | 16 |
| libversion | 2.0.0 | Version string comparison functions and versiontext type using libversion | TYPE | MIT | C | 10–16 | 14 |
| inetrange | 1.0.2 | Range type for PostgreSQL inet values with range operators and GiST indexing support. | TYPE | MIT | C | — | 11 |
| plid | 0.0.0 | A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation. | TYPE | MIT | Rust | 13–18 | 8 |
| jansson-json | 0.0.2 | JSON data type, operators, and functions backed by the Jansson JSON library. | TYPE | MIT | C | 10–18 | 7 |
| pg-json | 0.0.1 | A json data type and related functions | TYPE | MIT | C | — | 7 |
| pg_datatype_password | 0.0.1 | SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage. | TYPE | MIT | SQL | 10–18 | 6 |
| pg_semver | 0.0.1 | Version(SEMVER) data type for postgresql | TYPE | MIT | C | — | 6 |
| kmea | 1.0 | K-Mer Extension for Analysis | TYPE | MIT | C | — | 4 |
| number | 1 | Variable-width integer data type for PostgreSQL | TYPE | MIT | C | — | 4 |
| numhstore | 0.1.7 | Adds inthstore and floathstore numeric hstore types and helpers | TYPE | MIT | C | — | 4 |
| pgsfti | 1.0 | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. | TYPE | MIT | C | — | 4 |
| dna | 1.0 | Compact DNA sequence and k-mer types with comparison, validation, and analysis functions. | TYPE | MIT | C | — | 3 |
| pg_chainutils | 0.2.4 | Blockchain utility types and functions for PostgreSQL, built with pgrx. | TYPE | MIT | Rust | 17 | 3 |
| pg_duration | 1.0.2 | data type for representing durations | TYPE | MIT | C | 17–18 | 3 |
| bankbsb | 0.0.1 | Postgres Extension for Australian BSB numbers data type. | TYPE | MIT | C | — | 2 |
| damm | 1.0 | SQL implementation of the Damm check digit algorithm with a damm_code domain and helper functions. | TYPE | MIT | SQL | — | 2 |
| numeric_domains | 1.0 | Custom numeric domains for PostgreSQL | TYPE | MIT | SQL | 10 | 2 |
| pg_money | 0.3.0 | Exact currency-aware monetary types, arithmetic, and allocation | TYPE | MIT | Rust | 14–18 | 2 |
| pgpm-types | 0.15.5 | PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. | TYPE | MIT | C | — | 2 |
| vercomp | 1.0.0 | Deprecated semantic-version data type and comparison operators | TYPE | MIT | C | 10 | 2 |
| eigen | 1.1 | New array types and linear-algebra functions based on the Eigen numerical template library. | TYPE | MIT | C++ | 10–18 | 1 |
| pg_cryptocurrency | 0.2.0 | Native blockchain asset, amount, address, and uint256 types | TYPE | MIT | Rust | 14–18 | 1 |
| pg_lexo | 0.6.0 | Provides a Base62 lexicographic position type and helper functions for stable list ordering and reordering without bulk row updates. | TYPE | MIT | Rust | 16–18 | 1 |
| saturated_int | 0.0.1 | Integer data type with saturation arithmetic that clamps overflow to int4 bounds. | TYPE | MIT | C | 10–16 | 1 |
| text_domains | 1.0 | Pure-SQL collection of constrained PostgreSQL text domains for nonempty, alphabetic, alphanumeric, case-specific, and fixed-length values. | TYPE | MIT | SQL | 10 | 1 |
| chess_index | 0.0.1 | Data types for indexing chess positions. | TYPE | MIT | C | — | |
| compact_uuid | 0.1.1 | UUID type with canonical 22-character Base64url text | TYPE | MIT | Rust | 18 | |
| conda_pgsql_rust_ext | 0.0.0 | Conda version data type and helpers for PostgreSQL, implemented with pgrx and rattler_conda_types. | TYPE | MIT | Rust | 13–17 | |
| condaversion | 1.0 | Conda package version number data type implemented as a C++ PostgreSQL extension. | TYPE | MIT | C++ | — | |
| ednb | 0.0.1 | Postgres extension to support EDN as a custom datatype | TYPE | MIT | C | — | |
| launchql-ext-types | 0.4.5 | 🛠. basic pg utils | TYPE | MIT | C | — | |
| pg_conda | 1.0.1 | PostgreSQL extension adding conda ecosystem version types, aggregates, and functions. | TYPE | MIT | Rust | 13–17 | |
| pg_hlc | 0.1.0 | PostgreSQL HLC (Hybrid Logical Clock) extension in Rust compatible with Dart CRDT library. | TYPE | MIT | Rust | — | |
| pg_smolid | 0.1.0 | A Postgres pgrx extension adding smolid type and helper functions. | TYPE | MIT | Rust | 13–18 | |
| semver_rs | 0.1.0 | A semantic version data type for PostgreSQL written in Rust | TYPE | MIT | Rust | — |