ClickHouse Best Practices
Skill ActiveMUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
To ensure users are following best practices when working with ClickHouse, leading to improved performance, stability, and cost-efficiency.
Features
- 31 atomic rules for ClickHouse best practices
- Guidance on schema design, data types, and partitioning
- Optimization strategies for queries, JOINs, and indices
- Best practices for data ingestion and mutation avoidance
- Agent connectivity and schema discovery workflows
Use Cases
- When reviewing or designing ClickHouse schemas.
- When troubleshooting slow ClickHouse queries.
- When planning data ingestion strategies.
- When setting up AI agents to interact with ClickHouse.
Non-Goals
- Providing generic SQL best practices.
- Acting as a ClickHouse query execution engine.
- Replacing official ClickHouse documentation entirely, but complementing it with actionable rules.
Workflow
- Follow priority order: check rules, cite them, use LLM knowledge if no rule applies.
- For agent connectivity: Connect via MCP/CLI, discover schema (databases, tables, columns, sort keys, indices), sample data, verify query plan with EXPLAIN.
- For schema reviews: Follow order for `schema-pk-`, `schema-types-`, `schema-partition-` rules.
- For query reviews: Follow order for `query-join-`, `query-index-`, `schema-pk-filter-on-orderby` rules.
- For insert strategy reviews: Follow order for `insert-batch-`, `insert-mutation-`, `insert-async-`, `insert-optimize-` rules.
- Cite sources for recommendations (rule name, documentation URL).
Practices
- Schema Design
- Query Optimization
- Insert Strategy
- Agent Integration
Trust
- warning:Issues AttentionThere were 2 issues opened in the last 90 days and 0 closed, indicating a closure rate below 10% and potential slow response from maintainers.
Installation
First, add the marketplace
/plugin marketplace add clickhouse/agent-skills/plugin install agent-skills@clickhouse-agent-skillsQuality Score
Trust Signals
Similar Extensions
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
MongoDB Connection Optimizer
100Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Performance Analysis
100Comprehensive performance analysis, bottleneck detection, and optimization recommendations for Claude Flow swarms
Core Web Vitals
100Optimize Core Web Vitals (LCP, INP, CLS) for better page experience and search ranking. Use when asked to "improve Core Web Vitals", "fix LCP", "reduce CLS", "optimize INP", "page experience optimization", or "fix layout shifts".