select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

timeflux · TimeFlux+: Advanced Time-Series Storage Engine · 1.0 · Time series · MulanPSL-2.0 · C++ · Not packagedpgrouting · pgRouting Extension · 4.0.2 · Geospatial · GPL-2.0 · C++ · Packagedeaggr · The OpenEAGGR software library is an implementation of a Discrete Global Grid System (DGGS) which models the Earth's surface as a network of equal area cells. · 2.0 · Geospatial · LGPL-3.0 · C++ · Not packagedvrprouting · Vehicle Routing Problems on the Database · 0.5.0 · Geospatial · GPL-2.0 · C++ · Not packagedmapcode · Mapcodes in PostgreSQL · 0.0.6 · Geospatial · PostgreSQL · C++ · Not packagedosrmint · PostgreSQL route OSRM integration · 0.1 · Geospatial · LGPL-3.0 · C++ · Not packagedpgtempus · Multimodal transport graph loading, routing, and isochrone functions. · 2.1 · Geospatial · LGPL-2.0-only · C++ · Not packagedpgtfs · PostgreSQL Extension for public transportation routing using GTFS · 0.0.4 · Geospatial · Unknown · C++ · Not packagedpgvroom · VROOM functionality reached from the database · 0.1.0 · Geospatial · GPL-2.0 · C++ · Not packagedpg_deeplake · Deeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training. · 1.0 · AI and vectors · Apache-2.0 · C++ · Not packagedvexdb_lite · A cross-platform vector database, which can be integrated into existing databases as a plugin. · 1.0 · AI and vectors · MIT · C++ · Not packagedogai · OGAI - AI vectorization and search framework for openGauss · 1.0 · AI and vectors · MulanPSL-2.0 · C++ · Not packagedmadlib · An open-source in-database analytics library · 2.1.0 · AI and vectors · Apache-2.0 · C++ · Not packagedpgdl · PostgreSQL extension for deep learning model inference and vector storage inside the database. · 1.3.0 · AI and vectors · Unknown · C++ · Not packagedpg_onnx · ONNX Runtime integrated with PostgreSQL. Perform ML inference with data in your database. · 1.2.1 · AI and vectors · MIT · C++ · Not packagedpg_ask · Postgres Extension which uses AI to create SQL from Natural language. · 1.0 · AI and vectors · MIT · C++ · Not packagedtlsh_gist · TLSH fuzzy-hash data type, distance operations, and GiST indexing for similarity search. · 1.0 · AI and vectors · Unknown · C++ · Not packagedai_toolkit · AI-powered query generation and explanation tools for PostgreSQL. · 1.0 · AI and vectors · Unknown · C++ · Not packagedpg_gen_query · A PostgreSQL extension written in C++ that adds no-maintenance GenAI querying functionality using Clickhouse's AI SDK · 1.0 · AI and vectors · MIT · C++ · Not packagedpg_ai_sdk · Translate natural language to SQL using Clickhouse ai-sdk-cpp · 1.0 · AI and vectors · Unknown · C++ · Not packagedpg_llm · Integrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features. · 1.1 · AI and vectors · PostgreSQL · C++ · Not packagedpg_jieba · Chinese full-text search parser based on cppjieba · 1.1.0 · Full-text search · BSD-3-Clause · C++ · Packagedpg_mystem · Runs Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries. · 1.0.1 · Full-text search · MIT · C++ · Not packagedjiebaparser · Postgresql full-text search extension for chinese (jiaba engine) using shared mem. · 1.0 · Full-text search · Apache-2.0 · C++ · Not packagedpg_cld2 · Detects likely human language and script in PostgreSQL using CLD2. · 1.0.0 · Full-text search · MIT · C++ · Not packagedjieba_parser · Jieba parser for full-text search. · 1.0 · Full-text search · Unknown · C++ · Not packagedpg_duckdb · DuckDB Embedded in Postgres · 1.1.1 · Analytics · MIT · C++ · Packagedpg_clickhouse · Interfaces to query ClickHouse databases from PostgreSQL · 0.10.0 · Analytics · Apache-2.0 · C++ · Packagedpg_ducklake · DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet · 1.0.0 · Analytics · MIT · C++ · Packagedfalcon · FalconFS is a high-performance distributed file system (DFS) designed for AI workloads. · 1.0 · Analytics · MulanPSL-2.0 · C++ · Not packagedyezzey · Offload Greenplum and Cloudberry append-only tables to S3 · 1.8.11 · Analytics · PostgreSQL · C++ · Not packagedpg_orca · ORCA query optimizer as a PostgreSQL extension · 1.0.0 · Analytics · Apache-2.0 · C++ · Packagedpg_yaap · YAAP optimizer + executor integration prototype · 1.0 · Analytics · Apache-2.0 · C++ · Not packagedspq · Spq Share-nothing parallel query · 2.0.0 · Analytics · AGPL-3.0 · C++ · Not packagedrdkit · Cheminformatics functionality for PostgreSQL. · 202503.6 · Features · BSD-3-Clause · C++ · Packagedhll · type for storing hyperloglog data · 2.21 · Features · Apache-2.0 · C++ · Packagedpg_ai_query · AI-powered SQL query generation for PostgreSQL · 0.1.1 · Features · Apache-2.0 · C++ · Packagedprovsql · Semiring provenance and probability management for PostgreSQL · 1.12.0 · Features · MIT · C++ · Packageddoom · DOOM in the terminal with curses · 0.0.1 · Features · Unknown · C++ · Not packagedbztree · BzTree index access method with equality operator classes for common PostgreSQL scalar types. · 1.0 · Features · Apache-2.0 · C++ · Not packagedcadfix · OCC interface implementation in JavaScript · 1.0 · Features · Unknown · C++ · Not packagedgraph_db · A PostgreSQL extension for graph-database usage · 1.0 · Features · Unknown · C++ · Not packagedpgchem_tigress · Legacy molecule types, chemical fingerprints, operators, and GiST indexing. · 3.2 · Features · LGPL-2.1-or-later · C++ · Not packagedribollita · Se non è zuppa, è pan bagnato. · 0.0 · Features · BSD-3-Clause · C++ · Not packagedplcoffee · CoffeeScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime · 3.1.10 · Procedural languages · PostgreSQL · C++ · Not packagedplls · LiveScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime · 3.1.10 · Procedural languages · PostgreSQL · C++ · Not packagedplv8 · PL/JavaScript (v8) trusted procedural language · 3.2.4 · Procedural languages · PostgreSQL · C++ · Packagedpg_libphonenumber · Adds a packed phone-number type and parsing functions backed by Google libphonenumber. · 0.1.0 · Data types · Apache-2.0 · C++ · Not packagediban · IBAN data type and validation functions for PostgreSQL · 1.1 · Data types · GPL-3.0 · C++ · Not packagedvpack · VelocyPack data type, path type, operators, casts, and JSON/BSON conversion support for PostgreSQL. · 0.1 · Data types · Unknown · C++ · Not packagedeigen · New array types and linear-algebra functions based on the Eigen numerical template library. · 1.1 · Data types · MIT · C++ · Not packagedcondaversion · Conda package version number data type implemented as a C++ PostgreSQL extension. · 1.0 · Data types · MIT · C++ · Not packagedpg_phonenumber · C++ libphonenumber-backed phone type, equality operators, and supported-region helpers · 1.0 · Data types · Unknown · C++ · Not packagedpostgres_protobuf · C++ functions for querying protobuf values stored as bytea and converting Protocol Buffers to and from their JSON representation. · 0.2 · Utilities · MIT · C++ · Not packagedpg_simdjson · Prototype SIMD-accelerated parser that converts JSON text to jsonb · 0.1 · Utilities · Apache-2.0 · C++ · Not packagedre2 · ClickHouse-compatible regex functions using RE2 · 0.4.1 · Utilities · PostgreSQL · C++ · Packagedpg_consul · C++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs. · 0.1.0 · Utilities · PostgreSQL · C++ · Not packagedcompress · C/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them. · 0.0.2 · Utilities · GPL-3.0 · C++ · Not packagedpg_wthtmltopdf · Render HTML into PDF from a PostgreSQL function. · 1.0 · Utilities · MIT · C++ · Not packagedpg_zerialize · Binary serialization and deserialization for MessagePack, CBOR, ZERA, FlexBuffers, Ion, BSON, and BEVE. · 1.12 · Utilities · MIT · C++ · Not packageddatasketches · Approximate analytics sketches and aggregates for PostgreSQL · 1.7.0 · Functions and aggregates · Apache-2.0 · C++ · Packagedmoss_uuidgen · Generates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type · 1.0 · Functions and aggregates · GPL-3.0 · C++ · Not packagednumpgsql · Array and numerical computing library for PostgreSQL · 0.0.1 · Functions and aggregates · MIT · C++ · Not packagedpg_libnumbertext · Converts numbers to words in multiple languages through libnumbertext. · 0.1.0 · Functions and aggregates · BSD-3-Clause · C++ · Not packagedpg_json_diff · JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL · 1.0 · Functions and aggregates · MIT · C++ · Not packagedstringtheory · C++ extension providing SIMD-optimized exact equality and substring-search functions for PostgreSQL text values. · 1.0.2 · Functions and aggregates · PostgreSQL · C++ · Not packagedpg_stat_ch · Export PostgreSQL query telemetry to ClickHouse · 0.4 · Monitoring · Apache-2.0 · C++ · Packagedpgotel · PostgreSQL extension exposing OpenTelemetry functionality for other extensions. · 1.0 · Monitoring · Apache-2.0 · C++ · Not packagedpg_oidc_validator · OAuth and OIDC token validator for PostgreSQL 18 · 1.1.0 · Security · Apache-2.0 · C++ · Packagedpg_fhe · Microsoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL. · 0.1 · Security · Unknown · C++ · Not packagedparquet_fdw · Read-only foreign data wrapper for Apache Parquet files · 0.2 · Foreign data wrappers · PostgreSQL · C++ · Not packagedclickhouse_fdw · ClickHouse foreign data wrapper for PostgreSQL · 1.4 · Foreign data wrappers · Apache-2.0 · C++ · Not packagedparquet_s3_fdw · Foreign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL. · 0.3 · Foreign data wrappers · PostgreSQL · C++ · Not packagedkv_fdw · Foreign data wrapper for key-value storage backed by RocksDB/VidarDB. · 0.0.1 · Foreign data wrappers · Apache-2.0 · C++ · Not packagedlsm · RocksDB foreign data wrapper for PostgreSQL · 0.1 · Foreign data wrappers · Apache-2.0 · C++ · Not packagedlevel_pivot · LevelDB FDW with support for pivoting and key templating · 1.0 · Foreign data wrappers · GPL-3.0 · C++ · Not packagedgms_raw · process raw type data for PL/SQL applications · 1.0 · Compatibility · MulanPSL-2.0 · C++ · Not packagedgms_tcp · provides TCP/IP client=side access functionality in PL/SQL · 1.1 · Compatibility · MulanPSL-2.0 · C++ · Not packagedshark · extension for D compatibility · 2.0 · Compatibility · MulanPSL-2.0 · C++ · Not packagedpipeline_kinesis · Consume Amazon Kinesis streams into PipelineDB streams with dynamic background workers and persisted shard positions · 0.9.0 · Replication and streams · GPL-3.0 · C++ · Not packagedcopy_parquet · PoC to support PostgreSQL COPY with Apache Parquet · 0.0.1 · Replication and streams · Apache-2.0 · C++ · Not packaged

81 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_deeplake 1.0 Deeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training. RAG Apache-2.0 C++ 9.2k
rdkit 202503.6 Cheminformatics functionality for PostgreSQL. FEAT BSD-3-Clause C++ 14–18 3.6k
pg_duckdb 1.1.1 DuckDB Embedded in Postgres OLAP MIT C++ 14–18 3.2k
vexdb_lite 1.0 A cross-platform vector database, which can be integrated into existing databases as a plugin. RAG MIT C++ 2.4k
plcoffee 3.1.10 CoffeeScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime LANG PostgreSQL C++ 10–16 2.1k
plls 3.1.10 LiveScript procedural language for PostgreSQL, compiled and executed by the PL/v8 runtime LANG PostgreSQL C++ 10–16 2.1k
plv8 3.2.4 PL/JavaScript (v8) trusted procedural language LANG PostgreSQL C++ 14–18 2.1k
pgrouting 4.0.2 pgRouting Extension GIS GPL-2.0 C++ 14–18 1.4k
hll 2.21 type for storing hyperloglog data FEAT Apache-2.0 C++ 14–18 1.2k
gms_raw 1.0 process raw type data for PL/SQL applications SIM MulanPSL-2.0 C++ 784
gms_tcp 1.1 provides TCP/IP client=side access functionality in PL/SQL SIM MulanPSL-2.0 C++ 784
ogai 1.0 OGAI - AI vectorization and search framework for openGauss RAG MulanPSL-2.0 C++ 784
madlib 2.1.0 An open-source in-database analytics library RAG Apache-2.0 C++ 475
pg_jieba 1.1.0 Chinese full-text search parser based on cppjieba FTS BSD-3-Clause C++ 14–18 420
parquet_fdw 0.2 Read-only foreign data wrapper for Apache Parquet files FDW PostgreSQL C++ 10–16 387
pg_clickhouse 0.10.0 Interfaces to query ClickHouse databases from PostgreSQL OLAP Apache-2.0 C++ 14–18 280
clickhouse_fdw 1.4 ClickHouse foreign data wrapper for PostgreSQL FDW Apache-2.0 C++ 11–17 275
pg_ai_query 0.1.1 AI-powered SQL query generation for PostgreSQL FEAT Apache-2.0 C++ 14–18 247
parquet_s3_fdw 0.3 Foreign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL. FDW PostgreSQL C++ 13–17 241
kv_fdw 0.0.1 Foreign data wrapper for key-value storage backed by RocksDB/VidarDB. FDW Apache-2.0 C++ 13 131
pg_ducklake 1.0.0 DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet OLAP MIT C++ 14–18 130
postgres_protobuf 0.2 C++ functions for querying protobuf values stored as bytea and converting Protocol Buffers to and from their JSON representation. UTIL MIT C++ 11–18 130
pg_stat_ch 0.4 Export PostgreSQL query telemetry to ClickHouse STAT Apache-2.0 C++ 16–18 123
datasketches 1.7.0 Approximate analytics sketches and aggregates for PostgreSQL FUNC Apache-2.0 C++ 14–18 96
pg_libphonenumber 0.1.0 Adds a packed phone-number type and parsing functions backed by Google libphonenumber. TYPE Apache-2.0 C++ 96
provsql 1.12.0 Semiring provenance and probability management for PostgreSQL FEAT MIT C++ 14–18 73
falcon 1.0 FalconFS is a high-performance distributed file system (DFS) designed for AI workloads. OLAP MulanPSL-2.0 C++ 66
pgdl 1.3.0 PostgreSQL extension for deep learning model inference and vector storage inside the database. RAG C++ 12 63
pg_onnx 1.2.1 ONNX Runtime integrated with PostgreSQL. Perform ML inference with data in your database. RAG MIT C++ 13–18 62
doom 0.0.1 DOOM in the terminal with curses FEAT C++ 49
yezzey 1.8.11 Offload Greenplum and Cloudberry append-only tables to S3 OLAP PostgreSQL C++ 40
eaggr 2.0 The OpenEAGGR software library is an implementation of a Discrete Global Grid System (DGGS) which models the Earth's surface as a network of equal area cells. GIS LGPL-3.0 C++ 39
pg_oidc_validator 1.1.0 OAuth and OIDC token validator for PostgreSQL 18 SEC Apache-2.0 C++ 18 35
vrprouting 0.5.0 Vehicle Routing Problems on the Database GIS GPL-2.0 C++ 31
lsm 0.1 RocksDB foreign data wrapper for PostgreSQL FDW Apache-2.0 C++ 11–13 26
pg_simdjson 0.1 Prototype SIMD-accelerated parser that converts JSON text to jsonb UTIL Apache-2.0 C++ 22
re2 0.4.1 ClickHouse-compatible regex functions using RE2 UTIL PostgreSQL C++ 16–18 19
pg_fhe 0.1 Microsoft SEAL-backed CKKS operations over encrypted values stored in PostgreSQL. SEC C++ 18
iban 1.1 IBAN data type and validation functions for PostgreSQL TYPE GPL-3.0 C++ 14 11
pipeline_kinesis 0.9.0 Consume Amazon Kinesis streams into PipelineDB streams with dynamic background workers and persisted shard positions ETL GPL-3.0 C++ 10
pg_orca 1.0.0 ORCA query optimizer as a PostgreSQL extension OLAP Apache-2.0 C++ 18 8
pgotel 1.0 PostgreSQL extension exposing OpenTelemetry functionality for other extensions. STAT Apache-2.0 C++ 8
bztree 1.0 BzTree index access method with equality operator classes for common PostgreSQL scalar types. FEAT Apache-2.0 C++ 6
pg_mystem 1.0.1 Runs Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries. FTS MIT C++ 6
jiebaparser 1.0 Postgresql full-text search extension for chinese (jiaba engine) using shared mem. FTS Apache-2.0 C++ 5
cadfix 1.0 OCC interface implementation in JavaScript FEAT C++ 4
pg_ask 1.0 Postgres Extension which uses AI to create SQL from Natural language. RAG MIT C++ 16–18 4
tlsh_gist 1.0 TLSH fuzzy-hash data type, distance operations, and GiST indexing for similarity search. RAG C++ 4
mapcode 0.0.6 Mapcodes in PostgreSQL GIS PostgreSQL C++ 10–18 3
moss_uuidgen 1.0 Generates UUIDs for moss. We use this because there was no UUID type when moss was written, and I do not want to rewrite moss to use pgsql's uuid type FUNC GPL-3.0 C++ 3