Loading…
Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
io.github.coregentdevspace/sql-server-analyst-mcp is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 67/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding io.github.coregentdevspace/sql-server-analyst-mcp to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.
npx -y sql-server-analyst-mcp@0.1.1Review the upstream source before running this command.
{
"_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."
}
}