sql-mastery

What problem does it solve?

This Skill addresses the challenges of writing efficient, complex SQL queries and optimizing database performance, preventing common pitfalls like SQL injection and slow-running reports.

Core Features & Use Cases

• Advanced Querying: Utilize CTEs and window functions for sophisticated data manipulation and analysis.
• Performance Optimization: Learn indexing strategies and how to interpret query plans to speed up database operations.
• Schema Design Best Practices: Implement robust database structures with proper normalization and constraints.
• Use Case: Optimize a slow-running e-commerce report by analyzing its query plan, adding appropriate indexes, and refactoring complex joins using CTEs.

Quick Start

Use the sql-mastery skill to generate a CTE example for analyzing user activity over the last 30 days.