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 dawiddutoit-clickhouse-query-optimization npx -- -y @trustedskills/dawiddutoit-clickhouse-query-optimization
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"dawiddutoit-clickhouse-query-optimization": {
"command": "npx",
"args": [
"-y",
"@trustedskills/dawiddutoit-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 to improve performance and efficiency. It analyzes query structure, indexes, and data types to identify bottlenecks and suggest improvements. The skill aims to reduce query execution time and resource consumption within a ClickHouse database environment.
When to use it
- You're experiencing slow query times in your ClickHouse database.
- Your queries are consuming excessive resources (CPU, memory).
- You need help understanding why a specific ClickHouse query is performing poorly.
- You want to proactively optimize your ClickHouse environment for better overall performance.
Key capabilities
- Query analysis and bottleneck identification
- Index optimization suggestions
- Data type recommendations
- General query structure improvements
Example prompts
- "Optimize this ClickHouse query:
SELECT ... FROM ... WHERE ..." - "Why is this ClickHouse query so slow?" (followed by the query)
- "Suggest ways to improve the performance of my ClickHouse database."
Tips & gotchas
This skill requires a valid ClickHouse query as input. The more context provided about the data and schema, the better the optimization suggestions will be.
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.