Skip to main content
ClickHouse Managed Postgres includes a curated set of extensions to extend the functionality of your database. Below is the list of available extensions.

Installing extensions

To install an extension, connect to your database and run:
To see which extensions are currently installed:
To view all available extensions and their versions:

Available extensions

Extensions built by ClickHouse are marked with ClickHouse and link to their descriptions below.

pg_clickhouse extension

The pg_clickhouse extension is pre-installed on every ClickHouse Managed Postgres instance. It allows you to query ClickHouse databases directly from PostgreSQL, enabling a unified query layer for both transactions and analytics. See the pg_clickhouse documentation for setup instructions and usage details.

chdb extension

The chdb extension, from the pg_chdb project, embeds chDB, the in-process ClickHouse engine, in ClickHouse Managed Postgres. It allows you to run ClickHouse queries directly from PostgreSQL, and its chdb_hook module extends COPY to import and export data in formats such as Parquet, CSV, and TSV to and from S3, GCS, Azure Blob Storage, and HTTP URLs. See the chdb reference to run ClickHouse queries from PostgreSQL, or the chdb_hook reference to import and export data with COPY.

pg_stat_ch extension

The pg_stat_ch extension powers query-level observability for your ClickHouse Managed Postgres instance. It captures per-query telemetry (timings, rows, buffers, WAL, errors) and ships it into the ClickHouse Cloud UI, where it surfaces as the slow-query, error, and workload views. No setup required.

pg_re2 extension

The pg_re2 extension adds ClickHouse-compatible regex functions to ClickHouse Managed Postgres, backed by Google’s RE2 engine. Useful when porting queries between the two or running hybrid workloads that need identical pattern-matching semantics on both sides.