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.

pipelinedb · Run continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL · 1.1.0 · Analytics · Apache-2.0 · C · Not packagedcstore_fdw · Columnar storage extension for PostgreSQL built as a foreign data wrapper · 1.7 · Analytics · Apache-2.0 · C · Not packagedpg_extension_base · Extension development kit by Snowflake · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_extension_updater · Automatic extension updater · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake · Data lake extension by Snowflake · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_copy · Copy to/from data lake files · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_engine · Query engine for data lake queries · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_iceberg · Iceberg implementation in Postgres · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_table · Data lake tables and Iceberg tables · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_map · Map type for PostgreSQL, bundled as a required pg_lake component. · 3.5 · Analytics · Apache-2.0 · C · Packagedinterconnect · One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database. · 1.0 · Analytics · Apache-2.0 · C · Not packagedpg_clickhouse · Interfaces to query ClickHouse databases from PostgreSQL · 0.10.0 · Analytics · Apache-2.0 · C++ · Packagedimcs · In-Memory Columnar Store extension for PostgreSQL. · 1.1 · Analytics · Apache-2.0 · C · Not packagedquack · DuckDB Embedded in Postgres · 0.0.1 · Analytics · Apache-2.0 · C · Not packagedchdb · Execute isolated chDB queries from PostgreSQL through a helper process · 0.1 · Analytics · Apache-2.0 · C · Not packagedpg_orca · ORCA query optimizer as a PostgreSQL extension · 1.0.0 · Analytics · Apache-2.0 · C++ · Packagedkoldstore · PostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes. · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_delta_am · Delta table access method skeleton · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_iceberg_am · Iceberg table developed by Robert Mu · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_lakebase_runtime · Shared runtime for Lakebase table access method extensions · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedshard_manager · SQL/PLpgSQL toolkit for schema-based sharding, shard maps, template-table cloning, and 64-bit distributed ID generation. · 0.0.1 · Analytics · Apache-2.0 · SQL · Not packagedpg_ocpm · Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. · 1.0.0 · Analytics · Apache-2.0 · C · Not packagedpg_tier · Tier PostgreSQL table data to external S3 storage through parquet_s3_fdw. · 0.0.5 · Analytics · Apache-2.0 · Rust · Not packagedpg_yaap · YAAP optimizer + executor integration prototype · 1.0 · Analytics · Apache-2.0 · C++ · Not packagedtab_tier · PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. · 1.1 · Analytics · Apache-2.0 · SQL · Not packaged

25 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pipelinedb 1.1.0 Run continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL OLAP Apache-2.0 C 10–11 2.7k
cstore_fdw 1.7 Columnar storage extension for PostgreSQL built as a foreign data wrapper OLAP Apache-2.0 C 10–12 1.8k
pg_extension_base 3.5 Extension development kit by Snowflake OLAP Apache-2.0 C 16–18 1.6k
pg_extension_updater 3.5 Automatic extension updater OLAP Apache-2.0 C 16–18 1.6k
pg_lake 3.5 Data lake extension by Snowflake OLAP Apache-2.0 C 16–18 1.6k
pg_lake_copy 3.5 Copy to/from data lake files OLAP Apache-2.0 C 16–18 1.6k
pg_lake_engine 3.5 Query engine for data lake queries OLAP Apache-2.0 C 16–18 1.6k
pg_lake_iceberg 3.5 Iceberg implementation in Postgres OLAP Apache-2.0 C 16–18 1.6k
pg_lake_table 3.5 Data lake tables and Iceberg tables OLAP Apache-2.0 C 16–18 1.6k
pg_map 3.5 Map type for PostgreSQL, bundled as a required pg_lake component. OLAP Apache-2.0 C 16–18 1.6k
interconnect 1.0 One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database. OLAP Apache-2.0 C 1.4k
pg_clickhouse 0.10.0 Interfaces to query ClickHouse databases from PostgreSQL OLAP Apache-2.0 C++ 14–18 280
imcs 1.1 In-Memory Columnar Store extension for PostgreSQL. OLAP Apache-2.0 C 202
quack 0.0.1 DuckDB Embedded in Postgres OLAP Apache-2.0 C 14–15 151
chdb 0.1 Execute isolated chDB queries from PostgreSQL through a helper process OLAP Apache-2.0 C 15–19 20
pg_orca 1.0.0 ORCA query optimizer as a PostgreSQL extension OLAP Apache-2.0 C++ 18 8
koldstore 0.1.0 PostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes. OLAP Apache-2.0 Rust 5
pg_delta_am 0.1.0 Delta table access method skeleton OLAP Apache-2.0 Rust 2
pg_iceberg_am 0.1.0 Iceberg table developed by Robert Mu OLAP Apache-2.0 Rust 2
pg_lakebase_runtime 0.1.0 Shared runtime for Lakebase table access method extensions OLAP Apache-2.0 Rust 2
shard_manager 0.0.1 SQL/PLpgSQL toolkit for schema-based sharding, shard maps, template-table cloning, and 64-bit distributed ID generation. OLAP Apache-2.0 SQL 1
pg_ocpm 1.0.0 Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. OLAP Apache-2.0 C 13–18
pg_tier 0.0.5 Tier PostgreSQL table data to external S3 storage through parquet_s3_fdw. OLAP Apache-2.0 Rust 14–16
pg_yaap 1.0 YAAP optimizer + executor integration prototype OLAP Apache-2.0 C++
tab_tier 1.1 PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. OLAP Apache-2.0 SQL 10–18