Clickhouse Best Practices
clickhouse/agent-skillsClickHouse is a fast database for analytics. To get the best performance you need to follow specific rules. This guide contains 31 rules organized into four groups: schema design, query optimization, data insertion, and AI agent connectivity.
These rules cover important topics like how to choose your table's sort key, which data types to use, and how to avoid common mistakes. Each rule is documented in a separate file and should be cited when giving advice.
Anyone reviewing ClickHouse code or settings should check these rules first. They help you avoid slow queries and wasted storage. The rules are based on tested ClickHouse behavior that differs from other databases.
Add Clickhouse Best Practices skill to your workflow
Global
mkdir -p ~/.claude/skills/clickhouse-best-practicesProject
mkdir -p .claude/skills/clickhouse-best-practicesSource Repository
More Databases Claude Code Skills
Supabase Postgres Best Practicessupabase/agent-skills
Follow Supabase's expert guidelines for faster Postgres queries and smarter schema design
Firebase Data Connectfirebase/agent-skills
Build secure PostgreSQL backends with Firebase using GraphQL schemas and type-safe SDKs
Convex Migration Helperget-convex/agent-skills
Plan and run safe Convex schema migrations without downtime or data loss
Firebase Firestorefirebase/agent-skills
Master Cloud Firestore setup, queries, full-text search, security rules, and indexes
Neon Postgresneondatabase/agent-skills
Set up and manage Neon Serverless Postgres with ease and speed
Firebase Firestore Standardfirebase/agent-skills
Set up and secure Cloud Firestore with clear provisioning rules and SDK guides
Firebase Firestore Enterprise Native Modefirebase/agent-skills
Master Firestore Enterprise Native Mode provisioning data modeling security rules and SDK usage
Postgresql Table Designwshobson/agents
Design PostgreSQL tables with best practices for performance and reliability