SQL Window Functions Helper skill for Claude and Codex
The right window function query for a running total, rank, previous-row comparison, or moving average over your table, with the PARTITION BY, ORDER BY, and…
Install it once and Claude or Codex runs it for you. When your request matches, your AI loads the skill, asks for anything it is missing, and works through the template itself. Prefer to fill it in by hand? See the full prompt template.
Download the skill (.zip) · View SKILL.md
When it is used
Use when a query needs a running total, rank, previous-row comparison, or moving average per group, built with the correct window function and frame. Do not use for plain aggregates with GROUP BY, or tuning an existing query's performance. Related topics: coding, database, sql.
What it will ask you for
- Table name (free text, e.g. "employee_salaries")
- Operation (choose one: Running total, Rank/Denserank, Lead/Lag comparison, Moving average)
- Partition column (free text, e.g. "department_id")
- Order column (free text, e.g. "salary")
- Value column (free text, e.g. "the column to sum or average or compare")
- Database (choose one: PostgreSQL, MySQL 8+, SQL Server, Oracle, SQLite, BigQuery)
How it works
- Pick the window function the operation calls for and state in one line why it beats the alternatives (tie handling, defaults).
- Write the frame clause explicitly, using ROWS for running totals and moving averages so equal order values do not merge.
- Build the query with the given partition and order columns, selecting the source columns beside the computed one.
- Note the dialect caveats that apply to the chosen database.
- Add the variation that filters on the window result through an outer query or QUALIFY.
What you get
A sql code block with the query, a two-line explanation of the function and frame, and a second code block showing how to filter on the computed column.
What it watches out for
- Leaving the default RANGE frame on a running total, which sums all rows that tie on the order column at once.
- Filtering on a window column in WHERE, which fails because window functions are evaluated after WHERE.
- Using ROW_NUMBER for a leaderboard, which breaks ties arbitrarily where RANK would show the tie.
How to install
Claude.ai and the Claude desktop app
- Download the skill .zip.
- Open Settings, then Capabilities, and find Skills.
- Choose Upload skill and select the .zip.
- Ask Claude for help with the task. It loads the skill when your request matches.
Claude Code
- Download the skill .zip.
- Unzip it into ~/.claude/skills/ (or .claude/skills/ inside a project).
- Start a new session. Claude Code loads the skill when your request matches.
Codex
- Download the skill .zip.
- Unzip it into ~/.agents/skills/ (or .agents/skills/ inside a project).
- Codex picks it up on its own. Type $ and the skill name to use it, or just ask for the task.
Cursor
- Download the Cursor rule (.mdc).
- Save it in .cursor/rules/ inside your project.
- Cursor's agent applies the rule when your request matches its description.
AGENTS.md (Codex, Cursor, and other coding agents)
- Copy the AGENTS.md section.
- Paste it into AGENTS.md at the root of your repository, creating the file if needed.
- Coding agents that read AGENTS.md follow it when your request fits.