Installing extensions
To install an extension, connect to your database and run:Available extensions
Extensions built by ClickHouse are marked with ClickHouse and link to their descriptions below.pg_clickhouse extension
Thepg_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
Thechdb 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
Thepg_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
Thepg_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.