Microsoft Fabric
Microsoft Fabric MCP helps you query and manage Fabric workspaces, items, connections, jobs, and SQL Endpoints in Agent Chat.
Basic Information
Authentication
Uses OAuth 2.0 for authentication.
Key Features
- Query, create, update, and delete Fabric workspaces
- Manage workspace role assignments
- Manage workspace items and connections
- Run jobs and manage schedules
- Run T-SQL against Fabric Warehouse or Lakehouse SQL Endpoints
Supported MCP Tools
list_workspaces
Runs the Microsoft Fabric list_workspaces operation.
get_workspace
Runs the Microsoft Fabric get_workspace operation.
create_workspace
Runs the Microsoft Fabric create_workspace operation.
update_workspace
Runs the Microsoft Fabric update_workspace operation.
delete_workspace
Runs the Microsoft Fabric delete_workspace operation.
list_workspace_role_assignments
Runs the Microsoft Fabric list_workspace_role_assignments operation.
add_workspace_role_assignment
Runs the Microsoft Fabric add_workspace_role_assignment operation.
update_workspace_role_assignment
Runs the Microsoft Fabric update_workspace_role_assignment operation.
delete_workspace_role_assignment
Runs the Microsoft Fabric delete_workspace_role_assignment operation.
list_workspace_items
Runs the Microsoft Fabric list_workspace_items operation.
assign_workspace_to_capacity
Runs the Microsoft Fabric assign_workspace_to_capacity operation.
unassign_workspace_from_capacity
Runs the Microsoft Fabric unassign_workspace_from_capacity operation.
provision_workspace_identity
Runs the Microsoft Fabric provision_workspace_identity operation.
list_capacities
Runs the Microsoft Fabric list_capacities operation.
list_connections
Runs the Microsoft Fabric list_connections operation.
get_connection
Runs the Microsoft Fabric get_connection operation.
create_connection
Runs the Microsoft Fabric create_connection operation.
update_connection
Runs the Microsoft Fabric update_connection operation.
delete_connection
Runs the Microsoft Fabric delete_connection operation.
list_supported_connection_types
Runs the Microsoft Fabric list_supported_connection_types operation.
get_item
Runs the Microsoft Fabric get_item operation.
create_item
Runs the Microsoft Fabric create_item operation.
update_item
Runs the Microsoft Fabric update_item operation.
delete_item
Runs the Microsoft Fabric delete_item operation.
get_item_definition
Runs the Microsoft Fabric get_item_definition operation.
update_item_definition
Runs the Microsoft Fabric update_item_definition operation.
list_item_connections
Runs the Microsoft Fabric list_item_connections operation.
run_on_demand_job
Runs the Microsoft Fabric run_on_demand_job operation.
cancel_job_instance
Runs the Microsoft Fabric cancel_job_instance operation.
get_job_instance
Runs the Microsoft Fabric get_job_instance operation.
list_job_instances
Runs the Microsoft Fabric list_job_instances operation.
create_schedule
Runs the Microsoft Fabric create_schedule operation.
get_schedule
Runs the Microsoft Fabric get_schedule operation.
list_schedules
Runs the Microsoft Fabric list_schedules operation.
update_schedule
Runs the Microsoft Fabric update_schedule operation.
delete_schedule
Runs the Microsoft Fabric delete_schedule operation.
get_operation_status
Runs the Microsoft Fabric get_operation_status operation.
get_operation_result
Runs the Microsoft Fabric get_operation_result operation.
execute_sql
Runs the Microsoft Fabric execute_sql operation.
list_sql_endpoints
Runs the Microsoft Fabric list_sql_endpoints operation.
Usage Examples
- “Show me the Fabric workspace list”
- “List the items in this workspace”
- “Run a SELECT query on the Lakehouse SQL Endpoint”
Notes
- To access Microsoft Fabric resources, the Microsoft account must have the required Fabric permissions.
- Some features may require Microsoft Fabric or Power BI API permissions, tenant settings, or administrator roles.
- If Microsoft Entra app permissions change, disconnect and reconnect the existing OAuth connection so the new permissions can take effect.