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 skills add PatrickGallucci/fabric-skills --skill fabric-onelake-perf-remediategit clone --depth 1 https://github.com/PatrickGallucci/fabric-skillsWrote 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/skills/patrickgallucci/fabric-skills/fabric-onelake-perf-remediate)<a href="https://agentmods.dev/skills/patrickgallucci/fabric-skills/fabric-onelake-perf-remediate"><img src="https://agentmods.dev/badge/skills/patrickgallucci/fabric-skills/fabric-onelake-perf-remediate/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/patrickgallucci/fabric-skills/fabric-onelake-perf-remediate"><img src="https://agentmods.dev/badge/skills/patrickgallucci/fabric-skills/fabric-onelake-perf-remediate.svg" alt="Reviewed on agentmods" width="80" 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.1 | $0.00109 | $0.01634 |
| Opus 5 | $0.00055 | $0.00817 |
| Sonnet 5 | $0.00022 | $0.00327 |
| Haiku 4.5 | $0.00011 | $0.00163 |
Grade A, and why
fabric-onelake-perf-remediate 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 12d 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 — 133 lines — stays where its author put it; the contents beside it link to each section on GitHub.
OneLake Performance remediate
Systematic diagnostic and remediation toolkit for Microsoft Fabric OneLake performance issues. Covers the full stack from capacity-level throttling down to individual Delta table file layout problems.
When to Use This Skill
- OneLake read or write operations are slow or timing out
- Lakehouse or warehouse queries have unexpectedly high latency
- Spark jobs are being throttled with HTTP 430 errors
- Delta tables have accumulated many small files (small file problem)
- Direct Lake semantic models are falling back to DirectQuery
- Cold cache performance is significantly slower than warm cache
- Cross-region data access is adding network latency
- V-Order is not applied or needs to be enabled/disabled
- Table maintenance (OPTIMIZE, VACUUM) is failing or not improving performance
- Capacity utilization is high and jobs are queuing
Prerequisites
- Microsoft Fabric workspace with Contributor or higher role
- Access to the Monitoring Hub in the Fabric portal
- PowerShell 7+ with Az.Fabric module (for automation scripts)
- Familiarity with Spark SQL or T-SQL for diagnostic queries
Diagnostic Decision Tree
Follow this sequence to isolate the root cause:
1. Is the issue capacity-level? → Check Spark VCore utilization and queue depth
2. Is the issue cold cache? → Check data_scanned_remote_storage_mb
3. Is the issue file layout? → Check small file count and V-Order status
4. Is the issue cross-region? → Verify data and capacity are co-located
5. Is the issue query design? → Check string column widths, partition pruning
Step-by-Step Workflows
Workflow 1: Diagnose Capacity Throttling
When Spark jobs fail with HTTP 430 (TooManyRequestsForCapacity):
- Open the Monitoring Hub in the Fabric portal
- Check active Spark sessions against your SKU's VCore limit (1 CU = 2 Spark VCores)
- Review the queue depth against your SKU's queue limit (see capacity-sku-reference.md)
- Cancel unnecessary jobs or scale up the capacity SKU
- For burst workloads, use the spark-capacity-check.ps1 script to monitor utilization
What ships with it
16 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
- LICENSE.txt 11 KB
- references/capacity-sku-reference.md 3.0 KB
- references/cold-cache-diagnostics.md 4.3 KB
- references/direct-lake-troubleshooting.md 4.0 KB
- references/onelake-consumption-optimization.md 7.8 KB
- references/onelake-diagnostics-guide.md 7.7 KB
- references/onelake-shortcuts-performance.md 7.8 KB
- references/table-maintenance-workflow.md 4.9 KB
- references/v-order-decision-guide.md 4.8 KB
- scripts/region-latency-test.ps1 5.0 KB runs code
- scripts/run-table-maintenance.ps1 7.2 KB runs code
- scripts/spark-capacity-check.ps1 5.0 KB runs code
- scripts/table-health-check.ps1 5.0 KB runs code
- scripts/Test-OneLakeHealth.ps1 11 KB runs code
- templates/diagnostic-report.md 2.1 KB
- templates/onelake-performance-checklist.md 4.8 KB
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.
- 12d ago First seen · 133 lines · 109 tokens per session scan A 9d378f349ea6
fabric-onelake-perf-remediate is a skill published in the GitHub repository PatrickGallucci/fabric-skills (16 stars, last pushed 3mo ago), licensed MIT. It adds 109 tokens to every session and 1,634 once invoked, about $0.0005 per session on Opus 5. 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-30.
Other skills, from other repositories
data-integrity-post-normalize
Apply a composable pipeline of normalization operations to a string. Trim whitespace, fix encoding, normalize unicode, strip HTML, and more — in a single call.
multai
Intelligent Multi-AI Router & Orchestrator. Submits prompts to 7 AI platforms simultaneously (or sequentially in Cowork) and synthesizes results. Supports two runtimes automatically detected at startup: • Code tab (Mac): Playwright/Browser-Use engine — parallel, full-featured • Cowork tab (Linux sandbox)…
llm-council
Run any question, idea, or decision through a council of 5 AI advisors who independently analyze it, peer-review each other anonymously, and synthesize a final verdict. Based on Karpathy's LLM Council methodology. MANDATORY TRIGGERS: 'council this', 'run the council', 'war room this', 'pressure-test this'…
umap-learn
Use UMAP-learn for nonlinear dimensionality reduction, 2D/3D embeddings, clustering preprocessing, supervised or semi-supervised UMAP, DensMAP, AlignedUMAP, and Parametric UMAP workflows.
optimize-for-gpu
GPU-accelerates scientific Python on NVIDIA hardware and verifies that the result is correct and faster. Use for CUDA/GPU optimization; CPU-bound NumPy, SciPy, pandas, scikit-learn, NetworkX, scikit-image, vector-search, image-processing, graph, simulation, or file-I/O workloads; CuPy, cuDF, cuML, cuGraph, cuVS…
torchdrug
Build and troubleshoot TorchDrug 0.2.1 workflows for molecular graphs, property prediction, self-supervised pretraining, molecule generation, retrosynthesis, protein representation learning, and knowledge graph reasoning. Use when code imports torchdrug or needs its datasets, models, tasks, or Engine.