Skip to main content
skill CX Codex

tsql-functions — Claude Code skill: what it does, how to install

tsql-functions is a Claude Code skill with a categorized, version-tagged reference for T-SQL functions in SQL Server and Azure SQL Database. It activates when a conversation involves T-SQL functions.

MIT 187 installs ★ 66 updated 2026-06-18

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a claude-code
Open on GitHub

What tsql-functions does

The skill carries a catalogue of T-SQL functions split into groups: text handling, date arithmetic, math and casts, ranking and window frames, JSON, XML, aggregates with GROUP BY extensions, and the system views that describe objects. It wakes up on its own when a query touches STRING_AGG, DATETRUNC or OPENJSON, and the answer comes as a snippet you can run.

SKILL.md holds compact tables with a version column plus worked patterns: a running total over a partition, splitting delimited text into rows, building a JSON object from ordinary columns. Two categories get their own files, references/string-functions.md and references/window-functions.md, for the long tail.

Those version tags are the useful part. CONCAT_WS, STRING_AGG and TRIM start at 2017, AT TIME ZONE at 2016, while DATETRUNC and GENERATE_SERIES only show up in 2022. Point one of them at an older instance and the query dies at compile time.

What it helps with

  • join name columns without leaving stray commas when one value is NULL
  • split a delimited string into rows
  • compute a running total per customer
  • pull a nested JSON field out as a plain column
  • match the functions in a query against the SQL Server release you run

Example prompts for the agent

  • Rewrite this aggregate so employees are listed per department, comma separated, in HireDate order
  • Swap JSON_VALUE for OPENJSON with a WITH clause so OrderDetails comes back as a table
  • Tell me which functions here break on SQL Server 2019 and what to use instead

How to install tsql-functions

1Skills CLI (Vercel)

npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a claude-code

2Manually: put the files in place

~/.claude/skills/tsql-functions/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/tsql-functions/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about tsql-functions

How do I install tsql-functions in Claude Code?

Run npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a claude-code. The skill lands in ~/.claude/skills/tsql-functions/SKILL.md.

What does tsql-functions do?

It is a T-SQL function reference for SQL Server and Azure SQL Database: a catalogue by category, query patterns, and a note on which release introduced each function. It triggers by itself when the conversation turns to strings, dates, windows, JSON or XML.

Does the skill say which SQL Server version a function needs?

Every table row carries a version, and a separate matrix lines up the 2016, 2019 and 2022 releases. That keeps you from writing a function your instance does not have.

Source text

SKILL.md · MIT
---
name: tsql-functions
description: |
  Complete T-SQL function reference for SQL Server and Azure SQL Database.
  PROACTIVELY activate for: (1) string functions (CONCAT_WS, STRING_SPLIT, STRING_AGG, TRIM, REPLACE, LEFT/RIGHT/SUBSTRING), (2) date/time functions (DATEADD, DATEDIFF, FORMAT, DATETRUNC, AT TIME ZONE), (3) math and conversion functions (CAST, CONVERT, TRY_CAST, ROUND, FLOOR, CEILING), (4) window/ranking functions (ROW_NUMBER, RANK, LEAD/LAG, FIRST_VALUE, LAST_VALUE, NTILE), (5) JSON functions (JSON_VALUE, JSON_QUERY, JSON_MODIFY, OPENJSON), (6) XML functions (FOR XML, .nodes, .value), (7) aggregate functions and GROUP BY extensions, (8) system and metadata functions (sys.* views, OBJECT_ID, OBJECT_NAME).
  Provides: function catalog grouped by category, version-availability matrix (SQL 2016+/2019+/2022+), and worked examples for each function family.
---

# T-SQL Functions Reference

Complete reference for all T-SQL function categories with version-specific availability.

## Quick Reference

### String Functions
| Function | Description | Version |
|----------|-------------|---------|
| `CONCAT(str1, str2, ...)` | NULL-safe concatenation | 2012+ |
| `CONCAT_WS(sep, str1, ...)` | Concatenate with separator | 2017+ |
| `STRING_AGG(expr, sep)` | Aggregate strings | 2017+ |
| `STRING_SPLIT(str, sep)` | Split to rows | 2016+ |
| `STRING_SPLIT(str, sep, 1)` | With ordinal column | 2022+ |
| `TRIM([chars FROM] str)` | Remove leading/trailing | 2017+ |
| `TRANSLATE(str, from, to)` | Character replacement | 2017+ |
| `FORMAT(value, format)` | .NET format strings | 2012+ |

### Date/Time Functions
| Function | Description | Version |
|----------|-------------|---------|
| `DATEADD(part, n, date)` | Add interval | All |
| `DATEDIFF(part, start, end)` | Difference (int) | All |
| `DATEDIFF_BIG(part, s, e)` | Difference (bigint) | 2016+ |
| `EOMONTH(date, [offset])` | Last day of month | 2012+ |
| `DATETRUNC(part, date)` | Truncate to precision | 2022+ |
| `DATE_BUCKET(part, n, date)` | Group into buckets | 2022+ |
| `AT TIME ZONE 'tz'` | Timezone conversion | 2016+ |

### Window Functions
| Function | Description | Version |
|----------|-------------|---------|
| `ROW_NUMBER()` | Sequential unique numbers | 2005+ |
| `RANK()` | Rank with gaps for ties | 2005+ |
| `DENSE_RANK()` | Rank without gaps | 2005+ |
| `NTILE(n)` | Distribute into n groups | 2005+ |
| `LAG(col, n, default)` | Previous row value | 2012+ |
| `LEAD(col, n, default)` | Next row value | 2012+ |
| `FIRST_VALUE(col)` | First in window | 2012+ |
| `LAST_VALUE(col)` | Last in window | 2012+ |
| `IGNORE NULLS` | Skip NULLs in offset funcs | 2022+ |

### SQL Server 2022 New Functions
| Function | Description |
|----------|-------------|
| `GREATEST(v1, v2, ...)` | Maximum of values |
| `LEAST(v1, v2, ...)` | Minimum of values |
| `DATETRUNC(part, date)` | Truncate date |
| `GENERATE_SERIES(start, stop, [step])` | Number sequence |
| `JSON_OBJECT('key': val)` | Create JSON object |
| `JSON_ARRAY(v1, v2, ...)` | Create JSON array |
| `JSON_PATH_EXISTS(json, path)` | Check path exists |
| `IS [NOT] DISTINCT FROM` | NULL-safe comparison |

## Core Patterns

### String Manipulation
```sql
-- Concatenate with separator (NULL-safe)
SELECT CONCAT_WS(', ', FirstName, MiddleName, LastName) AS FullName

-- Split string to rows with ordinal
SELECT value, ordinal
FROM STRING_SPLIT('apple,banana,cherry', ',', 1)

-- Aggregate strings with ordering
SELECT DeptID,
       STRING_AGG(EmployeeName, ', ') WITHIN GROUP (ORDER BY HireDate)
FROM Employees
GROUP BY DeptID
```

### Date Operations
```sql
-- Truncate to first of month
SELECT DATETRUNC(month, OrderDate) AS MonthStart

-- Group by week buckets
SELECT DATE_BUCKET(week, 1, OrderDate) AS WeekBucket,
       COUNT(*) AS OrderCount
FROM Orders
GROUP BY DATE_BUCKET(week, 1, OrderDate)

-- Generate date series
SELECT CAST(value AS date) AS Date
FROM GENERATE_SERIES(
    CAST('2024-01-01' AS date),
    CAST('2024-12-31' AS date),
    1
)
```

### Window Functions
```sql
-- Running total with partitioning
SELECT OrderID, CustomerID, Amount,
       SUM(Amount) OVER (
           PARTITION BY CustomerID
           ORDER BY OrderDate
           ROWS UNBOUNDED PRECEDING
       ) AS RunningTotal
FROM Orders

-- Get previous non-NULL value (SQL 2022+)
SELECT Date, Value,
       LAST_VALUE(Value) IGNORE NULLS OVER (
           ORDER BY Date
           ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING
       ) AS PreviousNonNull
FROM Measurements
```

### JSON Operations
```sql
-- Extract scalar value
SELECT JSON_VALUE(JsonColumn, '$.customer.name') AS CustomerName

-- Parse JSON array to rows
SELECT j.ProductID, j.Quantity
FROM Orders
CROSS APPLY OPENJSON(OrderDetails)
WITH (
    ProductID INT '$.productId',
    Quantity INT '$.qty'
) AS j

-- Build JSON object (SQL 2022+)
SELECT JSON_OBJECT('id': CustomerID, 'name': CustomerName) AS CustomerJson
FROM Customers
```

## Additional References

For deeper coverage of specific function categories, see:

- `references/string-functions.md` - Complete string function reference with examples
- `references/window-functions.md` - Window and ranking functions with frame specifications

© JosiahSiegel · MIT · JosiahSiegel/claude-plugin-marketplace

Similar skills

All skills for Data and databases →

From the same set96

The whole set →
powershell-security powershell-security implements modern PowerShell hardening: stores credentials with SecretManagement, creates JEA role endpoints, and configures WDAC policies. CX Codex +1 194installs query-optimization query-optimization — an agent skill for slow T-SQL on SQL Server and Azure SQL: check schema and plan evidence first, then rewrite, re-index or hint. CX Codex +1 194installs ffmpeg-kinetic-captions ffmpeg-kinetic-captions writes ASS subtitles with animated captions: a karaoke highlight that scales each word, pop-in bounces, shake on the beat. Made for vertical video. CX Codex +1 193installs docker-platform-guide docker-platform-guide — a skill that briefs your coding agent on Docker differences between Windows, Linux and macOS, from WSL2 backends to multi-arch builds. CX Codex +1 192installs viral-video-short-form viral-video-short-form is a Claude Code skill for planning short videos on TikTok, Reels, and YouTube Shorts. It activates for work on hooks, captions, and posting strategy. CX Codex +1 186installs ado-pipeline-best-practices ado-pipeline-best-practices guides coding agents in designing, auditing, and optimizing Azure DevOps YAML pipelines using enterprise patterns. CX Codex +1 182installs parallel-processing-patterns The parallel-processing-patterns skill covers parallel Bash jobs with GNU Parallel, xargs -P, and background processes. Use it to process files concurrently or cap the number of running tasks. CX Codex +1 181installs compose-patterns-2025 The compose-patterns-2025 skill guides Docker Compose setups for multiple environments, service health checks, and network separation. Use it when shaping production Compose files. CX Codex +1 179installs

Project sponsors

Companies that keep this analytics open