Search
SQL · Data warehousing
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint). | supabase/ | 111k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | today |
| 2 | A skill your agent uses when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. | vemetric/ | 395 | 2 repos | ~1.4k | Automated safety check: Pass | Apache-2.0 | today |
| 3 | 3.Chdb SQL A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse… | vemetric/ | 395 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | today |
| 4 | 4.Bisect Bisect a ClickHouse regression using pre-built master binaries from CI. | ClickHouse/ | 50k | — | ~1.4k | Automated safety check: Pass | Apache-2.0 | today |
| 5 | Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. | FrankChen021/ | 327 | — | ~731 | Automated safety check: Pass | Unknown | 2 mo ago |
| 6 | Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection. | sidequery/ | 129 | — | ~5.5k | Automated safety check: Pass | AGPL-3.0 | yesterday |
| 7 | Profile a ClickHouse query using the sampling query profiler and system.tracelog. | ClickHouse/ | 50k | — | ~1.9k | Automated safety check: Notes | Apache-2.0 | today |
| 8 | Queries the data warehouse with SQL and answers business questions about data. | astronomer/ | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 9 | 9.Surf Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls. | BlockRunAI/ | 6.6k | — | ~4k | Automated safety check: Pass | MIT | 3 days ago |
| 10 | 10.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 11 | Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. | databricks/ | 345 | 1 repo | ~2.8k | Automated safety check: Pass | Unknown | today |
| 12 | Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx. | tempoxyz/ | 107 | — | ~3.1k | Automated safety check: Pass | MIT | today |
| 13 | 13.Datajunction Activate this skill whenever working with DataJunction (DJ) semantic layer. | DataJunction/ | 162 | — | ~2k | Automated safety check: Pass | MIT | today |
| 14 | Diagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-code root cause analysis. | FrankChen021/ | 327 | — | ~610 | Automated safety check: Pass | Unknown | 2 mo ago |
| 15 | Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer. | sidequery/ | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | yesterday |
| 16 | Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis. | warpdotdev/ | 825 | — | ~1.1k | Automated safety check: Pass | MIT | 1 mo ago |
| 17 | Skill for Graph Query Language (GQL) or SQL/PGQ queries against a property graph. | google/ | 22k | — | ~4.8k | Automated safety check: Pass | Apache-2.0 | today |
| 18 | Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database. | pytorch/ | 113 | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 19 | 19.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 | 4 days ago |
| 20 | 20.SQL Expert Expert system for generating, validating, and optimizing ClickHouse SQL. | FrankChen021/ | 327 | — | ~919 | Automated safety check: Pass | Unknown | 2 mo ago |
| 21 | Audit open "flaky test" GitHub issues and close those whose tests are no longer failing on master. | ClickHouse/ | 50k | — | ~1.9k | Automated safety check: Notes | Apache-2.0 | today |
| 22 | 22.Clickhouse A skill your agent uses when changing or reviewing Speakeasy ClickHouse schemas, migrations, queries, inserts, access principals, bootstrap SQL, Cloud compatibility, partial migration failures, or… | speakeasy-api/ | 273 | — | ~3.2k | Automated safety check: Pass | AGPL-3.0 | today |
| 23 | Analytics engineering across data modeling, dbt, transformation, and semantic layers. | borghei/ | 886 | — | ~3.4k | Automated safety check: Pass | MIT | 2 days ago |
| 24 | Queries JGI Lakehouse (Dremio) for genomics metadata from GOLD, IMG, Mycocosm, Phytozome. | BioTender-max/ | 199 | — | ~3.7k | Automated safety check: Pass | Unknown | 3 mo ago |
| 25 | 25.SQL Pro Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. | davila7/ | 32k | 9 repos | ~1.9k | Automated safety check: Pass | MIT | today |
| 26 | Diagnose ClickHouse cluster health and provide concrete remediation. | FrankChen021/ | 327 | — | ~1.6k | Automated safety check: Pass | Unknown | 2 mo ago |
| 27 | Wavelet 项目专用:当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写… | Rain-kl/ | 288 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 28 | Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them. | AltimateAI/ | 128 | — | ~662 | Automated safety check: Pass | MIT | yesterday |
| 29 | Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 30 | 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 |
| 31 | 31.SQL Queries Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). | w95/ | 239 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | 7 mo ago |
| 32 | ClickHouse queries, Goose migrations, chdb test schema, or telemetry storage paths. | latitude-dev/ | 4.7k | — | ~1.2k | Automated safety check: Pass | MIT | today |
| 33 | A skill your agent uses to get context about Fabric Lakehouse and its features for software systems and AI-powered functions. | github/ | 40k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | today |
| 34 | Queries and downloads public cancer imaging data from NCI Imaging Data Commons. | K-Dense-AI/ | 48k | 1 repo | ~7.8k | Automated safety check: Pass | MIT | 4 days ago |
| 35 | Manages datasets, tables, and jobs in BigQuery. An agent skill from google/skills. | google/ | 21k | 1 repo | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 36 | Optimizes Snowflake query performance using query ID from history. | AltimateAI/ | 128 | — | ~919 | Automated safety check: Pass | MIT | yesterday |
| 37 | Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). | github/ | 40k | 1 repo | ~1.1k | Automated safety check: Pass | MIT | today |
| 38 | 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 |
| 39 | Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants. | HybridAIOne/ | 158 | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 40 | Design GCP architectures for startups and enterprises. An agent skill from alirezarezvani/claude-skills. | alirezarezvani/ | 28k | — | ~3.2k | Automated safety check: Pass | MIT | 1 mo ago |
| 41 | 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 |
| 42 | Time-series database implementation for metrics, IoT, financial data, and observability backends. | ancoleman/ | 526 | — | ~1.7k | Automated safety check: Pass | MIT | 10 mo ago |
| 43 | 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 |
| 44 | 44.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 |
| 45 | Generates Python code using BigQuery DataFrames (BigFrames). | google/ | 21k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 46 | 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 |
| 47 | Provides workflows to optimize BigQuery environments (capacity planning, editions), storage assets (partitioning, clustering, storage lifecycles, billing models), and SQL queries. | google/ | 21k | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | today |
| 48 | 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 |