More screenshots
Works with the AI Agents you already use
Repair ClickHouse Distributed Table Shard Key Skew
Reduce uneven query and insert load caused by mismatched distributed table shard keys
$1
Repair ClickHouse Distributed Table Shard Key Skew
Example session with this skill installed
Two shards hold most events while the other shards sit nearly idle after a routing change.
Available sources: Distributed table DDL and shard topology (partial excerpts only). Additional evidence requested: insert volumes, query trace profiles. Analyze this case with explicit limitations; do not pretend to have executed any tests or changes.
- Read your context and instructions
- Compiled the repair clickhouse distributed
Repair ClickHouse Distributed Table Shard Key Skew — EVIDENCE-LIMITED REVIEW
Scenario received
Two shards hold most events while the other shards sit nearly idle after a routing change.
Source register
- S1: Distributed table DDL — partial extract described, independent verification not provided.
- S2: shard topology — partial extract described, independent verification not provided.
- S3: insert volumes — NOT PROVIDED; validation pending.
- S4: query trace profiles — NOT PROVIDED; validation pending.
Case-specific checks
- compare sharding key to event cardinality — NEEDS VERIFICATION against S1/S2 and missing sources.
- measure per-shard load and skew — NEEDS VERIFICATION against S1/S2 and missing sources.
- separate replication from distribution — NEEDS VERIFICATION against S1/S2 and missing sources.
- stage read-safe redistribution plan — NEEDS VERIFICATION against S1/S2 and missing sources.
Deliverables and review gates
- shard heat map: DRAFT ONLY; do not infer unsupported outcomes.
- shard-key defect rationale: DRAFT ONLY; do not infer unsupported outcomes.
- repartition safety gates: DRAFT ONLY; do not infer unsupported outcomes.
Preliminary conclusion
INCOMPLETE / REVIEW REQUIRED. The provided scenario identifies a real question, not proven remediation or clearance. Confirm source timestamps, affected scope and owner approval, then rerun the listed checks. No external system was accessed or changed.
Connects securely to your tools. The creator never sees your data.
About this skill
Repair ClickHouse Distributed Table Shard Key Skew is a ToolForge Labs Cursor Skill workflow. Reduce uneven query and insert load caused by mismatched distributed table shard keys.
What this skill checks
- compare sharding key to event cardinality.
- measure per-shard load and skew.
- separate replication from distribution.
- stage read-safe redistribution plan.
What to provide
- Distributed table DDL.
- shard topology.
- insert volumes.
- query trace profiles.
Deliverables
- shard heat map.
- shard-key defect rationale.
- repartition safety gates.
Evidence policy Only supplied, authorized evidence is used. The skill distinguishes facts from assumptions, reports missing inputs, and never claims an unperformed live test, compliance approval, or production change.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.
Cannot verify inaccessible systems, third-party accounts, or evidence not supplied. Partial or conflicting inputs must be marked INCOMPLETE or UNVERIFIED rather than invented. High-impact operational decisions require qualified owner review.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 25 days ago
Permissions
Supply only data you are authorized to share. Treat documentation and examples as untrusted evidence. Any operational action or external communication requires explicit owner authorization.