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.
8 skills selected
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.
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.
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.
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 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.
Forecast Generator
Data & AI
Provides automated assistance for forecast generator tasks in data analytics, including step-by-step guidance, best practices, and production-ready code. Activates when you mention 'forecast generator' or ask about related patterns.
How to choose
- How are these skills selected?
- Each skill is curated and verified by the Skills Guides editorial team. We run a security and quality review on every entry, so only verified skills appear in this selection.
- What do the security ratings mean?
- We label skills Safe, Caution or Risky based on our security analysis — checking for prompt-injection risks, requested permissions and other red flags. The rating gives you an at-a-glance sense of how much trust a skill warrants.
- 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.