Copilot Agent Mode Lands in SSMS Preview
Microsoft has placed an Agent mode for GitHub Copilot inside SQL Server Management Studio, letting the AI work on database tasks autonomously.
What this means: The preview shows Copilot moving beyond simple query suggestions to handling multi-step database workflows, executing queries, tuning performance and enforcing security under user approval.
Actionable guidance:
- Enable preview features in Copilot settings and install the latest SSMS version.
- Grant only the permissions required for the tasks you delegate.
- Start with straightforward natural-language commands like ‘Find slow queries in the Orders table’.
- Review each suggested query before Copilot runs it to maintain control.
- Monitor execution results and adjust your database user profile as needed.
These capabilities build on the public preview described in the Azure updates feed and the detailed Microsoft Learn documentation GitHub Copilot Agent Mode (Preview).