Sql Expert

This is a ClickHouse SQL assistant that enforces best practices at the schema level. It won't let you write a query without validating it first, and it knows the sharp edges of ClickHouse's sparse indexing, so you won't accidentally scan a billion rows because you filtered on a secondary key column without including the partition key. It discovers schemas on demand, handles system table queries by deferring to a specialist skill, and optimizes for the common case of time series analytics. Use it when you need to pull data from ClickHouse and want the query to actually be fast. The mandatory validation step feels heavy handed until you've debugged one too many queries that passed syntax checks but killed production.

GitHub stars: 320
last updated: May 14, 2026

View on GitHub

Install

$ npx -y skills add frankchen021/datastoria --skill sql-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

🚨 CRITICAL RULE: MANDATORY VALIDATION

You MUST call validate_sql(sql) for every new query you generate. Context Note: Historical validation steps are pruned to save tokens, but this does NOT excuse you from validating new queries in the current turn. Always validate before executing.

SKILL.md on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly