Search
Databases · Data pipelines and ETL
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Stands up a throwaway local SQL Server 2022 backend, applies SQL fixtures and runs Airbyte spec, check, discover and read against source-mssql images. | airbytehq/ | 22k | — | ~4.4k | Automated safety check: Pass | Unknown | today |
| 2 | Stands up a throwaway local MySQL 8.0 backend, applies SQL fixtures and sweeps the Airbyte spec, check, discover and read commands against a source-mysql image. | airbytehq/ | 22k | — | ~2.6k | 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 | 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 |
| 5 | 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.6k | Automated safety check: Pass | Unknown | today |
| 6 | Queries the data warehouse with SQL and answers business questions about data. | astronomer/ | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 7 | Turns a Tushare API doc URL into a full data plugin for the stock_datasource repo: extractor, ClickHouse schema, query service, config and curl examples. | Yourdaylight/ | 189 | — | ~2.5k | Automated safety check: Pass | MIT | 1 mo ago |
| 8 | Reproduces MySQL binlog change-data-capture behavior for the Airbyte source-mysql connector on a local MySQL backend, with fixtures, a catalog and smoke cases. | airbytehq/ | 22k | — | ~1.8k | Automated safety check: Pass | Unknown | today |
| 9 | 9.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 10 | Reproduces PostgreSQL logical-decoding CDC behavior for Airbyte's source-postgres connector on a local backend, with CDC fixtures, a catalog and smoke case scripts. | airbytehq/ | 22k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 11 | Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context… | unxed/ | 243 | 2 repos | ~2.9k | Automated safety check: Pass | MIT | today |
| 12 | Create a new Whirl environment in the envs/ directory. An agent skill from godatadriven/whirl. | godatadriven/ | 205 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | 8 days ago |
| 13 | Sets up Dinobase, a local DuckDB database that syncs data from 100+ business sources, then answers questions across them with SQL joins and previewed write-backs. | kappa90/ | 263 | — | ~1.5k | Automated safety check: Pass | Unknown | 3 mo ago |
| 14 | 14.DB Sculptor Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and… | EliasOulkadi/ | 114 | — | ~3.1k | Automated safety check: Notes | MIT | 5 days ago |
| 15 | Helps choose an incremental strategy, design a reliable unique_key and debug failing dbt incremental models, and says when a plain table is the better choice. | AltimateAI/ | 128 | — | ~2.3k | Automated safety check: Pass | MIT | 2 days ago |
| 16 | Analytics engineering across data modeling, dbt, transformation, and semantic layers. | borghei/ | 891 | — | ~3.4k | Automated safety check: Pass | MIT | 3 days ago |
| 17 | Rules for writing Tinybird datasources, pipes, endpoints and materialized views, with SQL constraints, optimization habits and deduplication patterns. | TryGhost/ | 56k | — | ~417 | Automated safety check: Pass | MIT | today |
| 18 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | affaan-m/ | 276k | 1 repo | ~2.7k | Automated safety check: Pass | MIT | today |
| 19 | 19.Cocoindex Comprehensive toolkit for developing with the CocoIndex library. | davila7/ | 33k | 2 repos | ~6.4k | Automated safety check: Notes | MIT | today |
| 20 | Analyze DBSQL queries, including SQL embedded in notebooks (spark.sql(...), %sql cells), for anti-patterns, lint issues, and performance problems, using Databricks-specific dialect and platform… | AltimateAI/ | 128 | — | ~6.7k | Automated safety check: Pass | MIT | 2 days ago |
| 21 | 21.Rocky Poc Authoring a new POC under examples/playground/pocs/. An agent skill from rocky-data/rocky. | rocky-data/ | 304 | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 22 | Run large-scale batch NER, PII extraction, or de-identification over many clinical notes on-device with OpenMed, with sharding, checkpointing, resumability, and append-only JSONL output. | maziyarpanahi/ | 5.5k | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | today |
| 23 | Generates SQL validation notebooks for dbt PR changes with before/after comparison queries. | sickn33/ | 47k | 1 repo | ~1.1k | Automated safety check: Pass | MIT | yesterday |
| 24 | Optimizes Snowflake query performance using query ID from history. | AltimateAI/ | 128 | — | ~919 | Automated safety check: Pass | MIT | 2 days ago |
| 25 | 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 | yesterday |
| 26 | Provide a lookup index of dbt models (BigQuery tables) to guide query writing against a data warehouse. | warpdotdev/ | 824 | — | ~915 | Automated safety check: Pass | MIT | 1 mo ago |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. | aiskillstore/ | 433 | 7 repos | ~2.5k | Automated safety check: Pass | No licence | today |
| 31 | Running experiments out of the data warehouse instead of via dedicated experiment platforms. | rampstackco/ | 945 | — | ~7.3k | Automated safety check: Pass | MIT | 3 days ago |
| 32 | 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 |
| 33 | 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 |
| 34 | 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 |
| 35 | 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 |
| 36 | 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 |
| 37 | Initialize warehouse schema discovery. An agent skill from astronomer/agents. | astronomer/ | 451 | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 38 | 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 |
| 39 | Define implementation contracts (APIs and data models) that developers will build against during PRD v0.6 Architecture. | mattgierhart/ | 180 | — | ~3.4k | Automated safety check: Pass | MIT | 1 mo ago |
| 40 | 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 | 2 days ago |
| 41 | A skill your agent uses when building Query Reports, Script Reports, or configuring Report Builder, including chart data integration. | Impertio-Studio/ | 189 | — | ~2.3k | Automated safety check: Pass | MIT | 23 days ago |
| 42 | Optimizes Snowflake SQL query performance from provided query text. | AltimateAI/ | 128 | — | ~1.7k | Automated safety check: Pass | MIT | 2 days ago |
| 43 | Guard production Databricks data pipelines — Delta Lake, Liquid Clustering, Structured Streaming, Auto Loader, and DLT — against the twelve foot-guns that fire at scale: OPTIMIZE/auto-compaction… | jeremylongshore/ | 2.8k | — | ~3.5k | Automated safety check: Pass | MIT | today |
| 44 | 44.Database Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering. | aiskillstore/ | 433 | 3 repos | ~1.2k | Automated safety check: Pass | No licence | today |
| 45 | A Data Engineering interviewer focused on database performance. | PrepLabsAI/ | 112 | — | ~2.1k | Automated safety check: Pass | MIT | 3 days ago |
| 46 | A skill your agent uses when starting empirical analysis, creating a data pipeline, generating results, or when data or model specifications change. | brycewang-stanford/ | 4.6k | — | ~1.7k | Automated safety check: Pass | Unknown | 4 days ago |
| 47 | 47.Ddia Systems Design data systems by understanding storage engines, replication, partitioning, transactions, and consistency models. | wondelai/ | 2.4k | — | ~4.2k | Automated safety check: Pass | MIT | 29 days ago |
| 48 | 48.V5 Migration The olm:v5 migration script, UpdateTagsService, batch processing, migratedat, ClassifyTagsService deprecated mappings, and data migration from v4 category tables. | OpenLitterMap/ | 134 | — | ~1.7k | Automated safety check: Pass | GPL-3.0 | 25 days ago |