sql-master

What problem does it solve?

This Skill helps developers and DBAs identify and fix SQL performance bottlenecks, design robust schemas, and implement scalable data models.

Core Features & Use Cases

• Query Optimization: Diagnose slow queries, propose indexing strategies, and rewrite patterns for better execution plans.
• Schema Design: Recommend normalization, relationships, and data modeling practices for scalable databases.
• Advanced Queries: Provide patterns for complex analytics using window functions, CTEs, and joins.
• Use Case: For a high-traffic e-commerce app, optimize the user_orders reporting query and redesign the orders schema to support fast lookups.

Quick Start

Pose a task like optimize the following query or design a schema: "Analyze the orders table and propose an index on (user_id, created_at) to improve reporting performance."