Download

Skill UI

Browse and discover 10585+ curated skills

All Development Artificial Intelligence Design & Creative Product & Business Data Science Marketing Soft Skills Productivity Engineering Languages

Search ClickHouse , found 26 results

Default Newest Most Downloaded

ClickHouse Analytics and Data Engineering Patterns

cc-skill-clickhouse-io

sickn33/antigravity-awesome-skills

This guide provides comprehensive patterns and best practices for working with ClickHouse, a high-performance OLAP database. It covers advanced topics such as MergeTree engine design, efficient query optimization (filtering, aggregations, window functions), bulk/streaming data ingestion, materialized view creation, and performance monitoring techniques, ensuring optimal performance for large-scale analytical workloads.

ClickHouse Analytics Patterns

affaan-m/everything-claude-code

Guides ClickHouse database architects through schema designs, query optimization, ingestion strategies, and monitoring techniques tailored for high-performance analytical workloads.

Optimize ClickHouse Cloud Costs

clickhouse-cost-tuning

jeremylongshore/claude-code-plugins-plus-skills

A comprehensive guide to reducing expenses on ClickHouse Cloud. Learn advanced techniques for storage optimization (compression, TTL), compute resource tuning (scaling, thread limits), and query efficiency improvements. Use this when managing data budgets or analyzing high ClickHouse billing charges.

Collect ClickHouse Diagnostic Bundle

clickhouse-debug-bundle

jeremylongshore/claude-code-plugins-plus-skills

This tool collects comprehensive diagnostic data from ClickHouse system tables. It gathers crucial metrics, query logs, merge statuses, and disk usage information. It is essential for troubleshooting performance bottlenecks, preparing detailed support tickets, or investigating complex database infrastructure issues.

Deploy ClickHouse Applications to Cloud Platforms

clickhouse-deploy-integration

jeremylongshore/claude-code-plugins-plus-skills

A comprehensive guide on deploying applications connected to ClickHouse Cloud across various modern cloud environments, including Vercel, Fly.io, and Google Cloud Run. This guide covers best practices for connection pooling, secure secret management, implementing health checks, and ensuring graceful shutdowns in serverless and containerized setups.

ClickHouse Concurrency And Resource Management

clickhouse-rate-limits

jeremylongshore/claude-code-plugins-plus-skills

This guide details how to configure and manage resource constraints in ClickHouse, addressing server-side limits, user quotas, and connection management. Use it when encountering "too many simultaneous queries," optimizing resource usage, or implementing robust rate limiting strategies in applications connecting to ClickHouse. Covers SQL quota setup and client-side pooling techniques.

ClickHouse Data Ingestion Pipelines

clickhouse-webhooks-events

jeremylongshore/claude-code-plugins-plus-skills

A comprehensive guide and implementation template for building robust data ingestion pipelines into ClickHouse. Supports multiple sources including HTTP webhooks (with batching), Kafka streams, S3, and direct SQL inserts. Demonstrates best practices for data handling, such as deduplication using ReplacingMergeTree and monitoring query logs, ensuring reliable, scalable data analytics.

Debugging Common ClickHouse Database Errors

clickhouse-common-errors

jeremylongshore/claude-code-plugins-plus-skills

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.

ClickHouse Data Analysis and Querying

clickhouse-core-workflow-b

jeremylongshore/claude-code-plugins-plus-skills

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

Configure ClickHouse Enterprise RBAC

clickhouse-enterprise-rbac

jeremylongshore/claude-code-plugins-plus-skills

A comprehensive guide to implementing Role-Based Access Control (RBAC) in ClickHouse. Learn how to manage user authentication, define hierarchical roles, enforce row-level security (RLS) for tenant isolation, restrict data access via column-level grants, and manage resource consumption using quotas and settings profiles. Essential for multi-tenant SaaS and secure data analytics platforms.

ClickHouse Quick Start and Data Analysis

clickhouse-hello-world

jeremylongshore/claude-code-plugins-plus-skills

This comprehensive guide teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

Configure ClickHouse Client and Authentication

clickhouse-install-auth

jeremylongshore/claude-code-plugins-plus-skills

This guide provides comprehensive steps for setting up and authenticating the official ClickHouse client for both Node.js and Python. It covers connecting to ClickHouse Cloud or a self-hosted instance, managing environment variables, and verifying the connection using sample code snippets. Ideal for new ClickHouse projects or integrating data analytics pipelines into existing applications.

Language