Best data warehousing skills, page 2

Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.

sidequery/sidemantic

Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis.

warpdotdev/oz-skills

Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance.

hypequery/hypequery

Show a report of open ClickHouse PRs whose only non-green CI check is "CH Inc sync" (or that are fully green) — i.e.

ClickHouse/ClickHouse

Write idiomatic application code with the ClickHouse Node.js client (@clickhouse/client).

vemetric/vemetric

Skill for Graph Query Language (GQL) or SQL/PGQ queries against a property graph.

google/adk-python

Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

pytorch/test-infra

TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and…

2025Emma/vibe-coding-cn

Decision guide for testing in the ar-io-node repo — which test layer to use, how to run it, and which helpers to reach for.

ar-io/ar-io-node

Work inside the Databuddy monorepo for internal implementation, debugging, review, and refactoring.

databuddy-analytics/Databuddy

Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

EliasOulkadi/shokunin

Expert system for generating, validating, and optimizing ClickHouse SQL.

FrankChen021/datastoria

Designing Data-Intensive Applications (DDIA) distilled reference guide by Martin Kleppmann.

luoling8192/ai-coding-principles

Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client).

vemetric/vemetric

Analyzes BigQuery slot use, query costs and execution bottlenecks from INFORMATION_SCHEMA to diagnose slow queries, slot contention and unpartitioned scans.

google/skills

Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval

RobThePCGuy/Claude-Patent-Creator

Benchling R&D platform integration. An agent skill from davila7/claude-code-templates.

davila7/claude-code-templates

Queries JGI Lakehouse (Dremio) for genomics metadata from GOLD, IMG, Mycocosm, Phytozome.

BioTender-max/awesome-bio-agent-skills

Analytics engineering across data modeling, dbt, transformation, and semantic layers.

borghei/Claude-Skills

Helps choose an incremental strategy, design a reliable unique_key and debug failing dbt incremental models, and says when a plain table is the better choice.

AltimateAI/data-engineering-skills

Continue work on an existing PR - resolve conflicts, fix CI failures, address reviewer feedback, and push updates.

ClickHouse/ClickHouse

Locally reproduce ClickHouse CI performance comparison results for a given commit.

ClickHouse/ClickHouse

Edit an auto-generated ClickHouse release changelog into the form that gets committed to CHANGELOG.md.

ClickHouse/ClickHouse

Update a ClickHouse third-party library (contrib submodule) to a new version.

ClickHouse/ClickHouse

Top-level router for Rocky development tasks. An agent skill from rocky-data/rocky.

rocky-data/rocky

Post a Discord message via Caspian to a channel snowflake id.

TryCaspian/caspian-sdk

Connecting Streamlit apps to Snowflake. An agent skill from iusztinpaul/designing-real-world-ai-agents-workshop.

iusztinpaul/designing-real-world-ai-agents-workshop

Audit open "flaky test" GitHub issues and close those whose tests are no longer failing on master.

ClickHouse/ClickHouse

Fix the "CH Inc sync" job in a pull request. An agent skill from ClickHouse/ClickHouse.

ClickHouse/ClickHouse

Analyze CI performance comparison reports for a ClickHouse PR.

ClickHouse/ClickHouse

Analyze Langfuse Cloud infrastructure cost structure using Metabase cost marts.

langfuse/langfuse

A skill your agent uses when changing or reviewing Gram ClickHouse schemas, migrations, queries, inserts, access principals, bootstrap SQL, Cloud compatibility, partial migration failures, or…

speakeasy-api/gram

Wavelet 项目专用：当新增或修改 ClickHouse 批量写入、接入 internal/infra/persistence/batchwriter、将业务域异步 flush 到分析表、迁移 riskcontrol/节点访问日志/可观测时序写入、或评估 asyncinsert 与背压策略时必须使用。本技能指导分层职责、各域独立 Writer 实例、repository 批量 API…

Rain-kl/OpenFlare

This skill should be used whenever the user mentions a "semantic model", "data model", or "dataset", or asks to "build", "model", "design", "optimize", "review", or "audit" one, or to "add a…

data-goblin/power-bi-agentic-development

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

davila7/claude-code-templates

Audit already-implemented Data warehouse import sources for endpoints, schemas, and tables the vendor's API offers but we never wired up.

PostHog/posthog

Seed reproducible local Langfuse data in ClickHouse and Postgres.

langfuse/langfuse

Unattended variant of continue-pr for automation (driven by utils/continue-all-prs.sh).

ClickHouse/ClickHouse

Investigate a ClickHouse CI failure end-to-end from a PR or S3 report URL.

ClickHouse/ClickHouse

Review a ClickHouse Pull Request for correctness, safety, performance, and compliance.

ClickHouse/ClickHouse

Build scalable data pipelines, modern data warehouses, and real-time streaming architectures.

davila7/claude-code-templates

Diagnose ClickHouse cluster health and provide concrete remediation.

FrankChen021/datastoria

Debug a failed Activepieces flow run end-to-end: given a flow run id (or BullMQ job id), find why it failed, cross-referencing the live BullMQ job + Postgres rows (SSH script on the DevOps box), the…

activepieces/activepieces

Skill for BigQuery AI and Machine Learning queries using standard SQL and AI.

google/adk-python

Wavelet 项目专用：当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写…

Rain-kl/OpenFlare

Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them.

AltimateAI/data-engineering-skills

Review code for logging patterns and suggest evlog adoption.

evloghq/evlog

ClickHouse数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from affaan-m/ECC.

affaan-m/ECC