clickhouse-upgrade-migration

Featured

Upgrade ClickHouse server versions and @clickhouse/client SDK safely. Use when upgrading ClickHouse, handling breaking changes between versions, or migrating from older client libraries. Trigger: "upgrade clickhouse", "clickhouse version upgrade", "update clickhouse client", "clickhouse breaking changes", "new clickhouse version".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# ClickHouse Upgrade & Migration ## Overview Safely upgrade ClickHouse server and the `@clickhouse/client` Node.js SDK, with rollback procedures and breaking change detection. ## Prerequisites - Current ClickHouse version known (`SELECT version()`) - Git for version control - Test suite for integration validation - Staging environment for pre-production testing ## Instructions ### Step 1: Check Current Versions ```bash # Check server version (via HTTP) curl 'http://localhost:8123/?query=SELECT+version()' # Check Node.js client version npm list @clickhouse/client # Check latest available npm view @clickhouse/client version ``` ```sql -- Server-side version details SELECT version() AS server_version, uptime() AS uptime_sec, currentDatabase() AS current_db; ``` ### Step 2: Review Changelog ```bash # View release notes open https://github.com/ClickHouse/clickhouse-js/releases # Server changelog open https://github.com/ClickHouse/ClickHouse/blob/master/CHANGELOG.md ``` **Key breaking changes to watch for:** - Client API signature changes (`createClient` options) - Default setting changes (compression, timeouts) - New query result format behavior - Deprecated SQL functions removed in server upgrades - MergeTree settings renamed or defaults changed ### Step 3: Upgrade the Node.js Client ```bash git checkout -b upgrade/clickhouse-client npm install @clickhouse/client@latest npm test ``` **Common migration patterns:** ```typescript ...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category