All authors

Claude Skills by jeremylongshore
github.com/jeremylongshore5,187 skills76 installs8,596 views
- Clickhouse Data HandlingHandle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL. Use when implementing data retention, fulfilling GDPR/CCPA deletion requests, or managing sensitive data in ClickHouse. Trigger with "clickhouse data retention", "clickhouse TTL", "clickhouse GDPR", "delete data clickhouse", "clickhouse data lifecycle", "clickhouse PII".Votes: 0GitHub stars: 2,719
- Clickhouse Debug BundleCollect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting. Use when investigating persistent issues, preparing debug artifacts, or collecting evidence for ClickHouse support. Trigger with "clickhouse debug", "clickhouse diagnostics", "clickhouse support bundle", "collect clickhouse logs", "clickhouse system tables".Votes: 0GitHub stars: 2,719
- Clickhouse Deploy IntegrationDeploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks. Use when deploying applications that connect to ClickHouse Cloud, configuring platform secrets, or setting up deployment pipelines to serverless or container hosts. Trigger with "deploy clickhouse app", "clickhouse Vercel", "clickhouse Cloud Run", "clickhouse production deploy", "clickhouse Fly.io".Votes: 0GitHub stars: 2,719
- Clickhouse Enterprise RbacConfigure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management. Use when setting up multi-user access control, implementing tenant isolation, or configuring enterprise security for ClickHouse. Trigger with "clickhouse RBAC", "clickhouse roles", "clickhouse permissions", "clickhouse row policy", "clickhouse enterprise access", "clickhouse GRANT".Votes: 0GitHub stars: 2,719
- Clickhouse Hello WorldCreate your first ClickHouse table, insert data, and run analytical queries. Use when starting a new ClickHouse project, learning MergeTree basics, or testing your ClickHouse connection with real operations. Trigger with "clickhouse hello world", "first clickhouse table", "clickhouse quick start", "create clickhouse table", "clickhouse example".Votes: 0GitHub stars: 2,719
- Clickhouse Incident RunbookClickHouse 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".Votes: 0GitHub stars: 2,719
- Clickhouse Install AuthInstall @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".Votes: 0GitHub stars: 2,719
- Clickhouse Local Dev LoopRun 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".Votes: 0GitHub stars: 2,719
- Clickhouse Migration Deep DiveExecute 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".Votes: 0GitHub stars: 2,719
- Clickhouse Multi Env SetupConfigure 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".Votes: 0GitHub stars: 2,719
- Clickhouse ObservabilityMonitor 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".Votes: 0GitHub stars: 2,719
- Clickhouse Performance TuningOptimize 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".Votes: 0GitHub stars: 2,719
- Clickhouse Prod ChecklistProduction 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".Votes: 0GitHub stars: 2,719
- Clickhouse Rate LimitsConfigure 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".Votes: 0GitHub stars: 2,719
- Clickhouse Reference ArchitectureProduction 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".Votes: 0GitHub stars: 2,719
- Clickhouse Sdk PatternsProduction-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".Votes: 0GitHub stars: 2,719
- Clickhouse Security BasicsSecure 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".Votes: 0GitHub stars: 2,719
- Clickhouse Upgrade MigrationUse 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".Votes: 0GitHub stars: 2,719
- Clickhouse Webhooks EventsIngest 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".Votes: 0GitHub stars: 2,719
- Clickup Ci IntegrationGate ClickUp adapters with offline OpenAPI contracts and a protected read-only live probe. Use when adding CI for a ClickUp-backed repository. Trigger with "ClickUp CI", "test ClickUp integration", or "ClickUp contract tests".Votes: 0GitHub stars: 2,719
- Clickup Common ErrorsAnalyze and diagnose ClickUp authentication, authorization, plan, request, pagination, throttling, webhook, and provider failures from redacted evidence. Use when a ClickUp integration fails or behaves inconsistently. Trigger with "ClickUp error", "ClickUp 429", or "diagnose ClickUp API".Votes: 0GitHub stars: 2,719
- Clickup Core Workflow ACreate, reconcile, update, and retire ClickUp tasks with schema validation, durable source identity, and explicit destructive approval. Use when automating task lifecycle work through ClickUp API v2. Trigger with "ClickUp task sync", "create ClickUp tasks", or "ClickUp task CRUD".Votes: 0GitHub stars: 2,719
- Clickup Core Workflow BAnalyze, inventory, and change ClickUp Spaces, Folders, Lists, tags, and views with parent-aware plans and reversible boundaries. Use when managing ClickUp hierarchy through API v2. Trigger with "ClickUp hierarchy", "ClickUp Lists", or "ClickUp views".Votes: 0GitHub stars: 2,719
- Clickup Cost TuningReduce ClickUp integration cost and request load using measured traffic, pagination, cache policy, webhooks, and current plan facts. Use when forecasting or optimizing ClickUp operations. Trigger with "ClickUp cost", "reduce ClickUp requests", or "ClickUp plan sizing".Votes: 0GitHub stars: 2,719
- Clickup Debug BundleCollect a minimal redacted ClickUp connectivity and contract bundle without task bodies, tokens, or webhook secrets. Use when escalating a ClickUp API incident. Trigger with "ClickUp debug bundle", "ClickUp diagnostics", or "collect ClickUp evidence".Votes: 0GitHub stars: 2,719
- Clickup Deploy IntegrationDeploy and roll back a server-side ClickUp API and webhook service with secret injection, workspace guards, health probes, and durable queues. Use when releasing a ClickUp integration. Trigger with "deploy ClickUp", "ClickUp production release", or "ClickUp webhook service".Votes: 0GitHub stars: 2,719
- Clickup Hello WorldProve the smallest safe ClickUp API connection by reading the authorized user and Workspaces without creating work. Use when validating a new ClickUp credential. Trigger with "ClickUp hello world", "test ClickUp token", or "first ClickUp API call".Votes: 0GitHub stars: 2,719
- Clickup Install AuthConfigure ClickUp personal-token or OAuth authorization with server-side storage, state validation, Workspace verification, and rotation ownership. Use when connecting an application to ClickUp. Trigger with "ClickUp auth", "install ClickUp API", or "ClickUp OAuth setup".Votes: 0GitHub stars: 2,719
- Clickup Prod ChecklistIssue an evidence-backed go or no-go decision for a ClickUp integration across auth, versions, plans, data, limits, webhooks, recovery, and ownership. Use when reviewing a production launch or major change. Trigger with "ClickUp production checklist", "ClickUp go-live", or "review ClickUp release".Votes: 0GitHub stars: 2,719
- Clickup Rate LimitsAnalyze and control ClickUp request concurrency from plan-aware per-token limits, response headers, bounded queues, and reset-based retries. Use when preventing or recovering from ClickUp 429 responses. Trigger with "ClickUp rate limit", "ClickUp 429", or "size ClickUp concurrency".Votes: 0GitHub stars: 2,719
- Clickup Security BasicsHarden ClickUp credentials, OAuth callbacks, Workspace boundaries, webhooks, logging, and incident response with least-privilege controls. Use when threat-modeling or reviewing a ClickUp integration. Trigger with "secure ClickUp", "ClickUp security review", or "ClickUp token rotation".Votes: 0GitHub stars: 2,719
- Clickup Upgrade MigrationMigrate ClickUp endpoints, schemas, clients, and terminology with version inventory, dual contracts, canaries, and rollback. Use when adopting selected API v3 surfaces or provider changes. Trigger with "upgrade ClickUp API", "ClickUp v3 migration", or "ClickUp schema change".Votes: 0GitHub stars: 2,719
- Coderabbit Ci IntegrationDesign a fail-closed merge policy that combines CodeRabbit review state with provider checks without inventing a CodeRabbit status-check name. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "gate merges with CodeRabbit".Votes: 0GitHub stars: 2,719
- Coderabbit Common ErrorsTriage missing, duplicate, noisy, or misconfigured reviews from observed pull-request and configuration evidence. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "debug CodeRabbit reviews".Votes: 0GitHub stars: 2,719
- Coderabbit Core Workflow ARun the primary CodeRabbit review loop from eligibility through finding disposition and verification. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "run a CodeRabbit PR review".Votes: 0GitHub stars: 2,719
- Coderabbit Core Workflow BTune review signal with current learnings, detected guideline files, path instructions, and measured feedback. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "tune CodeRabbit reviews".Votes: 0GitHub stars: 2,719
- Coderabbit Cost TuningReview plan, seat, limit, and pay-as-you-go usage from current billing evidence without hard-coded prices. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "reduce CodeRabbit cost".Votes: 0GitHub stars: 2,719
- Coderabbit Data HandlingDefine code, cache, retention, export, and sensitive-path controls for a repository or organization. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "audit CodeRabbit data handling".Votes: 0GitHub stars: 2,719
- Coderabbit Debug BundleAssemble a minimal redacted diagnostic package for configuration, review, CLI, or provider failures. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "build a CodeRabbit debug bundle".Votes: 0GitHub stars: 2,719
- Coderabbit Deploy IntegrationRoll out CodeRabbit with staged installation, central configuration, ownership, evidence, and rollback. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "deploy CodeRabbit organization-wide".Votes: 0GitHub stars: 2,719
- Coderabbit Enterprise RbacDesign and audit roles, seats, API access, and administrative separation for an enterprise organization. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "audit CodeRabbit RBAC".Votes: 0GitHub stars: 2,719
- Coderabbit Hello WorldRun a bounded first pull-request review with minimal supported configuration and explicit cleanup. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "smoke test CodeRabbit".Votes: 0GitHub stars: 2,719
- Coderabbit Incident RunbookCoordinate a review outage, harmful-output wave, access incident, or merge-policy failure without silently bypassing safeguards. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "handle a CodeRabbit incident".Votes: 0GitHub stars: 2,719
- Coderabbit Install AuthAnalyze and implement platform installation plus interactive or headless CLI authentication with least privilege. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "install CodeRabbit".Votes: 0GitHub stars: 2,719
- Coderabbit Local Dev LoopOperate CLI reviews inside an agentic coding loop with bounded diffs, current authentication, and fix verification. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "review local changes with CodeRabbit".Votes: 0GitHub stars: 2,719
- Coderabbit Migration Deep DiveMigrate from another review process through measured coexistence, control mapping, and reversible cohorts. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "migrate to CodeRabbit".Votes: 0GitHub stars: 2,719
- Coderabbit Multi Env SetupDesign behavior for default, development, release, and hotfix targets using supported auto-review controls. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "configure CodeRabbit by branch".Votes: 0GitHub stars: 2,719
- Coderabbit ObservabilityMeasure review adoption, latency, findings, usage, and outcomes from documented dashboards, exports, reports, or API data. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "measure CodeRabbit reviews".Votes: 0GitHub stars: 2,719
- Coderabbit Performance TuningImprove review speed and signal using measured scope, config, cache, and review behavior without timing bands. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "tune CodeRabbit performance".Votes: 0GitHub stars: 2,719
- Coderabbit Prod ChecklistMake an evidence-backed go-live decision for installation, configuration, governance, security, continuity, and operations. Use when this operator task needs a current, evidence-backed CodeRabbit workflow. Trigger with "review CodeRabbit go-live".Votes: 0GitHub stars: 2,719