skills.rest
Borisserz
BorisserzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

clickhouse-best-practices

Apply 31 rule-based ClickHouse best practices to schemas, queries, and agent workflows.

1|1|Updated Apr 11, 2026
Search Tags:#best-practices#query-optimization#schema-design#clickhouse#performance-review#data-ingestion#agent-connectivity
One-click install
npx skills add https://github.com/Borisserz/FoodTracker --skill clickhouse-best-practices-borisserz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickhouse-best-practices
Source: https://github.com/Borisserz/FoodTracker/tree/main/.agents/skills/skills/clickhouse-best-practices
Command: npx skills add https://github.com/Borisserz/FoodTracker --skill clickhouse-best-practices-borisserz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This knowledge base provides a structured, rule-driven framework to review and optimize ClickHouse schemas, queries, and agent workflows, ensuring consistent, high-performance deployments.

Core Features & Use Cases

  • 31 atomic rules organized by category (schema, query, insert, agent) to guide design and optimization.
  • 7-step discovery workflow and explicit schema exploration steps to avoid costly scans.
  • Agent connectivity and safety guidance for MCP/CLI integrations, including query safety limits and explainable recommendations.
  • Practical references to official ClickHouse documentation and best-practice patterns.

Quick Start

Ask the AI to review a ClickHouse deployment against the 31 rules and cite the exact rules in every recommendation.

Frequently Asked Questions about clickhouse-best-practices

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize ClickHouse schema design for high-performance deployments?▼

ClickHouse schema design optimization is achieved by applying a formal, rule-driven framework of 31 atomic rules organized by schema, query, insert, and agent categories to ensure consistent, high-performance deployments.

What is the best way to review ClickHouse queries and avoid costly table scans?▼

The best way to review ClickHouse queries is using a 7-step discovery workflow with explicit schema exploration steps designed to avoid costly scans and align with official best-practice patterns.

How does agent connectivity and query safety work with ClickHouse MCP and CLI integrations?▼

Agent connectivity and query safety for ClickHouse MCP/CLI integrations work by enforcing safety limits and explainable recommendations, guided by specific agent rules within the 31-rule framework.

Can I use a rule-based framework to tune ClickHouse insert operations and schema configurations?▼

Yes, you can tune ClickHouse insert operations and schema configurations using a rule-based framework that enforces 31 published rules across insert, schema, query, and agent guidelines with explicit citations.

Why should I apply formal rule citations when optimizing ClickHouse performance?▼

Applying formal rule citations when optimizing ClickHouse performance ensures responses align with official documentation and best-practice patterns, providing explainable recommendations rather than ad-hoc suggestions.

Related Skills

Explore More Data & Analytics Skills→
Sake-TeamSake-Team

clickhouse-io

Analyze and optimize ClickHouse database configurations and queries.

Official
Advanced
ethpandaopsethpandaops

optimize-model

Analyze ClickHouse transformation model queries and recommend performance improvements.

Official
Advanced
JamkrisJamkris
86

clickhouse-io

Optimize ClickHouse analytical workloads with schema, query, and ingestion patterns.

Community
Advanced
AngKSAngKS

clickhouse-best-practices

Enforce 28 atomic rules for ClickHouse schema, query, and insert optimization.

Community
Advanced