Clickhouse Js Node Troubleshooting

作者 ClickHouse2f6ec4b17a81無授權條款544 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫9 天前更新

Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client). Use this skill whenever a user reports errors, unexpected behavior, or configuration questions involving the Node.js client specifically — including socket hang-up errors, Keep-Alive problems, stream handling issues, data type mismatches, read-only user restrictions, proxy/TLS setup problems, or long-running query timeouts. Trigger even when the user hasn't precisely named the issue; vague symptoms like "my inserts keep failing" or "connection drops randomly" in a Node.js context are strong signals to use this skill. Do NOT use for browser/Web client issues.

僅含說明Software Development
AI 產生的概覽

排查並解決 ClickHouse Node.js 客戶端（@clickhouse/client）的常見錯誤與設定問題。

功能
此技能會把使用者回報的 ClickHouse Node.js 客戶端症狀對應到九個參考檔案，涵蓋 socket hang-up、資料型別不符、唯讀使用者、代理路徑名稱混淆、TLS、壓縮、記錄、查詢參數以及 FORMAT 子句錯誤。它引導代理先提出診斷再給出修正方式，標示版本限制，並只詢問缺少的資訊。產出是排查建議與說明，而非程式碼變更或檔案。
適用情境
當使用者回報涉及 ClickHouse Node.js 客戶端的錯誤、非預期行為或設定問題時使用，包括插入失敗、連線隨機中斷等模糊症狀。僅適用於 Node.js 執行環境（含 Next.js Node 執行環境），不適用於瀏覽器、邊緣執行環境或 @clickhouse/client-web。
執行需求
不需要指令碼，只有說明與參考 Markdown 檔案。對於依版本而異的修正，代理需要使用者提供客戶端版本，並可能查閱外部 ClickHouse 文件連結。

ClickHouse Node.js Client Troubleshooting

Reference: https://clickhouse.com/docs/integrations/javascript

⚠️ Node.js runtime only. This skill covers the @clickhouse/client package running in a Node.js runtime exclusively — including Next.js Node runtime API routes, React Server Components, Server Actions, and standard Node.js processes. Do not apply this skill to browser client components, Web Workers, Next.js Edge runtime, Cloudflare Workers, or any usage of @clickhouse/client-web. For browser/edge environments, the correct package is @clickhouse/client-web.

How to Use This Skill

  1. Identify the issue — match symptoms to the Issue Index below and read the corresponding reference file.
  2. Lead with the diagnosis — explain what's likely causing the issue before giving the fix.
  3. Note version constraints — flag if a fix requires a minimum client version and check it against what the user provided.
  4. Ask only what's missing — if the fix is version-dependent and you don't know their version, ask; otherwise help immediately.

Issue Index

Identify the user's issue from the list below and read the corresponding reference file for detailed troubleshooting steps.

IssueSymptomsReference file
Socket Hang-Up / ECONNRESETsocket hang up, ECONNRESET, intermittent connection drops, long-running queries timing outreference/socket-hangup.md
Data Type MismatchesLarge integers returned as strings, decimal precision loss, Date/DateTime insertion failures, CANNOT_PARSE_INPUT_ASSERTION_FAILED inserting a UUID into a UInt128 columnreference/data-types.md
Read-Only User ErrorsErrors when using response compression with readonly=1 usersreference/readonly-users.md
Proxy / Pathname URL ConfusionWrong database selected, requests failing behind a proxy with a path prefixreference/proxy-pathname.md
TLS / Certificate ErrorsTLS handshake failures, certificate verification issues, mutual TLS setupreference/tls.md
Compression Not WorkingGZIP compression not activating for requests or responsesreference/compression.md
Logging Not Showing AnythingNo log output, need custom logger integrationreference/logging.md
Query Parameters Not InterpolatedParameterized queries not working, SQL injection concernsreference/query-params.md
FORMAT Clause / SHOW POLICIES ErrorsSyntax error from a duplicate FORMAT, or SHOW [ROW] POLICIES failing even with a format providedreference/query-format-clause.md

Still Stuck?

來源與署名

來源：ClickHouse/agent-skills位於skills/clickhouse-js-node-troubleshooting提交2f6ec4b

授權條款： 無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

檢舉或申請下架

更多來自 ClickHouse/agent-skills 的技能

Clickhouse Managed Postgres Rca

ClickHouse

針對 ClickHouse 代管 Postgres 執行個體效能問題、以證據為基礎的根因分析工作流程。

DevOps & Cloud5449 天前更新

Clickhouse Best Practices

ClickHouse

依據 31 條最佳實務規則審查 ClickHouse 的結構定義、查詢與寫入策略。

Data & Analytics5449 天前更新

Clickhouse Architecture Advisor

ClickHouse

針對特定工作負載指導 ClickHouse 架構決策，並將每項建議標註為官方、推導或經驗。

Data & Analytics5449 天前更新

Chdb Sql

ClickHouse

Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ functions, Session for stateful multi-step pipelines, parametrized queries, and cross-source joins via `s3()`, `mysql()`, `postgresql()`, `iceberg()`, `deltaLake()`, `remoteSecure()` table functions. TRIGGER when: user wants SQL on parquet/csv/files or across remote analytical sources; uses ClickHouse SQL features (window functions, windowFunnel, geoToH3, JSON path ops, Session, parametrized queries); imports `chdb` or calls `chdb.query()`. SKIP this skill for pandas-style DataFrame method-chaining (use chdb-datastore instead) or ClickHouse server administration.

包含腳本
待分類5449 天前更新

Chdb Datastore

ClickHouse

使用 chdb DataStore 作為 pandas 的替代方案，以 ClickHouse 為底層查詢、合併與彙總表格資料。

包含腳本
Data & Analytics5449 天前更新

更多Software Development技能

Playground

anthropics

精選

建立自成一體的互動式 HTML 遊樂場，包含控制項、即時預覽與可複製的提示詞輸出。

Software Development37K今天更新

M5 Onboard

anthropics

精選

透過 USB 偵測 M5Stack ESP32 開發板，燒錄 UIFlow 2.0 韌體並安裝 MicroPython 應用程式套件。

Software Development37K今天更新

Cardputer Buddy

anthropics

精選

指導迭代 Cardputer-Adv 的 MicroPython 應用程式套件：新增應用程式、透過 USB 序列埠推送檔案、查看日誌並執行 REPL 指令。

Software Development37K今天更新

Dpop Adoption

google

精選

指導為 Google OAuth 平台實作 OAuth 2.0 DPoP（RFC 9449）傳送方約束的更新權杖。

Software Development21K今天更新

Gemini Live Api

google

精選

產生 Gemini Live API WebSocket 用戶端類別、測試、文件，以及用於雙向串流的示範介面。

Software Development21K今天更新

Gemini Api

google

精選

說明如何在 Google Agent Platform 上使用 Gen AI SDK 呼叫 Gemini API，涵蓋多種語言與多項功能。

Software Development21K今天更新