Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition
Microsoft Developer — Jun 30, 2026 — tutorial
Why watch
This episode demonstrates how to give GitHub Copilot controlled access to SQL Server using two MCP server implementations: a custom server with 30 DMV-powered tools for DBA operations like diagnosing blocking and checking AG health, and Data API Builder for zero-code natural language access to application data with permission controls. Ideal for developers and DBAs looking to integrate AI agents with SQL Server while maintaining security guardrails.