Best skills for: Data & analysis
For data and analysis tasks, AI skills must emphasize accuracy and scalability. **Historical Data Validation** is essential—it catches inconsistencies, duplicates, and outliers in large datasets, directly impacting model reliability. Look for implementations that support schema evolution and provide clear audit trails. Another key skill is **TACC Vista HPC Cluster Management**, which enables parallel processing for high-volume computations. Mastering this ensures efficient job scheduling, resource monitoring, and cost control. A common pitfall is underestimating memory management or neglecting to set up logging for failed jobs. These skills go beyond basic coding; they architect the backbone of reproducible data pipelines. Focus on tools that integrate seamlessly with your existing stack and offer active community support. Always validate outputs against known benchmarks to catch regressions early.
22 skills selected
DuckDB Schema Design & SQL Queries
Data & AI
Design DuckDB schemas, write SQL queries, and perform analytical data operations using the DuckDB Python library.
Google Cloud Platform
Data & AI
Query BigQuery datasets and manage Cloud Storage buckets. Use package tools for all operations.
dbt Coder - Patterns and Organization
Data & AI
Provides patterns for organizing dbt models into staging, intermediate, and marts layers, along with incremental strategies and testing. Helps structure scalable dbt projects with clear separation of concerns.
Read-Only KingbaseES Queries
Data & AI
Queries KingbaseES databases in read-only mode using validated SQL and psycopg2 or ksycopg2. Supports SELECT, SHOW, and custom SQL; blocks writes.
NewSQL & Distributed SQL - 12 Database Guide
Data & AI
Provides production-level operational guidance for 12 NewSQL and distributed SQL databases including CockroachDB, YugabyteDB, TiDB, Google Spanner, Vitess, PlanetScale, Citus, SingleStore, OceanBase, Neon, and AlloyDB. Covers multi-region topologies, sharding, HTAP, and CAP tradeoffs. Useful when implementing globally distributed SQL, horizontal scaling, or HTAP workloads.
Enterprise Database Architecture
Data & AI
Specialist in enterprise database architecture with expertise in PostgreSQL 17, MySQL 8.4, MongoDB 8.0, and Redis 7.4. Focuses on connection pooling (PgBouncer, ProxySQL), query optimization, caching strategies, and database DevOps automation to build scalable and resilient systems. Provides comprehensive monitoring and disaster recovery planning.
dbt for Analytics Engineering
Data & AI
Build and modify dbt models, write SQL transformations using ref() and source(), create tests and validate results with dbt show. Use for any dbt work including building, debugging, and evaluating changes.
Database Assistant
Data & AI
Expert in schema design, SQL query optimization, migrations, and ORM frameworks. Helps normalize, index, and optimize your databases.
ICP Visitor Outreach
Data & AI
Identify signed-up users matching the ideal customer profile but stalled, and draft personalized outreach to re-engage them.
Database Migration Planner
Data & AI
Plans and generates safe database migration scripts.
Create Initial MariaDB MSM Schema
Data & AI
Scaffold a MariaDB Schema Management (MSM) project and author the initial schema version in the development folder using msm.* MCP tools.
Supabase Database Queries
Data & AI
Executes SQL queries against a Supabase PostgreSQL database for SELECT, INSERT, UPDATE, and DELETE operations. It connects using the DATABASE_URL from .env and accepts raw SQL or natural language descriptions of queries. Useful for interacting with tables like competition, team, race, admin, flight, halfflight, and feedback.
SQL Writing and Optimization
Data & AI
Helps write, optimize, or explain SQL queries. Looks for issues like missing indexes, N+1 patterns, unnecessary SELECT *, and suggests improvements. Best used when you need to generate clean SQL or troubleshoot query performance.
PostgreSQL Queries
Data & AI
Execute SQL queries against a local PostgreSQL database. Accepts raw SQL or natural language queries automatically converted to SQL.
Run WordPress SQL Queries
Data & AI
Run SQL queries against the WordPress development database via docker compose, handling multiple WordPress table prefixes.
SQL Patterns
Data & AI
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies.
Advanced SQL and Database Mastery
Data & AI
Expert in modern SQL, performance optimization, and cloud-native databases. Covers OLTP/OLAP, indexing, and query plan analysis.
dbt Model Versioning
Data & AI
Load when task involves dbt model versioning, creating v2 of a model, or backward-compatible model changes. Covers versions YAML config, defined_in, latest_version, and ref() with version pins.
ggsql Query Writer
Data & AI
Write ggsql queries for declarative data visualization using Grammar of Graphics principles.
SQL Expert
Data & AI
This skill enables writing, validating, and explaining optimized SQL queries for various database dialects. It includes a syntax validation tool and strictly adheres to provided schemas. Helpful for data analysts who need reliable queries with brief explanations.
SQL - Database Queries and Optimization
Data & AI
Assists in writing efficient SQL queries, from simple SELECTs to complex joins and window functions. Helps optimize slow queries using EXPLAIN and indexing strategies. Useful when designing database schemas, performing migrations, or debugging transactional issues.
SQL Pro - Advanced Query Optimization
Data & AI
Expert in modern SQL, performance tuning, and data modeling across cloud-native databases and hybrid OLTP/OLAP systems.
How to choose
- How are these skills selected?
- An algorithm picks them among the published skills that match this page's criteria, such as category, tags or compatible tools. It ranks them by the quality score a language model gave them. On ranking pages, it also weighs GitHub stars and the security rating. Nobody reviews them one by one.
- What do the security ratings mean?
- A language model reads the SKILL.md file, without running it, and gives it a rating. Safe means it sees no meaningful execution risk. Caution means the skill uses powerful tools such as bash, docker or the network for a legitimate purpose. Risky means it asks for destructive actions, for secrets to be sent out, or for obfuscated code to run; a skill rated Risky is never published. The rating does not replace your own reading of the file.
- How do I install a skill?
- Open any skill page and follow its install instructions for your tool — Claude Code, Cursor or Copilot. Each skill lists the exact steps so you can get it running in a couple of minutes.