Clickhouse Query Optimization
Helps with querying, optimization as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add clickhouse-query-optimization npx -- -y @trustedskills/clickhouse-query-optimization
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"clickhouse-query-optimization": {
"command": "npx",
"args": [
"-y",
"@trustedskills/clickhouse-query-optimization"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill optimizes ClickHouse queries for improved performance. It analyzes query structure, suggests indexes, and recommends alternative approaches to reduce execution time and resource consumption. The skill aims to identify bottlenecks and provide actionable insights for efficient data retrieval in ClickHouse databases.
When to use it
- You're experiencing slow query execution times in your ClickHouse environment.
- Your ClickHouse queries are consuming excessive resources (CPU, memory).
- You need assistance identifying missing indexes or suboptimal query patterns.
- You want to proactively improve the performance of new and existing ClickHouse queries.
Key capabilities
- Query analysis
- Index recommendations
- Performance bottleneck identification
- Alternative query suggestions
Example prompts
- "Optimize this ClickHouse query:
SELECT ... FROM ... WHERE ..." - "What indexes would improve the performance of this ClickHouse query?"
- "Can you suggest a more efficient way to run this ClickHouse query?"
Tips & gotchas
The skill's effectiveness depends on providing complete and accurate ClickHouse queries. It is designed for standard SQL syntax within the ClickHouse ecosystem; complex or non-standard queries may yield less precise recommendations.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.