SQL Cursor Rules

Code Style

• Uppercase keywords (SELECT, FROM, WHERE)
• Each major clause on new line
• Indent subqueries and CTEs
• snake_case for tables/columns

Best Practices

• Never use SELECT *
• Add indexes on WHERE/JOIN columns
• Use EXPLAIN to analyze plans
• Prefer CTEs over subqueries
• Use specific JOIN types

AI Instructions

• Ask about database type (Postgres, MySQL, etc.)
• Include comments for complex logic
• Add appropriate indexes
• Write migrations for schema changes