Dbatools Mcp Server
by dataplatcommunityv0.5.0
3
1
This MCP server exposes dbatools commands for AI assistants to discover, explain, and execute commands directly, utilizing metadata from dbatools' comment-based help.
From the registry: MCP server for dbatools — exposes SQL Server management commands as MCP tools
Install & configure
Prerequisites
- required
- required
- requiredInstall dbatools PowerShell moduleInstall the dbatools module from PSGallery.
https://dbatools.io/download$ Install-Module dbatools -Scope CurrentUser
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `dbatools-mcp-server` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Node.js 20+** — Install Node.js 20 or later. (https://nodejs.org)
- **PowerShell 7+** — Install PowerShell 7 (`pwsh`). (https://github.com/PowerShell/PowerShell/releases)
- **Install dbatools PowerShell module** — Install the dbatools module from PSGallery. Run: `Install-Module dbatools -Scope CurrentUser` (https://dbatools.io/download)
Canonical MCP server config (stdio transport):
- command: `npx`
- args: ["-y","dbatools-mcp-server@latest"]
- optional environment variables:
- `PWSH_EXE`: Path to PowerShell executable (example: `pwsh`)
- `DBATOOLS_SAFE_MODE`: Require confirm:true on non-readonly commands (example: `true`)
- `MAX_OUTPUT_ROWS`: Max rows returned per command (example: `100`)
- `COMMAND_TIMEOUT_SECONDS`: Seconds before PowerShell process is killed (example: `60`)
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Tools (4)
list_dbatools_commands
Search commands by verb, noun, keyword, or risk level.
get_dbatools_command_help
Provides full normalized help from Get-Help -Full.
invoke_dbatools_command
Executes any dbatools command with safe parameter validation.
check_dbatools_environment
Verifies PowerShell and dbatools installation and version alignment.
Environment variables
DBATOOLS_SAFE_MODErequiredWhen true, non-readonly commands require confirm: true.MAX_OUTPUT_ROWSrequiredMaximum rows returned per command execution.COMMAND_TIMEOUT_SECONDSrequiredSeconds before PowerShell process is killed.Packages
dbatools-mcp-server
npmv0.5.0transport: stdio
Details
- Language
- TypeScript
- License
- MIT
- Released
- Apr 18, 2026
- Last commit
- Jun 4, 2026
- Registry name
- io.github.dataplat/dbatools-mcp-server