Claude Skills by jeremylongshore

'Identify and avoid the top Clay anti-patterns, gotchas, and integration

'Scale Clay enrichment pipelines for high-volume processing (10K-100K+

'Set up a local development loop for building and testing Clay integrations.

'Migrate to Clay from other enrichment tools or consolidate multiple

'Configure Clay integrations across development, staging, and production

'Monitor Clay enrichment pipeline health, credit consumption, and data

'Optimize Clay table enrichment throughput, reduce processing time, and

'Implement credit spending limits, data privacy enforcement, and input

'Execute production readiness checklist for Clay integrations.

'Handle Clay rate limits, webhook throttling, and credit pacing strategies.

'Design production Clay enrichment pipelines with table schemas, waterfall

'Build fault-tolerant Clay integrations with circuit breakers, dead letter

'Apply production-ready patterns for integrating with Clay via webhooks

'Apply Clay security best practices for API keys, webhook secrets, and

'Navigate Clay plan changes, pricing migrations, and feature upgrades.

'Implement Clay webhook receivers and HTTP API column callbacks for real-time

'Configure Clerk CI/CD integration with GitHub Actions and testing.

'Troubleshoot common Clerk errors and issues.

'Implement user sign-up and sign-in flows with Clerk.

'Implement session management and middleware with Clerk.

'Optimize Clerk costs and understand pricing.

'Handle user data, privacy, and GDPR compliance with Clerk.

'Collect comprehensive debug information for Clerk issues.

'Configure Clerk for deployment on various platforms.

'Configure enterprise SSO, role-based access control, and organization

'Create your first authenticated request with Clerk.

'Manage incident response for Clerk authentication issues.

'Install and configure Clerk SDK/CLI authentication.

'Set up local development workflow with Clerk.

'Migrate from other authentication providers to Clerk.

'Configure Clerk for multiple environments (dev, staging, production).

'Implement monitoring, logging, and observability for Clerk authentication.

'Optimize Clerk authentication performance.

'Production readiness checklist for Clerk deployment.

'Understand and manage Clerk rate limits and quotas.

'Reference architecture patterns for Clerk authentication.

'Common Clerk SDK patterns and best practices.

'Implement security best practices with Clerk authentication.

'Manage Clerk SDK version upgrades and handle breaking changes.

'Configure Clerk webhooks and handle authentication events.

Run ClickHouse integration tests in CI with GitHub Actions and Docker containers. Use when setting up automated testing against a real ClickHouse instance, configuring CI pipelines, or implementing schema validation in CI. Trigger with "clickhouse CI", "clickhouse GitHub Actions", "clickhouse integration tests", "test clickhouse in CI", "clickhouse automated testing".

Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues. Use when a ClickHouse query or insert throws an exception, a server-side error appears in logs, or a failed query needs root-cause analysis. Trigger with "clickhouse error", "fix clickhouse", "clickhouse not working", "debug clickhouse", "clickhouse exception", "clickhouse syntax error".

Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning. Use when creating new tables, choosing an engine, designing sort keys, or modeling data for analytical workloads on ClickHouse or ClickHouse Cloud. Trigger with "clickhouse schema design", "clickhouse table design", "clickhouse ORDER BY", "clickhouse partitioning", "MergeTree table".

Insert, query, and aggregate data in ClickHouse with real SQL patterns. Use when writing analytical queries, inserting data at scale, building dashboards, or implementing materialized views for pre-aggregation. Trigger with "clickhouse query", "clickhouse insert", "clickhouse aggregate", "clickhouse materialized view", "clickhouse SQL".

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 with "clickhouse cost", "clickhouse billing", "reduce clickhouse spend", "clickhouse pricing", "clickhouse expensive", "clickhouse storage cost".

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, 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".

Collect 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".

Deploy 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".

Configure 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".

Create 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".