sql server analyst mcp MCP

v0.1.1

io.github.coregentdevspace/sql-server-analyst-mcp

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

transport:stdio runtime:npm

View source

Target client

run in your project directory

MSSQL_SERVER

MSSQL_PORT

MSSQL_DATABASE

MSSQL_USER

MSSQL_PASSWORD

MSSQL_ENCRYPT

MSSQL_TRUST_SERVER_CERT

ALLOWED_DATABASES

ALLOWED_SCHEMAS

MAX_ROWS

MAX_ROWS_LIMIT

QUERY_TIMEOUT_MS

LOG_LEVEL

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

claude mcp add sql-server-analyst-mcp -e MSSQL_SERVER=<MSSQL_SERVER> -e MSSQL_PORT=<MSSQL_PORT> -e MSSQL_DATABASE=<MSSQL_DATABASE> -e MSSQL_USER=<MSSQL_USER> -e MSSQL_PASSWORD=<MSSQL_PASSWORD> -e MSSQL_ENCRYPT=<MSSQL_ENCRYPT> -e MSSQL_TRUST_SERVER_CERT=<MSSQL_TRUST_SERVER_CERT> -e ALLOWED_DATABASES=<ALLOWED_DATABASES> -e ALLOWED_SCHEMAS=<ALLOWED_SCHEMAS> -e MAX_ROWS=<MAX_ROWS> -e MAX_ROWS_LIMIT=<MAX_ROWS_LIMIT> -e QUERY_TIMEOUT_MS=<QUERY_TIMEOUT_MS> -e LOG_LEVEL=<LOG_LEVEL> -- npx -y sql-server-analyst-mcp