Set up docs MCPClickHouse 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:
CREATE EXTENSION extension_name;To see which extensions are currently installed:
SELECT * FROM pg_extension;To view all available extensions and their versions:
SELECT * FROM pg_available_extensions;Available extensions
| Extension | Version | Description |
|---|---|---|
address_standardizer |
3.6.3 | Used to parse an address into constituent elements |
address_standardizer_data_us |
3.6.3 | Address Standardizer US dataset example |
adminpack |
2.1 | Administrative functions for PostgreSQL (PG16 only) |
age |
1.7.0 | Apache AGE graph database extension |
amcheck |
Functions for verifying relation integrity | |
autoinc |
1.0 | Functions for auto-incrementing fields |
bloom |
1.0 | Bloom access method - signature file based index |
bool_plperl |
1.0 | Transform between bool and plperl |
bool_plperlu |
1.0 | Transform between bool and plperlu |
btree_gin |
1.3 | Support for indexing common datatypes in GIN |
btree_gist |
1.8 | Support for indexing common datatypes in GiST |
citext |
1.8 | Data type for case-insensitive character strings |
cube |
1.5 | Data type for multidimensional cubes |
dblink |
1.2 | Connect to other PostgreSQL databases from within a database |
dict_int |
1.0 | Text search dictionary template for integers |
dict_xsyn |
1.0 | Text search dictionary template for extended synonym processing |
earthdistance |
1.2 | Calculate great-circle distances on the surface of the Earth |
file_fdw |
1.0 | Foreign-data wrapper for flat file access |
fuzzystrmatch |
1.2 | Determine similarities and distance between strings |
h3 |
4.2.3 | H3 bindings for PostgreSQL |
h3_postgis |
4.2.3 | H3 PostGIS integration |
hll |
2.19 | Type for storing HyperLogLog data |
hstore |
1.8 | Data type for storing sets of (key, value) pairs |
hstore_plperl |
1.0 | Transform between hstore and plperl |
hstore_plperlu |
1.0 | Transform between hstore and plperlu |
hypopg |
1.4.2 | Hypothetical indexes for PostgreSQL |
intagg |
1.1 | Integer aggregator and enumerator (obsolete) |
insert_username |
1.0 | Functions for tracking who changed a table |
intarray |
1.5 | Functions, operators, and index support for 1-D arrays of integers |
ip4r |
2.4 | IPv4 and IPv6 range index types |
isn |
1.3 | Data types for international product numbering standards |
jsonb_plperl |
1.0 | Transform between jsonb and plperl |
jsonb_plperlu |
1.0 | Transform between jsonb and plperlu |
lo |
1.2 | Large Object maintenance |
ltree |
1.3 | Data type for hierarchical tree-like structures |
moddatetime |
1.0 | Functions for tracking last modification time |
mysql_fdw |
1.2 | Foreign data wrapper for querying a MySQL server |
old_snapshot |
1.0 | Utilities in support of old_snapshot_threshold (PG16 only) |
orafce |
4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
pageinspect |
1.13 | Inspect the contents of database pages at a low level |
pg_buffercache |
Examine the shared buffer cache | |
pg_clickhouse |
0.3 | Interfaces to query ClickHouse databases from PostgreSQL |
pg_cron |
1.6 | Job scheduler for PostgreSQL |
pg_freespacemap |
1.3 | Examine the free space map (FSM) |
pg_hint_plan |
Optimizer hints for PostgreSQL | |
pg_ivm |
1.13 | Incremental view maintenance on PostgreSQL |
pg_logicalinspect |
1.0 | Functions to inspect logical decoding components (PG18+) |
pg_partman |
5.4.3 | Extension to manage partitioned tables by time or ID |
pg_prewarm |
1.2 | Prewarm relation data |
pg_re2 |
0.1 | ClickHouse-compatible regular expression functions backed by Google’s RE2 |
pg_repack |
1.5.3 | Reorganize tables in PostgreSQL databases with minimal locks |
pg_similarity |
1.0 | Support similarity queries |
pg_stat_ch |
0.3 | Streams per-query execution telemetry to ClickHouse in real time |
pg_stat_statements |
Track planning and execution statistics of all SQL statements executed | |
pg_surgery |
1.0 | Extension to perform surgery on a damaged relation |
pg_tokenizer |
0.1.1 | Text tokenizer used with vchord_bm25 |
pg_trgm |
1.6 | Text similarity measurement and index searching based on trigrams |
pg_visibility |
1.2 | Examine the visibility map (VM) and page-level visibility info |
pg_walinspect |
1.1 | Functions to inspect contents of PostgreSQL Write-Ahead Log |
pgaudit |
Provides auditing functionality | |
pgcrypto |
1.4 | Cryptographic functions |
pglogical |
2.4.6 | PostgreSQL Logical Replication |
pglogical_origin |
1.0.0 | Dummy extension for compatibility when upgrading from Postgres 9.4 |
pgrouting |
4.0.1 | pgRouting Extension |
pgrowlocks |
1.2 | Show row-level locking information |
pgstattuple |
1.5 | Show tuple-level statistics |
pgtap |
1.3.4 | Unit testing for PostgreSQL |
plperl |
1.0 | PL/Perl procedural language |
plperlu |
1.0 | PL/PerlU untrusted procedural language |
plpgsql |
1.0 | PL/pgSQL procedural language |
plpgsql_check |
2.8 | Extended check for plpgsql functions |
postgis |
3.6.3 | PostGIS geometry and geography spatial types and functions |
postgis_raster |
3.6.3 | PostGIS raster types and functions |
postgis_sfcgal |
3.6.3 | PostGIS SFCGAL functions |
postgis_tiger_geocoder |
3.6.3 | PostGIS tiger geocoder and reverse geocoder |
postgis_topology |
3.6.3 | PostGIS topology spatial types and functions |
postgres_fdw |
1.2 | Foreign-data wrapper for remote PostgreSQL servers |
prefix |
1.2.0 | Prefix Range module for PostgreSQL |
refint |
1.0 | Functions for implementing referential integrity (obsolete) |
seg |
1.4 | Data type for representing line segments or floating-point intervals |
semver |
0.41.0 | Semantic version data type |
sslinfo |
1.2 | Information about SSL certificates |
tablefunc |
1.0 | Functions that manipulate whole tables, including crosstab |
tcn |
1.0 | Triggered change notifications |
tds_fdw |
2.0.5 | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
tsm_system_rows |
1.0 | TABLESAMPLE method which accepts number of rows as a limit |
tsm_system_time |
1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit |
uint |
Unsigned integer types | |
unaccent |
1.1 | Text search dictionary that removes accents |
unit |
7 | SI units extension |
uuid-ossp |
1.1 | Generate universally unique identifiers (UUIDs) |
vchord |
1.1.1 | Vector indexing access methods for Postgres |
vchord_bm25 |
0.3.0 | BM25 ranking access method for full-text search |
vector |
0.8.2 | Vector data type and ivfflat and hnsw access methods |
xml2 |
1.2 | XPath querying and XSLT |
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.
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.