Search
Data & Analytics · SQL
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Analyzes uploaded Excel and CSV files with SQL through DuckDB, producing schema inspections, statistical summaries and exports to CSV, JSON or Markdown. | bytedance/ | 83k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | today |
| 2 | A skill your agent uses to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. | timescale/ | 1.9k | 1 repo | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 3 | 3.Sl ktx's semantic layer - a structured catalog of sources (tables/views), measures, joins, and segments expressed as YAML. | Kaelio/ | 1.6k | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | 27 days ago |
| 4 | Queries the data warehouse with SQL and answers business questions about data. | astronomer/ | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 5 | Create DAC dashboards by writing YAML or TSX dashboard definition files. | bruin-data/ | 1.8k | — | ~4.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 6 | Build and troubleshoot Cloudflare Basin analytics workflows with Basin Pipelines, Basin Catalog, and Basin SQL. | cloudflare/ | 3k | 1 repo | ~684 | Automated safety check: Pass | Apache-2.0 | 7 days ago |
| 7 | Rules for charts and visualization. An agent skill from FrankChen021/datastoria. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 8 | A skill your agent uses when the user is writing datafusion-python (Apache DataFusion Python bindings) DataFrame or SQL code. | apache/ | 606 | — | ~7.8k | Automated safety check: Pass | Apache-2.0 | today |
| 9 | Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. | databricks/ | 345 | 1 repo | ~2.8k | Automated safety check: Pass | Unknown | today |
| 10 | Find every OWID surface that references a chart, indicator, MDIM, or explorer — articles (links vs embeds), explorers, narrative charts, data insights, static viz, key-chart slots, MDIM views. | owid/ | 158 | — | ~4.9k | Automated safety check: Pass | MIT | today |
| 11 | 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 |
| 12 | Works with datasets far too big to download or load in pandas — SQL over remote Parquet with DuckDB, aggregate-then-model, iterate on samples. | flyrank-bih/ | 140 | — | ~750 | Automated safety check: Pass | Unknown | 1 mo ago |
| 13 | Guides writing and tuning Apache Spark jobs: DataFrame and RDD code, Spark SQL, partitioning, caching, shuffle tuning and structured streaming. | Jeffallan/ | 12k | 1 repo | ~1.7k | Automated safety check: Pass | MIT | 5 days ago |
| 14 | Audits a Dinobase source's existing annotations and fills only the gaps in table descriptions, column docs, PII flags and relationships through a subagent. | kappa90/ | 263 | — | ~1.3k | Automated safety check: Pass | Unknown | 3 mo ago |
| 15 | Creates or modifies dbt models in line with a project's own conventions, then runs dbt build and dbt show to check the output instead of stopping at compile. | AltimateAI/ | 128 | — | ~890 | Automated safety check: Pass | MIT | 6 days ago |
| 16 | Walks through fixing dbt compilation, database and test errors: read the full error, check upstream models, apply a fix, then verify with dbt build and a data preview. | AltimateAI/ | 128 | — | ~1.1k | Automated safety check: Pass | MIT | 6 days ago |
| 17 | Analytics engineering across data modeling, dbt, transformation, and semantic layers. | borghei/ | 881 | — | ~3.4k | Automated safety check: Pass | MIT | yesterday |
| 18 | Rules for writing Tinybird datasources, pipes, endpoints and materialized views, with SQL constraints, optimization habits and deduplication patterns. | TryGhost/ | 55k | — | ~417 | Automated safety check: Pass | MIT | today |
| 19 | 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 |
| 20 | Generates production-ready analysis code in Python, R, SQL. An agent skill from liangdabiao/claude-data-analysis-ultra-main. | liangdabiao/ | 290 | — | ~513 | Automated safety check: Pass | No licence | 5 mo ago |
| 21 | Converts legacy SQL to modular dbt models. An agent skill from AltimateAI/data-engineering-skills. | AltimateAI/ | 128 | — | ~762 | Automated safety check: Pass | MIT | 6 days ago |
| 22 | Develop and deploy Lakeflow Jobs on Databricks via DABs, Python SDK, or the CLI. | Kilo-Org/ | 190 | 1 repo | ~3.1k | Automated safety check: Pass | Unknown | 9 days ago |
| 23 | 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 | 6 days ago |
| 24 | 24.Data Analyst Connects to databases, runs SQL queries, and analyzes datasets using code to provide actionable business insights. | clawdotnet/ | 520 | — | ~291 | Automated safety check: Pass | MIT | 4 days ago |
| 25 | Generates SQL validation notebooks for dbt PR changes with before/after comparison queries. | sickn33/ | 47k | 1 repo | ~1.1k | Automated safety check: Pass | MIT | today |
| 26 | 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 |
| 27 | 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 |
| 28 | Creates product analytics or SQL-backed box plot insights in PostHog. | PostHog/ | 40k | — | ~1.1k | Automated safety check: Pass | Unknown | today |
| 29 | Explains how to query PostHog data, defaulting to typed runners for supported product analytics. | PostHog/ | 40k | — | ~4.1k | Automated safety check: Pass | Unknown | today |
| 30 | Surfaces Monte Carlo data observability context (table health, alerts, lineage, blast radius) before SQL/dbt edits. | sickn33/ | 47k | 1 repo | ~3.3k | Automated safety check: Pass | MIT | today |
| 31 | 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 |
| 32 | Develop Lakeflow Spark Declarative Pipelines (formerly Delta Live Tables) on Databricks. | databricks/ | 345 | 1 repo | ~8.6k | Automated safety check: Pass | Unknown | today |
| 33 | A skill your agent uses when building Query Reports, Script Reports, or configuring Report Builder, including chart data integration. | Impertio-Studio/ | 187 | — | ~2.3k | Automated safety check: Pass | MIT | 21 days ago |
| 34 | 34.Database Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering. | aiskillstore/ | 430 | 3 repos | ~1.2k | Automated safety check: Pass | No licence | yesterday |
| 35 | Runs SQL analytics on SageMaker Catalog asset metadata tables exported as Apache Iceberg in S3 Tables. | aws/ | 2.8k | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | today |
| 36 | Connect MATLAB to Databricks via Spark (Databricks Connect) or JDBC (Database Toolbox). | matlab/ | 1.1k | — | ~3.5k | Automated safety check: Pass | Unknown | yesterday |
| 37 | A skill your agent uses when editing rule cookbooks, parity matrix, or cookbook CI (cookbook-parity.yml, cookbookparitycheck.py). | bbartling/ | 172 | — | ~382 | Automated safety check: Pass | Unknown | today |
| 38 | Analyze cluster data and metrics using raw SQL recipes against system.querylog and system.parts when no dedicated tool exists. | chmonitor/ | 299 | — | ~2k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 39 | 39.Data Analyst Data analysis across SQL, visualization, statistics, and reporting. | borghei/ | 881 | — | ~3.1k | Automated safety check: Pass | MIT | yesterday |
| 40 | A skill your agent uses when enforcing Open-FDD product boundaries: production DataFusion SQL vs pandas oracle, vibe19/vibe20 ownership, dual cookbooks, edge/os never-delete, ownership.yaml… | bbartling/ | 172 | — | ~565 | Automated safety check: Pass | Unknown | today |
| 41 | A skill your agent uses when working on production DataFusion SQL FDD: sqlrules registry, central /api/fdd/run, parity with pandas oracle, no pandas in central. | bbartling/ | 172 | — | ~514 | Automated safety check: Pass | Unknown | today |
| 42 | A skill your agent uses when a metric (revenue, MRR, margin) needs defining once in a governed semantic layer so every dashboard, report and agent returns the same number, or when an LLM must answer… | ericrisco/ | 167 | — | ~2.5k | Automated safety check: Pass | MIT | today |
| 43 | 43.Duckdb En DuckDB CLI specialist for SQL analysis, data processing and file conversion. | aAAaqwq/ | 105 | 1 repo | ~1.6k | Automated safety check: Pass | MIT | 11 days ago |
| 44 | A skill your agent uses when working with structured data files (CSV, JSON, YAML, TOML, Parquet) — querying, transforming, filtering, aggregating, or converting between formats | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | today |
| 45 | Design and spec an analytical dashboard — define the question each chart answers, write the SQL queries, spec the layout and refresh cadence. | jeremylongshore/ | 2.8k | — | ~2.3k | Automated safety check: Notes | MIT | today |
| 46 | 46.Lens Metrics Produce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like. | jeremylongshore/ | 2.8k | — | ~2.8k | Automated safety check: Notes | MIT | today |
| 47 | Assist with sql transform helper operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~565 | Automated safety check: Pass | MIT | today |
| 48 | Generate window function generator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~580 | Automated safety check: Pass | MIT | today |