Topic · Databases
Best data warehousing skills, page 3
Data warehousing skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 97 | Adding a new warehouse or source adapter crate to the Rocky engine. | rocky-data/ | 304 | — | ~2k | Automated safety check: Pass | Apache-2.0 | today |
| 98 | Serverless Aura Graph Analytics (AGA) GDS Sessions — covers GdsSessions, AuraGraphDataScience, AuraAPICredentials, DbmsConnectionInfo, SessionMemory, getorcreate, remote graph projection with… | neo4j-contrib/ | 114 | — | ~4.6k | Automated safety check: Notes | MIT | yesterday |
| 99 | Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 100 | 100.Add Analytics Design or add Sesori product analytics. An agent skill from sesori-ai/sesori_apps_monorepo. | sesori-ai/ | 126 | — | ~1.8k | Automated safety check: Pass | Unknown | today |
| 101 | 101.Simplywallst Data financiera de 120K+ stocks globales: snowflake scores, valuation, financial health, dividend analysis, insider transactions. | gauss314/ | 246 | — | ~2.9k | Automated safety check: Pass | MIT | 3 mo ago |
| 102 | Translates Snowflake dbt SQL models into standardized BigQuery SQL, keeping Jinja constructs and tracking progress in a migration tasks file. | google/ | 21k | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | today |
| 103 | MUST use when writing Snowflake queries. An agent skill from windmill-labs/windmill. | windmill-labs/ | 18k | — | ~2.2k | Automated safety check: Pass | Unknown | today |
| 104 | 104.Clickhouse Io 고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례. | affaan-m/ | 275k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | 3 days ago |
| 105 | 105.SQL Queries Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). | w95/ | 237 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | 7 mo ago |
| 106 | 106.Clickhouse Io ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | affaan-m/ | 275k | 1 repo | ~2.7k | Automated safety check: Pass | MIT | 3 days ago |
| 107 | 107.GCP Audit Logs Configure GCP Cloud Audit Logs for compliance. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~3.8k | Automated safety check: Pass | MIT | today |
| 108 | Runs 2 to 30 Pure functions or tests concurrently on the warm LSP daemon via pure-lsp execute-parallel, or every test in a package or .pure file with --package/--source. | finos/ | 112 | — | ~927 | Automated safety check: Pass | Apache-2.0 | today |
| 109 | Benchling Python SDK and REST API integration for registry entities, inventory, ELN entries, workflows, Benchling Apps, and Data Warehouse queries. | K-Dense-AI/ | 48k | 1 repo | ~2.1k | Automated safety check: Notes | MIT | 2 days ago |
| 110 | 110.Lamindb Manages biological datasets and models with LaminDB, including artifact registration, lineage tracking, schema validation, Bionty ontology annotation, query/search, collections, branches, storage… | K-Dense-AI/ | 48k | 1 repo | ~2.1k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 111 | 111.Whodb Database operations including querying, schema exploration, and data analysis. | xiaoyuge886/ | 198 | — | ~894 | Automated safety check: Pass | MIT | 2 mo ago |
| 112 | ClickHouse queries, Goose migrations, chdb test schema, or telemetry storage paths. | latitude-dev/ | 4.7k | — | ~1.2k | Automated safety check: Pass | MIT | today |
| 113 | How to add a new attribute value (dimension) that the generic org-scoped telemetry.query analytics endpoint can group by and filter on. | speakeasy-api/ | 272 | — | ~2.4k | Automated safety check: Pass | AGPL-3.0 | today |
| 114 | Query the live/remote Snowflake warehouse instead of the local practice copy. | ai-analyst-lab/ | 304 | — | ~1.4k | Automated safety check: Notes | MIT | 7 days ago |
| 115 | 115.Data Engineering Data engineering patterns for ETL pipelines, data warehousing, Apache Spark, and data quality validation | rohitg00/ | 2.7k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | 4 mo ago |
| 116 | A skill your agent uses to get context about Fabric Lakehouse and its features for software systems and AI-powered functions. | github/ | 40k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | today |
| 117 | Power BI semantic modeling assistant for building optimized data models. | github/ | 40k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | today |
| 118 | Twice-monthly check that evlog's drain adapters still send what each provider's own client sends. | evloghq/ | 1.9k | — | ~1.3k | Automated safety check: Pass | MIT | today |
| 119 | Queries and downloads public cancer imaging data from NCI Imaging Data Commons. | K-Dense-AI/ | 48k | 1 repo | ~7.8k | Automated safety check: Pass | MIT | 2 days ago |
| 120 | Manages datasets, tables, and jobs in BigQuery. An agent skill from google/skills. | google/ | 21k | 1 repo | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 121 | Generates Python code using BigQuery DataFrames (BigFrames). | google/ | 21k | 1 repo | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 122 | Expert guide for pushing metadata, lineage, and query logs to Monte Carlo from any data warehouse. | sickn33/ | 47k | 1 repo | ~4.6k | Automated safety check: Pass | MIT | today |
| 123 | 123.Fabric CLI Expert guidance for the Fabric CLI (fab) and the Fabric and Power BI REST APIs: workspaces, items, lakehouses, notebooks, pipelines, semantic models, reports, capacities, OneLake, deployment and… | data-goblin/ | 1k | — | ~10k | Automated safety check: Pass | GPL-3.0 | today |
| 124 | 124.Testing Writing or debugging tests, choosing unit vs integration style, Postgres/ClickHouse tests, regenerating ClickHouse test schema, or exporting test helpers from packages without pulling test code into… | latitude-dev/ | 4.7k | — | ~1.1k | Automated safety check: Pass | MIT | today |
| 125 | Apache Iceberg tables on Databricks — Managed Iceberg tables, External Iceberg Reads (fka Uniform), Compatibility Mode, Iceberg REST Catalog (IRC), Iceberg v3, Snowflake interop, PyIceberg, OSS… | databricks/ | 345 | — | ~2.6k | Automated safety check: Pass | Unknown | today |
| 126 | 126.Opensourcefaq 解答与开源产品有关的深度技术问题,输出图文并茂的 Markdown 技术文章。触发条件:用户提出与开源项目(如 PostgreSQL、Redis、Kafka、Kubernetes、ClickHouse、Flink 等)相关的技术问题,并提供源码目录或 URL、deepwiki repo 名称。即使用户只说"帮我解答这个开源问题"或"分析一下这个项目的某个机制",也应使用本… | digoal/ | 8.6k | — | ~966 | Automated safety check: Pass | GPL-2.0 | 10 days ago |
| 127 | Optimizes Snowflake query performance using query ID from history. | AltimateAI/ | 128 | — | ~919 | Automated safety check: Pass | MIT | 6 days ago |
| 128 | Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). | github/ | 40k | 1 repo | ~1.1k | Automated safety check: Pass | MIT | today |
| 129 | Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt… | sickn33/ | 47k | 2 repos | ~2.1k | Automated safety check: Pass | MIT | today |
| 130 | 130.Warehouse SQL Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants. | HybridAIOne/ | 158 | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 131 | Run isolated Moraine dev sandbox validation. An agent skill from eric-tramel/moraine. | eric-tramel/ | 117 | — | ~668 | Automated safety check: Pass | Apache-2.0 | 3 days ago |
| 132 | MUST use when writing BigQuery queries. | windmill-labs/ | 18k | — | ~2.2k | Automated safety check: Pass | Unknown | today |
| 133 | 133.Clickhouse Io ClickHouse 数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh. | xu-xiang/ | 2k | — | ~2.1k | Automated safety check: Pass | MIT | 7 mo ago |
| 134 | 134.Dbt Model Index Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse. | warpdotdev/ | 825 | — | ~915 | Automated safety check: Pass | MIT | 1 mo ago |
| 135 | Chief Data Officer advisory for startups: AI training data rights and consent provenance, data product strategy (warehouse vs lakehouse vs mesh, build-vs-buy), B2B customer-data-as-asset valuation… | alirezarezvani/ | 28k | — | ~2.9k | Automated safety check: Pass | MIT | 1 mo ago |
| 136 | Design GCP architectures for startups and enterprises. An agent skill from alirezarezvani/claude-skills. | alirezarezvani/ | 28k | — | ~3.2k | Automated safety check: Pass | MIT | 1 mo ago |
| 137 | A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python… | alirezarezvani/ | 28k | — | ~3.2k | Automated safety check: Pass | MIT | 1 mo ago |
| 138 | Time-series database implementation for metrics, IoT, financial data, and observability backends. | ancoleman/ | 526 | — | ~1.7k | Automated safety check: Pass | MIT | 10 mo ago |
| 139 | 139.Plot Structure This skill should be used when the user asks to "create a plot arc", "story structure", "add a plot point", "story timeline", "track foreshadowing", "pacing", "sagging middle", "act structure"… | danjdewhurst/ | 279 | 1 repo | ~4k | Automated safety check: Notes | MIT | today |
| 140 | Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties already work: feature flag targeting… | PostHog/ | 40k | — | ~2.9k | Automated safety check: Pass | Unknown | today |
| 141 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 40k | — | ~5.1k | Automated safety check: Pass | Unknown | today |
| 142 | Build reusable revenue models — MRR, ARR, gross revenue, new/expansion/contraction/churn, ARPU, LTV, and per-customer/per-account revenue — on either PostHog data-warehouse views (HogQL) or an… | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 143 | Root-cause a vLLM torch-nightly CI regression report. An agent skill from pytorch/test-infra. | pytorch/ | 113 | — | ~2.4k | Automated safety check: Pass | Unknown | today |
| 144 | Create and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery. | aws/ | 2.8k | 1 repo | ~2.2k | Automated safety check: Pass | Apache-2.0 | today |