Data API Builder and SQL MCP with Jerry Nixon

Data API Builder and SQL MCP with Jerry Nixon

From RunAs Radio by Richard Campbell

June 3, 2026 · 37 min · Episode 1039

About this episode

Richard Campbell interviews Jerry Nixon about Data API Builder, a Microsoft tool for providing secure access to databases.

How do you intelligently surface access to your database? While at NDC Toronto, Richard spoke with Jerry Nixon about Data API Builder, Microsoft's tool that enables data professionals using Microsoft databases, including SQL Server, Postgres, CosmosDB, and MySQL, to provide an API layer with security, schema extraction, and governance policies. You can expose the API as a REST interface, a GraphQL interface, and an MCP server! This is a powerful tool for providing controlled access to data while still allowing for ad-hoc access. The potential is huge - you need to check it out!

People in this episode

Host: Richard Campbell

Guest: Jerry Nixon

Topics covered

  • Data API
  • Database Access
  • Microsoft Tools
  • API Layer
  • Security
  • Governance

Keywords

  • Data API Builder
  • SQL Server
  • Postgres
  • CosmosDB
  • MySQL
  • API security
  • GraphQL
  • REST interface

Mentioned in this episode

Organizations: Microsoft

Products: Data API Builder, SQL Server, Postgres, CosmosDB, MySQL

More episodes of RunAs Radio

Explore listener stats, chart rankings, contacts and more on the RunAs Radio podcast page.