SQL Queries

Write and optimize SQL across major dialects (PostgreSQL, MySQL, BigQuery, Snowflake, Databricks, SQL Server). Use when user asks for query authoring, debugging, optimization, translation between dialects, or analytical SQL patterns.

rldyourmnd befe369 743 B Updated

File contents

SQL Queries

Workflow

  1. Clarify schema, keys, and required output columns.
  2. Start with correct baseline query.
  3. Add performance improvements (indexes, predicate pushdown, join strategy, window usage).
  4. Validate edge cases: nulls, duplicates, timezone/date handling.
  5. Provide explainability: why this shape, tradeoffs, and alternatives.

Output Standard

  • Correct query.
  • Dialect notes if non-portable.
  • Optional optimized variant for large datasets.

rldyourmnd/codex-cli-bootstrap/tree/main/codex/os/linux/runtime/skills/custom/sql-queries commit befe369678

Frequently asked questions

npx skillmds@latest add rldyourmnd/sql-queries