Microsoft SQL Server MCP Server (MSSQL)

by dperussina
Verified
# Server Configuration PORT=3333 TRANSPORT=sse # Options: sse, stdio HOST=0.0.0.0 # Database Configuration DB_SERVER=localhost DB_PORT=1433 DB_DATABASE=master DB_USER=sa DB_PASSWORD=YourStrong@Passw0rd DB_ENCRYPT=true DB_TRUST_SERVER_CERT=true DB_CONNECTION_TIMEOUT=15000 DB_REQUEST_TIMEOUT=15000 DB_POOL_MAX=10 DB_POOL_MIN=0 DB_POOL_IDLE_TIMEOUT=30000 # Query Results Storage QUERY_RESULTS_PATH=./query_results # Logging Configuration LOG_LEVEL=info # Options: error, warn, info, http, verbose, debug, silly LOG_FILE=./logs/mcp-server.log LOG_MAX_SIZE=10m LOG_MAX_FILES=5 LOG_FORMAT=json # Options: json, console, simple # Security Configuration RATE_LIMIT_WINDOW_MS=60000 # 1 minute RATE_LIMIT_MAX=100 # 100 requests per minute # Client Configuration MCP_SERVER_URL=http://localhost:3333