Data API builder

 Data API builder

Quickstart: Use Data API builder with SQL

https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart/mssql

What is SQL MCP Server?

https://learn.microsoft.com/en-us/azure/data-api-builder/mcp/overview#how-to-configure-sql-mcp-server

https://github.com/Azure/data-api-builder

dotnet --version

dotnet tool install microsoft.dataapibuilder -g

dab --version

echo "my-connection-string=$env:database_connection_string" > .env

dab init --database-type mssql --connection-string "@env('my-connection-string')"  --host-mode development

dab add Todo --source "dbo.Todo" --permissions "anonymous:*"

dab start

http://localhost:5000

GET http://localhost:5000/api/Todo

DAB’s Health endpoint: http://localhost:5000/health

DAB’s Swagger UI: http://localhost:5000/swagger

DAB’s Nitro UI: http://localhost:5000/graphql