Skip to content
mcp/harbor
Gemini CLI

dbatools mcp server for Gemini CLI

io.github.dataplat/dbatools-mcp-server

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

client:Gemini CLI transport:stdio runtime:npm

Install dbatools mcp server in Gemini CLI

~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

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

Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs

dbatools mcp server in other clients

dbatools mcp server MCP server