VS Code Live: Build AI-Ready Apps in VS Code: GitHub Copilot, Schema Designer, Data API builder

Carlos Robles demonstrates new capabilities in the MSSQL extension for VS Code, including spec-driven development with GitHub Copilot, AI-assisted schema design with Schema Designer, and generating REST and GraphQL endpoints using Data API builder and MCP to get from a spec to a running API inside the editor.

Overview

The session focuses on building an “AI-ready” API workflow directly in Visual Studio Code using the MSSQL extension and related tooling.

What’s covered

• Using GitHub Copilot to support spec-driven development workflows.
• Using Schema Designer for AI-assisted database schema design.
• Using Data API builder to generate and run instant APIs over data:
  • REST endpoints
  • GraphQL endpoints
• Using MCP in the workflow (as referenced in the session description) alongside Data API builder.

Links shared

• Demos: https://aka.ms/vscode-mssql-demos
• Blog: https://aka.ms/vscode-mssql-blogs
• GitHub Repo: https://aka.ms/vscode-mssql-repo
• Docs: https://aka.ms/vscode-mssql-docs
• Extension: https://aka.ms/vscode-mssql
• GitHub Copilot FAQ: https://copilot.github.trust.page/faq

Featuring

• Reynald Adolphe
• Carlos Robles