Skip to main content
Glama
sdebruyn

fabric-dw-mcp-cli

by sdebruyn

set_audit_retention

Set the audit log retention period for a Fabric data warehouse or SQL endpoint without toggling audit on/off. Specify workspace, warehouse, and number of days (1-3650).

Instructions

Update the audit log retention period without changing the audit enabled/disabled state.

Audit must already be enabled; if disabled, enable it first with enable_audit.

CAUTION: The pre-flight GET used to round-trip the existing action-group list is eventually consistent and may lag a recent PATCH by several minutes. If the action-group list was changed within that window, this call may silently revert it. Space audit writes at least a few minutes apart.

Args: workspace: Workspace name or GUID. warehouse: Warehouse or SQL analytics endpoint name or GUID. days: Retention period in days (1-3650). The API enforces its own upper bound.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
daysYes
warehouseYes
workspaceYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Behavior5/5

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

Discloses important behavioral traits: that it does not toggle audit state, and the caution about eventual consistency potentially reverting recent action-group changes. With no annotations provided, the description fully carries the burden of transparency.

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

Conciseness4/5

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

Well-structured with clear sections: purpose, prerequisite, caution, and parameter list. Slightly lengthy due to caution detail but remains efficient and readable.

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

Completeness4/5

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

Covers prerequisites, side effects, and parameter details. Output schema exists but is not shown; description does not mention return value, but given output schema, this is acceptable. Overall complete for intended use.

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

Parameters4/5

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

Adds meaning for all three parameters (workspace, warehouse, days) beyond the schema, specifying data types and constraints. Schema description coverage is 0%, so the description compensates well, though could include examples or format hints.

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 clearly states the specific action: 'Update the audit log retention period without changing the audit enabled/disabled state.' This distinguishes it from sibling tools like enable_audit or disable_audit.

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

Usage Guidelines5/5

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

Explicitly states prerequisite ('Audit must already be enabled; if disabled, enable it first with enable_audit') and provides a caution about eventual consistency, giving clear guidance on when and how to use the tool.

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