# My Favorite Undocumented Feature in SQL MCP Server

DevFeed: [My Favorite Undocumented Feature in SQL MCP Server](<https://devfeed.tech/articles/my-favorite-undocumented-feature-in-sql-mcp-server-115915.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/sql-mcp-server-hidden-feature-default-configuration/>)

Author: Jerry Nixon

Published: 2026-11-03T21:29:25Z

Content type: article

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Undocumented feature](<https://devfeed.tech/topics/undocumented-feature.md>)

Tags: [aca](<https://devfeed.tech/tags/aca.md>), [aci](<https://devfeed.tech/tags/aci.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [aks](<https://devfeed.tech/tags/aks.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-container-apps](<https://devfeed.tech/tags/azure-container-apps.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [container](<https://devfeed.tech/tags/container.md>), [container-apps](<https://devfeed.tech/tags/container-apps.md>), [data-api-builder](<https://devfeed.tech/tags/data-api-builder.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [docker](<https://devfeed.tech/tags/docker.md>), [feature](<https://devfeed.tech/tags/feature.md>), [mcp](<https://devfeed.tech/tags/mcp.md>), [mcp-server](<https://devfeed.tech/tags/mcp-server.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [server](<https://devfeed.tech/tags/server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-mcp-server](<https://devfeed.tech/tags/sql-mcp-server.md>)

## AI overview

The Data API builder 2.0 container image includes a default configuration that exposes tables through `autoentities`; setting `DAB_CONNSTRING` supplies or overrides its database connection string, enabling a quick MCP proof of concept without a custom configuration file or image. The excerpt gives deployment examples for Docker, Azure Container Apps Express (in preview), regular Container Apps, ACI, and AKS. The default configuration is intended for development: it enables Swagger and Nitro, allows anonymous health endpoint access, and grants anonymous users all CRUD operations, including mutations. The author cautions against using it in production without changing those settings.

## Source excerpt

Deploy Microsoft's SQL MCP Server in minutes without a configuration file. Learn how DAB_CONNSTRING enables fast deployment using Docker, Azure Container Apps, ACI, or AKS. The post My Favorite Undocumented Feature in SQL MCP Server appeared first on Azure SQL Dev Corner.