Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

mk_sunitha

Explore, edit, and organize Item definitions and Fabric MCP server in VS Code

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 


We have been iterating quickly on the Fabric extension for Visual Studio Code to make it easier to explore and work with Fabric items directly from your editor. Here’s a quick roundup of what is new with Microsoft Fabric extension in VS Code.

Browse workspace folders

Folders are now accessible within the workspace, allowing you to examine the contents of each folder in detail. This makes it much easier to understand how your Fabric content is organized without leaving VS Code.

Explore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_CodeExplore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_Code

AI-generated content may be incorrect." />

Figure: View folders and items within the folder.

View Fabric item definitions

The extension now supports viewing and editing item definitions from within VS Code. By default, you cannot edit the item definition and it’s in read-only mode.

Edit Fabric item definitions

Update the Fabric extension settings to allow editing. Make your changes, and to save them, select File > Save. Saved changes will update your Fabric item in your workspace. Be sure to make these changes carefully incorrect values can break your Fabric item.

Explore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_CodeExplore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_Code

AI-generated content may be incorrect." />

Figure: Enable ‘Edit item definitions’ in Fabric extension settings.

Fabric MCP server for GitHub Copilot chat

The Fabric MCP server is available as pre-release version. If you also have the Fabric extension and GitHub Copilot Chat extension installed, you will be prompted to enable Fabric MCP server extension if it’s not installed. This provides you with access to the Fabric MCP tools within GitHub Copilot chat and tailored experience for working with various Fabric artifacts.

Explore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_CodeExplore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_Code

AI-generated content may be incorrect." />

Figure: Prompted to install Fabric MCP extension.

Example

Explore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_CodeExplore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_Code

AI-generated content may be incorrect." />

Figure: Write a design doc for implementing Medallion architecture in Fabric.

Use Fabric agent mode

When you’re developing VS Code, switch to Fabric agent mode to get a more tailored experience. This is especially helpful for tasks like understanding an item definition; working with Fabric REST APIs; accessing Microsoft Fabric documentation; and creating updating, deleting, and listing items in your tenant.

Explore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_CodeExplore_edit_and_organize_Item_definitions_and_Fabric_MCP_server_in_VS_Code

AI-generated content may be incorrect." />

Figure: Use Fabric agent mode.

To view all the tools available, refer to Microsoft MCP tools on GitHub. Share feedback by creating an issue in this repo for Fabric MCP server.

The table includes example prompts to get started:

Category Prompt
Perform CRUD operations I need to test OneLake file operations. In Workspace1, create a "DataLakehouse" lakehouse. Upload a CSV file from <local path> with sample sales data to that directory. List the contents to verify the upload.

OR

I want to create and run a new notebook, called SampleNotebook in Workspace1 workspace. Add a markdown cell with the title “Sample Notebook". Add a Python cell that prints "Hello, Fabric!".

Generate specs and plan Create a design document for data analytics architecture in Microsoft Fabric for my sales project using Medallion Architecture. Provide recommendations for each layer (Bronze, Silver, and Gold) on what item types to use for storing and processing the data. Also include a detailed execution plan.

Share your feedback

If you run into issues or have suggestions for what you’d like to see next, please share your feedback with us on GitHub. Install the Microsoft Fabric extension today to start exploring.

Comments