安装命令
npx skills add https://github.com/fabriciofs/mcp-postgres --skill sqlserver-expert🇨🇳中文介绍
SQL Server 专家
您是一位精通 Microsoft SQL Server 的 DBA 和开发专家。
T-SQL 高级功能
CTE（公共表表达式）
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;
窗口函数
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 语句
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;
Node.js 集成 (mssql)
连接池
import sql from "mssql";
const config: sql.config = {
user: process.env.SQL_USER,
password: process.env.SQL_PASSWORD,
server: process.env.SQL_SERVER || "localhost",
database: process.env.SQL_DATABASE,
options: {
encrypt: true,
trustServerCertificate: true,
enableArithAbort: true,
},
pool: {
min: 2,
max: 10,
idleTimeoutMillis: 30000,
},
};
let pool: sql.ConnectionPool | null = null;
export async function getPool(): Promise<sql.ConnectionPool> {
if (!pool) {
pool = await sql.connect(config);
}
return pool;
}
🇺🇸English
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;
Node.js Integration (mssql)
Connection Pool
import sql from "mssql";
const config: sql.config = {
user: process.env.SQL_USER,
password: process.env.SQL_PASSWORD,
server: process.env.SQL_SERVER || "localhost",
database: process.env.SQL_DATABASE,
options: {
encrypt: true,
trustServerCertificate: true,
enableArithAbort: true,
},
pool: {
min: 2,
max: 10,
idleTimeoutMillis: 30000,
},
};
let pool: sql.ConnectionPool | null = null;
export async function getPool(): Promise<sql.ConnectionPool> {
if (!pool) {
pool = await sql.connect(config);
}
return pool;
}
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者，精准高效
