Topic · Databases
Best data warehousing skills, page 6
Data warehousing skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 241 | 241.Gx Ga4 Expert Configure GA4 properties, GTM, custom events, conversions, audiences, and BigQuery export. | criptogus/ | 288 | — | ~749 | Automated safety check: Pass | MIT | 28 days ago |
| 242 | Printing Press CLI for Clickhouse Cloud. An agent skill from mvanhorn/printing-press-library. | mvanhorn/ | 2.1k | — | ~3.9k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 243 | Debug ClickHouse deserialization errors in Rust caused by column ORDER mismatch when using SELECT alias. | divinevideo/ | 265 | — | ~1.6k | Automated safety check: Pass | MPL-2.0 | today |
| 244 | Fix ClickHouse "Code: 243 Cannot reserve 1.00 MiB, not enough space" errors caused by system log tables (textlog, tracelog, processorsprofilelog, querylog) filling the disk. | divinevideo/ | 265 | — | ~2k | Automated safety check: Pass | MPL-2.0 | today |
| 245 | Deploy funnelcake (api + relay) to ANY environment (production, staging, poc) on GKE via ArgoCD. | divinevideo/ | 265 | — | ~3.6k | Automated safety check: Pass | MPL-2.0 | today |
| 246 | Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors. | divinevideo/ | 265 | — | ~810 | Automated safety check: Pass | MPL-2.0 | today |
| 247 | Debug "API returns data that doesn't exist in database" when multiple Kubernetes clusters exist (production, staging, POC). | divinevideo/ | 265 | — | ~1.3k | Automated safety check: Pass | MPL-2.0 | today |
| 248 | Fix "content disappears after publishing" bugs caused by REST API indexing lag. | divinevideo/ | 265 | — | ~1.3k | Automated safety check: Pass | MPL-2.0 | today |
| 249 | See what your chat is doing — pull usage & message metrics via REST, stream real-time events to your data/observability stack via webhooks, monitor client-side errors & the init/login path, and read… | cometchat/ | 129 | — | ~1.5k | Automated safety check: Pass | MIT | 2 days ago |
| 250 | Selects, investigates, and compares AWS object, file, and block storage services, and answers cost, performance, configuration, security, and troubleshooting questions about storage services. | aws/ | 2.8k | — | ~5.8k | Automated safety check: Pass | Apache-2.0 | today |
| 251 | Resolve data lake and lakehouse asset references across Glue Data Catalog, S3, S3 Tables, and Redshift. | aws/ | 2.8k | — | ~4.2k | Automated safety check: Warn | Apache-2.0 | today |
| 252 | 252.Setup Snowflake This skill should be used before any Snowflake command to verify MCP connectivity, guide users through access provisioning, and set the session context. | openshift-eng/ | 120 | — | ~1.9k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 253 | 253.Io Connectors Guides development and usage of I/O connectors in Apache Beam. | Kilo-Org/ | 189 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 254 | Reference for Snowflake Cortex AI Functions (AICOMPLETE, AICLASSIFY, AIEXTRACT, AIFILTER, etc.) and Cortex Search for building RAG applications entirely inside Snowflake. | Mindrally/ | 267 | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 255 | Best practices for Snowflake SQL, semi-structured data, and data pipelines built with Dynamic Tables, Streams, Tasks, and Snowpipe. | Mindrally/ | 267 | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 256 | Best practices for Snowpark Python (DataFrames, UDFs, UDTFs, stored procedures) and dbt with the dbt-snowflake adapter. | Mindrally/ | 267 | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 257 | 257.Bi Dashboard Full pipeline where an agent team collaborates to generate data warehouse design, KPI definitions, visualizations, and automated reports for a BI dashboard. | revfactory/ | 1.3k | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 258 | Local PostHog documentation reference (latest). An agent skill from olorehq/olore. | olorehq/ | 103 | — | ~598 | Automated safety check: Pass | MIT | yesterday |
| 259 | ClickHouse expert for columnar OLAP analytics, MergeTree engines, materialized views, and high-performance data warehousing. | theneoai/ | 183 | — | ~4.6k | Automated safety check: Pass | MIT | 4 mo ago |
| 260 | 260.Data Engineer Expert-level Data Engineer skill covering batch and streaming pipeline design, data warehouse modeling (dbt, Kimball), orchestration (Airflow, Prefect), cloud platforms (BigQuery, Snowflake… | theneoai/ | 183 | — | ~2.5k | Automated safety check: Pass | MIT | 4 mo ago |
| 261 | 261.Data Engineer Elite Data Engineer skill with expertise in building scalable data pipelines, ETL/ELT processes, data warehousing (Snowflake, BigQuery, Redshift), streaming (Kafka, Spark Streaming), and data lake… | theneoai/ | 183 | — | ~2.1k | Automated safety check: Pass | MIT | 4 mo ago |
| 262 | 262.Duckdb Expert DuckDB expert for embedded OLAP analytics, Parquet/CSV querying, and high-performance analytical SQL on local data. | theneoai/ | 183 | — | ~4.2k | Automated safety check: Pass | MIT | 4 mo ago |
| 263 | 263.GCP Cloud Expert Google Cloud Platform expert: GKE, BigQuery, Cloud Run, Vertex AI. | theneoai/ | 183 | — | ~2.4k | Automated safety check: Pass | MIT | 4 mo ago |
| 264 | 264.Lakehouse Expert Invoke when: User needs help with lakehouse architecture, Delta Lake, Apache Iceberg, or table format optimization. | theneoai/ | 183 | — | ~3.5k | Automated safety check: Pass | MIT | 4 mo ago |
| 265 | Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password. | PostHog/ | 721 | — | ~585 | Automated safety check: Pass | MIT | today |
| 266 | Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production. | PostHog/ | 721 | — | ~9.1k | Automated safety check: Pass | MIT | today |
| 267 | Workflow for optimizing ClickHouse and HogQL queries. An agent skill from PostHog/posthog-foss. | PostHog/ | 721 | — | ~5.7k | Automated safety check: Pass | MIT | today |
| 268 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 721 | — | ~1k | Automated safety check: Pass | MIT | today |
| 269 | 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/ | 721 | — | ~2.3k | Automated safety check: Pass | MIT | today |
| 270 | A skill your agent uses when the user asks about revenue, payments, subscriptions, billing, CRM deals, support tickets, ad spend, production database tables, or other data PostHog does not collect… | PostHog/ | 721 | — | ~2.2k | Automated safety check: Pass | MIT | today |
| 271 | 271.GCP Patterns Cloud Run deployment, BigQuery optimization, Pub/Sub patterns, IAM best practices | vibeeval/ | 531 | — | ~1.4k | Automated safety check: Pass | MIT | 2 mo ago |
| 272 | 272.Conversion Debug Conversion Tracking Debugger — diagnose discrepancies across GTM, GA4, Google Ads & Meta Pixel with live API access, BigQuery validation queries, and troubleshooting flowcharts | cognyai/ | 104 | — | ~6.7k | Automated safety check: Notes | No licence | 3 mo ago |
| 273 | Produces an API data extraction design covering authentication approach, pagination strategy, rate limit handling, response parsing specification, and error handling protocol. | FerroxLabs/ | 608 | — | ~4.6k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 274 | ClickHouse columnar OLAP expert covering table engine selection (MergeTree family), materialized views, aggregating merge trees, data sharding and replication, query optimization for analytical… | FerroxLabs/ | 608 | — | ~4.4k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 275 | Architecture expertise for data lakehouse platforms covering Delta Lake, Apache Iceberg, Apache Hudi, medallion architecture design, table format selection, storage optimization, schema evolution… | FerroxLabs/ | 608 | — | ~3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 276 | 276.Data Modeler Expert data modeling covering star schema, snowflake schema, Data Vault 2.0, dimensional modeling, slowly changing dimensions, bridge tables, fact table types, conformed dimensions, ERD creation… | FerroxLabs/ | 608 | — | ~5.2k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 277 | Produces a relational or dimensional data schema with entities, attributes, data types, keys, relationships, normalization decisions with rationale, and a schema diagram description. | FerroxLabs/ | 608 | — | ~4.5k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 278 | Designs a data warehouse structure by selecting star or snowflake schema, defining fact tables and dimension tables, specifying grain for each fact table, and producing the entity-relationship… | FerroxLabs/ | 608 | — | ~4.6k | Automated safety check: Pass | Apache-2.0 | yesterday |