dataplat/dbatools
🚀 SQL Server automation and instance migrations have never been safer, faster or freer observed · 2026-08-28
Health v2 · maintenance only
98/100
- Activity 99
- Release rhythm 95
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 8.0
- age_days: 4230
- days_rel: 33
- days_push: 7
- n_releases_24m: 39
Adoption not part of the score
2827 stars · 867 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
dbatools is a free, open-source PowerShell module with nearly 700 commands for automating SQL Server administration, including instance migrations, backup testing, and disaster recovery. It manages SQL Server instances remotely from a workstation, supporting SQL Server 2000 through 2022 plus Azure SQL variants on Windows, Linux, and macOS.
Use cases
- migrate a sql server instance to a new server
- test that my database backups actually restore
- run t-sql queries against 50 servers at once
- automate sql server patching across an estate
- set up tde encryption without manual certificate work
- export instance configuration for disaster recovery
- generate html or excel reports of my sql servers
When to choose
- you administer one or many SQL Server instances and want scriptable, repeatable operations
- you need to migrate instances, test backups, or manage configurations faster than manual SSMS work
- you want a free, community-proven alternative to paid SQL Server management tooling
When to avoid
- you primarily use other database engines like PostgreSQL, MySQL, or Oracle
- you need a GUI-driven administration experience rather than a command-line module
- you rely heavily on Azure SQL Database, where only ~40% of commands are supported
Facets
library · maturity active
database backup developer-tools cli workflow-automation databases developer-tools windows cli cross-platform powershell-module sql-server dba instance-migration backup-verification mssql command-line automation linux macos
7 sources
- readme: https://github.com/dataplat/dbatools · fetched 2026-08-28 · 176342bb869c
- homepage: https://dbatools.io · fetched 2026-08-29 · 6d1b1842c971
- site_page: https://dbatools.io/getting-started · fetched 2026-08-29 · c52b9b105300
- site_page: https://dbatools.io/install · fetched 2026-08-29 · 0a330ccbcbd1
- site_page: https://dbatools.io/offline-install · fetched 2026-08-29 · ccf4e1cce988
- site_page: https://dbatools.io/troubleshooting · fetched 2026-08-29 · c7b074b7f489
- site_page: https://dbatools.io/offline · fetched 2026-08-29 · 23db2e1c4526
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| dataplat/dbatools | main | 98 |
For agents
markdown · JSON · MCP: product_card(name="dataplat/dbatools")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem