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
- Naming, tables, columns, aliases, suffixes (
sql-style-naming-schema.md).
- Layout, keywords, river, joins, subqueries (
sql-style-query-layout.md).
- DDL, CREATE, types, constraints (
sql-style-ddl-types.md).
- Patterns, BETWEEN/IN/CASE, comments, parameters (
sql-style-query-patterns.md).
- 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.mdawesome-guidelines/references/sql-style-naming-schema.mdawesome-guidelines/references/sql-style-query-layout.mdawesome-guidelines/references/sql-style-ddl-types.mdawesome-guidelines/references/sql-style-query-patterns.md
1---2name: sql-scripting-practices3description: Use when authoring or reviewing SQL, snake_case naming, uppercase keywords, river-aligned layout, portable DDL types, suffix conventions, and parameterized queries.4---56# SQL Scripting Practices78Application 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`.910## Core Principle1112SQL readability is **consistent relational naming plus scannable layout**, river-aligned keywords, portable types, parameters at the app boundary.1314## When to Use / NOT1516- Hand-written migrations, analytics queries, views, stored procedures.17- Reviewing schema naming and query formatting in PRs.1819**NOT when:**2021- ORM-only codebases with no raw SQL, validate ORM/migration generator instead.22- NoSQL query languages.2324## Workflow25261. **Naming**, tables, columns, aliases, suffixes (`sql-style-naming-schema.md`).272. **Layout**, keywords, river, joins, subqueries (`sql-style-query-layout.md`).283. **DDL**, CREATE, types, constraints (`sql-style-ddl-types.md`).294. **Patterns**, BETWEEN/IN/CASE, comments, parameters (`sql-style-query-patterns.md`).305. **Verify**, sqlfluff/SQLFluff or project linter + migration apply/dry-run on changed files.3132## Red Flags3334- camelCase or `tbl_`/`sp_` prefixes35- lowercase `select`/`from` in shared SQL36- missing `AS` on aliases37- `FLOAT` for money38- bare `id` everywhere39- EAV schema for relational data40- string-concatenated user input41- vendor-only functions without portability note4243## Verification4445- sqlfluff/sql-formatter on changed `.sql` files46- migration apply or `EXPLAIN` on touched queries47- Capsule checklist on schema/query review484950## References5152- `awesome-guidelines/references/sql-style-learning-note.md`53- `awesome-guidelines/references/sql-style-naming-schema.md`54- `awesome-guidelines/references/sql-style-query-layout.md`55- `awesome-guidelines/references/sql-style-ddl-types.md`56- `awesome-guidelines/references/sql-style-query-patterns.md`
ryan-brosas