SQL Patterns Skill

When to Activate

• Writing SQL queries for a new feature
• Reviewing SQL for performance or security issues
• Designing database schema for a new entity
• Writing database migrations
• Optimizing slow queries
• Setting up row-level security or audit logging
• Replacing OFFSET pagination with keyset cursors on a large or growing table
• Adding UPSERT logic to eliminate check-then-insert race conditions in concurrent writes

Core Query Patterns

SELECT — always explicit columns