# 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.

- Skill: `rldyourmnd/sql-queries` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rldyourmnd/sql-queries`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rldyourmnd/sql-queries/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: rldyourmnd (https://skillmd.com/u/rldyourmnd)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rldyourmnd/sql-queries

---


# 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.