{"servers":[{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.coregentdevspace/sql-server-analyst-mcp","description":"Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.","repository":{"url":"https://github.com/coregentdevspace/sql-server-analyst-mcp","source":"github"},"version":"0.1.1","packages":[{"registryType":"npm","identifier":"sql-server-analyst-mcp","version":"0.1.1","transport":{"type":"stdio"},"environmentVariables":[{"description":"SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).","isRequired":true,"format":"string","name":"MSSQL_SERVER"},{"description":"TCP port (default 1433; set 0 for named instance with dynamic port).","format":"string","name":"MSSQL_PORT"},{"description":"Default database to connect to. Most tools also accept an override argument.","format":"string","name":"MSSQL_DATABASE"},{"description":"SQL authentication login name.","isRequired":true,"format":"string","name":"MSSQL_USER"},{"description":"SQL authentication password. Quote values containing '#' in .env files.","isRequired":true,"format":"string","isSecret":true,"name":"MSSQL_PASSWORD"},{"description":"Encrypt the connection (true|false). Required true for Azure SQL.","format":"string","name":"MSSQL_ENCRYPT"},{"description":"Trust self-signed certificates (true|false). Use true only for local dev.","format":"string","name":"MSSQL_TRUST_SERVER_CERT"},{"description":"Comma-separated allowlist of databases the server may access. Empty = unrestricted.","format":"string","name":"ALLOWED_DATABASES"},{"description":"Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.","format":"string","name":"ALLOWED_SCHEMAS"},{"description":"Default row limit per safe query (default 100).","format":"string","name":"MAX_ROWS"},{"description":"Hard cap on query rows (default 1000).","format":"string","name":"MAX_ROWS_LIMIT"},{"description":"Query execution timeout in milliseconds (default 30000).","format":"string","name":"QUERY_TIMEOUT_MS"},{"description":"error | warn | info | debug (default info).","format":"string","name":"LOG_LEVEL"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-04-22T02:08:34.978063Z","publishedAt":"2026-04-22T02:08:34.978063Z","updatedAt":"2026-04-22T02:08:34.978063Z","isLatest":true}}}],"metadata":{"count":1}}