Microsoft SQL Server for VS Code

{
  "inputs": [
    {
      "type": "promptString",
      "id": "mcpmssql-connection-string",
      "description": "MCPMSSQL_CONNECTION_STRING",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-description",
      "description": "MCPMSSQL_DESCRIPTION",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-query-max-rows",
      "description": "MCPMSSQL_QUERY_MAX_ROWS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-query-command-timeout-seconds",
      "description": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-query-snapshot-max-rows",
      "description": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-query-snapshot-command-timeout-seconds",
      "description": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-analyze-command-timeout-seconds",
      "description": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-allow-write",
      "description": "MCPMSSQL_ALLOW_WRITE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcpmssql-write-command-timeout-seconds",
      "description": "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "dotnet-environment",
      "description": "DOTNET_ENVIRONMENT",
      "password": true
    }
  ],
  "servers": {
    "mcp-mssql": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "Alyio.McpMssql",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "${input:mcpmssql-connection-string}",
        "MCPMSSQL_DESCRIPTION": "${input:mcpmssql-description}",
        "MCPMSSQL_QUERY_MAX_ROWS": "${input:mcpmssql-query-max-rows}",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "${input:mcpmssql-query-command-timeout-seconds}",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "${input:mcpmssql-query-snapshot-max-rows}",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "${input:mcpmssql-query-snapshot-command-timeout-seconds}",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "${input:mcpmssql-analyze-command-timeout-seconds}",
        "MCPMSSQL_ALLOW_WRITE": "${input:mcpmssql-allow-write}",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "${input:mcpmssql-write-command-timeout-seconds}",
        "DOTNET_ENVIRONMENT": "${input:dotnet-environment}"
      }
    }
  }
}