dbatools MCP Server

Ask an AI assistant how to restore a database with dbatools and you will usually get something that looks right. Then you run it and find out -RecoveryTime was never a parameter, or that the command it confidently recommended does not exist.

This server fixes that. Point your assistant at it and it searches the real dbatools documentation - 700+ commands with their syntax, parameters and published examples, plus the articles on this site - and cites the page each answer came from, so you can check it. It also carries a set of curated answers to the questions people actually ask in support, indexed under the error messages that provoke them, and 183 lessons from our book, dbatools in a Month of Lunches.

Endpoint: https://mcp.dbatools.io

There is no signup, no API key and no account. Add the URL and it works.

This MCP was built after seeing just how useful Microsoft’s Learn MCP server was for our projects. Their read-only docs MCP is like this one, but for all of their products like SQL Server, PowerShell, .NET and more.

Add it to your client

claude mcp add --transport http dbatools https://mcp.dbatools.io

{
  "servers": {
    "dbatools": {
      "type": "http",
      "url": "https://mcp.dbatools.io"
    }
  }
}

{
  "mcpServers": {
    "dbatools": {
      "url": "https://mcp.dbatools.io"
    }
  }
}

[mcp_servers.dbatools]
url = "https://mcp.dbatools.io"

curl https://mcp.dbatools.io \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{
    "jsonrpc": "2.0",
    "id": 1,
    "method": "tools/call",
    "params": {
      "name": "dbatools_docs_search",
      "arguments": { "query": "restore to a point in time" }
    }
  }'

Once it is connected, ask your assistant to list its tools. You should see three names beginning with dbatools_.

What to ask it

You never have to name a tool. Ask the question you actually have and your assistant will reach for the server on its own:

• How do I restore a database to a point in time with dbatools?
• What is the difference between -SqlCredential and -Credential?
• Show me a worked example of backing up to Azure blob storage.
• Which dbatools commands run on Linux?
• I need to copy logins between two instances without copying passwords.
• What has to exist before I can create a SQL Agent job step?

Pasting an error verbatim works too - “The command was found in the module ‘dbatools’, but the module could not be loaded” - because the curated answers are indexed under the exact text you would paste.

It is at its best on the questions models get wrong from memory: exact parameter names, which switches are mutually exclusive, and whether a command exists at all.

The three tools

What it can’t do

It reads documentation. That is the whole job.

It cannot connect to a SQL Server instance, cannot run a dbatools command, and holds no credentials of any kind - there is nowhere to put them and nothing that would use them. The search never leaves the process, because the documentation is compiled into the deployment artifact and searched in memory.

All three tools are declared read-only in the protocol, so most clients will let you auto-approve them and stop asking. That is the truthful description of the server, not a convenience setting.

If what you want is an MCP server that does run dbatools commands against your instances, that is dbatools-mcp-server - a separate project that runs locally on your own machine. You can install both at once; their tool names do not overlap.

Where it falls short

It is a search engine over a pile of documentation, and it is worth knowing exactly how narrow that is before you rely on it.

It has no notion of meaning - it has a vocabulary. Queries and documents are both stemmed, so “migrate”, “migrating” and “migration” count as one word, and a curated list of about 120 phrases maps the words DBAs type onto the words the module uses. That is why “moving a database to another server” does reach the migration commands: because somebody wrote that mapping down, not because anything understood the question. A phrasing nobody anticipated falls back to plain word matching and can still come back empty. When it does, try again in the words the documentation itself would use.

It cannot tell reading from writing. Ask which port an instance is listening on and Set-DbaTcpPort may well rank above Get-DbaTcpPort, because nothing in the ranking distinguishes a command that reports something from one that changes it. Check the verb on anything you are about to run.

It only knows what is published on this site, plus the FAQ and the book. Command help, articles, a few dozen curated answers mined from years of community support, and the lessons from dbatools in a Month of Lunches. Not the GitHub issues, not the rest of the Slack channel, and not the source code. Plenty of the best dbatools knowledge lives in those and none of it is in here.

It is only as good as the docs are. Where a command’s help is thin or out of date, the answer is thin or out of date. Nothing in this server checks the documentation against the module’s actual behaviour.

The FAQ answers are the exception - each one was tested against a live instance and says which module version it was checked against. That also makes them the part most likely to go stale, because command counts and parameter names move between releases. If an answer names a version older than yours, treat it as a strong hint rather than a fact.

The book lessons were not re-tested, so each one names the chapter it came from and the ones that turn on a default or a parameter name say so outright. The judgement in them holds; check the command page before trusting a specific flag.

Platform support is the clearest case. Every command carries the same Availability: Windows, Linux, macOS in its help - Get-DbaDiskSpace and Get-DbaFirewallRule included, though both lean on WMI or remoting and do not work on Linux. The real answer is in dbatools & SQL on Linux, which the server does return for that question: the pure-SQL commands work, the ones that reach into Windows do not, and the article puts the split at about three quarters. Trust the article, not the field.

It knows nothing about you. Not your SQL Server version, not which dbatools version you have installed, not your instances. Every answer is the general case.

It can be a day behind. The index rebuilds daily, so a command merged this morning may not be findable until tomorrow.

Results are capped, too: ten documents per search, twenty code samples. That is a deliberate ceiling on how much of your context window one call can eat.

What it costs your context

The three tool definitions and the server’s instructions add up to roughly 735 tokens per session - about 0.3% of a 200K window, which is nothing. Clients that defer tool schemas until a tool is actually used bring that down to about 30 tokens for the three names.

The FAQ answers and the book lessons cost nothing extra here. They are extra kinds of document inside the existing search tool rather than tools of their own, each of which would have added roughly 150 tokens to every session for the rest of time.

The real cost is in results, not definitions. dbatools_docs_fetch returns a whole command page, and a page like Backup-DbaDatabase runs to thousands of tokens on its own. A ten-hit search with excerpts costs more than the tool definitions did for the entire session. If your context is tight, fetch deliberately rather than reflexively.

Install Microsoft’s Learn server too

If you only add one MCP server this week, make it Microsoft’s rather than this one.

The Microsoft Learn MCP server puts the whole of Microsoft Learn in front of your assistant: SQL Server itself, T-SQL, Azure SQL, PowerShell, Windows, the lot. It is free, hosted by Microsoft, and needs no sign-in. We use it constantly, and it is genuinely the reason this server exists - once you have watched an assistant stop guessing about SQL Server, the fact that it was still guessing about dbatools becomes impossible to ignore.

claude mcp add --transport http microsoft-learn https://learn.microsoft.com/api/mcp

Or in VS Code, in .vscode/mcp.json:

{
  "servers": {
    "microsoft-learn": {
      "type": "http",
      "url": "https://learn.microsoft.com/api/mcp"
    }
  }
}

Claude Code and Copilot CLI users can install their plugin instead, which brings the server plus three skills that teach the assistant when to reach for it:

/plugin marketplace add microsoftdocs/mcp
/plugin install microsoft-docs@microsoft-docs-marketplace

The two servers answer different halves of the same question. Learn tells you what SQL Server does and why; this one tells you which dbatools command does it and what the parameter is actually called. Run both. Their tool names do not collide, and the shape of this server - search, code samples, fetch - is copied from theirs on purpose, because it was the right design and there was no reason to invent a worse one.

How it stays current

The index is rebuilt from three public sources every day at 09:00 UTC, and again on every deploy:

The FAQ answers and the book lessons are the two things not downloaded. They are written and versioned with the server’s own source, so they change when somebody edits them rather than on a schedule.

Search is lexical BM25, with stemming, stop words and the synonym map sitting in front of it. There are no embeddings and no vector database. Storing vectors would be cheap, but embedding your query at request time would mean either a 25 MB model loaded in the cold-start path or an API round trip on every single call, and a documentation search does not need to cost that. The whole corpus fits in memory instead, so a query costs nothing and returns the same results every time.