Skip to main content
Glama
sdebruyn

fabric-dw-mcp-cli

by sdebruyn

create_statistics

Creates a single-column statistic on a warehouse table to enable efficient query plans. Use FULLSCAN or sample percentage to control accuracy.

Instructions

Create a single-column statistic on a table.

Only supported on Data Warehouses (SQL Analytics Endpoints are read-only). Only single-column statistics are supported (Fabric limitation).

Args: workspace: Workspace name or GUID. item: Warehouse name or GUID. SQL Analytics Endpoints are rejected. qualified_table: Qualified table name, e.g. dbo.sales. column: Column name to build the statistic on. stat_name: Name for the new statistic. fullscan: When True (default), use WITH FULLSCAN. Ignored when sample_percent is provided. sample_percent: Sample percentage (1-100). When provided, overrides fullscan and uses WITH SAMPLE n PERCENT.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
itemYes
columnYes
fullscanNo
stat_nameYes
workspaceYes
sample_percentNo
qualified_tableYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the disclosure burden. It explains the Fabric single-column limitation, the SQL Analytics Endpoints read-only restriction, and the fullscan/sample_percent override interaction. It does not discuss permissions, overwrite behavior, or failure modes, but it covers the most material behavioral constraints.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is front-loaded with the core purpose and key limitations, then organized into a clear Args block. Each parameter receives one concise line. The slight repetition of the SQL Analytics Endpoints restriction is acceptable because it appears at both overview and parameter-specific levels.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a create operation, the description covers platform support, supported statistic type, parameter semantics, and scan/sample behavior. An output schema exists, so return-value details are not required here. The remaining gaps, such as duplicate-handling and permission requirements, are minor compared to the completeness of the provided context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must compensate. It documents all seven parameters, adds practical meaning (workspace name or GUID, warehouse selectivity, qualified table example, sample_percent overrides fullscan), and clarifies how fullscan and sample_percent interact beyond the raw schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb and resource: 'Create a single-column statistic on a table.' It immediately distinguishes itself from sibling statistics tools (list/update/delete/show) by stating the single-column scope and the Data Warehouse target. The purpose is unambiguous.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives clear when/where context: only Data Warehouses are supported, SQL Analytics Endpoints are read-only and rejected, and only single-column statistics are possible. It does not name alternative tools such as update_statistics or show_statistics, so it falls just short of explicit alternative routing.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/sdebruyn/fabric-dw-mcp-cli'

If you have feedback or need assistance with the MCP directory API, please join our Discord server