--- title: Giving AI agents visibility into SQL Server with MCP |... description: A demonstration of using Model Context Protocol (MCP) to give AI agents visibility into SQL Server for DBA tasks. Two MCP servers are built: one exposing 28... canonical: https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition | daily.dev og:description: A demonstration of using Model Context Protocol (MCP) to give AI agents visibility into SQL Server for DBA tasks. Two MCP servers are built: one exposing 28... og:url: https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd og:image: https://api.daily.dev/og/posts/FSf58H1Pd.png og:image:alt: Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition **[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 22 min read · 0 upvotes · 0 comments ## Summary A demonstration of using Model Context Protocol (MCP) to give AI agents visibility into SQL Server for DBA tasks. Two MCP servers are built: one exposing 28 DMV-based tools for DBA monitoring (health snapshots, wait stats, availability groups, fleet-wide queries), and another using Microsoft's Data API Builder to expose application database tables via REST for natural language queries. The setup runs via Docker Compose and integrates with GitHub Copilot in VS Code using Claude. Key themes include controlling what agents can execute (read-only vs. write access), fan-out parallel queries across multiple SQL Server instances, and the importance of guardrails when giving agents access to production systems. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#docker](https://daily.dev/tags/docker), [#ai-agents](https://daily.dev/tags/ai-agents), [#mcp](https://daily.dev/tags/mcp), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server) [View this post on daily.dev](https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition","url":"https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd"},"datePublished":"2026-06-30T16:13:14.472Z","dateModified":"2026-06-30T16:13:36.824Z","description":"A demonstration of using Model Context Protocol (MCP) to give AI agents visibility into SQL Server for DBA tasks. Two MCP servers are built: one exposing 28...","image":"https://i.ytimg.com/vi/tLAfkruOOWo/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/tLAfkruOOWo/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Microsoft Developer","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Microsoft Developer","logo":"https://media.daily.dev/image/upload/s--xZzU3zUq--/f_auto/v1746714872/logos/microsoftdeveloper","url":"https://daily.dev/sources/microsoftdeveloper"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/giving-ai-agents-visibility-into-sql-server-with-mcp-data-exposed-mvp-edition-fsf58h1pd","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"docker,ai-agents,mcp,microsoft-sql-server","timeRequired":"PT22M","video":{"@type":"VideoObject","name":"Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition","description":"A demonstration of using Model Context Protocol (MCP) to give AI agents visibility into SQL Server for DBA tasks. Two MCP servers are built: one exposing 28...","thumbnailUrl":"https://i.ytimg.com/vi/tLAfkruOOWo/sddefault.jpg","uploadDate":"2026-06-30T16:13:14.472Z","duration":"PT22M","url":"https://api.daily.dev/r/FSf58H1Pd","embedUrl":"https://www.youtube.com/embed/tLAfkruOOWo"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Microsoft Developer","item":"https://daily.dev/sources/microsoftdeveloper"},{"@type":"ListItem","position":3,"name":"Giving AI agents visibility into SQL Server with MCP | Data Exposed MVP Edition"}]} ```