加载中…
Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
io.github.coregentdevspace/sql-server-analyst-mcp 是 ChatHome Skills 收录的 MCP 条目，来源为 Official MCP Registry，质量分 67/100。 作为 Model Context Protocol 服务器，它向 Claude、Cursor、Copilot 等兼容 MCP 的 LLM 客户端暴露可直接调用的工具，让 agent 的能力超出模型内置范围。 该条目由 ChatHome Skills 的每日抓取从官方 registry 和 GitHub 发现查询中收录，每次运行都会重新核验仓库事实、新鲜度信号和安装元数据。 质量分综合了官方 registry 收录情况、可用安装命令、许可证完整性、仓库活跃度和 GitHub star 趋势，完整算法说明见来源页。安装命令已列于上方，可直接复制使用。 在将 io.github.coregentdevspace/sql-server-analyst-mcp 加入生产 agent 工作流前，请核对上方的最近更新日期和仓库状态——下方事实快照是最近一次抓取的时点值。
npx -y sql-server-analyst-mcp@0.1.1运行此命令前，请先核对上游源码。
{
"_meta": {
"io.modelcontextprotocol.registry/official": {
"status": "active",
"isLatest": true,
"updatedAt": "2026-04-22T02:08:34.978063Z",
"publishedAt": "2026-04-22T02:08:34.978063Z",
"statusChangedAt": "2026-04-22T02:08:34.978063Z"
}
},
"server": {
"name": "io.github.coregentdevspace/sql-server-analyst-mcp",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.1.1",
"packages": [
{
"version": "0.1.1",
"transport": {
"type": "stdio"
},
"identifier": "sql-server-analyst-mcp",
"registryType": "npm",
"environmentVariables": [
{
"name": "MSSQL_SERVER",
"format": "string",
"isRequired": true,
"description": "SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL)."
},
{
"name": "MSSQL_PORT",
"format": "string",
"description": "TCP port (default 1433; set 0 for named instance with dynamic port)."
},
{
"name": "MSSQL_DATABASE",
"format": "string",
"description": "Default database to connect to. Most tools also accept an override argument."
},
{
"name": "MSSQL_USER",
"format": "string",
"isRequired": true,
"description": "SQL authentication login name."
},
{
"name": "MSSQL_PASSWORD",
"format": "string",
"isSecret": true,
"isRequired": true,
"description": "SQL authentication password. Quote values containing '#' in .env files."
},
{
"name": "MSSQL_ENCRYPT",
"format": "string",
"description": "Encrypt the connection (true|false). Required true for Azure SQL."
},
{
"name": "MSSQL_TRUST_SERVER_CERT",
"format": "string",
"description": "Trust self-signed certificates (true|false). Use true only for local dev."
},
{
"name": "ALLOWED_DATABASES",
"format": "string",
"description": "Comma-separated allowlist of databases the server may access. Empty = unrestricted."
},
{
"name": "ALLOWED_SCHEMAS",
"format": "string",
"description": "Comma-separated allowlist of schemas for schema tools. Empty = unrestricted."
},
{
"name": "MAX_ROWS",
"format": "string",
"description": "Default row limit per safe query (default 100)."
},
{
"name": "MAX_ROWS_LIMIT",
"format": "string",
"description": "Hard cap on query rows (default 1000)."
},
{
"name": "QUERY_TIMEOUT_MS",
"format": "string",
"description": "Query execution timeout in milliseconds (default 30000)."
},
{
"name": "LOG_LEVEL",
"format": "string",
"description": "error | warn | info | debug (default info)."
}
]
}
],
"repository": {
"url": "https://github.com/coregentdevspace/sql-server-analyst-mcp",
"source": "github"
},
"description": "Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis."
}
}