The MSSQL extension for Visual Studio Code now introduces Data API builder in public preview with built-in GitHub Copilot integration, bringing a guided back-end generation experience directly into your development workflow. You can generate REST, GraphQL, and MCP endpoints from your SQL database schema inside Visual Studio Code without manually configuring infrastructure or connection strings.
You select tables, define CRUD operations, and configure per-entity settings such as authorization roles, and primary keys, and route behavior through a dedicated API design interface. The generated Data API builder configuration file stays synchronized with your selections, can be previewed directly in the extension, and can be added to your workspace for full transparency and version control. You can modify the configuration manually or use GitHub Copilot to plan and generate updates.
With just a few steps, the extension provisions and runs a local Data API builder container using your existing database connection context. This guided experience helps you move from validated schema to a working back end in minutes, enabling you to build modern, AI-ready, secure applications faster without switching tools or losing control.