Is it suitable for time-series data analysis?

Yes, it covers advanced window functions like LAG, LEAD, and running totals which are essential for analyzing trends and changes over time.

Does it support different database dialects?

Yes, it includes specific syntax and patterns for PostgreSQL, MySQL, and SQLite, especially for operations like UPSERTs and conditional aggregations.

Can it help with hierarchical data structures?

Absolutely, it provides specialized recursive CTE patterns designed to navigate organizational charts, category trees, and other recursive data models.

How does this skill improve query performance?

It provides patterns for index-friendly queries, efficient keyset pagination, and batching techniques that minimize database locking and resource consumption.

SQL Patterns & Optimization

Name: SQL Patterns & Optimization
Author: majesticlabs-dev

bymajesticlabs-dev

•

Database Management

Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.

The SQL Patterns skill equips Claude with specialized knowledge for architecting high-performance database queries and complex data transformations. It goes beyond basic CRUD operations to offer implementation guidance for Common Table Expressions (CTEs), window functions, recursive hierarchies, and database-specific UPSERT patterns. This skill is particularly useful for developers and data engineers looking to refactor slow queries, implement efficient pagination, or manage large-scale batch operations while maintaining index-friendly search patterns across PostgreSQL, MySQL, and SQLite.

Key Features

01Complex conditional logic patterns using CASE expressions and lateral joins

02Recursive CTE implementation for navigating hierarchical data structures

0318 GitHub stars

04Advanced Window Functions for analytical reporting and time-series analysis

05Performance optimization techniques including keyset pagination and index-friendly queries

06Database-specific UPSERT patterns for PostgreSQL, MySQL, and SQLite

Use Cases

01Performing large-scale data migrations or batch updates without locking production tables

02Refactoring legacy nested queries into readable and maintainable Common Table Expressions

03Building efficient real-time analytics dashboards using window functions and materialized views

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add majesticlabs-dev/majestic-marketplace sql-patterns

For use in Claude.ai and ChatGPT

Download Skill