Add Azure SQL MCP quickstart with azd deployment templates#1485
Open
kshyju wants to merge 1 commit into
Open
Conversation
…l-mcp`. The sample deploys a hosted `mcp-sql` server in Azure Connector Namespace backed by Azure SQL Database Adds a new Azure SQL MCP sample under `samples/applications/azure-sql-mcp`. The sample deploys a hosted `mcp-sql` server in Azure Connector Namespace backed by Azure SQL Database, using `azd` and Bicep. ### Whatâ��s included - Provisions Azure SQL Database with a seeded `dbo.BlogPosts` table - Deploys Azure Connector Namespace and a hosted SQL MCP server - Configures Data API Builder through the included `dab-config.json` - Passes SQL and Application Insights connection strings as hosted MCP configuration values - Grants the Connector Namespace managed identity access to the SQL database - Adds Application Insights and Log Analytics for telemetry - Includes post-provision scripts for database seeding, firewall setup, and managed identity grants - Provides README instructions for deployment, VS Code MCP setup, Azure Portal inspection, cleanup, and related docs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Summary
Adds a new Azure SQL MCP sample under
samples/applications/azure-sql-mcp. The sample deploys a hostedmcp-sqlserver in Azure Connector Namespace backed by Azure SQL Database, usingazdand Bicep.https://learn.microsoft.com/en-us/azure/logic-apps/connector-namespace/hosted-mcp-quickstart?pivots=sql
What's included
dbo.BlogPoststabledab-config.jsonValidation