MSSQL Extension for VS Code: Fabric Integration (Preview)
The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more integrated, more consistent, and more developer friendly. In version v1.36.0, Fabric Connectivity (Browse) and SQL Database in Fabric Provisioning — two capabilities that bring Microsoft Fabric directly into your local development workflow inside Visual Studio Code.
Fabric Connectivity (Preview)
The MSSQL extension for Visual Studio Code now includes Fabric connectivity, making it easier than ever to browse and connect to your Fabric workspaces directly from your development environment. This new integration eliminates the friction of connection strings and brings Fabric resources into the familiar VS Code experience.
With this update, you can authenticate once, browse all your workspaces in an intuitive tree view, and establish connections to your Fabric resources in just a few clicks—all without leaving VS Code.
Key highlights
- Dedicated Fabric Experience: A new Fabric connection type joins the existing Parameters and Azure options in the connection dialog, providing a purpose-built interface for Fabric users.
- Seamless Authentication: Leverage Microsoft Entra ID for secure, one-click authentication with persistent sign-in that remembers your credentials across sessions.
- Intelligent Workspace Browsing: Explore all your Fabric workspaces in an intuitive view that loads all your resources on-demand for optimal performance.
- Smart Search & Discovery: Find workspaces quickly with real-time search that brings the most relevant results to the top.
SQL database in Fabric Provisioning (Preview)
With Fabric Provisioning, you can now create SQL databases in Fabric without leaving VS Code. The new provisioning flow allows you to authenticate, select or create a workspace, name your database, and connect instantly—all in under three minutes.
By bringing provisioning directly into the Deployments page, this experience eliminates the need to use the Fabric Portal or Azure Portal, reducing context switching and making early prototyping significantly faster.
Key highlights
- Simple Provisioning Flow: Authenticate, select or create a workspace, name your database, and create.
- Immediate Connection: The new database is automatically added to your connections for instant querying.
- Consistent Experience: Provisioning flow aligns with other backend options, like local SQL Server containers.
- Capacity Awareness: Disabled workspaces are clearly shown with guidance if capacity isn’t available.
Conclusion
By making it simple to connect to Fabric resources and provision databases directly from VS Code, the MSSQL extension continues to simplify the way developers build and manage modern applications. Combined with ongoing performance, usability, and reliability improvements, this update further positions the extension as the easiest way to get started with SQL Server, Azure SQL, and now Fabric, all without leaving your editor.
If there’s something you’d love to see in a future update, here’s how you can contribute:
- GitHub discussions – Share your ideas and suggestions to improve the extension.
- New feature requests – Request missing capabilities and help shape future updates.
- Report bugs – Help us track down and fix issues to make the extension more reliable.
Thanks for being part of the journey—happy coding!
