procedures

procedures is a command for Claude Code from sdebruyn/fabric-dw-mcp-cli. It costs 0 tokens per session (2,045 once invoked), scanned A, original, MIT.

A set of commands for creating, inspecting, updating, and deleting stored procedures in Microsoft Fabric Data Warehouses and SQL Analytics Endpoints. A stored procedure is saved SQL code that can be run by name.

In plain words
What is it for?
Use it to create procedures from a body or file, retrieve their definitions, update them, and safely drop them when needed.
Why use it?
It lets you manage reusable database operations from inline SQL or SQL files instead of editing each procedure manually.

Command for Claude Code

Written for Claude Code: a Claude Code command (commands/*.md).

Not installable on its own: it runs a file from its repository that does not travel with it. Clone the repository, or install whatever ships that file. The line is --from-file ./procs/usp_archive_orders_v2.sql.

Install

Getting it into your agent

There is no command for this one: it runs only inside a plugin, and the catalogue could not identify which plugin ships it. The source is linked below.

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for procedures

README.md
[![agentmods](https://agentmods.dev/badge/commands/sdebruyn/fabric-dw-mcp-cli/procedures.svg)](https://agentmods.dev/commands/sdebruyn/fabric-dw-mcp-cli/procedures)
Your own site
<a href="https://agentmods.dev/commands/sdebruyn/fabric-dw-mcp-cli/procedures"><img src="https://agentmods.dev/badge/commands/sdebruyn/fabric-dw-mcp-cli/procedures.svg" alt="Measured on agentmods" height="20"></a>
Per session 0 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 2,045 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00000 $0.02045
Opus 5 $0.00000 $0.01022
Sonnet 5 $0.00000 $0.00409
Haiku 4.5 $0.00000 $0.00204

Measured 6d ago against content hash ecc132a5d44b, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

procedures scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 6d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

docs/commands/procedures.md · 277 lines

How it starts

The opening of the file, as written. The whole thing — 277 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Stored procedures

Manage stored procedures on Microsoft Fabric Data Warehouses and SQL Analytics Endpoints.

Targets: Data Warehouse / SQL Analytics Endpoint

CLI

procedures create

Targets: Data Warehouse / SQL Analytics Endpoint

Create a new stored procedure.

Synopsis

fdw [-w WORKSPACE] procedures create [OPTIONS] [ITEM]
Option Description
--name SCHEMA.PROC Required. Qualified procedure name (e.g. dbo.usp_load_sales).
--body TEXT Inline procedure body (the AS … section).
--from-file PATH Path to a .sql file containing the procedure body.

Exactly one of --body or --from-file must be provided.

Example

fdw -w MyWorkspace procedures create SalesWH \
  --name dbo.usp_archive_orders \
  --body "BEGIN INSERT INTO dbo.archive SELECT * FROM dbo.orders; END"

procedures drop

Targets: Data Warehouse / SQL Analytics Endpoint

Drop a stored procedure. You will be asked to confirm unless --yes is passed.

Synopsis

fdw [-w WORKSPACE] procedures drop [ITEM] QUALIFIED_NAME

Example

fdw -w MyWorkspace --yes procedures drop SalesWH dbo.usp_archive_orders

procedures get

Targets: Data Warehouse / SQL Analytics Endpoint

Get the full definition of a single stored procedure.

Synopsis

fdw [-w WORKSPACE] procedures get [ITEM] QUALIFIED_NAME

QUALIFIED_NAME must be a dot-separated schema.proc_name string, e.g. dbo.usp_load_sales.

Example

fdw -w MyWorkspace procedures get SalesWH dbo.usp_load_sales

procedures list

Targets: Data Warehouse / SQL Analytics Endpoint

List stored procedures on a warehouse or SQL Analytics Endpoint. Pass --schema to filter to a single schema.

Synopsis

fdw [-w WORKSPACE] procedures list [OPTIONS] [ITEM]
Option Description
--schema TEXT Only list procedures in this schema.

Example

fdw -w MyWorkspace procedures list SalesWH --schema dbo

Read the full file on GitHub · 277 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 6d ago First seen · 277 lines · 0 tokens per session scan A ecc132a5d44b

Subscribe to this mod's changes

procedures is a command published in the GitHub repository sdebruyn/fabric-dw-mcp-cli (10 stars, last pushed 2d ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 2,045 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.