# SQL Best Practices

> SQL Best Practices is an Agent Skill for development published in the aiming-lab/MetaClaw repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Use this skill when writing SQL queries — selects, joins, aggregations, window functions, or schema modifications. Apply whenever SQL is needed to ensure correctness, safety, and performance.

- Skill name: `sql-best-practices`
- Category: [Development](https://www.openparable.com/skill/development/1)
- Source: https://github.com/aiming-lab/MetaClaw/blob/HEAD/memory_data/skills/sql-best-practices/SKILL.md
- Repository: aiming-lab/MetaClaw (3,466 GitHub stars when collected)

## SKILL.md

# SQL Best Practices

**Query quality:**
- Use `SELECT col1, col2` — never `SELECT *` in production code.
- Use CTEs (`WITH`) for readability instead of deeply nested subqueries.
- Filter early: apply `WHERE` before `JOIN` when possible to reduce data scanned.
- Use `EXPLAIN` / `EXPLAIN ANALYZE` to inspect query plans for slow queries.

**Safety:**
- Always use parameterized queries from application code — never string interpolation.
- Wrap destructive operations (`DELETE`, `UPDATE`, `DROP`) in a transaction.
- Test on a staging/dev environment before running on production.

**Naming:** `snake_case` for tables/columns, descriptive names, consistent pluralization.

---

Source: https://www.openparable.com/skill/development/sql-best-practices (OpenParable). Cite the canonical URL above.
