Browse reusable instructions for your AI tools. Copy and customize a prompt, or download a skill for a supported agent.
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.
Production readiness checklist for ClickHouse \u2014 server tuning,\
Secure ClickHouse with user management, network restrictions, TLS, and
Diagnose and fix the top 15 ClickHouse errors \u2014 query failures,\
Configure ClickHouse enterprise RBAC \u2014 SQL-based users, roles,\
Execute ClickHouse schema migrations \u2014 ALTER TABLE operations,\
Configure ClickHouse query concurrency, memory quotas, and connection
Collect ClickHouse diagnostic data \u2014 system tables, query logs,\
Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL. Use when implementing data retention, GDPR deletion requests, or managing sensitive data in ClickHouse. Trigger: "clickhouse data retention", "clickhous...
ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures. Use when ClickHouse is slow, unresponsive, or producing errors in production. Trigger: "clickhouse incident", "clickhouse outage", "clickhouse dow...
Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills. Use when analyzing ClickHouse Cloud bills, reducing storage costs, or optimizing compute utilization. Trigger: "clickhouse cost", "clickhouse billing", "reduce clickhouse spend",...
Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables. Use when queries are slow, investigating performance bottlenecks, or tuning ClickHouse server settings. Trigger: "clickhouse performance", "optimize clickhouse query", "click...
Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns. Use when setting up per-environment ClickHouse instances, managing connection configs, or deploying to multiple environments. Trigger: "clickhouse ...
ClickHouse columnar database for analytics. Use for real-time analytics.
Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
ClickHouse 数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践。
Try another platform, a broader search, or fewer filters.
Explore all resourcesResource formats: Prompts are ready to copy into a conversation. Skills install into the compatible agent shown on their page.
How it worksInclude the instructions, intended platforms, author, and license. Submissions are reviewed before publication.