dataplat avatar

Dbatools Mcp Server

dataplat/dbatools-mcp-server

Bridges Claude to dbatools, the 500+ command PowerShell module for SQL Server administration. Exposes three core operations: search commands by verb or keyword, fetch full help with parameters and examples pulled from Get-Help, and execute commands with JSON output. Runs PowerShell subprocesses and validates risk levels automatically, so destructive verbs like Remove or Drop require explicit confirmation in safe mode. Pass SqlCredential for SQL auth instances. You'll want this if you're managing SQL Server estates and need Claude to discover backup commands, check configurations, or run migrations without leaving the conversation. Requires PowerShell 7 and a local dbatools install. Help index regenerates from your installed module version.

GitHub stars
3
tools
4
transport
STDIO
env vars
4
last updated
Apr 18, 2026

Tools

4 tools

Public tool metadata for what this MCP can expose to an agent.

list_dbatools_commandssearch commands by verb, noun, keyword, or risk level

search commands by verb, noun, keyword, or risk level

No parameter schema in public metadata yet.

get_dbatools_command_helpfull normalized help (synopsis, parameters, examples) from `Get-Help -Full`

full normalized help (synopsis, parameters, examples) from `Get-Help -Full`

No parameter schema in public metadata yet.

invoke_dbatools_commandexecute any dbatools command with safe parameter validation, risk gating, and structured JSON output

execute any dbatools command with safe parameter validation, risk gating, and structured JSON output

No parameter schema in public metadata yet.

check_dbatools_environmentverify PowerShell + dbatools installation, index freshness, and version alignment

verify PowerShell + dbatools installation, index freshness, and version alignment

No parameter schema in public metadata yet.

Sponsors

Configuration

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'.

Readme

dbatools-mcp-server

Install in VS Code Install in VS Code Insiders

A Model Context Protocol (MCP) server for the dbatools PowerShell module.

Exposes dbatools commands as MCP tools so AI assistants (GitHub Copilot, Claude, etc.) can discover, explain, and execute dbatools commands directly — with all metadata sourced from dbatools' own comment-based help.


Features


View the full README on GitHub

Details

Repository
github.com/dataplat/dbatools-mcp-server
Category
Databases
Package
dbatools-mcp-server
Transport
STDIO
Registry
MCP registry, active

Related Databases MCP servers

View all
1devilsfave avatarDagpipedevilsfave/dagpipeCrash-proof LLM pipelines. Resumes from failure without a database.3stars
2domdomegg avatarOpen Food Factsdomdomegg/openfoodfacts-mcpSearch and contribute to the Open Food Facts database.3stars
3oxgeneral avataragentmemoxgeneral/agentmemLightweight persistent memory for AI agents. Hybrid search. 16 tools. One SQLite file.3stars
4zafety-vibin avatarGrimoire for Gamemasterszafety-vibin/grimoire-mcpD&D and TTRPG campaign manager for GMs: your AI reads and writes a live, typed campaign database.2stars
5cklam12345 avatarWisdomgraphcklam12345/wisdomgraphNeo4j-native DIKW memory for Claude Code — knowledge that compounds across sessions2stars
6colabfit avatarColabfit Mcpcolabfit/colabfit-mcpAn MCP server that provides access to the ColabFit database2stars