Topic · Databases
Best data warehousing skills, page 5
Data warehousing skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 193 | 193.Cdo Review /cs:cdo-review <plan — Decision-driven Chief Data Officer interrogation of any plan that touches training data, data architecture, data productization, or data team hiring. | alirezarezvani/ | 28k | — | ~1.3k | Automated safety check: Pass | MIT | 1 mo ago |
| 194 | 194.Bigquery Public Run read-only SQL against BigQuery public datasets with local result capture, cost safeguards, and reproducibility outputs. | ClawBio/ | 1.2k | — | ~1.5k | Automated safety check: Pass | MIT | today |
| 195 | Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password. | PostHog/ | 40k | — | ~585 | Automated safety check: Pass | Unknown | today |
| 196 | Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production. | PostHog/ | 40k | — | ~9.1k | Automated safety check: Pass | Unknown | today |
| 197 | Workflow for optimizing ClickHouse and HogQL queries. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~5.7k | Automated safety check: Pass | Unknown | today |
| 198 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
| 199 | Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights. | PostHog/ | 40k | — | ~2.3k | Automated safety check: Pass | Unknown | today |
| 200 | 200.Sragent Query the Sequence Read Archive (SRA), retrieve scientific publications, and analyze genomics metadata using the SRAgent toolkit. | aiskillstore/ | 430 | 2 repos | ~3.5k | Automated safety check: Pass | No licence | today |
| 201 | 201.Query Validation SQL query review for correctness, performance, and best practices. | nimrodfisher/ | 465 | — | ~551 | Automated safety check: Pass | MIT | 12 days ago |
| 202 | Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores (taskstatestore, assetstatestore) and the crash-safe ResumableJobMixin. | astronomer/ | 451 | — | ~6.1k | Automated safety check: Pass | Apache-2.0 | today |
| 203 | Operates Amazon MSK Provisioned clusters (Standard and Express brokers). | aws/ | 2.8k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 204 | Execute and manage Athena SQL queries across default and federated catalogs (Glue, S3 Tables, Redshift). | aws/ | 2.8k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | today |
| 205 | Prove the deployed chmonitor product actually works, not just that the Worker answers. | chmonitor/ | 299 | — | ~2.2k | Automated safety check: Notes | GPL-3.0 | 2 days ago |
| 206 | 206.Rocky Config Canonical rocky.toml authoring reference. An agent skill from rocky-data/rocky. | rocky-data/ | 304 | — | ~6.9k | Automated safety check: Pass | Apache-2.0 | today |
| 207 | Generate a copy-paste Grafana data source provisioning file (YAML or Terraform) for any plugin from its standardized settings schema on the plugins CDN. | grafana/ | 279 | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 208 | Fix ClickHouse Cloud migration failures caused by multi-table RENAME statements. | divinevideo/ | 266 | — | ~1.4k | Automated safety check: Pass | MPL-2.0 | today |
| 209 | 209.Setup Snowflake First-time Snowflake setup wizard for the NATIVE ConnectionManager path (the connection the analyst actually queries through, with auto-logged provenance). | ai-analyst-lab/ | 304 | — | ~2k | Automated safety check: Notes | MIT | 7 days ago |
| 210 | 210.Using Duckdb Query Fabric lakehouse and warehouse data using DuckDB, either locally or inside a Fabric notebook. | data-goblin/ | 1k | — | ~1.2k | Automated safety check: Pass | GPL-3.0 | today |
| 211 | Signals scout for warehouse imports. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~11k | Automated safety check: Pass | Unknown | today |
| 212 | Add support for a new vendor API version to an existing Data warehouse import source, or deprecate an old one. | PostHog/ | 40k | — | ~8.6k | Automated safety check: Pass | Unknown | today |
| 213 | Guide for writing performant ClickHouse queries in PostHog product code. | PostHog/ | 40k | — | ~575 | Automated safety check: Pass | Unknown | today |
| 214 | Optimizes Snowflake SQL query performance from provided query text. | AltimateAI/ | 128 | — | ~1.7k | Automated safety check: Pass | MIT | 6 days ago |
| 215 | Audit Snowflake effective access and produce a safe least-privilege change packet. | jeremylongshore/ | 2.8k | — | ~3.2k | Automated safety check: Pass | MIT | today |
| 216 | Audit and analyze Snowflake warehouse, serverless, Adaptive, storage, transfer, and AI cost evidence with a typed ledger that prevents double counting and exposes freshness, attribution, control… | jeremylongshore/ | 2.8k | — | ~4.1k | Automated safety check: Pass | MIT | today |
| 217 | Assess trusted Snowflake data metric function coverage and expectation evidence without reading customer rows. | jeremylongshore/ | 2.8k | — | ~2k | Automated safety check: Pass | MIT | today |
| 218 | Review and safely diagnose Snowflake infrastructure and database deployments across the snowflakedb/snowflake Terraform 2.x provider, grants/state/imports, schemachange versioned and repeatable… | jeremylongshore/ | 2.8k | — | ~3.9k | Automated safety check: Pass | MIT | today |
| 219 | Analyze Snowflake failover-group RPO/RTO readiness from independently trusted, privacy-preserving live receipts without executing refresh, failover, failback, redirect, cancellation, resume, or… | jeremylongshore/ | 2.8k | — | ~2.1k | Automated safety check: Pass | MIT | today |
| 220 | Audit trusted Snowflake classification, tags, masking, row access, projection, join, aggregation, and privacy-policy evidence without reading customer data. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 221 | Preflight Snowflake Native App package releases from trusted, privacy-safe provider evidence without publishing, upgrading, altering, granting, or approving anything. | jeremylongshore/ | 2.8k | — | ~2k | Automated safety check: Pass | MIT | today |
| 222 | Analyze Snowflake pipelines spanning tasks, streams, dynamic tables, and Snowpipe from bounded read-only evidence. | jeremylongshore/ | 2.8k | — | ~2.7k | Automated safety check: Pass | MIT | today |
| 223 | Audit, analyze, and diagnose completed or failed Snowflake queries from query history, Query Insights, and GETQUERYOPERATORSTATS evidence. | jeremylongshore/ | 2.8k | — | ~4.3k | Automated safety check: Pass | MIT | today |
| 224 | Pilot a Snowflake authentication modernization without lockouts or credential exposure. | jeremylongshore/ | 2.8k | — | ~3k | Automated safety check: Pass | MIT | today |
| 225 | 225.SQL Queries 将自然语言描述转化为 SQL 查询语句。支持 BigQuery、PostgreSQL、MySQL 及其他方言。可从上传的结构图或文档中读取数据库结构。适用于编写 SQL、构建数据报表、探查数据库,或将业务问题转化为查询语句。 | killvxk/ | 168 | — | ~423 | Automated safety check: Pass | MIT | 6 mo ago |
| 226 | This skill should be used when the user asks to "optimize Snowflake queries", "analyze Snowflake SQL performance", "size Snowflake warehouses", "review Snowflake data models", or "troubleshoot… | borghei/ | 881 | — | ~746 | Automated safety check: Pass | MIT | today |
| 227 | 227.Agent SQL Pro Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. | xiaoyuge886/ | 198 | — | ~315 | Automated safety check: Pass | MIT | 2 mo ago |
| 228 | Enables Redshift system-table (SYS) log publishing to S3 Tables in Apache Iceberg format for both Provisioned clusters and Serverless namespaces, verifies publishing status, and queries the… | aws/ | 2.8k | — | ~5.9k | Automated safety check: Pass | Apache-2.0 | today |
| 229 | 229.Data Export Export marketing data — metrics, contacts, campaigns, performance snapshots — to BigQuery, Google Sheets, or Supabase as clean tabular data with schema documentation, PII redaction, and post-export… | indranilbanerjee/ | 855 | 1 repo | ~3.7k | Automated safety check: Pass | MIT | 4 days ago |
| 230 | 230.Setup Assistant Guides through installation, configuration, and first-time setup of the Claude Patent Creator system. | RobThePCGuy/ | 196 | — | ~1.4k | Automated safety check: Notes | MIT | yesterday |
| 231 | Diagnoses and resolves MCP server registration failures, GPU detection, BigQuery authentication, index build failures, import errors, search quality issues, and performance problems. | RobThePCGuy/ | 196 | — | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 232 | Guide customers through building an inbound lead-routing workflow in Clay Workflows. | clay-run/ | 130 | — | ~1.8k | Automated safety check: Pass | No licence | today |
| 233 | Fix HTTP 500 / ClickHouse "column not found" errors when filtering by a MATERIALIZED column through a VIEW that doesn't expose it. | divinevideo/ | 266 | — | ~1k | Automated safety check: Pass | MPL-2.0 | today |
| 234 | Run Neo4j Graph Analytics algorithms (PageRank, Louvain, WCC, Dijkstra, KNN, Node2Vec, FastRP, GraphSAGE) directly inside Snowflake without moving data. | neo4j-contrib/ | 114 | — | ~7k | Automated safety check: Notes | MIT | yesterday |
| 235 | 235.Gram Demo Seed A skill your agent uses when adding a new feature or changing an existing one that surfaces data in the dashboard — the demo org (app.getgram.ai/explore-demo) must show it — and when editing or… | speakeasy-api/ | 272 | — | ~2.5k | Automated safety check: Pass | AGPL-3.0 | today |
| 236 | Exports Amazon RDS or Aurora database snapshots to Amazon S3 in Apache Parquet format for analytics, backup, or data migration. | aws/ | 2.8k | — | ~495 | Automated safety check: Pass | Apache-2.0 | today |
| 237 | Operates Amazon Kinesis Data Streams (KDS). An agent skill from aws/agent-toolkit-for-aws. | aws/ | 2.8k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 238 | Guides an end-to-end data-warehouse migration to Amazon Redshift — discovery, schema/SQL/stored-procedure/macro/script conversion, data migration, validation, performance comparison, and reporting. | aws/ | 2.8k | — | ~2.7k | Automated safety check: Notes | Apache-2.0 | today |
| 239 | Amazon Redshift is NOT PostgreSQL — corrects PostgreSQL-derived LLM mistakes; covers Redshift-specific SQL, DDL, COPY/UNLOAD, system views, metadata discovery, and operational patterns. | aws/ | 2.8k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 240 | 240.Cloud SaaS Mode Work on chmonitor's Cloud (SaaS) vs self-hosted (OSS) behaviour from ONE codebase. | chmonitor/ | 299 | — | ~2.5k | Automated safety check: Notes | GPL-3.0 | 2 days ago |