Help us improve
Share bugs, ideas, or general feedback.
From clickhouse-best-practices
Troubleshoots ClickHouse Node.js client issues: socket hang-ups, data type mismatches, read-only user errors, proxy/TLS setup, and query timeouts.
npx claudepluginhub clickhouse/agent-skills --plugin chdb-sqlHow this skill is triggered — by the user, by Claude, or both
Slash command
/clickhouse-best-practices:clickhouse-js-node-troubleshootingThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Reference: https://clickhouse.com/docs/integrations/javascript
Writes idiomatic application code using the ClickHouse Node.js client (@clickhouse/client). Covers client setup, inserts, selects, query parameters, sessions, temporary tables, data types, and JSON parsing for Node.js runtimes only.
Installs official ClickHouse Node.js (@clickhouse/client) or Python (clickhouse-connect) clients and configures authentication for Cloud or self-hosted instances with connection verification examples.
Diagnoses and fixes Supabase errors in PostgREST, PostgreSQL, Auth, Storage, and Realtime including PGRST codes, RLS violations, unique constraints, and auth failures.
Share bugs, ideas, or general feedback.
Reference: https://clickhouse.com/docs/integrations/javascript
⚠️ Node.js runtime only. This skill covers the
@clickhouse/clientpackage 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.
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 | 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 |