2026-NET-Days-SQL

Guide for .NET Aspire orchestration of SQL Server + Data API Builder + SQL Commander + MCP Inspector. Use when asked to create an Aspire-based DAB environment.

Add SQL Commander to a .NET Aspire AppHost for browsing and querying SQL Server. Use when asked to add a SQL query tool, browse database tables, or configure SQL Commander in Aspire.

Docker Compose orchestration of SQL Server, Data API Builder, SQL Commander, and MCP Inspector. Use when asked to create docker-compose.yml, set up local containers, or run DAB without Aspire.

Add MCP Inspector to a .NET Aspire AppHost for debugging MCP servers such as Data API Builder.

Create and audit GitHub Copilot Agent Skills with clear discovery descriptions, correct SKILL.md frontmatter, and reusable multi-step workflows.

Use Data API Builder CLI to initialize, add/update entities, validate config, and run DAB. Use when asked to create or modify dab-config.json via CLI commands.

Create and refine dab-config.json for Data API Builder, including data-source, runtime, entities, permissions, relationships, and MCP settings.

Enable and secure Data API Builder MCP endpoints so AI agents can query databases through DAB tools. Use when asked to set up /mcp, client config, or MCP tool restrictions.