Does this skill handle SQL security?

This skill focuses on performance and structure; it defers specific security tasks like SQL injection prevention to the specialized security skill.

Can I use this for data warehousing tasks?

Yes, it includes specific patterns for data modeling, including star schemas, slowly changing dimensions, and optimized analytical query structures.

Which SQL dialects does this skill support?

The skill is optimized for PostgreSQL, Redshift, Athena, and Spark SQL, though the core optimization and design principles apply to most relational databases.

How does this skill help with query performance?

It provides patterns for index-aware queries, early filtering, and identifying anti-patterns like functions on indexed columns that cause slow full table scans.

Why does the skill prioritize CTEs over subqueries?

Common Table Expressions (CTEs) are prioritized because they improve code readability and maintainability, making complex queries easier for teams to debug and optimize.

Data SQL & Schema Design

Name: Data SQL & Schema Design
Author: AlexanderStephenThompson

byAlexanderStephenThompson

0•

Database Management

Optimizes SQL queries, designs scalable database schemas, and implements high-performance data modeling patterns.

This skill equips Claude with specialized expertise for writing high-performance SQL and designing robust database architectures across PostgreSQL, Redshift, Athena, and Spark SQL. It emphasizes performance-first principles, such as index-aware query construction and early filtering, while promoting maintainability through Common Table Expressions (CTEs) and explicit column selection. By identifying common anti-patterns like correlated subqueries and non-idempotent operations, this skill helps developers avoid production bottlenecks and build scalable data models ranging from normalized relational schemas to analytical star schemas.

Key Features

01Implementation of idempotent upserts and window functions

02Complex logic organization using readable CTE patterns

03Advanced SQL query optimization and performance tuning

040 GitHub stars

05Scalable database schema design and normalization

06Anti-pattern detection for indexed columns and join conditions

Use Cases

01Refactoring slow legacy queries to improve execution speed and reduce resource consumption

02Developing complex analytical reports using advanced window functions and data modeling

03Designing new relational database schemas for application features with proper indexing

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