From finops-toolkit
Analyzes Azure cloud costs on FinOps hubs using KQL queries in Azure Data Explorer. Handles trends, anomalies, recommendations, deployments, and operations via structured agent framework.
How this skill is triggered — by the user, by Claude, or both
Slash command
/finops-toolkit:finops-toolkitThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
- **Cost Analysis:** #codebase → #azmcp-kusto-query
README.mdreferences/docs-mslearn/TOC.ymlreferences/docs-mslearn/best-practices/compute.mdreferences/docs-mslearn/best-practices/databases.mdreferences/docs-mslearn/best-practices/general.mdreferences/docs-mslearn/best-practices/library.mdreferences/docs-mslearn/best-practices/networking.mdreferences/docs-mslearn/best-practices/storage.mdreferences/docs-mslearn/best-practices/web.mdreferences/docs-mslearn/conduct-iteration.mdreferences/docs-mslearn/fabric/create-fabric-workspace-finops.mdreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/endpoints-page-storage-account.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/exports-cost-and-usage-focus.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-create-workspace.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-lakehouse-copy-path-load-table.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-load-table-lakehouse.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-new-lakehouse.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-new-more-options.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-new-shortcut-connection-settings.pngreferences/docs-mslearn/fabric/media/create-fabric-workspace-finops/fabric-new-shortcut.pngTHINK → PLAN → VERIFY → EXECUTE → VALIDATE
graph LR
A[Request] --> B{Think & Analyze}
B --> C[Validate Schema]
C --> D[Select Tool]
D --> E[Execute]
E --> F[Format Results]
F --> G[Deliver Insights]
Example: "Why are costs increasing?"
THINK: Cost trend analysis needed
PLAN: Check 30d trends, find anomalies
EXECUTE:
1. Query: cost-anomaly-detection.kql
2. Found: Storage +250% (day 15 spike)
3. Cause: New backup policy
4. Impact: +$5,000/month
5. Fix: Adjust retention → Save $3,000
Confidence: [High/Medium/Low]
Scope: [Time period, filters]
💰 [Key finding with primary metric]
[1-2 paragraphs with data table]
# Auto-retry up to 3x with fixes:
- Schema errors → verify & fix columns
- Timeouts → add filters & optimize
- Syntax → auto-correct
- Access → guide permissions
1. STOP operations
2. DOCUMENT error
3. NOTIFY user
4. PROVIDE workaround
## ⚠️ Clarification Needed
I need more information:
- Time period? (default: 30 days)
- Scope? (default: all resources)
[Specify or proceed with defaults]
references/queries/INDEX.mdFinOps hubs query and deployment skills. Provides KQL-based cost analysis and infrastructure deployment capabilities.
Always read references/finops-hubs.md before attempting any FinOps hubs queries or analysis. Use references/queries/INDEX.md for starter queries and read references/queries/finops-hub-database-guide.md before attempting to create your own queries.
Always read references/finops-hubs-deployment.md before attempting any FinOps hubs infrastructure deployment.
KQL queries for FinOps hubs analysis:
| Resource | Path | Purpose |
|---|---|---|
| Index | references/queries/INDEX.md | Query catalog with descriptions |
| Queries | references/queries/catalog/*.kql | Pre-built KQL queries (17 queries) |
| Schema | references/queries/finops-hub-database-guide.md | Database schema documentation |
| Domain | Purpose | Key Operations |
|---|---|---|
| finops-hubs | Query cost data via KQL | Kusto queries, anomaly detection, forecasting |
| finops-hubs-deployment | Deploy/manage hubs infrastructure | ADX clusters, Fabric, exports, Power BI |
Prerequisites: Load this skill before using the azure-mcp-server kusto command.
Key Facts:
Costs(), Prices(), Recommendations(), Transactions()tenant parameter for cross-tenant scenariosQuery Execution:
{
"cluster-uri": "<cluster-uri from .ftk/environments.local.md>",
"database": "Hub",
"tenant": "<tenant from .ftk/environments.local.md>",
"query": "<KQL query>"
}
Configuration: Read environment settings from .ftk/environments.local.md at the project root. Use the default environment unless the user specifies one. See references/settings-format.md for the file format.
For detailed documentation: references/finops-hubs.md
Deployment targets:
Key commands: az deployment, az kusto, az storage
For detailed documentation: references/finops-hubs-deployment.md
Load the appropriate reference file when detailed workflows, API examples, or troubleshooting are needed.
| File | Description |
|---|---|
| references/finops-hubs.md | Domain knowledge for cost analysis: KQL execution, anomaly detection, savings optimization, and FinOps Framework-aligned reporting. Read before any cost query. |
| references/finops-hubs-deployment.md | Deployment and configuration of FinOps hub infrastructure: ADX clusters, Fabric, Data Factory, exports, Key Vault, and Power BI dashboards. |
| references/settings-format.md | Format specification for .ftk/environments.local.md — named environments with cluster-uri, tenant, subscription, and resource-group. |
| references/queries/INDEX.md | Query catalog with scenario-to-query matrix, parameter docs, and usage guidance for all 17 pre-built KQL queries. |
| references/queries/finops-hub-database-guide.md | Hub database schema: Costs(), Prices(), Recommendations(), Transactions() functions, column definitions, enrichment columns, and query best practices. Read before writing custom KQL. |
| references/workflows/ftk-hubs-connect.md | Step-by-step workflow to discover FinOps hub instances via Resource Graph, connect, and save environment config. |
| references/workflows/ftk-hubs-healthCheck.md | Health check workflow: version comparison against stable/dev releases, upgrade guidance, and diagnostic steps. |
| Query | Description |
|---|---|
| costs-enriched-base.kql | Base query with full enrichment and savings logic for all cost columns. Start here for custom analytics. |
| monthly-cost-trend.kql | Total billed and effective cost by month for trend analysis and executive reporting. |
| monthly-cost-change-percentage.kql | Month-over-month cost change percentage for both billed and effective costs. |
| top-services-by-cost.kql | Top N Azure services by cost. Key for cost visibility. |
| top-resource-types-by-cost.kql | Top N resource types by cost and usage (VMs, storage, etc.). |
| top-resource-groups-by-cost.kql | Top N resource groups by effective cost. |
| quarterly-cost-by-resource-group.kql | Effective cost by resource group for quarterly or multi-month reporting. |
| cost-by-region-trend.kql | Effective cost by Azure region for regional cost driver analysis. |
| cost-by-financial-hierarchy.kql | Cost allocation by billing profile, invoice section, team, product, and app for showback/chargeback. |
| cost-anomaly-detection.kql | Detect unusual cost spikes or drops using statistical anomaly detection. |
| cost-forecasting-model.kql | Project future costs for budgeting and planning with configurable forecast horizon. |
| service-price-benchmarking.kql | Compare list, contracted, effective, negotiated, and commitment prices by service. |
| commitment-discount-utilization.kql | Reservation and savings plan utilization analysis for rate optimization. |
| savings-summary-report.kql | Total realized savings and Effective Savings Rate (ESR) KPI. |
| top-commitment-transactions.kql | Top N reservation or savings plan purchases by cost impact. |
| top-other-transactions.kql | Top N non-commitment, non-usage transactions (support, marketplace, etc.). |
| reservation-recommendation-breakdown.kql | Microsoft reservation recommendations with projected savings and break-even analysis. |
Official Microsoft documentation for FinOps and the FinOps toolkit. Source: learn.microsoft.com.
| File | Description |
|---|---|
| overview.md | Microsoft Cloud FinOps overview |
| implementing-finops-guide.md | Guide to implementing FinOps in Azure |
| conduct-iteration.md | Conducting a FinOps iteration |
| File | Description |
|---|---|
| finops-framework.md | FinOps Framework overview |
| capabilities.md | FinOps capabilities reference |
| File | Description |
|---|---|
| understand-cloud-usage-cost.md | Understand pillar overview |
| ingestion.md | Data ingestion |
| allocation.md | Cost allocation |
| reporting.md | Reporting and analytics |
| anomalies.md | Anomaly management |
| File | Description |
|---|---|
| quantify-business-value.md | Quantify pillar overview |
| planning.md | Planning and estimating |
| budgeting.md | Budgeting |
| forecasting.md | Forecasting |
| benchmarking.md | Benchmarking |
| unit-economics.md | Unit economics |
| File | Description |
|---|---|
| optimize-cloud-usage-cost.md | Optimize pillar overview |
| architecting.md | Architecting for cloud |
| workloads.md | Workload optimization |
| rates.md | Rate optimization |
| licensing.md | Licensing and SaaS |
| sustainability.md | Cloud sustainability |
| File | Description |
|---|---|
| manage-finops.md | Manage pillar overview |
| onboarding.md | FinOps onboarding |
| education.md | FinOps education and enablement |
| operations.md | FinOps operations |
| governance.md | FinOps and governance |
| assessment.md | FinOps assessment |
| invoicing-chargeback.md | Invoicing and chargeback |
| tools-services.md | Tools and services |
| intersecting-disciplines.md | Intersecting disciplines |
| File | Description |
|---|---|
| what-is-focus.md | What is FOCUS (FinOps Open Cost and Usage Specification) |
| mapping.md | FOCUS column mapping |
| metadata.md | FOCUS metadata |
| convert.md | Converting data to FOCUS |
| validate.md | Validating FOCUS data |
| conformance-summary.md | FOCUS conformance summary |
| conformance-full-report.md | FOCUS conformance full report |
| File | Description |
|---|---|
| general.md | General cost optimization best practices |
| compute.md | Compute cost optimization |
| databases.md | Database cost optimization |
| networking.md | Networking cost optimization |
| storage.md | Storage cost optimization |
| web.md | Web and app service cost optimization |
| library.md | Best practices library |
| File | Description |
|---|---|
| finops-toolkit-overview.md | FinOps toolkit overview |
| changelog.md | Toolkit changelog |
| roadmap.md | Toolkit roadmap |
| open-data.md | Open data (pricing units, regions, services, resource types) |
| data-lake-storage-connectivity.md | Data lake storage connectivity |
| File | Description |
|---|---|
| finops-hubs-overview.md | FinOps hubs overview |
| deploy.md | Deploy FinOps hubs |
| upgrade.md | Upgrade FinOps hubs |
| template.md | Hub Bicep template reference |
| data-model.md | Hub database data model. Read for authoritative schema reference. |
| data-processing.md | Data processing pipeline |
| savings-calculations.md | Savings calculations methodology |
| compatibility.md | Version compatibility matrix |
| configure-scopes.md | Configure cost export scopes |
| configure-dashboards.md | Configure dashboards |
| configure-remote-hubs.md | Configure remote hubs |
| configure-ai.md | Configure AI copilot for FinOps hubs |
| private-networking.md | Private networking configuration |
| File | Description |
|---|---|
| finops-alerts-overview.md | FinOps alerts overview |
| configure-finops-alerts.md | Configure FinOps alerts |
| File | Description |
|---|---|
| modules.md | Bicep registry modules |
| scheduled-actions.md | Scheduled actions module |
| File | Description |
|---|---|
| overview.md | Optimization engine overview |
| setup-options.md | Setup options |
| configure-workspaces.md | Configure workspaces |
| customize.md | Customize the optimization engine |
| reports.md | Optimization reports |
| suppress-recommendations.md | Suppress recommendations |
| troubleshooting.md | Troubleshooting |
| faq.md | Frequently asked questions |
| File | Description |
|---|---|
| reports.md | Power BI reports overview |
| setup.md | Power BI setup |
| connector.md | FinOps toolkit Power BI connector |
| template-app.md | Power BI template app |
| help-me-choose.md | Help me choose a Power BI report |
| cost-summary.md | Cost summary report |
| rate-optimization.md | Rate optimization report |
| workload-optimization.md | Workload optimization report |
| governance.md | Governance report |
| data-ingestion.md | Data ingestion report |
| invoicing.md | Invoicing report |
| File | Description |
|---|---|
| finops-workbooks-overview.md | FinOps workbooks overview |
| customize-workbooks.md | Customize workbooks |
| optimization.md | Optimization workbook |
| governance.md | Governance workbook |
| File | Description |
|---|---|
| create-fabric-workspace-finops.md | Create a Fabric workspace for FinOps |
| File | Description |
|---|---|
| powershell-commands.md | PowerShell commands overview |
| File | Description |
|---|---|
| cost-management-commands.md | Cost Management commands overview |
| get-finopscostexport.md | Get-FinOpsCostExport |
| new-finopscostexport.md | New-FinOpsCostExport |
| start-finopscostexport.md | Start-FinOpsCostExport |
| remove-finopscostexport.md | Remove-FinOpsCostExport |
| add-finopsserviceprincipal.md | Add-FinOpsServicePrincipal |
| File | Description |
|---|---|
| open-data-commands.md | Open data commands overview |
| get-finopspricingunit.md | Get-FinOpsPricingUnit |
| get-finopsregion.md | Get-FinOpsRegion |
| get-finopsresourcetype.md | Get-FinOpsResourceType |
| get-finopsservice.md | Get-FinOpsService |
| File | Description |
|---|---|
| finops-hubs-commands.md | FinOps hubs commands overview |
| deploy-finopshub.md | Deploy-FinOpsHub |
| get-finopshub.md | Get-FinOpsHub |
| initialize-finopshubdeployment.md | Initialize-FinOpsHubDeployment |
| register-finopshubproviders.md | Register-FinOpsHubProviders |
| remove-finopshub.md | Remove-FinOpsHub |
| remove-finopshubscope.md | Remove-FinOpsHubScope |
| File | Description |
|---|---|
| finops-toolkit-commands.md | Toolkit commands overview |
| get-finopstoolkitversion.md | Get-FinOpsToolkitVersion |
| File | Description |
|---|---|
| help-options.md | Help options |
| support.md | Support |
| troubleshooting.md | Troubleshooting |
| errors.md | Error reference |
| deploy.md | Deployment help |
| data-dictionary.md | Data dictionary |
| terms.md | Terms and definitions |
| contributors.md | Contributors |
npx claudepluginhub msbrettorg/maenifold --plugin finops-toolkitExpert FinOps guidance for cloud, AI, and SaaS spend across AWS, Azure, GCP, Databricks, Snowflake, and more. Includes commitment management, rightsizing, cost allocation, and AI cost optimization.
Provides expert guidance on Azure Cost Management: budgets/alerts, cost exports, reservations/savings plans, billing accounts, RBAC for cost data, and cost optimization best practices.
Queries Azure historical costs by service/resource/tag, forecasts spending, and suggests optimizations like rightsizing VMs or finding unused resources.