S08E24 - Giving AI Agents Safe Access to Your Data: SQL MCP Server with Jerry Nixon
Principal Product Manager Jerry Nixon returns to The Modern .NET Show to discuss SQL MCP Server: an MCP server that exposes your database’s data plane to AI agents, built on the very same engine as Data API Builder — which has just reached 2.0 general availability. Together, Jamie and Jerry look at why natural-language-to-SQL is so tempting and so dangerous, how a deterministic query builder keeps agents honest, why on-behalf-of authentication matters for your audit trail, and how just seven built-in tools keep an LLM’s context window manageable whether your database has ten tables or ten thousand. Along the way they cover embeddings, chunking, and a look ahead at the semantic search features arriving next.
dotnetcore.show