// MCP TOOL REFERENCE

FORCE FABRIC MCP SERVER TOOLS

33 tools from the Force Fabric MCP Server MCP Server, categorised by risk level.

View the Force Fabric MCP Server policy →
// ALL 33 FORCE FABRIC MCP SERVER TOOLS
READ 17 tools
Read auth_status Check if you are currently authenticated to Microsoft Fabric. Read eventhouse_list List all eventhouses in a Fabric workspace with their query/ingestion URIs and KQL database counts. Read eventhouse_list_kql_databases List all KQL databases in a Fabric workspace. Read eventhouse_optimization_recommendations LIVE SCAN: Connects to a Fabric Eventhouse KQL endpoint and runs real diagnostic commands. Read fabric_optimization_report Generate a comprehensive optimization report for an entire Fabric workspace. Read gateway_list List all gateways with their status, version, type, and VNet configuration. Read gateway_list_connections List all connections with their connectivity type, gateway binding, and privacy level. Read gateway_optimization_recommendations LIVE SCAN: Scans all gateways and connections with 12 rules covering availability (online status, connectiv... Read lakehouse_get_job_status Check the status of a table maintenance job on a Fabric Lakehouse. Read lakehouse_list List all lakehouses in a Fabric workspace with their metadata, SQL endpoint status, and OneLake paths. Read lakehouse_list_tables List all tables in a Fabric Lakehouse with their type, format (Delta/Parquet), and location. Read lakehouse_optimization_recommendations LIVE SCAN: Analyzes a Fabric Lakehouse by checking table formats (Delta vs non-Delta), Read semantic_model_list List all semantic models in a Fabric workspace. Read warehouse_list List all warehouses in a Fabric workspace with their metadata and connection details. Read workspace_capacity_info List Fabric capacities with their SKU, state, and region. Includes capacity optimization tips. Read workspace_list List all Fabric workspaces you have access to with their IDs, types, and capacity assignments. Read workspace_list_items List all items in a Fabric workspace, optionally filtered by type (Lakehouse, Warehouse,
WRITE 1 tools
Write semantic_model_auto_optimize AUTO-OPTIMIZE: Applies all 19 safe fixes to a Semantic Model using XMLA/TMSL commands
DESTRUCTIVE 1 tools
Destructive auth_logout Logout from Microsoft Fabric and clear cached credentials.
EXECUTE 13 tools
Execute lakehouse_run_table_maintenance Run table maintenance (OPTIMIZE with V-Order, Z-ORDER, VACUUM) on a Fabric Lakehouse. Execute eventhouse_auto_optimize AUTO-OPTIMIZE: Scans a Fabric Eventhouse for all fixable issues across all KQL databases and applies fixes. Execute eventhouse_fix AUTO-FIX: Applies fixes to a Fabric Eventhouse. Execute eventhouse_fix_materialized_views AUTO-FIX: Diagnoses and repairs broken materialized views in a Fabric Eventhouse. Execute gateway_fix AUTO-FIX: Applies fixes to gateway and connection issues. Execute lakehouse_auto_optimize AUTO-OPTIMIZE: Discovers ALL Delta tables in a Lakehouse and applies fixes to every table Execute lakehouse_fix AUTO-FIX: Applies Spark SQL fixes to a Lakehouse via Livy API (no notebooks needed). Execute semantic_model_fix AUTO-FIX: Uses XMLA/TMSL commands for atomic per-object fixes (measures, columns, tables). Execute semantic_model_optimization_recommendations LIVE SCAN: Connects to a Fabric Semantic Model and executes DAX queries (COLUMNSTATISTICS) Execute warehouse_analyze_query_patterns LIVE SCAN: Connects to a Fabric Warehouse SQL endpoint and analyzes real query execution Execute warehouse_auto_optimize AUTO-OPTIMIZE: Scans a Fabric Warehouse for all fixable issues and applies all safe fixes automatically. Execute warehouse_fix AUTO-FIX: Connects to a Fabric Warehouse and applies fixes for detected issues. Execute warehouse_optimization_recommendations LIVE SCAN: Connects to a Fabric Warehouse SQL endpoint and runs real diagnostic queries.
OTHER 1 tools
Other auth_login Login to Microsoft Fabric. MUST be called before using any other tool.

Route Force Fabric MCP Server through PolicyLayer and every one of its 33 tools is checked against your policy before it runs.

CHECK YOUR STACK →

See every tool, the dangerous ones, and the token cost across your stack.

// FAQ
How many tools does the Force Fabric MCP Server MCP server have? +

The Force Fabric MCP Server MCP server exposes 33 tools across 5 categories: Read, Write, Destructive, Execute, Other.

How do I enforce policies on Force Fabric MCP Server tools? +

Route the Force Fabric MCP Server server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Force Fabric MCP Server tools fall into? +

Force Fabric MCP Server tools are categorised as Read (17), Write (1), Destructive (1), Execute (13), Other (1). Each category has a recommended default policy.

Enforce policy on every Force Fabric MCP Server tool call.

Start from Force Fabric MCP Server, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Free to start. No card required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.