MCP server for Microsoft SQL Server - schema discovery, profiling, and safe data operations
stdiocommunityapplication
Package Details
@connorbritain/mssql-mcp-server
Transportstdio
Environment Variables
SERVER_NAME(str)
Required
SQL Server hostname or IP address
DATABASE_NAME(str)
Required
Target database name
SQL_AUTH_MODE(str)
Authentication mode: sql, windows, or aad
SQL_USERNAME(str)
Username for SQL or Windows auth
SQL_PASSWORD(str)
Secret
Password for SQL or Windows auth
SQL_PORT(str)
SQL Server port (default: 1433)
TRUST_SERVER_CERTIFICATE(str)
Set true for self-signed certs
READONLY(str)
Set true to disable write operations