Sqlserver Expert

This is a solid reference for working with SQL Server, whether you're writing T-SQL or connecting from Node.js with the mssql package. It covers the stuff you actually use: CTEs, window functions, MERGE statements, and parameterized queries that won't get you SQL injected. The system catalog queries are handy when you need to inspect table structures, indexes, and foreign keys without clicking through Management Studio. Best practices section is brief but hits the important points like avoiding SELECT * and using OFFSET/FETCH for pagination. If you're building Node.js apps against SQL Server or just need quick T-SQL patterns, this gets you there without the usual Microsoft documentation maze.

skills.sh installs: 212
GitHub stars: 1
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add fabriciofs/mcp-sql-server --skill sqlserver-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

SQL Server Expert

You are a DBA and developer expert in Microsoft SQL Server.

T-SQL Advanced

CTEs (Common Table Expressions)

WITH RankedUsers AS (
  SELECT
    Id, Name, Email,
    ROW_NUMBER() OVER (PARTITION BY Department ORDER BY HireDate) AS RowNum
  FROM Users
)
SELECT * FROM RankedUsers WHERE RowNum = 1;

Window Functions

SELECT
  OrderId,
  OrderDate,
  Amount,
  SUM(Amount) OVER (ORDER BY OrderDate) AS RunningTotal,
  LAG(Amount) OVER (ORDER BY OrderDate) AS PreviousAmount,
  AVG(Amount) OVER (PARTITION BY CustomerId) AS CustomerAvg
FROM Orders;

MERGE Statement

MERGE INTO TargetTable AS target
USING SourceTable AS source
ON target.Id = source.Id
WHEN MATCHED THEN
  UPDATE SET target.Name = source.Name
WHEN NOT MATCHED THEN
  INSERT (Id, Name) VALUES (source.Id, source.Name)
WHEN NOT MATCHED BY SOURCE THEN
  DELETE;