Introducing Agent mode in SQL Server Management Studio (SSMS) | Data Exposed
Microsoft launched Agent mode in SQL Server Management Studio, bringing multi-step Copilot automation via MCP to SSMS.
“Agent mode is let's have Copilot do more, right? So, what are the complex, multi-step kind of scenarios that I can offload and let Copilot do on my behalf.”
Microsoft introduced Agent mode in SQL Server Management Studio, extending Copilot from single-shot 'ask mode' to autonomous multi-step database tasks powered by an MCP integration, with GPT-5 models restored and new usage-based billing. It matters as a sign of agentic AI moving into mainstream database administration tooling, though it is an incremental product feature rather than a major industry shift.