Claude Skills by jeremylongshore

Monitor ClickHouse with Prometheus metrics, Grafana dashboards, system table queries, and alerting for query performance, merge health, and resource usage. Use when setting up ClickHouse monitoring, building Grafana dashboards, or configuring alerts for production ClickHouse deployments. Trigger with "clickhouse monitoring", "clickhouse metrics", "clickhouse Grafana", "clickhouse observability", "monitor clickhouse", "clickhouse Prometheus".

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 with "clickhouse performance", "optimize clickhouse query", "clickhouse slow query", "clickhouse indexing", "clickhouse tuning", "clickhouse projections".

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification. Use when launching a ClickHouse deployment, doing a go-live review, or auditing production readiness before flipping traffic. Trigger with "clickhouse production", "clickhouse go-live", "clickhouse launch checklist", "production clickhouse", "clickhouse prod ready".

Configure ClickHouse query concurrency, memory quotas, and connection limits. Use when hitting "too many simultaneous queries", managing concurrent users, or tuning server-side resource limits so an app never starves the cluster. Trigger with "clickhouse rate limit", "clickhouse concurrency", "clickhouse quota", "too many simultaneous queries", "clickhouse connection limit".

Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology. Use when designing a new ClickHouse system, reviewing an existing analytics architecture, or establishing standards for ClickHouse integrations. Trigger with "clickhouse architecture", "clickhouse project structure", "clickhouse design", "clickhouse multi-tenant", "clickhouse reference".

Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management. Use when building robust ClickHouse integrations, implementing streaming inserts or low-memory streaming reads, or establishing team coding standards. Trigger with "clickhouse SDK patterns", "clickhouse client patterns", "clickhouse best practices", "clickhouse streaming insert".

Secure ClickHouse with user management, network restrictions, TLS, and audit logging. Use when hardening a ClickHouse deployment, creating restricted users, enforcing multi-tenant row isolation, or configuring network-level access controls. Trigger with "clickhouse security", "clickhouse user management", "secure clickhouse", "clickhouse TLS", "clickhouse access control", "clickhouse firewall".

Use when upgrading ClickHouse server versions or the @clickhouse/client SDK, handling breaking changes between versions, or migrating from older client libraries — covers version checks, changelog review, staged upgrade, post-upgrade validation, and rollback. Trigger with phrases like "upgrade clickhouse", "clickhouse version upgrade", "update clickhouse client", "clickhouse breaking changes", "new clickhouse version".

Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns. Use when building data ingestion pipelines, consuming webhook payloads, or integrating Kafka topics into ClickHouse. Trigger with "clickhouse ingestion", "clickhouse webhook", "clickhouse Kafka", "stream data to clickhouse", "clickhouse data pipeline".

'Set up CI/CD pipelines for ClickUp API integrations with GitHub Actions,

'Diagnose and fix ClickUp API v2 errors by HTTP status and error code.

'Manage ClickUp tasks via API v2: create, read, update, delete tasks

'Manage ClickUp workspaces, spaces, folders, lists, and views via API

'Optimize ClickUp API usage costs through plan selection, request reduction,

'Collect ClickUp API diagnostic information for troubleshooting and support.

'Deploy ClickUp API integrations to Vercel, Fly.io, and Cloud Run with

'Make your first ClickUp API v2 calls: list workspaces, spaces, and create

'Set up ClickUp API v2 authentication with personal tokens or OAuth 2.0.

'Production readiness checklist for ClickUp API v2 integrations covering

'Handle ClickUp API rate limits with backoff, queuing, and header monitoring.

'Secure ClickUp API tokens, implement least-privilege access, and audit

'Migrate between ClickUp API versions (v2 to v3) and handle breaking

'Execute automatically formats and validates code files using Prettier

'Configure CodeRabbit as a CI gate with GitHub Actions, branch protection,

'Diagnose and fix CodeRabbit common errors and configuration issues.

'Execute CodeRabbit primary workflow: automated PR code review with configuration.

'Tune CodeRabbit review configuration: learnings, code guidelines, and

'Optimize CodeRabbit costs through seat management, repo selection, and

'Implement CodeRabbit PII handling, data retention, and GDPR/CCPA compliance

'Collect CodeRabbit debug evidence for support tickets and troubleshooting.

'Roll out CodeRabbit across an organization: multi-repo deployment, org-level

'Configure CodeRabbit enterprise access control, seat management, and

'Create a minimal working CodeRabbit configuration and trigger your first

'Execute CodeRabbit incident response procedures when reviews stop working

'Install and configure CodeRabbit AI code review on GitHub or GitLab

'Configure CodeRabbit CLI for local pre-commit code reviews and fast

'Migrate to CodeRabbit from other code review tools or roll out across

'Configure CodeRabbit review behavior per branch and environment using

'Monitor CodeRabbit review effectiveness with metrics, dashboards, and

'Optimize CodeRabbit review speed, relevance, and signal-to-noise ratio.

'Execute CodeRabbit production readiness checklist for org-wide deployment.

'Understand and handle CodeRabbit and GitHub API rate limits for review

'Implement CodeRabbit reference architecture with production-grade .coderabbit.yaml

'Apply production-ready CodeRabbit automation patterns using GitHub API

'Configure CodeRabbit for security-focused code review with secret detection

'Update CodeRabbit configuration for new features, migrate between plans,

'Implement CodeRabbit webhook signature validation and event handling.

'Diagnose and fix Cohere API v2 errors and exceptions.

'Build a complete RAG pipeline with Cohere Chat, Embed, and Rerank.

'Build tool-use agents and function calling with Cohere API v2.