Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
136 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| emailaddr | 0 | Email address type for PostgreSQL | TYPE | — | C | 14–18 | 46 |
| 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 |
| inetrange | 1.0.2 | Range type for PostgreSQL inet values with range operators and GiST indexing support. | TYPE | MIT | C | — | 11 |
| numeral | 1.3 | numeral datatypes extension | TYPE | GPL-2.0 | C | 14–18 | 11 |
| pg_thrift | 1.0 | Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. | TYPE | — | C | 10–11 | 10 |
| country | 0.0.3 | Country data type, ISO 3166-1 | TYPE | PostgreSQL | C | 14–18 | 9 |
| datalink | 0.5.0 | SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 9 |
| md5hash | 1.0.1 | type for storing 128-bit binary data inline | TYPE | BSD-2-Clause | C | 14–18 | 9 |
| telephone | 0.0.1 | PostgreSQL data type for normalized telephone numbers with dialing-plan validation. | TYPE | PostgreSQL | C | 10–18 | 8 |
| cbor | 0.1.0 | Concise Binary Object Representation data type for PostgreSQL. | TYPE | PostgreSQL | C | 10–18 | 7 |
| hashtypes | 0.1.5 | sha1, md5 and other data types for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 7 |
| intpair | 0.2 | Packed int64pair data type with comparison, hash, and index operator support. | TYPE | Apache-2.0 | C | — | 7 |
| 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 |
| pgbrtypes | 1.0 | Brazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support | TYPE | — | C | 10–18 | 7 |