Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition

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.