io.github.dataplat/dbatools-mcp-server MCP Server

Name: io.github.dataplat/dbatools-mcp-server MCP Server
Author: io.github.dataplat

io.github.dataplat/dbatools-mcp-server

Repository Registry

What is the io.github.dataplat/dbatools-mcp-server MCP server?

MCP server for dbatools — exposes SQL Server management commands as MCP tools

How to install io.github.dataplat/dbatools-mcp-server

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

DBATOOLS_SAFE_MODE
Set to 'false' to allow write/destructive dbatools operations. Defaults to true (read-only safe mode).
MAX_OUTPUT_ROWS
Maximum number of rows returned per command. Defaults to 100. Allowed range: 1–10000.
COMMAND_TIMEOUT_SECONDS
Timeout in seconds for each dbatools command. Defaults to 60. Allowed range: 5–3600.
PWSH_EXE
Path to the PowerShell executable. Defaults to 'pwsh'.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "dbatools-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "dbatools-mcp-server"
      ],
      "env": {
        "DBATOOLS_SAFE_MODE": "<YOUR_DBATOOLS_SAFE_MODE>",
        "MAX_OUTPUT_ROWS": "<YOUR_MAX_OUTPUT_ROWS>",
        "COMMAND_TIMEOUT_SECONDS": "<YOUR_COMMAND_TIMEOUT_SECONDS>",
        "PWSH_EXE": "<YOUR_PWSH_EXE>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbatools-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "dbatools-mcp-server"
      ],
      "env": {
        "DBATOOLS_SAFE_MODE": "<YOUR_DBATOOLS_SAFE_MODE>",
        "MAX_OUTPUT_ROWS": "<YOUR_MAX_OUTPUT_ROWS>",
        "COMMAND_TIMEOUT_SECONDS": "<YOUR_COMMAND_TIMEOUT_SECONDS>",
        "PWSH_EXE": "<YOUR_PWSH_EXE>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "dbatools-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "dbatools-mcp-server"
      ],
      "env": {
        "DBATOOLS_SAFE_MODE": "<YOUR_DBATOOLS_SAFE_MODE>",
        "MAX_OUTPUT_ROWS": "<YOUR_MAX_OUTPUT_ROWS>",
        "COMMAND_TIMEOUT_SECONDS": "<YOUR_COMMAND_TIMEOUT_SECONDS>",
        "PWSH_EXE": "<YOUR_PWSH_EXE>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "dbatools-mcp-server": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "dbatools-mcp-server"
      ],
      "env": {
        "DBATOOLS_SAFE_MODE": "<YOUR_DBATOOLS_SAFE_MODE>",
        "MAX_OUTPUT_ROWS": "<YOUR_MAX_OUTPUT_ROWS>",
        "COMMAND_TIMEOUT_SECONDS": "<YOUR_COMMAND_TIMEOUT_SECONDS>",
        "PWSH_EXE": "<YOUR_PWSH_EXE>"
      }
    }
  }
}

Claude Code

claude mcp add dbatools-mcp-server --env DBATOOLS_SAFE_MODE=<YOUR_DBATOOLS_SAFE_MODE> --env MAX_OUTPUT_ROWS=<YOUR_MAX_OUTPUT_ROWS> --env COMMAND_TIMEOUT_SECONDS=<YOUR_COMMAND_TIMEOUT_SECONDS> --env PWSH_EXE=<YOUR_PWSH_EXE> -- npx -y dbatools-mcp-server