Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
197 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 |
| automerge | 0.0.1 | CRDT support in Postgres (experimental) | TYPE | PostgreSQL | C | — | 649 |
| zson | 1.1 | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. | TYPE | MIT | C | — | 568 |
| uint | 1.20250815 | unsigned integer types | TYPE | PostgreSQL | C | 14–18 | 342 |
| uri | 1.20251029 | URI Data type for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 324 |
| roaringbitmap | 1.2.0 | support for Roaring Bitmaps | TYPE | Apache-2.0 | C | 14–18 | 287 |
| unit | 7.10 | SI units extension | TYPE | GPL-2.0 | C | 14–18 | 280 |
| pg_rational | 0.0.3 | bigint fractions | TYPE | MIT | C | 14–18 | 257 |
| pgpdf | 0.1.0 | PDF type with meta admin & Full-Text Search | TYPE | GPL-3.0 | C | 14–18 | 226 |
| pgfaceting | 0.2.0 | fast faceting queries using an inverted index | TYPE | BSD-3-Clause | SQL | 14–18 | 181 |
| pg_rrule | 0.3.0 | RRULE field type for PostgreSQL | TYPE | MIT | C | 14–18 | 175 |
| semver | 0.41.0 | Semantic version data type | TYPE | PostgreSQL | C | 14–18 | 168 |
| ip4r | 2.4.3 | IPv4/v6 and IPv4/v6 range index type for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 166 |
| pgcalendar | 1.1.0 | Recurring calendar, schedule, and exception management for PostgreSQL | TYPE | MIT | SQL | 14–18 | 141 |
| postpic | 0.9.1 | A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities. | TYPE | LGPL-3.0 | C | — | 137 |
| prefix | 1.2.11 | Prefix Range module for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 106 |
| pgbson | 2.1.0 | BSON data type and accessor functions for PostgreSQL | TYPE | MIT | C | 14–18 | 104 |
| pg_libphonenumber | 0.1.0 | Adds a packed phone-number type and parsing functions backed by Google libphonenumber. | TYPE | Apache-2.0 | C++ | — | 96 |
| timestamp9 | 1.4.0 | timestamp nanosecond resolution | TYPE | MIT | C | 14–18 | 95 |
| acl | 1.0.4 | ACL Data type | TYPE | BSD-2-Clause | C | 14–18 | 90 |
| upid_pg | 0.0.0 | Prefixed, sortable 128-bit identifier type and generator | TYPE | MIT | Rust | 18 | 71 |
| emailaddr | 0 | Email address type for PostgreSQL | TYPE | — | C | 14–18 | 46 |
| pg_ferroid | 2.0.0 | PostgreSQL ULID type and generation functions backed by ferroid | TYPE | MIT | Rust | 13–18 | 44 |
| fixeddecimal | 1.1.0 | Fixed-precision decimal type optimized for performance and storage. | TYPE | PostgreSQL | C | 10–18 | 36 |
| 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 |
| pgmp | 1.0.6 | Multiple Precision Arithmetic extension | TYPE | LGPL-3.0 | C | 14–18 | 32 |
| uint128 | 1.2.0 | Native uint128 type | TYPE | PostgreSQL | C | 14–18 | 29 |
| tinyint | 0.1.1 | One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. | TYPE | PostgreSQL | C | 10 | 28 |
| pg_sphere | 1.5.2 | spherical objects with useful functions, operators and index support | TYPE | BSD-3-Clause | C | 14–18 | 25 |
| collection | 2.1.3 | Associative-array data types for high-performance PL/pgSQL workflows | TYPE | Apache-2.0 | C | 14–18 | 24 |
| bignum | 0.8.0 | Unlimited precision integers for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 23 |
| pgbitmap | 0.9.5 | Bitmap-type extension for PostgreSQL | TYPE | BSD-2-Clause | C | 10–18 | 23 |
| 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 |
| ccnumber | 1.0 | data type representing encrypted CC numbers | TYPE | — | C | — | 18 |
| pg_toolkit_brazil | 0.1 | Brazilian CPF and CNPJ types, validation, formatting, casts, and operators. | TYPE | BSD-3-Clause | C | — | 16 |
| wltree | 2.0 | data type for hierarchical tree-like structures with wide character support | TYPE | MIT | C | 10–17 | 16 |
| varint | 0.1.0 | A signed and unsigned 64 bit integer encoding scheme that saves disk space | TYPE | PostgreSQL | C | — | 15 |
| libversion | 2.0.0 | Version string comparison functions and versiontext type using libversion | TYPE | MIT | C | 10–16 | 14 |
| crockford | 0.8.34 | Crockford Base32 encoded unsigned integer data types | TYPE | PostgreSQL | C | 11 | 13 |
| pair | 0.1.2 | A key/value pair data type for PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 12 |
| iban | 1.1 | IBAN data type and validation functions for PostgreSQL | TYPE | GPL-3.0 | C++ | 14 | 11 |
| inetrange | 1.0.2 | Range type for PostgreSQL inet values with range operators and GiST indexing support. | TYPE | MIT | C | — | 11 |
| l10n_table_dependent_extension | 0.8.3 | PostgreSQL l10n toolbox | TYPE | PostgreSQL | SQL | 14–18 | 11 |
| numeral | 1.3 | numeral datatypes extension | TYPE | GPL-2.0 | C | 14–18 | 11 |
| pg_xenophile | 0.8.3 | More than the bare necessities for PostgreSQL i18n and l10n. | TYPE | PostgreSQL | SQL | 14–18 | 11 |
| cas_codes | 0.1.0 | CAS Registry Number data type and validation support for PostgreSQL. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| elements | 0.1.0 | Chemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |