Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings. Secret.
MCPMSSQL_DESCRIPTION
No
Optional human-readable description for the default profile.
MCPMSSQL_QUERY_MAX_ROWS
No
Max rows per interactive query (default 500; ceiling 1000).
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS
No
Interactive query command timeout in seconds (default 30).
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS
No
Max rows for snapshot queries (default 10000; ceiling 50000).
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS
No
Snapshot query timeout in seconds (default 120).
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS
No
Execution plan analysis timeout in seconds (default 300; ceiling 600).
MCPMSSQL_ALLOW_WRITE
No
Enable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only — prefer a db_datareader login for a hard read-only guarantee.
MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS
No
Write command timeout in seconds (default 60; ceiling 600).
DOTNET_ENVIRONMENT
No
Set to Development to load dotnet user-secrets (local dev).
