Generally Available: GitHub Copilot integration in Schema Designer for the MSSQL extension

The GitHub Copilot integration with Schema Designer is now generally available in the MSSQL extension for Visual Studio Code, expanding the visual schema design experience with AI-assisted capabilities. Based on developer feedback and evolving workflows, this integration enables you to explore, design, and modify database schemas using natural language.

You can describe the tables or changes you want, and GitHub Copilot plans and generates proposed updates inside Schema Designer. Each schema change is previewed visually, color-coded, and tracked in a dedicated Change Tracking panel with familiar source control-style labels such as Add (A), Modify (M), and Delete (D). You can clearly differentiate between your own edits and AI-generated suggestions, inspect detailed modifications, and review changes before they are applied.

Moreover, Schema Designer now supports ORM script generation for migration, helping you move from visual schema changes to migration-ready scripts more efficiently. Whether you’re starting a new project or updating an existing one, this guided experience helps you move confidently from an idea to a validated data model.

From there, you can continue into Data API builder in the MSSQL extension, where GitHub Copilot plans and generates back-end endpoints from your schema. Together, these experiences give you an end-to-end path from database design to a working back end in minutes.

Learn more.