io.github.coregentdevspace

sql-server-analyst-mcp

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

stdiocommunityapplication

Package Details

sql-server-analyst-mcp

0.1.1•https://www.npmjs.com/package/sql-server-analyst-mcp
Transportstdio

Environment Variables

MSSQL_SERVER(str)
Required

SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).

MSSQL_PORT(str)

TCP port (default 1433; set 0 for named instance with dynamic port).

MSSQL_DATABASE(str)

Default database to connect to. Most tools also accept an override argument.

MSSQL_USER(str)
Required

SQL authentication login name.

MSSQL_PASSWORD(str)
RequiredSecret

SQL authentication password. Quote values containing '#' in .env files.

MSSQL_ENCRYPT(str)

Encrypt the connection (true|false). Required true for Azure SQL.

MSSQL_TRUST_SERVER_CERT(str)

Trust self-signed certificates (true|false). Use true only for local dev.

ALLOWED_DATABASES(str)

Comma-separated allowlist of databases the server may access. Empty = unrestricted.

ALLOWED_SCHEMAS(str)

Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.

MAX_ROWS(str)

Default row limit per safe query (default 100).

MAX_ROWS_LIMIT(str)

Hard cap on query rows (default 1000).

QUERY_TIMEOUT_MS(str)

Query execution timeout in milliseconds (default 30000).

LOG_LEVEL(str)

error | warn | info | debug (default info).