MCP server for AnalyticDB MySQL via OpenAPI and direct SQL connection
For Microsoft Fabric Analytics is installed from its publisher's own source and answers where it runs, so this marketplace is not in the path of a single call. There is no address here to send one to, and a panel that pretended otherwise would be showing you an answer we made up. Install it and call it from your own client — the Installation tab has the entry for each one.
Open InstallationWhat it does
MCP server for Microsoft Fabric Analytics with Synapse-to-Fabric migration - enables LLMs to access, analyze, and migrate workloads to Microsoft Fabric
Quickstart
# 1 — run it from where its publisher ships it
npx -y mcp-for-microsoft-fabric-analytics
# 2 — ask your agent something
> MCP server for Microsoft Fabric Analytics with Synapse-to-Fabric migration - enables LLMs to access, analyze, and migrate workloads to
For Microsoft Fabric Analytics is free: there is no plan to choose, no cap to set and nothing that can bill you.
Collected from a public index. Nobody has claimed this account, so nothing here was written by its author — claim it if it is yours.
Where are you running it?
Every route below installs the same thing and ends at the same approval screen. This one runs on your machine: your client starts For Microsoft Fabric Analytics as a process under your own user, with your files and your network, so the tool surface below is what it can do to your computer rather than to a server somewhere else. It is scanned, signed and pinned to the version you choose — read the surface before you approve it.
This is a public server: you run it yourself and this marketplace is not in the path. Claude Code registers it in one command.
claude mcp add for-microsoft-fabric-analytics-mcp -- npx -y mcp-for-microsoft-fabric-analyticsReconnect, or start a new session, and the tools appear in the model’s tool list.
One config entry your client uses to start the process locally. A local server runs with your file system and your network, which is why it is priced without metering.
82 tools, with what each one reads, writes and reaches shown before you agree — the same list on every route above. Read the tool surface.
Tool surface
What the model actually sees. Descriptions are diffed on every release — see version history.
Execute a query against a Microsoft Fabric dataset
Takes no parameters.
Retrieve analytics metrics for Microsoft Fabric items
Takes no parameters.
Analyze a Microsoft Fabric data model and get optimization recommendations
Takes no parameters.
Generate a comprehensive analytics report for Microsoft Fabric workspace
Takes no parameters.
List all available Fabric capacities
Takes no parameters.
Assign a workspace to a dedicated Fabric capacity
Takes no parameters.
Unassign a workspace from its capacity (move to shared capacity)
Takes no parameters.
List all workspaces assigned to a specific capacity
Takes no parameters.
List all Azure Synapse Analytics workspaces in your Azure subscription. Returns workspace names, IDs, locations, and resource groups to help you identify workspaces for migration.
Takes no parameters.
Discover and inventory all assets from an Azure Synapse Analytics workspace including notebooks, pipelines, linked services, and Spark job definitions. Returns detailed inventory for migration planning.
Takes no parameters.
Transform Synapse notebooks to Fabric-compatible format. Converts mssparkutils → notebookutils, rewrites paths, and removes Synapse-specific configurations. Can run in dry-run mode to preview changes without applying them.
Takes no parameters.
Takes no parameters.
Create a new lakehouse in a Microsoft Fabric workspace. Lakehouses provide unified storage for both structured and unstructured data with Delta Lake support.
Takes no parameters.
Provision transformed notebooks to a Microsoft Fabric workspace. Takes transformed notebook JSON from the transform tool and creates them in the target workspace.
Takes no parameters.
Assign a Fabric capacity to a workspace. Auto-selects the largest available capacity if not specified.
Takes no parameters.
Get Synapse Spark pool configurations for migration planning. Returns node sizes, counts, autoscale settings, and Spark versions.
Takes no parameters.
Generate Fabric Spark pool recommendations from Synapse pools using 2:1 VCore conversion (1 Synapse VCore = 2 Fabric VCores).
Takes no parameters.
Get comprehensive details of a Synapse workspace including resource information.
Takes no parameters.
Get compute spend data for a Synapse workspace to help with capacity sizing decisions.
Takes no parameters.
Migrate Synapse Spark pools to equivalent Fabric configurations.
Takes no parameters.
Recommend optimal Fabric capacity SKU based on Synapse compute usage patterns.
Takes no parameters.
List items in a Microsoft Fabric workspace
Takes no parameters.
Create a new item in Microsoft Fabric workspace
Takes no parameters.
Update an existing item in Microsoft Fabric workspace
Takes no parameters.
Delete an item from Microsoft Fabric workspace
Takes no parameters.
Get detailed information about a specific Microsoft Fabric item
Takes no parameters.
Execute a notebook in Microsoft Fabric workspace
Takes no parameters.
Submit a Spark job to run on a Lakehouse
Takes no parameters.
Get the status of a running job
Takes no parameters.
Create a new notebook in Microsoft Fabric workspace using the official API
Takes no parameters.
Get all Spark applications in a workspace for monitoring
Takes no parameters.
Get all Spark applications/sessions for a specific notebook
Takes no parameters.
Get all Spark applications/sessions for a specific Spark job definition
Takes no parameters.
Get all Spark applications/sessions for a specific lakehouse
Takes no parameters.
Get detailed information about a specific Spark application
Takes no parameters.
Cancel a running Spark application
Takes no parameters.
Get detailed information about a specific Spark application from a notebook session
Takes no parameters.
Get jobs for a specific Spark application from a notebook session
Takes no parameters.
Get comprehensive Spark monitoring dashboard for workspace
Takes no parameters.
Get Livy statement status with enhanced performance analysis and recommendations
Takes no parameters.
Analyze Livy session logs with LLM-powered performance insights and recommendations
Takes no parameters.
Analyze Livy statement execution with detailed performance metrics and LLM-powered optimization recommendations
Takes no parameters.
Analyze historical Livy execution patterns with trend analysis and performance insights
Takes no parameters.
List all notebooks in a Microsoft Fabric workspace
Takes no parameters.
Get details of a specific notebook in Microsoft Fabric workspace
Takes no parameters.
Update an existing notebook in Microsoft Fabric workspace
Takes no parameters.
Delete a notebook from Microsoft Fabric workspace
Takes no parameters.
Get the definition/content of a notebook in Microsoft Fabric workspace
Takes no parameters.
Execute/run a notebook in Microsoft Fabric workspace
Takes no parameters.
Create a Spark job instance from a Spark Job Definition
Takes no parameters.
Execute a Spark Job Definition with execution data
Takes no parameters.
Get the status of a Spark job instance
Takes no parameters.
Create a new Livy session for interactive Spark execution
Takes no parameters.
Get the status of a Livy session
Takes no parameters.
List all Livy sessions for a lakehouse
Takes no parameters.
Delete a Livy session
Takes no parameters.
Execute a statement in a Livy session
Takes no parameters.
Get the result of a statement execution
Takes no parameters.
Create a Livy batch job
Takes no parameters.
Get the status of a Livy batch job
Takes no parameters.
Check current authentication status and configuration
Takes no parameters.
List all workspaces accessible to the user
Takes no parameters.
Find workspace by name and get its ID for use in other operations
Takes no parameters.
Create a new workspace
Takes no parameters.
Create a new Dataflow Gen2 in Microsoft Fabric workspace
Takes no parameters.
List all Dataflow Gen2 in Microsoft Fabric workspace
Takes no parameters.
Get details of a specific Dataflow Gen2
Takes no parameters.
Update Dataflow Gen2 name or description
Takes no parameters.
Delete a Dataflow Gen2 from workspace
Takes no parameters.
Get comprehensive dataflow status with health monitoring and performance metrics
Takes no parameters.
Perform comprehensive health check with scoring, analysis, and recommendations
Takes no parameters.
Get monitoring overview of all dataflows in workspace with health scoring
Takes no parameters.
Generate comprehensive monitoring report with insights and recommendations
Takes no parameters.
Start continuous monitoring session with real-time health checks and alerts
Takes no parameters.
List all active monitoring sessions
Takes no parameters.
Get detailed status of a specific monitoring session
Takes no parameters.
Stop a specific monitoring session
Takes no parameters.
List all runs for a specific Fabric item with analysis
Takes no parameters.
Get detailed information about a specific Fabric item run
Takes no parameters.
List subactivities for a specific Fabric item run with analysis
Takes no parameters.
Get comprehensive monitoring dashboard for recent runs across workspace
Takes no parameters.
Perform detailed performance analysis on a specific run
Takes no parameters.
- Every tool, no call limit
- No card, no account needed
- Source published under a licence you can read
- Runs on your machine — nothing of it reaches our gateway
- Nothing to cap, because nothing bills
What counts against your monthly calls
| Tool | Unit | Calls used | Out of the allowance |
|---|
Nothing here is billable. For Microsoft Fabric Analytics costs nothing to install and nothing to call, at any volume.
Two independent axes, because powerful and malicious are different questions. The grade is threat only. The capability level is blast radius, and it is never a penalty on the grade — it is priced as one subtract-only term in the score, where you can see it.
| Term | Level | What it prices | Points |
|---|---|---|---|
| −6.3 | |||
| capability-exposure | high | capability blast radius (high) — client exposure if the model is manipulated | −6 |
| verification-discount | repo | publisher verification (public source) — no provenance, but the source is public and inspectable | −1 |
| coverage-honesty | source | inspection depth (source) — how much of the target the scan could see | −0 |
What the scan could actually read
A grade is only as meaningful as its coverage, so the scanner publishes its own depth before it publishes its result.
Tools were statically extracted from the published source (78 recovered), not enumerated from a running server. Tool-poisoning, Unicode-smuggling, capability and toxic-flow analysis ran on this inferred surface, but a mis-parsed registration could be missed or mis-attributed, so tool-derived findings are capped below “confirmed”. To grade the real runtime surface, scan the running server: --command "npx -y <package>".
Capability — what it could do if the model were manipulated
Tags derived from each tool’s schema and the implementation, not from what the tool calls itself. high is the level these add up to.
| Tool | Capability tags | Why the tag was assigned |
|---|---|---|
| fabric_list_capacities | no tags | |
| fabric_assign_workspace_to_capacity | no tags | |
| fabric_unassign_workspace_from_capacity | no tags | |
| fabric_list_capacity_workspaces | no tags | |
| fabric_list_synapse_workspaces | no tags | |
| fabric_discover_synapse_workspace | no tags | |
| fabric_transform_notebooks | no tags | |
| fabric_migrate_synapse_to_fabric | no tags | |
| fabric_create_lakehouse | no tags | |
| fabric_provision_notebooks | no tags | |
| fabric_assign_capacity | no tags | |
| fabric_get_synapse_spark_pools | no tags | |
| fabric_create_fabric_spark_pools | no tags | |
| fabric_synapse_workspace_details | no tags | |
| fabric_synapse_compute_spend | no tags | |
| fabric_migrate_spark_pools_to_fabric | no tags | |
| fabric_recommend_fabric_capacity | no tags | |
| list-fabric-items | no tags | |
| create-fabric-item | no tags | |
| update-fabric-item | no tags | |
| delete-fabric-item | no tags | |
| get-fabric-item | no tags | |
| execute-fabric-notebook | no tags | |
| submit-spark-job | no tags | |
| get-job-status | no tags | |
| create-fabric-notebook | no tags | |
| get-workspace-spark-applications | no tags | |
| get-notebook-spark-applications | no tags | |
| get-spark-job-definition-applications | no tags | |
| get-lakehouse-spark-applications | no tags | |
| get-spark-application-details | no tags | |
| cancel-spark-application | no tags | |
| get-notebook-spark-application-details | no tags | |
| get-notebook-spark-application-jobs | no tags | |
| get-spark-monitoring-dashboard | no tags | |
| get-livy-statement-enhanced | no tags | |
| analyze-livy-session-logs | no tags | |
| analyze-livy-statement-performance | no tags | |
| analyze-livy-execution-history | no tags | |
| list-fabric-notebooks | no tags | |
| get-fabric-notebook | no tags | |
| update-fabric-notebook | no tags | |
| delete-fabric-notebook | no tags | |
| get-fabric-notebook-definition | no tags | |
| run-fabric-notebook | no tags | |
| create-spark-job-instance | no tags | |
| execute-spark-job-definition | no tags | |
| get-spark-job-instance-status | no tags | |
| create-livy-session | no tags | |
| get-livy-session | no tags | |
| list-livy-sessions | no tags | |
| delete-livy-session | no tags | |
| execute-livy-statement | no tags | |
| get-livy-statement | no tags | |
| create-livy-batch | no tags | |
| get-livy-batch | no tags | |
| check-fabric-auth-status | no tags | |
| fabric_list_workspaces | no tags | |
| fabric_find_workspace | no tags | |
| fabric_create_workspace | no tags | |
| create-fabric-dataflow | no tags | |
| list-fabric-dataflows | no tags | |
| get-fabric-dataflow | no tags | |
| update-fabric-dataflow | no tags | |
| delete-fabric-dataflow | no tags | |
| monitor-dataflow-status | no tags | |
| perform-dataflow-health-check | no tags | |
| monitor-workspace-dataflows | no tags | |
| generate-dataflow-monitoring-report | no tags | |
| start-continuous-dataflow-monitoring | no tags | |
| list-monitoring-sessions | no tags | |
| get-monitoring-session-status | no tags | |
| stop-monitoring-session | no tags | |
| list-fabric-item-runs | no tags | |
| get-fabric-item-run | no tags | |
| list-fabric-run-subactivities | no tags | |
| monitor-fabric-runs-dashboard | no tags | |
| analyze-fabric-run-performance | no tags |
Toxic-flow graph
The lethal trifecta, checked as a graph rather than as a checklist: untrusted input, a sensitive source and an external sink have to meet before there is a path worth worrying about.
The public result for this release does not print the flow graph, so there is nothing to show here. That is not the same as "no paths were found": what the scan did read is above, under coverage.
Supply chain and provenance
This is the first scan of this surface here, so there is nothing yet to compare it against.
Every result on this tab comes from one deterministic pass over the published package — offline, rule by rule, and auditable line by line above. Same methodology version, same bytes, same score.
Release history
Pinned to 2.0.1 — the install command below asks for that release. A pin is part of an install, so it is kept for this visit and written down when you install.
No release note was published with this version.
Only accounts with at least 50 real tool calls against this server in the last 90 days can post. Ratings are weighted by how much the reviewer actually uses it, and publishers can reply once per review.
Writing one takes an account with at least 50 real tool calls against For Microsoft Fabric Analytics in the last 90 days. That is the whole gate — there is no other way to post, which is why the counts beside each review are worth reading.
Nobody has reviewed this listing. The rating on the card is the mean of the reviews written here and nothing else, so there is no rating until somebody writes the first — which takes an account with 50 real tool calls against it.