Data and Analytics, Microsoft Sessions, Cutting-Edge AI

T12 SQL MCP Server: Bringing AI Agents to Your SQL Data

07/28/2026

1:30pm - 2:45pm

Level: Intermediate

Bob Ward

Principal Architect, Microsoft Azure Data

Microsoft

You've built the databases. You've protected them. Now everyone wants AI to talk to them — and they're looking at you to make it happen. SQL MCP Server is how you do it safely. Built on Data API builder (DAB), it creates a governed bridge between AI tools like GitHub Copilot and your SQL Server, Azure SQL, or Fabric SQL Database using the Model Context Protocol (MCP). You decide what gets exposed — tables, views, stored procedures — through a typed, RBAC-enforced layer that agents query without ever touching raw SQL. We'll dig into how it works under the hood, walk through the security controls you already care about, and show you how your existing SQL skills are exactly what's needed to put AI to work on your data.