sql-best-practices

What problem does it solve?

Writing SQL that is correct, safe, and performant across queries, joins, aggregations, and schema changes can be error-prone and slow; this skill codifies best practices to prevent common pitfalls.

Core Features & Use Cases

• Enforce safe query patterns: avoid SELECT *, use CTEs for readability, apply early filtering, and analyze plans with EXPLAIN.
• Promote safe data modifications: require parameterized queries, wrap destructive operations in transactions, and test on staging environments.
• Enforce naming conventions: snake_case for tables/columns, descriptive names, and consistent pluralization.

Quick Start

Provide a sample SQL query you want reviewed and I will apply best practices to rewrite and optimize it.