efoo-team/skills

sql-writing-style

SQLを書くときに使用する。読み手が一瞥して理解できるSQLを書くためのスタイルルール。

First seen May 16, 2026

Installation

$ npx skills add efoo-team/skills --skill sql-writing-style

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

Also in this package

Other skills from efoo-team/skills · top by installs.

npx skills add efoo-team/skills

Browse all from efoo-team/skills

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Default branch main
Open issues 4
Status Active

Skill metadata

Parsed from SKILL.md frontmatter.

More metadata
tags
["sql","code-quality","style"]

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 1,043 B
  • docs SUMMARY.md 145 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 37 installs

SKILL.md

SQL Writing Style

SQLは実行回数より読まれる回数のほうが多い。読み手の認知負荷を最小にする。

各ルールは「見出し(### 採番. ルールの要旨)+1行の理由+bad / good の対比例」で書く。ルールを追加するときはこの節構造を踏襲する。

ルール

1. テーブルエイリアスは全文を使う。無意味な短縮をしない

FROM stores s のような1文字エイリアスで読み手に逆引きを強いるのは避ける。ただし自己結合や、極端に長いテーブル名で全文表記がかえって読みにくくなる場合は、意味が伝わる短縮エイリアスを許す。

-- bad
FROM stores s
JOIN users u ON u.store_id = s.id

-- good
FROM stores
JOIN users ON users.store_id = stores.id