---
title: "ClickHouse Agents is now available for Managed Postgres"
description: "ClickHouse Agents is now available for all Managed Postgres services in ClickHouse Cloud, extending its plain-English agent interface to operational data. The beta service, powered by Claude and built on LibreChat, combines an agent builder and chat interface with a sandboxed code interpreter; it is read-only by default and supports MCP-compatible systems. Agents can inspect Postgres schemas, run read-only queries, return the SQL used, and reason across Postgres and ClickHouse by querying each engine independently before merging results. Additional skills guide migration from Postgres to ClickHouse through discovery, access-pattern analysis, schema design, type mapping, CDC ingestion, and validation, while other workflows use metrics, Query Insights, and EXPLAIN to rank performance fixes. Planned extensions include scheduled recommendations and safe automated remediation, but the current release focuses on exploration, analysis, monitoring, and guided database work."
---

# ClickHouse Agents is now available for Managed Postgres

[Clickhouse](https://yomu.fyi/company/clickhouse) · Jul 2, 2026

**Type:** Announcement

## Summary

ClickHouse Agents is now available for all Managed Postgres services in ClickHouse Cloud, extending its plain-English agent interface to operational data. The beta service, powered by Claude and built on LibreChat, combines an agent builder and chat interface with a sandboxed code interpreter; it is read-only by default and supports MCP-compatible systems. Agents can inspect Postgres schemas, run read-only queries, return the SQL used, and reason across Postgres and ClickHouse by querying each engine independently before merging results. Additional skills guide migration from Postgres to ClickHouse through discovery, access-pattern analysis, schema design, type mapping, CDC ingestion, and validation, while other workflows use metrics, Query Insights, and EXPLAIN to rank performance fixes. Planned extensions include scheduled recommendations and safe automated remediation, but the current release focuses on exploration, analysis, monitoring, and guided database work.

## Context

ClickHouse Agents was previously available for data in ClickHouse Cloud, and this release extends the agentic experience to Managed Postgres. The stated motivation is to let teams explore operational data, combine OLTP and OLAP information, monitor and tune databases, and support migrations from Postgres to ClickHouse through a unified data stack.

## Approach / What changed

The service connects agents directly to Managed Postgres using tools including run\_postgres\_select\_query, get\_postgres\_metrics, and list\_postgres\_slow\_query\_patterns. Agents parse schemas, execute read-only queries, combine independent Postgres and ClickHouse results, and use skills for migration or performance tuning. The migration workflow covers discovery, access-pattern analysis, ClickHouse schema design, type mapping, CDC ingestion, and validation; tuning uses Query Insights, EXPLAIN, and service metrics.

## Takeaways

- Managed Postgres agents are read-only by default and return the SQL used for plain-English questions, allowing operational data exploration without changing data.
- An agent can query Postgres and ClickHouse independently, align the results, and answer requests spanning transactional and analytical data.
- The migration skill covers Postgres-to-ClickHouse discovery, data modeling, type mapping, ClickPipes or PeerDB CDC ingestion, and validation.

**Tags:** [LLMs](https://yomu.fyi/topic/llm), [Migrations](https://yomu.fyi/topic/migration), [Monitoring](https://yomu.fyi/topic/monitoring), [Performance](https://yomu.fyi/topic/performance), [Postgres](https://yomu.fyi/topic/postgres)

- Source: [Clickhouse](https://clickhouse.com/blog/clickhouse-agents-managed-postgres)
- Source URL: https://clickhouse.com/blog/clickhouse-agents-managed-postgres
- Ingested by Yomu: 2026-08-29T01:37:34.656Z

[Read original post](https://clickhouse.com/blog/clickhouse-agents-managed-postgres)