Search
ClickHouse · By jeremylongshore
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Run ClickHouse integration tests in CI with GitHub Actions and Docker containers. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 2 | Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 3 | Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning. | jeremylongshore/ | 2.8k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 4 | Insert, query, and aggregate data in ClickHouse with real SQL patterns. | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 5 | Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 6 | Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 7 | Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 8 | Deploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 9 | Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management. | jeremylongshore/ | 2.8k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 10 | Create your first ClickHouse table, insert data, and run analytical queries. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 11 | ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 12 | Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted. | jeremylongshore/ | 2.8k | — | ~1.2k | Automated safety check: Notes | MIT | yesterday |
| 13 | Run ClickHouse locally with Docker, configure test fixtures, and iterate fast. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Notes | MIT | yesterday |
| 14 | Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 15 | Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns. | jeremylongshore/ | 2.8k | — | ~1.6k | Automated safety check: Notes | MIT | yesterday |
| 16 | Monitor ClickHouse with Prometheus metrics, Grafana dashboards, system table queries, and alerting for query performance, merge health, and resource usage. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 17 | Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables. | jeremylongshore/ | 2.8k | — | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 18 | Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 19 | Configure ClickHouse query concurrency, memory quotas, and connection limits. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 20 | Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology. | jeremylongshore/ | 2.8k | — | ~2k | Automated safety check: Notes | MIT | yesterday |
| 21 | Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 22 | Secure ClickHouse with user management, network restrictions, TLS, and audit logging. | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 23 | A skill your agent uses when upgrading ClickHouse server versions or the @clickhouse/client SDK, handling breaking changes between versions, or migrating from older client libraries — covers version… | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 24 | Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
