language-sql

What problem does it solve?

This Skill helps you write correct, fast SQL by guiding query tuning, schema design, indexing, and safe pagination so performance and integrity issues don’t show up in production.

Core Features & Use Cases

• Query optimization with EXPLAIN: Use execution plans to identify the highest-cost operations, reconcile estimated vs actual row counts, and decide on index changes confidently.

• Schema and constraint design: Model durable facts, choose keys and foreign keys for integrity, and encode invariants with NOT NULL/UNIQUE/CHECK and referential actions.

• Operational safety for production SQL: Use appropriate transactions and isolation, avoid deadlocks via consistent lock ordering, and ensure deterministic pagination (keyset vs OFFSET/LIMIT).

• Use Case: You need to speed up a slow report that filters and joins multiple tables, add the right indexes, and then paginate results reliably without duplicates or missing rows.

Quick Start

Ask the AI to review your SQL and propose index, pagination, and transaction-isolation improvements using EXPLAIN ANALYZE guidance.