Basic Configuration

Environment variables

The safest way to configure the server is through environment variables. Copy the example template:

cp .env.example .env

Edit .env with your database credentials.

Load environment variables

Linux/macOS:

source .env

Windows PowerShell:

Get-Content .env | ForEach-Object {
  $name, $value = $_ -split '=', 2
  [Environment]::SetEnvironmentVariable($name, $value)
}

Required variables

Variable	Description
MSSQL_SERVER	SQL Server hostname or IP
MSSQL_DATABASE	Database name
MSSQL_USER	SQL Server username
MSSQL_PASSWORD	SQL Server password

Optional variables

Variable	Default	Description
MSSQL_PORT	1433	SQL Server port
DEVELOPER_MODE	false	true for development, false for production
MSSQL_READ_ONLY	false	Read-only mode
MSSQL_WHITELIST_TABLES	(empty)	Tables allowed for modification in read-only mode
MSSQL_AUTH	sql	Authentication mode (sql, integrated, azure)
MSSQL_CONNECTION_STRING	(empty)	Custom connection string (overrides other variables)

Execution modes

Development mode

DEVELOPER_MODE=true go run main.go

In development mode:

• Self-signed certificates are allowed
• Errors show technical details
• Encryption can be disabled for local SQL Server

Production mode

DEVELOPER_MODE=false ./mcp-go-mssql

In production mode:

• Valid TLS certificates are required
• Errors are generic (no technical details)
• Encryption is mandatory

Verify the connection

cd test
go run test-connection.go