Topic · Databases

Best data warehousing skills for Claude Code, Codex and other agents.

Skills that model and query analytical data warehouses.
skills
278
official
70

Data warehousing skills, ranked

Ranked by score. Sort bymost stars,trending,newest,recently updated

Data warehousing skills, ranked
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
1

A skill your agent uses when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas.

vemetric/vemetric3942 repos~1.4kAutomated safety check: PassApache-2.0today
2

Build or review Langfuse backend code. An agent skill from langfuse/langfuse.

langfuse/langfuse35k—~1.9kAutomated safety check: PassUnknowntoday
3

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

hellangleZ/burn-in-cceverywhere-ralph11214 repos~2.5kAutomated safety check: PassNo licence8 mo ago
4

A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…

vemetric/vemetric3941 repo~1.2kAutomated safety check: PassApache-2.0today
5

Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema.

airbytehq/airbyte22k—~918Automated safety check: PassUnknowntoday
6

Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.

ClickHouse/clickhouse-java1.6k—~3.1kAutomated safety check: PassApache-2.0yesterday
7

MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.

vemetric/vemetric3942 repos~791Automated safety check: PassApache-2.0today
8

Administers Observal users, settings, diagnostics, review queues, security events, audit logs, SAML, SCIM, the local Observal server, its upgrades and rollback, and its own PostgreSQL and ClickHouse…

Observal/Observal4.1k—~774Automated safety check: PassApache-2.0yesterday
9

Generates TypeScript or JavaScript readers and writers for ClickHouse's RowBinary formats over HTTP in Node.js, after checking that RowBinary suits the data.

ClickHouse/agent-skills544—~1.3kAutomated safety check: PassApache-2.08 days ago
10

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

vemetric/vemetric3942 repos~2.6kAutomated safety check: PassApache-2.0today
11

Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries.

FrankChen021/datastoria327—~731Automated safety check: PassUnknown2 mo ago
12

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

langfuse/langfuse35k—~3.5kAutomated safety check: PassApache-2.0today
13

Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection.

sidequery/sidemantic129—~5.5kAutomated safety check: PassAGPL-3.0today
14

Score and prepare Power BI semantic models for AI (Fabric Data Agent / Copilot).

DKH-DK/Self-Service-Power-BI-Fabric113—~2kAutomated safety check: PassNo licence3 mo ago
15

This skill should be used when the user wants to "set up tracing", "monitor my ADK agent", "configure logging", "add observability", "debug production traffic", or needs guidance on monitoring…

pifferologo/cloud-agents-cli1291 repo~2.5kAutomated safety check: PassApache-2.01 mo ago
16

Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling.

liam-machine/erd-studio165—~8.5kAutomated safety check: PassUnknown3 days ago
17

Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output.

ClickHouse/clickhouse-java1.6k—~457Automated safety check: PassApache-2.0yesterday
18

Queries the data warehouse with SQL and answers business questions about data.

astronomer/agents450—~1.3kAutomated safety check: PassApache-2.02 days ago
19
19.Surf

Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls.

BlockRunAI/ClawRouter6.6k—~4kAutomated safety check: PassMIT2 days ago
20

A skill your agent uses when authoring or debugging ade-bench tasks that must run on both DuckDB and Snowflake, including shared project migrations, setup patches, and solution patches

dbt-labs/ade-bench125—~2kAutomated safety check: PassApache-2.07 days ago
21

Scaffold, build, and verify a neocarta source or format connector against the connector contract.

neo4j-labs/neocarta145—~1.9kAutomated safety check: PassApache-2.0yesterday
22

Search, grep, browse, and read across registered MFS data sources via the mfs CLI — codebases, docs, PDFs, web crawls, databases (postgres/mysql/mongo/snowflake/bigquery), issue trackers…

zilliztech/mfs150—~4kAutomated safety check: PassApache-2.02 mo ago
23

Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo.

litefuse/litefuse1001 repo~5.8kAutomated safety check: PassUnknown14 days ago
24

Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator.

ar-io/ar-io-node127—~8.2kAutomated safety check: NotesAGPL-3.0today
25

Generate or improve a company-specific data analysis skill by extracting tribal knowledge from analysts.

w95/awesome-claude-corporate-skills2351 repo~1.8kAutomated safety check: PassMIT7 mo ago
26

Cut a stable hypequery release via Changesets, or explain/check the canary flow.

hypequery/hypequery103—~623Automated safety check: PassUnknowntoday
27

Build, validate, and manage semantic models using Sidemantic.

sidequery/sidemantic129—~4.2kAutomated safety check: PassApache-2.0today
28

Register, update, or re-sync data sources for MFS so they become searchable — postgres / mysql / mongo / snowflake / bigquery, github / jira / linear / notion / hubspot / zendesk, slack / discord /…

zilliztech/mfs150—~4.7kAutomated safety check: PassApache-2.02 mo ago
29
29.Databricks DbsqlOfficial

Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.

databricks/databricks-agent-skills3451 repo~2.8kAutomated safety check: PassUnknownyesterday
30

Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests.

ClickHouse/clickhouse-java1.6k—~290Automated safety check: PassApache-2.0yesterday
31

Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx.

tempoxyz/tidx107—~3.1kAutomated safety check: PassMITyesterday
32

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

AltimateAI/data-engineering-skills127—~1.4kAutomated safety check: PassMIT6 days ago
33

Activate this skill whenever working with DataJunction (DJ) semantic layer.

DataJunction/dj161—~2kAutomated safety check: PassMIT2 days ago
34

Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials.

computesdk/benchmarks126—~3kAutomated safety check: NotesMITyesterday
35

🇺🇸 B2B SaaS Growth — PLG vs SLG Playbook — Diagnose whether your problem is distribution, pricing, or PMF.

Gingiris-1031/Competitor-analysis-tool110—~1.2kAutomated safety check: PassNo licence2 days ago
36

Diagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-code root cause analysis.

FrankChen021/datastoria327—~610Automated safety check: PassUnknown2 mo ago
37

Learn from public breach disclosures — extract the audit question each one implies and check your own stack.

briiirussell/cybersecurity-skills412—~3.5kAutomated safety check: NotesMIT4 mo ago
38

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.

ClickHouse/agent-skills544—~1.2kAutomated safety check: PassApache-2.08 days ago
39

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

sidequery/sidemantic129—~982Automated safety check: PassAGPL-3.0today
40

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

warpdotdev/oz-skills825—~1.1kAutomated safety check: PassMIT1 mo ago
41

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

hypequery/hypequery103—~618Automated safety check: PassUnknowntoday
42

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

vemetric/vemetric3941 repo~2.8kAutomated safety check: PassAGPL-3.0today
43

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

google/skills21k—~2.3kAutomated safety check: PassApache-2.0yesterday
44
44.Bigquery GraphOfficial

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

google/adk-python22k—~4.8kAutomated safety check: PassApache-2.0today
45

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-infra113—~2.8kAutomated safety check: PassUnknowntoday
46

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

2025Emma/vibe-coding-cn23k1 repo~750Automated safety check: PassMIT9 mo ago
47

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-node127—~2.6kAutomated safety check: NotesAGPL-3.0today
48

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

databuddy-analytics/Databuddy1.2k—~11kAutomated safety check: NotesAGPL-3.0today

Questions, answered from the data.

What is the best data warehousing skill?

Chdb Datastore from vemetric/vemetric ranks first of the 278 data warehousing skills listed here, with the highest score: its repository has 394 GitHub stars, 2 other GitHub owners carry a copy, its SKILL.md loads about 1.4k tokens and it passes the automated safety check with no findings. Next come Backend Dev Guidelines and Clickhouse Io.

Which data warehousing skills are official?

70 of the 278 data warehousing skills are official, published by the vendor's own GitHub organization: Source Snowflake E2E Tests, Ade Bench Cross DB Tasks, Databricks Dbsql, BigQuery Slot and Cost Optimizer, Bigquery Graph and 65 more.

How are these skills ranked?

By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.