Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add commands/sdebruyn/fabric-dw-mcp-cli/statisticsgit clone --depth 1 https://github.com/sdebruyn/fabric-dw-mcp-cliWrote 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.
[](https://agentmods.dev/commands/sdebruyn/fabric-dw-mcp-cli/statistics)<a href="https://agentmods.dev/commands/sdebruyn/fabric-dw-mcp-cli/statistics"><img src="https://agentmods.dev/badge/commands/sdebruyn/fabric-dw-mcp-cli/statistics.svg" alt="Measured on agentmods" height="20"></a>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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00000 | $0.01663 |
| Opus 5 | $0.00000 | $0.00831 |
| Sonnet 5 | $0.00000 | $0.00333 |
| Haiku 4.5 | $0.00000 | $0.00166 |
Grade A, and why
statistics 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 5d 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.
How it starts
The opening of the file, as written. The whole thing — 205 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Statistics
Manage user-defined statistics on Fabric Data Warehouses and read their details on SQL Analytics Endpoints.
Targets: Data Warehouse / SQL Analytics Endpoint
!!! note
Only **single-column, histogram-based** statistics can be created or updated (Fabric limitation). Multi-column statistics are not supported.
CLI
statistics create
Targets: Data Warehouse only
Create a new single-column statistic.
fdw [-w WORKSPACE] statistics create [ITEM] --table schema.table --column COL --name NAME [OPTIONS]
| Option | Description | Default |
|---|---|---|
--table schema.table |
Qualified table name (required). | - |
--column COL |
Column name to build the statistic on (required). Single column only. | - |
--name NAME |
Statistic name (required). | - |
--fullscan |
Use WITH FULLSCAN (default). Mutually exclusive with --sample-percent. |
on |
--sample-percent N |
Sample N% of the table (1–100). Overrides --fullscan. |
- |
statistics delete
Targets: Data Warehouse only
Drop a statistic via DROP STATISTICS. Prompts for confirmation unless --yes is passed.
fdw [-w WORKSPACE] statistics delete [ITEM] QUALIFIED_TABLE STAT_NAME
statistics list
Targets: Data Warehouse / SQL Analytics Endpoint
List statistics on an item.
fdw [-w WORKSPACE] statistics list [ITEM] [OPTIONS]
| Option | Description | Default |
|---|---|---|
--schema NAME |
Filter by schema name. | (all schemas) |
--table NAME |
Filter by table name (unqualified). | (all tables) |
--user-only |
Only show user-created statistics. | off |
--auto-only |
Only show auto-created statistics. | off |
statistics show
Targets: Data Warehouse / SQL Analytics Endpoint
Show details of a named statistic using DBCC SHOW_STATISTICS. Returns the stat header, density vector, and histogram steps.
fdw [-w WORKSPACE] statistics show [ITEM] QUALIFIED_TABLE STAT_NAME [OPTIONS]
QUALIFIED_TABLE must be a dot-separated qualified name, e.g. dbo.sales.
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.
- 5d ago First seen · 205 lines · 0 tokens per session scan A 9c102c08f682
statistics 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 1,663 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.
Other commands, from other repositories
generate-crud
Tu es un développeur Symfony senior. Tu dois générer un CRUD complet respectant la Clean Architecture, incluant Entity, Repository, Controller, Templates, Form, et Tests.
optimize-doctrine
Optimisation Requêtes Doctrine.
migrate
Generate and manage database migrations.
check_schema_version
Check the Flyway schema version of the SQLite database on a Docker volume.
generate-model
Génération Model SQLAlchemy.
sql_schema
Command "sql_schema" from agentis-tools/ctx, covering ctx sql — public schema (v1), stability contract, views, v1.symbols — one row per symbol and v1.edges — one row per relationship.