SQL MCP Server
Data API builder-based MCP server for safe, deterministic agent access to SQL databases.
What it does
Connects agents to SQL Server, Azure SQL or Fabric SQL through a configured entity layer, so they can describe schemas and read or change data with controlled operations.
What an agent can do with it
- describe entities
- read records
- create records
- update and delete records
How to set it up
Run Data API builder with MCP enabled locally, in containers or Azure; configure a connection string.
Full steps: Microsoft's documentation.
Use cases that use it
Quarterly user access review reminders and evidence collection
Remind system owners to review who has access each quarter, collect their sign-off, and assemble… Read →
Security & compliance · Google Sheets · Google Drive · Slack or Microsoft TeamsPhishing-report inbox triage for small teams
Sort emails staff forward as suspicious, summarize the warning signs, and queue them by urgency for… Read →
Security & compliance · Google Workspace or Microsoft 365 shared mailbox · Claude · SlackEmployee offboarding access removal checklist
When someone leaves, an agent builds an access removal checklist from the app inventory, tracks… Read →
Security & compliance · Google Workspace · Microsoft 365 · AirtableMulti-factor authentication coverage gap report
A monthly report that checks which users and key business apps have multi-factor authentication… Read →
Security & compliance · Google Workspace · Microsoft 365 · OktaSources
Descriptions are written by Agents Lookup unless marked as quoted. Each link opens the original.
- MCP documentation: aka.ms/sql/mcp (checked 2026-11-19)
- Microsoft list where it appears: github.com/microsoft/mcp