Agent Skills › vemetric/vemetric › clickhouse-js-node-troubleshooting

clickhouse-js-node-troubleshooting

GitHub

用于排查和解决 ClickHouse Node.js 客户端(@clickhouse/client)的常见问题,如连接断开、数据类型不匹配、只读用户错误及 TLS/代理配置问题。

.agents/skills/clickhouse-js-node-troubleshooting/SKILL.md vemetric/vemetric

触发场景

用户报告 Node.js 环境下 ClickHouse 客户端报错或异常行为 涉及 socket hang-up、Keep-Alive、流处理或数据格式问题的咨询

安装

npx skills add vemetric/vemetric --skill clickhouse-js-node-troubleshooting -g -y
更多选项

非标准路径

npx skills add https://github.com/vemetric/vemetric/tree/main/.agents/skills/clickhouse-js-node-troubleshooting -g -y

不安装直接使用

npx skills use vemetric/vemetric@clickhouse-js-node-troubleshooting

指定 Agent (Claude Code)

npx skills add vemetric/vemetric --skill clickhouse-js-node-troubleshooting -a claude-code -g -y

安装 repo 全部 skill

npx skills add vemetric/vemetric --all -g -y

预览 repo 内 skill

npx skills add vemetric/vemetric --list

SKILL.md

Frontmatter
{
    "name": "clickhouse-js-node-troubleshooting",
    "description": "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."
}

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.

Issue Symptoms Reference file
Socket Hang-Up / ECONNRESET socket hang up, ECONNRESET, intermittent connection drops, long-running queries timing out reference/socket-hangup.md
Data Type Mismatches Large integers returned as strings, decimal precision loss, Date/DateTime insertion failures, CANNOT_PARSE_INPUT_ASSERTION_FAILED inserting a UUID into a UInt128 column reference/data-types.md
Read-Only User Errors Errors when using response compression with readonly=1 users reference/readonly-users.md
Proxy / Pathname URL Confusion Wrong database selected, requests failing behind a proxy with a path prefix reference/proxy-pathname.md
TLS / Certificate Errors TLS handshake failures, certificate verification issues, mutual TLS setup reference/tls.md
Compression Not Working GZIP compression not activating for requests or responses reference/compression.md
Logging Not Showing Anything No log output, need custom logger integration reference/logging.md
Query Parameters Not Interpolated Parameterized queries not working, SQL injection concerns reference/query-params.md
FORMAT Clause / SHOW POLICIES Errors Syntax error from a duplicate FORMAT, or SHOW [ROW] POLICIES failing even with a format provided reference/query-format-clause.md

Still Stuck?

版本历史

  • 4e8800b 当前 2026-09-28 16:05

同 Skill 集合

.agents/skills/clickhouse-architecture-advisor/SKILL.md
.agents/skills/clickhouse-best-practices/SKILL.md
.agents/skills/clickhouse-js-node-coding/SKILL.md
.agents/skills/infra-clickhouse/SKILL.md
.agents/skills/redis-clustering/SKILL.md
.agents/skills/redis-connections/SKILL.md
.agents/skills/redis-core/SKILL.md
.agents/skills/redis-observability/SKILL.md
.agents/skills/redis-security/SKILL.md
.agents/skills/chdb-datastore/SKILL.md
.agents/skills/chdb-sql/SKILL.md
.agents/skills/redis-search/SKILL.md

元信息

文件数
0
版本
2c917f7
Hash
a289008f
收录时间
2026-09-28 16:05

首页 - Wiki
Copyright © 2011-2026 iteam. Current version is 2.156.0. UTC+08:00, 2026-11-21 16:28
浙ICP备14020137号-1