How does this skill help with query performance?

It implements performance-first principles such as early filtering, index-aware WHERE clauses, and the replacement of slow correlated subqueries with JOINs or window functions.

Does it provide security recommendations?

While it focuses on performance and structure, it defers specific security concerns like SQL injection prevention to a dedicated security skill to ensure specialized coverage.

Which SQL dialects does this skill support?

This skill is optimized for modern SQL dialects including PostgreSQL, Amazon Redshift, Amazon Athena, and Spark SQL.

Can I use this for data warehousing tasks?

Yes, the skill includes specific patterns for data modeling concepts like star schemas and slowly changing dimensions (SCD) commonly used in data warehousing.

Data SQL Optimization & Modeling

Name: Data SQL Optimization & Modeling
Author: AlexanderStephenThompson

byAlexanderStephenThompson

0•

数据库管理

Optimizes SQL queries and database schemas using industry-standard patterns for performance, maintainability, and scalability.

The Data SQL skill empowers Claude with specialized knowledge for architecting robust database systems and writing high-performance queries across dialects like PostgreSQL, Redshift, and Spark SQL. It provides a structured framework for query optimization through Common Table Expressions (CTEs), efficient indexing strategies, and advanced window functions. By enforcing best practices such as idempotent operations and explicit column selection, this skill helps developers move from basic CRUD operations to sophisticated data modeling, including star schemas and slowly changing dimensions, while systematically avoiding common performance anti-patterns.

主要功能

01Index-aware query optimization and execution plan strategies

02Comprehensive window function patterns for analytical processing

03Structural CTE organization for complex, readable query steps

04Idempotent data operation patterns for resilient migrations and upserts

05Advanced data modeling patterns including star schema and SCD

060 GitHub stars

使用场景

01Implementing complex analytical reports using window functions and partitioning

02Refactoring legacy SQL queries to improve execution speed and readability

03Designing normalized or analytical database schemas for new applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add alexanderstephenthompson/claude-hub data-sql

For use in Claude.ai and ChatGPT

Download Skill