Microsoft Fabric MCP Server

1. list_workspaces

List all available Fabric workspaces.

2. set_workspace

Set the current workspace context for the session.

3. list_lakehouses

List all lakehouses in a workspace.

4. create_lakehouse

Create a new lakehouse.

5. set_lakehouse

Set current lakehouse context.

6. list_warehouses

List all warehouses in a workspace.

7. create_warehouse

Create a new warehouse.

8. set_warehouse

Set current warehouse context.

9. list_tables

List all tables in a lakehouse.

10. get_lakehouse_table_schema

Get schema for a specific table.

11. get_all_lakehouse_schemas

Get schemas for all tables in a lakehouse.

12. set_table

Set current table context.

13. get_sql_endpoint

Get SQL endpoint for lakehouse or warehouse.

14. run_query

Execute SQL queries.

15. load_data_from_url

Load data from URL into tables.

16. list_reports

List all reports in a workspace.

17. get_report

Get specific report details.

18. list_semantic_models

List semantic models in workspace.

19. get_semantic_model

Get specific semantic model.

20. list_notebooks

List all notebooks in a workspace.

21. get_notebook_content

Retrieve notebook content.

22. update_notebook_cell

Update specific notebook cells.

23. create_pyspark_notebook

Create notebooks from basic templates.

24. create_fabric_notebook

Create Fabric-optimized notebooks.

25. generate_pyspark_code

Generate code for common operations.

26. generate_fabric_code

Generate Fabric-specific code.

27. validate_pyspark_code

Validate PySpark code syntax and best practices.

28. validate_fabric_code

Validate Fabric compatibility.

29. analyze_notebook_performance

Comprehensive performance analysis.

30. clear_context

Clear current session context.

{ "mcp": { "servers": { "ms-fabric-mcp": { "type": "stdio", "command": "<FullPathToProjectFolder>\\.venv\\Scripts\\python.exe", "args": ["<FullPathToProjectFolder>\\fabric_mcp.py"] } } } }