# SQL Scripting Practices

> Use when authoring or reviewing SQL, snake_case naming, uppercase keywords, river-aligned layout, portable DDL types, suffix conventions, and parameterized queries.

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

---


# SQL Scripting Practices

Application skill for SQL style learning (from the archived `awesome-guidelines` style capsules). For ORM-specific patterns (Django, Prisma, SQLAlchemy), load stack capsules in `skills/*-foundation`.

## Core Principle

SQL readability is **consistent relational naming plus scannable layout**, river-aligned keywords, portable types, parameters at the app boundary.

## When to Use / NOT

- Hand-written migrations, analytics queries, views, stored procedures.
- Reviewing schema naming and query formatting in PRs.

**NOT when:**

- ORM-only codebases with no raw SQL, validate ORM/migration generator instead.
- NoSQL query languages.

## Workflow

1. **Naming**, tables, columns, aliases, suffixes (`sql-style-naming-schema.md`).
2. **Layout**, keywords, river, joins, subqueries (`sql-style-query-layout.md`).
3. **DDL**, CREATE, types, constraints (`sql-style-ddl-types.md`).
4. **Patterns**, BETWEEN/IN/CASE, comments, parameters (`sql-style-query-patterns.md`).
5. **Verify**, sqlfluff/SQLFluff or project linter + migration apply/dry-run on changed files.

## Red Flags

- camelCase or `tbl_`/`sp_` prefixes
- lowercase `select`/`from` in shared SQL
- missing `AS` on aliases
- `FLOAT` for money
- bare `id` everywhere
- EAV schema for relational data
- string-concatenated user input
- vendor-only functions without portability note

## Verification

- sqlfluff/sql-formatter on changed `.sql` files
- migration apply or `EXPLAIN` on touched queries
- Capsule checklist on schema/query review


## References

- `awesome-guidelines/references/sql-style-learning-note.md`
- `awesome-guidelines/references/sql-style-naming-schema.md`
- `awesome-guidelines/references/sql-style-query-layout.md`
- `awesome-guidelines/references/sql-style-ddl-types.md`
- `awesome-guidelines/references/sql-style-query-patterns.md`