--- title: What's new in clickhousectl v0.5.0 | daily.dev description: clickhousectl v0.5.0 adds an end-to-end UDF workflow, local to Cloud with one command, and new ClickHouse Managed Postgres observability. New Postgres commands... canonical: https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: What's new in clickhousectl v0.5.0 | daily.dev og:description: clickhousectl v0.5.0 adds an end-to-end UDF workflow, local to Cloud with one command, and new ClickHouse Managed Postgres observability. New Postgres commands... og:url: https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv og:image: https://api.daily.dev/og/posts/jyI34SOrV.png og:image:alt: What's new in clickhousectl v0.5.0 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # What's new in clickhousectl v0.5.0 **[ClickHouse](https://daily.dev/sources/clickhouse)** · 12 min read · 0 upvotes · 0 comments ## Summary clickhousectl v0.5.0 adds an end-to-end UDF workflow, local to Cloud with one command, and new ClickHouse Managed Postgres observability. New Postgres commands cover metrics, server logs, slow-query patterns, read-only SQL over HTTP, and IP allow rules. The release also standardizes the command surface with uniform selectors, global org selection, and JSON errors everywhere, though some of these changes are breaking. BigQuery CDC ClickPipes now support continuous replication on an interval or cron schedule, saved queries are GA with Query API endpoints, and ClickStack management arrives in the CLI. Every Cloud command's help now lists the API-key permissions it needs. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What breaking changes are in clickhousectl v0.5.0? Several breaking changes ship in clickhousectl v0.5.0: the rename flag on update commands changes from --name to --new-name (--name now selects the target), org commands require --org-id/--org-name instead of a positional ID, ClickPipe schema-discover argument order changes, native client flags must follow --, --wait/--wait-timeout is removed from postgres promote/switchover, GCP Postgres size names change (e.g. c4-standard-4 becomes c4-standard-lssd-4), and --encryption-key/--encryption-role are removed from service create. Old forms fail with a usage error (exit code 2) rather than being silently reinterpreted. _Check daily.dev before upgrading clickhousectl so these breaking flag changes don't silently break your scripts._ ### How do I create and deploy a user-defined function with clickhousectl? Run 'clickhousectl local udf init my_udf' to scaffold a UDF directory with a udf.json definition and a Python script or native amd64/arm64 binaries. Test it locally with 'clickhousectl local udf deploy my_udf' and query it via SQL. Once it works, 'clickhousectl cloud udf deploy my_udf --service ' packages the directory, creates the UDF or a new version, attaches it to the service, and wakes the service in one step. _Developers building ClickHouse UDFs can track CLI workflow changes like this on daily.dev._ ### Can I query ClickHouse Managed Postgres slow queries from the command line? Yes, 'clickhousectl cloud postgres slow-queries list ' lists normalized query patterns sorted by total, average, p95, or p99 duration, along with CPU, rows, and WAL data, filterable by a date range with --from-date and --to-date. The 'get' subcommand then shows one pattern's recent executions, and 'postgres prometheus' exposes the raw Prometheus endpoint for existing scraping setups. _Engineers debugging slow Postgres queries can keep up with tooling like this via daily.dev._ ## Similar posts on daily.dev - [clickhousectl v0.2.0: Postgres, ClickPipes and more](https://daily.dev/posts/clickhousectl-v0-2-0-postgres-clickpipes-and-more-6avhbbscz) · ClickHouse · 3 upvotes · 0 comments - [Introducing clickhousectl: the CLI for ClickHouse local and cloud \(beta\)](https://daily.dev/posts/introducing-clickhousectl-the-cli-for-clickhouse-local-and-cloud-beta--l18y28nsn) · ClickHouse · 2 upvotes · 0 comments - [Comparing ClickHouse versions with clickhousectl](https://daily.dev/posts/comparing-clickhouse-versions-with-clickhousectl-72srzkrtz) · ClickHouse · 0 upvotes · 0 comments - [pg\_clickhouse 0.3.1: Now With More C](https://daily.dev/posts/pg-clickhouse-0-3-1-now-with-more-c-h3naoiqtg) · Planet PostgreSQL · 1 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#cli](https://daily.dev/tags/cli), [#observability](https://daily.dev/tags/observability), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"What's new in clickhousectl v0.5.0","url":"https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv"},"datePublished":"2026-11-02T14:47:51.103Z","dateModified":"2026-11-02T14:48:27.258Z","description":"clickhousectl v0.5.0 adds an end-to-end UDF workflow, local to Cloud with one command, and new ClickHouse Managed Postgres observability. New Postgres commands...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/acced5d30acbdc369167ff9657eb9d8c?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/acced5d30acbdc369167ff9657eb9d8c?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"postgresql,cli,observability,clickhouse","timeRequired":"PT12M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"What's new in clickhousectl v0.5.0"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/what-s-new-in-clickhousectl-v0-5-0-jyi34sorv#faq","mainEntity":[{"@type":"Question","name":"What breaking changes are in clickhousectl v0.5.0?","acceptedAnswer":{"@type":"Answer","text":"Several breaking changes ship in clickhousectl v0.5.0: the rename flag on update commands changes from --name to --new-name (--name now selects the target), org commands require --org-id/--org-name instead of a positional ID, ClickPipe schema-discover argument order changes, native client flags must follow --, --wait/--wait-timeout is removed from postgres promote/switchover, GCP Postgres size names change (e.g. c4-standard-4 becomes c4-standard-lssd-4), and --encryption-key/--encryption-role are removed from service create. Old forms fail with a usage error (exit code 2) rather than being silently reinterpreted. Check daily.dev before upgrading clickhousectl so these breaking flag changes don't silently break your scripts."}},{"@type":"Question","name":"How do I create and deploy a user-defined function with clickhousectl?","acceptedAnswer":{"@type":"Answer","text":"Run 'clickhousectl local udf init my_udf' to scaffold a UDF directory with a udf.json definition and a Python script or native amd64/arm64 binaries. Test it locally with 'clickhousectl local udf deploy my_udf' and query it via SQL. Once it works, 'clickhousectl cloud udf deploy my_udf --service \u003cservice-id\u003e' packages the directory, creates the UDF or a new version, attaches it to the service, and wakes the service in one step. Developers building ClickHouse UDFs can track CLI workflow changes like this on daily.dev."}},{"@type":"Question","name":"Can I query ClickHouse Managed Postgres slow queries from the command line?","acceptedAnswer":{"@type":"Answer","text":"Yes, 'clickhousectl cloud postgres slow-queries list \u003cpostgres-id\u003e' lists normalized query patterns sorted by total, average, p95, or p99 duration, along with CPU, rows, and WAL data, filterable by a date range with --from-date and --to-date. The 'get' subcommand then shows one pattern's recent executions, and 'postgres prometheus' exposes the raw Prometheus endpoint for existing scraping setups. Engineers debugging slow Postgres queries can keep up with tooling like this via daily.dev."}}]} ```