Data API builder

The MSSQL extension for Visual Studio Code includes an integrated UI for

Data API builder

,

so you can create REST, GraphQL, and MCP endpoints for your SQL database tables without

writing configuration files or leaving Visual Studio Code. You can select which tables to expose,

configure CRUD permissions, choose API types, preview the generated configuration, and

deploy a local backend powered by Data API builder, all from a visual interface.

Data API builder integration offers these capabilities:





Tip

Data API builder is currently in preview and might change based on feedback. Join the

community at

to share ideas or report issues.

）

Important

This feature has known limitations, including SQL authentication-only support for

container deployment and restricted data type compatibility. Review

and

before deploying.