Topic · Databases
Best data warehousing skills, page 4
Data warehousing skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 145 | Full inventory and audit of AWS Glue Data Catalog assets across S3 Tables, Redshift-federated, and remote Iceberg catalogs. | aws/ | 2.8k | 1 repo | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 146 | Import data into the AWS data lake from S3 files, local uploads, JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS, Aurora), Amazon Redshift, Snowflake, BigQuery, DynamoDB, or existing Glue… | aws/ | 2.8k | 1 repo | ~2.8k | Automated safety check: Pass | Apache-2.0 | today |
| 147 | Internal — for Boundless team members only. An agent skill from boundless-xyz/boundless. | boundless-xyz/ | 193 | — | ~3.8k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 148 | 148.UI UX Audit Automated UI/UX + accessibility audit for the ClickHouse Monitor dashboard (apps/dashboard-tsr). | chmonitor/ | 299 | — | ~2k | Automated safety check: Notes | GPL-3.0 | 2 days ago |
| 149 | 149.SQL Sentinel Audit SQL for the cost & performance anti-patterns that burn warehouse credits. | sickn33/ | 47k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | today |
| 150 | 150.Warehouse Plan and review read-only data warehouse analysis with explicit scope, privacy, provenance, and validation checks. | sickn33/ | 47k | 1 repo | ~1.7k | Automated safety check: Pass | MIT | today |
| 151 | Provides data-retrieval best practices, tool selection guidance, and performant SQL query syntax for BigQuery telemetry across INFORMATIONSCHEMA, Cloud Monitoring, and the REST API. | google/ | 21k | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | today |
| 152 | Provides workflows to optimize BigQuery environments (capacity planning, editions), storage assets (partitioning, clustering, storage lifecycles, billing models), and SQL queries. | google/ | 21k | — | ~2k | Automated safety check: Pass | Apache-2.0 | today |
| 153 | Provides diagnostic workflows and step-by-step root-cause analysis procedures for actively broken, failing, or slow BigQuery jobs, execution graph and query plan stage bottlenecks, system… | google/ | 21k | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | today |
| 154 | Summarizes Google Cloud Data Lineage graphs to help users debug data quality issues and understand data provenance for BQ/GCS. | google/ | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 155 | Answer natural language questions and perform analysis on GKE cluster and workload costs using BigQuery billing exports, cost allocation data, and live cluster monitoring metrics. | google/ | 21k | — | ~1.5k | Automated safety check: Pass | Apache-2.0 | today |
| 156 | Stores, retrieves, and manages data as objects in Cloud Storage on Google Cloud (also known colloquially as GCS) buckets. | google/ | 21k | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | today |
| 157 | A skill your agent uses to manage Google Cloud Workload Manager evaluations, rules, scanned resources, and validation results by using public client libraries and the REST API. | google/ | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 158 | 158.Snowflake Use this when converting an AI-generated static HTML page (Stardust, Mobirise, Relume, Lovable, v0, Figma-derived, etc.) into an Edge Delivery Services page while preserving the original design and… | adobe/ | 196 | — | ~3.7k | Automated safety check: Pass | Apache-2.0 | today |
| 159 | 159.SQL Queries Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills. | phuryn/ | 27k | — | ~907 | Automated safety check: Pass | MIT | 23 days ago |
| 160 | 160.Bigquery Basics Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. | davila7/ | 32k | — | ~1.1k | Automated safety check: Pass | MIT | today |
| 161 | A skill your agent uses when polypainting in ZBrush (skin color zones, fills, cavity or AO passes, Spotlight), baking polypaint to a texture or vertex color, rendering a ZBrush model with BPR or… | scenario-labs/ | 913 | — | ~4.6k | Automated safety check: Pass | MIT | yesterday |
| 162 | 162.Clickhouse Io ClickHouse 数据库模式、查询优化、分析以及高性能分析负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh. | xu-xiang/ | 2k | — | ~2.2k | Automated safety check: Pass | MIT | 7 mo ago |
| 163 | Core skill for game sentiment querying and analysis. An agent skill from infometa/workbuddyskills. | infometa/ | 344 | — | ~3.3k | Automated safety check: Warn | No licence | today |
| 164 | How to add a new ingestion warning type to the event ingestion pipeline. | PostHog/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 165 | Analyze the experiment precompute result-consistency canary across prod-US and prod-EU, deep-dive any issues, and produce an actionable report. | PostHog/ | 40k | — | ~3.5k | Automated safety check: Pass | Unknown | today |
| 166 | Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas synced into the dogfood data warehouse (US project 2, "PostHog App + Website"). | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
| 167 | Audit the health of a PostHog project's materialized views (saved queries) — find every failed materialization and flag unused or stale materialized views that cost storage and compute. | PostHog/ | 40k | — | ~1.5k | Automated safety check: Pass | Unknown | today |
| 168 | ClickHouse migration patterns and rules. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~3k | Automated safety check: Pass | Unknown | today |
| 169 | Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~2.4k | Automated safety check: Notes | Unknown | today |
| 170 | Write or update the user-facing posthog.com documentation for a PostHog Data warehouse import source. | PostHog/ | 40k | — | ~1.7k | Automated safety check: Pass | Unknown | today |
| 171 | Implement and extend PostHog Data warehouse import sources. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~22k | Automated safety check: Pass | Unknown | today |
| 172 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 173 | Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (teamid, distinctid, sessionid, partition) during incident triage. | PostHog/ | 40k | — | ~2.3k | Automated safety check: Pass | Unknown | today |
| 174 | Strategic guidance for designing modern data platforms, covering storage paradigms (data lake, warehouse, lakehouse), modeling approaches (dimensional, normalized, data vault, wide tables), data… | ancoleman/ | 526 | — | ~3.6k | Automated safety check: Pass | MIT | 10 mo ago |
| 175 | 175.Deploying On GCP Implement applications using Google Cloud Platform (GCP) services. | ancoleman/ | 526 | — | ~3.9k | Automated safety check: Pass | MIT | 10 mo ago |
| 176 | Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness. | github/ | 40k | 1 repo | ~1.3k | Automated safety check: Pass | MIT | today |
| 177 | Running experiments out of the data warehouse instead of via dedicated experiment platforms. | rampstackco/ | 940 | — | ~7.3k | Automated safety check: Pass | MIT | yesterday |
| 178 | Build reusable activation models — an activation-rate metric and a per-user/per-account activated flag — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | today |
| 179 | Build reusable conversion models — funnel/step conversion rates, drop-off, and time-to-convert — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | today |
| 180 | Build reusable dimension / lookup tables for a star schema — country/region, timezone, currency, date, plan/product, and other descriptive attributes — on either PostHog data-warehouse views (HogQL)… | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | today |
| 181 | Build reusable product-usage and engagement models — retention, stickiness, and lifecycle — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.3k | Automated safety check: Pass | Unknown | today |
| 182 | Shared foundations for building reusable data models in PostHog, on either of two stacks: PostHog-native data-warehouse views / materialized views (HogQL, via the view- MCP tools), or an external… | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 183 | Retrieve, query, and identify relevant Cloud Monitoring metric descriptors on Google Cloud for a service or resource (such as Compute Engine, Spanner, BigQuery, Cloud Run, Cloud SQL, Pub/Sub, Cloud… | google/ | 21k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | today |
| 184 | Discovers requirements and designs a borderless open data lakehouse using Lakehouse for Apache Iceberg and BigQuery data agents. | google/ | 21k | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | today |
| 185 | Discovers requirements and designs an end-to-end governed agentic analytics solution using Knowledge Catalog and Managed Service for Apache Spark (Lightning Engine). | google/ | 21k | — | ~4.4k | Automated safety check: Pass | Apache-2.0 | today |
| 186 | 186.Warehouse Init Initialize warehouse schema discovery. An agent skill from astronomer/agents. | astronomer/ | 451 | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | today |
| 187 | 187.Sap Datasphere SAP Datasphere development skill with 3 specialized agents, 5 slash commands, and validation hooks. | secondsky/ | 462 | — | ~6k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 188 | Amazon Redshift domain expertise for query optimization, operational reviews, and cost optimization on provisioned clusters and Serverless workgroups. | aws/ | 100 | — | ~7.3k | Automated safety check: Pass | Apache-2.0 | today |
| 189 | Fix ClickHouse query errors when querying AggregatingMergeTree tables that use state functions. | divinevideo/ | 266 | — | ~1.7k | Automated safety check: Pass | MPL-2.0 | today |
| 190 | Analyzes the downstream impact (blast radius) when a BigQuery table or view is broken, stale, or modified. | google/ | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 191 | Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. | google/ | 21k | — | ~985 | Automated safety check: Pass | Apache-2.0 | today |
| 192 | Decision tree for thiserror (library crates) vs anyhow (CLI/binary) in the Rocky engine workspace. | rocky-data/ | 304 | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | today |