Claude Skills by jeremylongshore

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, OOM-killed, out of disk, backing up merges, or producing errors in production and you need an on-call playbook. Trigger with "clickhouse incident", "clickhouse outage", "clickhouse down", "clickhouse emergency", "clickhouse on-call", "clickhouse broken".

Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted. Use when setting up a new ClickHouse project, configuring connection strings, or initializing the official Node.js or Python client. Trigger with "install clickhouse", "setup clickhouse client", "clickhouse auth", "connect to clickhouse", "clickhouse credentials".

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast. Use when setting up a local ClickHouse dev environment, writing integration tests against ClickHouse, or running ClickHouse in Docker Compose for local work. Trigger with "clickhouse local dev", "clickhouse docker", "clickhouse dev environment", "run clickhouse locally", "clickhouse docker compose".

Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes. Use when modifying ClickHouse schemas, migrating data between tables, or implementing versioned migration workflows. Trigger with "clickhouse migration", "clickhouse ALTER TABLE", "clickhouse schema change", "migrate clickhouse", "clickhouse add column", or "clickhouse schema migration".

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, wiring secrets per environment, or deploying to multiple environments. Trigger with "clickhouse environments", "clickhouse dev staging prod", "clickhouse multi-env", "clickhouse environment config", "clickhouse staging setup".

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,

'Handle ClickUp data exports, PII redaction, GDPR compliance, and

'Collect ClickUp API diagnostic information for troubleshooting and support.

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

'Implement ClickUp Enterprise SSO, OAuth 2.0 multi-workspace access,

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

'Execute ClickUp API incident response: triage, diagnosis, mitigation,

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

'Set up local development for ClickUp API integrations with testing,

'Migrate to ClickUp from other project management tools (Jira, Asana,

'Configure ClickUp API access across dev, staging, and production environments

'Monitor ClickUp API integrations with metrics, tracing, structured logging,

'Optimize ClickUp API v2 performance with caching, pagination, connection

'Production readiness checklist for ClickUp API v2 integrations covering

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

'Production architecture for ClickUp API v2 integrations with layered

'Production-ready ClickUp API v2 client patterns with typed wrappers,

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

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

'Create and manage ClickUp webhooks for real-time event notifications.

'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