Optimize Clickhouse Sql

frankchen021/datastoria

This is the tool you want when a ClickHouse query is dragging or you need to find which queries are eating your cluster alive. It follows an evidence-first workflow: you feed it a slow query or query_id, it pulls execution stats and table schema details, then suggests concrete fixes ranked by impact and risk. The pre-flight logic is smart enough to ask what you're optimizing for (duration, CPU, memory, disk) if you don't have a specific query in hand. It defaults to a light evidence pass to keep things fast, only going deep when you need raw details. All recommendations get validated before it hands them back, and it knows the difference between minmax, bloom_filter, and set indexes based on your actual predicates.

GitHub stars

320

last updated

May 14, 2026

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Recommended

More Debugging

1communicating-conciselyganyuanran/aegisWhen you're grinding through a long debugging session or need to cut token usage, this mode strips out articles, filler words, and...0skills.sh installs

2nextjs-senior-devgeorgekhananaev/claude-skills-vaultSenior Next.js 15+/16 Engineer skill for App Router. Use when scaffolding production apps, enforcing RSC patterns, auditing codebases, or optimizing performance0skills.sh installs

3pester-migrationgithub/awesome-copilotPester migration skill for upgrading PowerShell Pester test suites across major versions — v3→v4, v4→v5, and v5→v6. Covers the Discovery/Run two-phase model, mo0skills.sh installs

4update-docshoangnguyen0403/agent-skills-standardAutomated workflow to detect and fix missing documentation0skills.sh installs

5verify-workhoangnguyen0403/agent-skills-standardVerify feature, bug, UI, API, mobile, security, or deployment work against acceptance criteria.0skills.sh installs

6mcp-maintainerhoangsonww/claude-code-agent-monitorOperate and maintain the local MCP server for this repository. Use for MCP tool updates, policy-guard changes, host configuration, and MCP runtime troubleshooti0skills.sh installs