Topic · Databases
Best data warehousing skills for Claude Code, Codex and other agents.
- skills
- 278
- official
- 70
Data warehousing skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 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/ | 394 | 2 repos | ~1.4k | Automated safety check: Pass | Apache-2.0 | today |
| 2 | Build or review Langfuse backend code. An agent skill from langfuse/langfuse. | langfuse/ | 35k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 3 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | hellangleZ/ | 112 | 14 repos | ~2.5k | Automated safety check: Pass | No licence | 8 mo ago |
| 4 | 4.Chdb SQL 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/ | 394 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | today |
| 5 | Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema. | airbytehq/ | 22k | — | ~918 | Automated safety check: Pass | Unknown | today |
| 6 | Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting. | ClickHouse/ | 1.6k | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 7 | MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. | vemetric/ | 394 | 2 repos | ~791 | Automated safety check: Pass | Apache-2.0 | today |
| 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/ | 4.1k | — | ~774 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 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/ | 544 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 8 days ago |
| 10 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | vemetric/ | 394 | 2 repos | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 11 | Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. | FrankChen021/ | 327 | — | ~731 | Automated safety check: Pass | Unknown | 2 mo ago |
| 12 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | langfuse/ | 35k | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | today |
| 13 | Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection. | sidequery/ | 129 | — | ~5.5k | Automated safety check: Pass | AGPL-3.0 | today |
| 14 | Score and prepare Power BI semantic models for AI (Fabric Data Agent / Copilot). | DKH-DK/ | 113 | — | ~2k | Automated safety check: Pass | No licence | 3 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/ | 129 | 1 repo | ~2.5k | Automated safety check: Pass | Apache-2.0 | 1 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/ | 165 | — | ~8.5k | Automated safety check: Pass | Unknown | 3 days ago |
| 17 | Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output. | ClickHouse/ | 1.6k | — | ~457 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 18 | Queries the data warehouse with SQL and answers business questions about data. | astronomer/ | 450 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 19 | 19.Surf Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls. | BlockRunAI/ | 6.6k | — | ~4k | Automated safety check: Pass | MIT | 2 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/ | 125 | — | ~2k | Automated safety check: Pass | Apache-2.0 | 7 days ago |
| 21 | Scaffold, build, and verify a neocarta source or format connector against the connector contract. | neo4j-labs/ | 145 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 22 | 22.Mfs Find 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/ | 150 | — | ~4k | Automated safety check: Pass | Apache-2.0 | 2 mo ago |
| 23 | Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo. | litefuse/ | 100 | 1 repo | ~5.8k | Automated safety check: Pass | Unknown | 14 days ago |
| 24 | Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator. | ar-io/ | 127 | — | ~8.2k | Automated safety check: Notes | AGPL-3.0 | today |
| 25 | Generate or improve a company-specific data analysis skill by extracting tribal knowledge from analysts. | w95/ | 235 | 1 repo | ~1.8k | Automated safety check: Pass | MIT | 7 mo ago |
| 26 | 26.Release Cut a stable hypequery release via Changesets, or explain/check the canary flow. | hypequery/ | 103 | — | ~623 | Automated safety check: Pass | Unknown | today |
| 27 | 27.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | today |
| 28 | 28.Mfs Ingest 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/ | 150 | — | ~4.7k | Automated safety check: Pass | Apache-2.0 | 2 mo ago |
| 29 | Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. | databricks/ | 345 | 1 repo | ~2.8k | Automated safety check: Pass | Unknown | yesterday |
| 30 | 30.Code Review Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests. | ClickHouse/ | 1.6k | — | ~290 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 31 | Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx. | tempoxyz/ | 107 | — | ~3.1k | Automated safety check: Pass | MIT | yesterday |
| 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/ | 127 | — | ~1.4k | Automated safety check: Pass | MIT | 6 days ago |
| 33 | 33.Datajunction Activate this skill whenever working with DataJunction (DJ) semantic layer. | DataJunction/ | 161 | — | ~2k | Automated safety check: Pass | MIT | 2 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/ | 126 | — | ~3k | Automated safety check: Notes | MIT | yesterday |
| 35 | 🇺🇸 B2B SaaS Growth — PLG vs SLG Playbook — Diagnose whether your problem is distribution, pricing, or PMF. | Gingiris-1031/ | 110 | — | ~1.2k | Automated safety check: Pass | No licence | 2 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/ | 327 | — | ~610 | Automated safety check: Pass | Unknown | 2 mo ago |
| 37 | Learn from public breach disclosures — extract the audit question each one implies and check your own stack. | briiirussell/ | 412 | — | ~3.5k | Automated safety check: Notes | MIT | 4 mo ago |
| 38 | MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. | ClickHouse/ | 544 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 8 days ago |
| 39 | Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer. | sidequery/ | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | today |
| 40 | Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis. | warpdotdev/ | 825 | — | ~1.1k | Automated safety check: Pass | MIT | 1 mo ago |
| 41 | 41.Manual Test Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance. | hypequery/ | 103 | — | ~618 | Automated safety check: Pass | Unknown | today |
| 42 | Write idiomatic application code with the ClickHouse Node.js client (@clickhouse/client). | vemetric/ | 394 | 1 repo | ~2.8k | Automated safety check: Pass | AGPL-3.0 | today |
| 43 | Analyzes BigQuery slot use, query costs and execution bottlenecks from INFORMATION_SCHEMA to diagnose slow queries, slot contention and unpartitioned scans. | google/ | 21k | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 44 | Skill for Graph Query Language (GQL) or SQL/PGQ queries against a property graph. | google/ | 22k | — | ~4.8k | Automated safety check: Pass | Apache-2.0 | today |
| 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/ | 113 | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 46 | TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and… | 2025Emma/ | 23k | 1 repo | ~750 | Automated safety check: Pass | MIT | 9 mo ago |
| 47 | 47.Testing 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/ | 127 | — | ~2.6k | Automated safety check: Notes | AGPL-3.0 | today |
| 48 | Work inside the Databuddy monorepo for internal implementation, debugging, review, and refactoring. | databuddy-analytics/ | 1.2k | — | ~11k | Automated safety check: Notes | AGPL-3.0 | today |
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.