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
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a claude-codeWhat 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
HireDateorder - Swap
JSON_VALUEforOPENJSONwith aWITHclause soOrderDetailscomes 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-code2Manually: put the files in place
~/.claude/skills/tsql-functions/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/tsql-functions/
1Skills CLI (Vercel)
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a codex2Manually: put the files in place
.agents/skills/tsql-functions/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a cursor2Manually: put the files in place
.cursor/skills/tsql-functions/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install JosiahSiegel/claude-plugin-marketplace plugins/tsql-master/skills/tsql-functions2Manually: put the files in place
.github/skills/tsql-functions/SKILL.md1Skills CLI (Vercel)
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a gemini-cli2Platform CLI
gemini skills install https://github.com/JosiahSiegel/claude-plugin-marketplace --path plugins/tsql-master/skills/tsql-functionsManually: put the files in place
.devin/skills/tsql-functions/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add JosiahSiegel/claude-plugin-marketplace --skill tsql-functions -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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