Does it follow a specific SQL style guide?

The skill promotes clean, readable code by emphasizing CTEs over nested subqueries and recommending explicit column selection over SELECT *.

Can this skill help optimize slow database queries?

Yes, it includes best practices for index awareness and using EXPLAIN statements to analyze and improve query performance.

Which databases is this compatible with?

The patterns are based on standard SQL and are highly compatible with major relational databases like PostgreSQL, MySQL, and SQL Server.

Is it suitable for business intelligence tasks?

Absolutely. It is specifically designed for metrics calculation, cohort analysis, and generating complex business reports.

What kind of SQL operations does this skill support?

It supports a wide range of advanced operations including window functions (LAG/LEAD, running totals), complex joins, aggregations, and Common Table Expressions (CTEs).

SQL Data Analysis

Name: SQL Data Analysis
Author: spjoshis

byspjoshis

•

Data Science & ML

Performs complex data extraction and sophisticated business analysis using advanced SQL techniques and performance-optimized queries.

The SQL Analysis skill enables Claude to handle advanced data exploration and business reporting tasks through the mastery of complex SQL operations. It provides structured patterns for implementing window functions, multi-table joins, and Common Table Expressions (CTEs) to solve intricate analytical problems such as cohort retention and funnel analysis. By incorporating best practices like query plan optimization and readable SQL styling, this skill ensures that data-driven insights are both accurate and maintainable within any development workflow.

Key Features

011 GitHub stars

02Data Cohort and Customer Segmentation analysis patterns

03Complex Multi-table Joins for deep data extraction

04Performance Optimization using EXPLAIN and index awareness

05Advanced Window Functions for running totals and growth metrics

06Common Table Expressions (CTEs) for readable query logic

Use Cases

01Performing customer retention and churn analysis using cohorts

02Optimizing slow-running legacy SQL queries for better performance

03Generating automated monthly revenue and business growth reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add spjoshis/claude-code-plugins sql-analysis

For use in Claude.ai and ChatGPT

Download Skill