# Introducing pg\_clickhouse: A Postgres extension for querying ClickHouse

DevFeed: [Introducing pg\_clickhouse: A Postgres extension for querying ClickHouse](<https://devfeed.tech/articles/introducing-pg-clickhouse-a-postgres-extension-for-querying-clickhouse-5335.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/introducing-pg_clickhouse>)

Author: David Wheeler

Published: 2025-12-10T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Extension](<https://devfeed.tech/topics/extension.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [docker](<https://devfeed.tech/tags/docker.md>), [follow](<https://devfeed.tech/tags/follow.md>), [migration](<https://devfeed.tech/tags/migration.md>), [observability](<https://devfeed.tech/tags/observability.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

The article introduces pg_clickhouse v0.1.0, an Apache 2-licensed PostgreSQL extension that transparently executes analytics queries on ClickHouse from PostgreSQL. It aims to simplify migrations by allowing existing PostgreSQL queries to run unmodified while pushing execution to ClickHouse.

## Source excerpt

Today, we're pleased to release pg_clickhouse, an Apache 2-licensed PostgreSQL extension to transparently execute analytics queries on ClickHouse directly from PostgreSQL.