ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
MUST USE when reviewing ClickHouse schemas, queries, or configurations.
Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills.
Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns.
Insert, query, and aggregate data in ClickHouse with real SQL patterns.
ClickHouse migration patterns and rules.
Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables.
Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification.
15+ schema rules for ClickHouse tables. ALWAYS LOAD when creating or modifying tables. Achieves sub-second queries, 10x compression, and…
Set up ClickUp integration for AI coding agents.
Set up local development for ClickUp API integrations with testing,
Clickup Operational
Use when a non-technical client asks "why is this taking so long", pushes back on a technical decision, or needs a delay, risk, or…
Onboards a new business onto the pipeline: provisions its Airtable base, captures its facts and goals, and writes them to Airtable…
Build a data-backed client onboarding proposal for an agency starting a new engagement, combining an WsCube Tech SEO + AI-search audit…
Generates a personalized BenAI x Client one-pager (HTML), deploys it to Vercel, and returns a shareable URL within minutes.
Generate professional client-facing performance reports with portfolio returns, allocation breakdowns, and market commentary.
Shared rules for CometChat React Native UI Kit v5.
Use when the user is weighing whether to take on a prospect — an inbound inquiry, a referral, a rescue of code an earlier developer…
myfy CliModule for custom CLI commands with DI injection.
Stage 4 of the Clinical ASR Flywheel. Use when priority KER is above 0.3 to run stock NeMo SFT on Parakeet TDT v2 and offline cycle N+1…