clickhouse-best-practices-ts-py

Analyze MooseStack data models and ClickHouse schemas for inline optimization guidance.

3|2|Updated Feb 5, 2026

Search Tags:#partitioning #schema-design #clickhouse #materialized-views #order-by #insert-strategy #moosestack

Ready to run

npx skills add https://github.com/514-labs/agent-skills --skill clickhouse-best-practices-ts-py

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: clickhouse-best-practices-ts-py
Source: https://github.com/514-labs/agent-skills/tree/main/skills/clickhouse/best-practices
Command: npx skills add https://github.com/514-labs/agent-skills --skill clickhouse-best-practices-ts-py

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Aligns MooseStack data modeling with ClickHouse best practices to reduce schema drift, optimize query performance, and simplify complex data pipelines. It provides inline, action-oriented guidance that helps engineers make correct, production-ready decisions without performing exhaustive rule reviews upfront.

Core Features & Use Cases

Inline guidance for core design choices such as ORDER BY keys, data types, partitioning, and materialized views to accelerate authoring and reduce costly migrations.
Scenario-driven guidance focused on schema design, join strategies, and insert/maintenance patterns for analytics workloads.
Use Case: While prototyping a new analytics feature, apply 1–2 relevant rules directly in the code path to validate an efficient schema and fast query plans without performing a full audit.

Quick Start

Pick the 1–2 rules directly relevant to your immediate decision and apply inline guidance while continuing to write code; request a formal review only if you explicitly ask for it.

Frequently Asked Questions about clickhouse-best-practices-ts-py

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

FAQPage Schema

How do I choose the best ORDER BY keys for a ClickHouse schema?▼

Choosing the best ClickHouse ORDER BY keys requires analyzing query patterns to surface columns frequently used in filtering. This Skill targets 1-2 relevant rules to provide inline guidance for optimizing ORDER BY selection and accelerating query performance in analytics workloads.

What is the best way to design ClickHouse partitioning for analytics workloads?▼

ClickHouse partitioning for analytics workloads should align with data ingestion patterns and query filtering needs. This Skill analyzes MooseStack data models to provide action-oriented guidance, reducing schema drift and simplifying complex data pipelines without exhaustive rule reviews.

How do materialized views work with MooseStack data models in ClickHouse?▼

Materialized views in ClickHouse work by pre-computing and storing query results to accelerate read performance. This Skill provides scenario-driven guidance on schema design and materialized views to help engineers make production-ready decisions while prototyping analytics features.

Can I get inline optimization guidance for ClickHouse schema design without a full audit?▼

Yes, you can get inline optimization guidance without a full audit. This Skill surfaces 1-2 relevant rules directly in the code path for immediate decisions on type sizing, partitioning, and ORDER BY selection, enabling faster iteration during analytics feature prototyping.

When do I need to review ClickHouse insert strategies and data types?▼

You need to review ClickHouse insert strategies and data types when optimizing data ingestion and query performance. This Skill analyzes schemas to provide action-oriented guidance on type sizing and insert patterns, reducing costly migrations for analytics workloads.