frankchen021 avatar

Diagnose Clickhouse Errors

When a ClickHouse query blows up in production and you need to understand why at the database level, this skill walks you through a structured diagnosis. It extracts the numeric error code, loads reference material for that specific code, and gives you a three part answer: what caused it, how to fix it, and an example of the corrected query. The workflow explicitly steers you away if you're actually trying to trace application code that generated the query, pushing you toward source code inspection instead. It's narrow by design. DataStoria built this to short circuit the cycle of pasting error codes into documentation searches when you just want the database level fix, not a debugging session.

GitHub stars
320
last updated
May 14, 2026

Install

$ npx -y skills add frankchen021/datastoria --skill diagnose-clickhouse-errors --agent claude-code

Installs into .claude/skills of the current project.

Files

When Not To Use

Do not use this skill when the user's primary goal is:

  • investigating application or repository source code
  • tracing where failing SQL was constructed in code
  • finding code paths that produced the ClickHouse error

In those cases, prefer source-code-inspection. Do not start this skill's error-code intake flow unless the user is asking for database-level diagnosis.

Workflow

Sponsors

Details

Repository
github.com/frankchen021/datastoria
Categories
Backend & APIs, Debugging, Databases
First seen
Jun 11, 2026

More from frankchen021/datastoria

All 7
1getsentry avatargenerate-migrationgetsentry/sentryGenerate Django database migrations for Sentry. Use when creating migrations, adding/removing columns or tables, adding indexes, or resolving migration conflict0skills.sh installs
2ghostsecurity avatarghost-scan-codeghostsecurity/skillsGhost Security - SAST code scanner. Finds security vulnerabilities in source code by planning and executing targeted scans for issues like SQL injection, XSS, B0skills.sh installs
3hoangnguyen0403 avatarpentesthoangnguyen0403/agent-skills-standardPTES-aligned adversarial security audit for backend, frontend, and mobile applications. Produces a CVSS-scored Hacker Report with verified PoCs and phased remed0skills.sh installs
4hoangnguyen0403 avatarverify-workhoangnguyen0403/agent-skills-standardVerify feature, bug, UI, API, mobile, security, or deployment work against acceptance criteria.0skills.sh installs
5hoangsonww avatarmcp-operationshoangsonww/claude-code-agent-monitorOperate and maintain the local MCP server for this project. Use when creating MCP host config, troubleshooting tool connectivity, modifying tool domains, or adj0skills.sh installs
6https-deeplearning-ai avatargenerating-cli-testshttps-deeplearning-ai/sc-agent-skills-filesGenerate pytest tests for Typer CLI commands. Includes fixtures (temp_storage, sample_data), CliRunner patterns, confirmation handling (y/n/--force), and edge c0skills.sh installs