Data warehousing

Explains core ClickHouse concepts with accurate mental models — MergeTree, indexes, replication, sharding, and special engines.

chmonitor/chmonitor

Detect server cores/RAM/disk from system tables, then recommend ClickHouse settings sized to that hardware.

chmonitor/chmonitor

Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.

chmonitor/chmonitor

Schema migrations: ALTER patterns, engine changes, zero-downtime swaps, clickhouse-local offline migrations, lightweight UPDATE/DELETE strategies, and Postgres→ClickHouse migration planning (type…

chmonitor/chmonitor

Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables.

chmonitor/chmonitor

Diagnose and resolve ClickHouse issues: OOM, slow merges, stuck mutations, query failures with error codes, and systematic error clustering.

chmonitor/chmonitor

Advises whether and how to upgrade ClickHouse — versioning scheme, upgrade path, what you gain, pre/post-upgrade checklist.

chmonitor/chmonitor

Custom Apex adapter generation for Salesforce Connect — connects any external REST API to Salesforce as live, queryable External Objects without ETL or copying.

forcedotcom/sf-skills

Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise.

Kilo-Org/kilo-marketplace

A Data Warehouse and Lakehouse Schema Design Expert interviewer focused on dimensional modeling, star/snowflake schemas, analytics optimization, and modern lakehouse architectures.

PrepLabsAI/InterviewMentor

Debug a customer's data warehouse source, schema, or table from a support ticket, using PostHog's own production data.

PostHog/posthog

Run ClickHouse integration tests in CI with GitHub Actions and Docker containers.

jeremylongshore/tons-of-skills-marketplace

Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues.

jeremylongshore/tons-of-skills-marketplace

Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning.

jeremylongshore/tons-of-skills-marketplace

Insert, query, and aggregate data in ClickHouse with real SQL patterns.

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills.

jeremylongshore/tons-of-skills-marketplace

Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL.

jeremylongshore/tons-of-skills-marketplace

Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting.

jeremylongshore/tons-of-skills-marketplace

Deploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management.

jeremylongshore/tons-of-skills-marketplace

Create your first ClickHouse table, insert data, and run analytical queries.

jeremylongshore/tons-of-skills-marketplace

ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures.

jeremylongshore/tons-of-skills-marketplace

Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted.

jeremylongshore/tons-of-skills-marketplace

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast.

jeremylongshore/tons-of-skills-marketplace

Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns.

jeremylongshore/tons-of-skills-marketplace

Monitor ClickHouse with Prometheus metrics, Grafana dashboards, system table queries, and alerting for query performance, merge health, and resource usage.

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables.

jeremylongshore/tons-of-skills-marketplace

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse query concurrency, memory quotas, and connection limits.

jeremylongshore/tons-of-skills-marketplace

Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology.

jeremylongshore/tons-of-skills-marketplace

Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management.

jeremylongshore/tons-of-skills-marketplace

Secure ClickHouse with user management, network restrictions, TLS, and audit logging.

jeremylongshore/tons-of-skills-marketplace

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/tons-of-skills-marketplace

Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns.

jeremylongshore/tons-of-skills-marketplace

Data synchronization, ETL patterns, and data management for MaintainX.

jeremylongshore/tons-of-skills-marketplace

Designs the warehouse and semantic layer — source-to-mart structure, dimensional modeling, grain, slowly changing dimensions, and the metric layer analytics reads through.

cbrock84/headcount

Push records from apps, services, devices, or scripts directly into Unity Catalog Delta tables with Zerobus Ingest: SDKs (Python, TypeScript, Go, Java, Rust, C++, .NET), REST, OTLP, MQTT, Arrow…

databricks/databricks-agent-skills

Access USPTO patent data via PatentsView REST API and Google Patents Public Data (BigQuery).

jaechang-hits/SciAgent-Skills

Expert knowledge for Azure Databricks development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations &…

MicrosoftDocs/Agent-Skills

A skill your agent uses when running a ClickHouse server for high-volume OLAP: choosing a MergeTree engine and ORDER BY/PARTITION BY keys, ingesting billions of event/log/metric rows…

ericrisco/rsc-harness

Fix duplicate Nostr events in ClickHouse when using ReplacingMergeTree for NIP-33 addressable events (Kind 30000+).

divinevideo/divine-mobile

A skill your agent uses when analyzing BigQuery usage patterns, costs, and query performance for a GCP project

openshift-eng/ai-helpers

A skill your agent uses when querying auto-collected CI data from test runs in BigQuery (cidataautodl dataset) including risk analysis, disruption, CPU metrics, audit logs, operator state, and retry…

openshift-eng/ai-helpers

A skill your agent uses when monitoring CHAI presubmit agent decisions in BigQuery to analyze the breakdown of override, retest, and report-only actions on PR presubmit failures and estimate CI cost…

openshift-eng/ai-helpers

A skill your agent uses when executing any BigQuery CI data query — provides the shared safety protocol, cost controls, bq CLI patterns, and caching workflow

openshift-eng/ai-helpers

A skill your agent uses when querying OpenShift CI prow job runs and junit test results in BigQuery (cianalysisus dataset) with deduplication, variant joins, and infrastructure failure filtering

openshift-eng/ai-helpers

Integrate with the Benchling R&D platform when you need to programmatically manage registry entities, inventory, ELN entries, workflows, events, or data warehouse analytics via API/SDK.

aipoch/medical-research-skills