Pages

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.

Commands Browser

Bill of Health

SQL Server Build Reference

Sponsorship

If dbatools has ever saved you time, either through our migration commands or easing SQL Server automation in general, please consider sponsoring one or more of us for a couple bucks a month. Sponsoring one or more of our developers through GitHub’s new Developer Sponsorship Program will help dbatools continue to live on, which ultimately means an easier, funner time at work for you as you relax while dbatools does all of the heavy-lifting.

Sponsorship

If dbatools has ever saved you time, either through our migration commands or easing SQL Server automation in general, please consider sponsoring one or more of us for a couple bucks a month. Sponsoring one or more of our developers through GitHub’s new Developer Sponsorship Program will help dbatools continue to live on, which ultimately means an easier, funner time at work for you as you relax while dbatools does all of the heavy-lifting.

Your First Pull Request

Here’s a quick tutorial on creating your first pull request. Fork the project, clone your fork, and configure the remotes: # Clone your fork of the repo into the current directory git clone https://github.com/<your-username>/dbatools.git # Navigate to the newly cloned directory cd dbatools # Assign the original repo to a remote called "upstream" git remote add upstream https://github.com/dataplat/dbatools.git If you cloned a while ago, get the latest changes from upstream: git checkout development git pull upstream development Create a new topic branch (off the main project development branch) to contain your feature, change, or fix: git checkout -b <topic-branch-name> Commit your changes in logical chunks.

Contact

Holler Thank you for your interest! It is best to write with questions or issues on our GitHub Repo. We are also on the SQL Server Community Slack in the channel #dbatools.

Guidelines

Here are a few things to keep in mind when programming for dbatools. Minimum Requirements One source of pride for this project is that it works on most systems. We at least try to make it work on SQL Server 2000, though sometimes it’s not possible. SQL Server 2005 and above usually works well. Also, remember that this module is intended for migrations and hence older systems, so PowerShell v3 is the base that we’ll be using to program.

Developing for dbatools

First thing is first, if you contribute a major amount, you’ll be added to the Major Contributors on the Team page 😀 Help Us Build an Amazing Toolset The types of commands we are looking for simplify whole tasks. As Microsoft continues its work on the PowerShell module for SQL Server, we’ll be here building commands for DBA Best Practices and common painful tasks. Benefits Help your fellow DBAs and yourself Build your resume Be an all-star DBA Ready to Join?