mcpField
S
sql-server-analyst-mcp

sql-server-analyst-mcp

Local
github.com/coregentdevspaceDatabases
Repository

About sql-server-analyst-mcp

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "coregentdevspace-sql-server-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_PORT": "<MSSQL_PORT>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<MSSQL_PASSWORD>",
        "MSSQL_ENCRYPT": "<MSSQL_ENCRYPT>",
        "MSSQL_TRUST_SERVER_CERT": "<MSSQL_TRUST_SERVER_CERT>",
        "ALLOWED_DATABASES": "<ALLOWED_DATABASES>",
        "ALLOWED_SCHEMAS": "<ALLOWED_SCHEMAS>",
        "MAX_ROWS": "<MAX_ROWS>",
        "MAX_ROWS_LIMIT": "<MAX_ROWS_LIMIT>",
        "QUERY_TIMEOUT_MS": "<QUERY_TIMEOUT_MS>",
        "LOG_LEVEL": "<LOG_LEVEL>"
      }
    }
  }
}
Run commandnpx -y sql-server-analyst-mcp
Environment variables to set
MSSQL_SERVERSQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
MSSQL_PORTTCP port (default 1433; set 0 for named instance with dynamic port).
MSSQL_DATABASEDefault database to connect to. Most tools also accept an override argument.
MSSQL_USERSQL authentication login name.
MSSQL_PASSWORDSecretSQL authentication password. Quote values containing '#' in .env files.
MSSQL_ENCRYPTEncrypt the connection (true|false). Required true for Azure SQL.
MSSQL_TRUST_SERVER_CERTTrust self-signed certificates (true|false). Use true only for local dev.
ALLOWED_DATABASESComma-separated allowlist of databases the server may access. Empty = unrestricted.
ALLOWED_SCHEMASComma-separated allowlist of schemas for schema tools. Empty = unrestricted.
MAX_ROWSDefault row limit per safe query (default 100).
MAX_ROWS_LIMITHard cap on query rows (default 1000).
QUERY_TIMEOUT_MSQuery execution timeout in milliseconds (default 30000).
LOG_LEVELerror | warn | info | debug (default info).

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npmsql-server-analyst-mcp0.1.1

Tools

12

Saved tool list · updated 2w ago

This tool takes no parameters.

Details

The maintainer has not added details yet. Check the README in the repository.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.