debug-clickhouse-queries

Investigate query evaluation failures in the Knowledge Graph synthetic data pipeline. Use when queries fail or return unexpected results after running the evaluate binary.

1.10x

Quality

76%

Does it follow best practices?

Impact

84%

1.10x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./.claude/skills/debug-clickhouse-queries/SKILL.md

Evaluation results

88%

11%

Debugging Empty Query Results in the Knowledge Graph Pipeline

Diagnose failing eval queries from evaluation report

Criteria

Without context

With context

UNKNOWN_COLUMN categorization

100%

Column name mismatch diagnosis

100%

Global sampling interpretation

12%

50%

Path-scoped vs global distinction

62%

100%

Sampling vs predicate hypothesis

75%

100%

Global count diagnostic SQL

87%

100%

Path entity count SQL

100%

orbit query command usage

62%

100%

MERGED edge direction

25%

DESCRIBE TABLE diagnostic

100%

Prioritized fix list

100%

Edge type verification SQL

87%

100%

96%

Knowledge Graph Data Quality Investigation

Diagnose garbage enum values in synthetic data generation

Criteria

Without context

With context

Garbage enum identification

100%

Root cause: fake_data.rs fallback

60%

100%

field.enum_values check

90%

100%

Both enum type variants

100%

Ontology values identified

100%

Verification SQL: state check

100%

Verification SQL: user_type check

100%

Ontology file location

50%

No sampling issue misdiagnosis

100%

Evidence from sample data

100%

70%

Edge Coverage Analysis for Knowledge Graph Queries

Diagnose edge direction and cardinality issues

Criteria

Without context

With context

Person-is-source convention

83%

100%

Query direction fix

100%

AUTHORED per-target cardinality

40%

50%

AUTHORED per-target vs per-source diagnosis

41%

50%

AUTHORED cardinality fix

30%

50%

MERGED edge count assessment

Edge count verification SQL

75%

87%

Simulator.yaml fix specification

30%

50%

Query JSON fix specification

100%

Entity count awareness

100%

Repository: gitlabhq/orbit-knowledge-graph
Commit: f5efc36

Evaluated: 2 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Debugging Empty Query Results in the Knowledge Graph Pipeline Knowledge Graph Data Quality Investigation Edge Coverage Analysis for Knowledge Graph Queries

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.