finops-toolkit

This skill should be used when the user asks about "FinOps hubs", "FinOps toolkit", "KQL queries", "Kusto", "cost data analysis", "Hub database", "Costs function", "Prices function", "Recommendations function", "FinOps hubs deployment", "Azure Data Explorer", "ADX cluster", or any FinOps hubs operations.

Jump to install

Repository: microsoft/finops-toolkit
Last source activity: August 13, 2026 at 05:52
Detected SKILL.md language: English
Stars: 599
Forks: 242

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/microsoft/finops-toolkit --skill finops-toolkit

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

16 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

FinOps Toolkit

FinOps hubs are a scalable platform for cloud cost analytics, insights, and optimization built on Azure Data Explorer (Kusto) or Microsoft Fabric RTI. This skill covers KQL-based cost analysis and hub infrastructure deployment.

Task routing

Load only the references relevant to the task at hand.

Maintainer note: The references in this table intentionally use shorthand skill paths for readability. They are not a claim that the plugin contains literal toolkit/..., focus/..., or bare .kql files next to SKILL.md.

FinOps Toolkit

Task routing

Load only the references relevant to the task at hand.

name	finops-toolkit
description	This skill should be used when the user asks about "FinOps hubs", "FinOps toolkit", "KQL queries", "Kusto", "cost data analysis", "Hub database", "Costs function", "Prices function", "Recommendations function", "FinOps hubs deployment", "Azure Data Explorer", "ADX cluster", or any FinOps hubs operations.
license	MIT
compatibility	Requires Azure MCP Server and Azure CLI authentication. For queries, requires Database Viewer access to FinOps hub ADX cluster.
metadata	{"author":"microsoft","version":"1.0"}

name	finops-toolkit
description	This skill should be used when the user asks about "FinOps hubs", "FinOps toolkit", "KQL queries", "Kusto", "cost data analysis", "Hub database", "Costs function", "Prices function", "Recommendations function", "FinOps hubs deployment", "Azure Data Explorer", "ADX cluster", or any FinOps hubs operations.
license	MIT
compatibility	Requires Azure MCP Server and Azure CLI authentication. For queries, requires Database Viewer access to FinOps hub ADX cluster.
metadata	{"author":"microsoft","version":"1.0"}

Task	Load these references first
Write or run a KQL query	`references/finops-hubs.md`, `references/queries/finops-hub-database-guide.md`
Use a pre-built query	`references/queries/INDEX.md`, then the specific `.kql` file
Deploy a new hub	`references/finops-hubs-deployment.md`, `toolkit/hubs/deploy.md`, `toolkit/hubs/template.md`
Upgrade a hub	`references/finops-hubs-deployment.md`, `toolkit/hubs/upgrade.md`, `toolkit/hubs/compatibility.md`
Savings / ESR analysis	`toolkit/hubs/savings-calculations.md`, `savings-summary-report.kql`, `commitment-discount-utilization.kql`
Reservation recommendations	`reservation-recommendation-breakdown.kql`, `toolkit/hubs/savings-calculations.md`
FOCUS columns / mapping	`focus/what-is-focus.md`, `focus/mapping.md`
Power BI setup	`toolkit/power-bi/setup.md`, `toolkit/power-bi/connector.md`
Troubleshooting / errors	`toolkit/help/troubleshooting.md`, `toolkit/help/errors.md`
PowerShell commands	`toolkit/powershell/powershell-commands.md` + the specific command file
Connect to hub for first time	`/ftk/hubs-connect`, `references/settings-format.md`
Check hub health / version	`/ftk/hubs-health-check`, `toolkit/hubs/compatibility.md`

Function	Purpose	Key columns
`Costs()`	Cost and usage analytics (FOCUS-aligned)	`BilledCost`, `EffectiveCost`, `ContractedCost`, `ListCost`, `ServiceName`, `ResourceName`, `Tags`
`Prices()`	Price sheets with list, contracted, and effective pricing	`ListUnitPrice`, `ContractedUnitPrice`, `x_EffectiveUnitPrice`, `PricingUnit`
`Recommendations()`	Reservation and savings plan recommendations	`x_EffectiveCostBefore`, `x_EffectiveCostAfter`, `x_EffectiveCostSavings`
`Transactions()`	Commitment purchases, refunds, and exchanges	`BilledCost`, `ChargeCategory`, `x_SkuTerm`, `x_TransactionType`

Query	Description
costs-enriched-base.kql	Base query with full enrichment and savings logic for all cost columns. Use for scoped row-level custom analytics or repeated drill-downs.
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.
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 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.
reservation-recommendation-breakdown.kql	Microsoft reservation recommendations with projected savings and break-even analysis.

finops-toolkit

Install options

Review the source files

FinOps Toolkit

Task routing

FinOps Toolkit

Task routing

Database functions

Query execution

Query catalog

Infrastructure deployment

Reference files

Microsoft Learn documentation

FinOps overview

FinOps Framework

Understand Usage & Cost

Quantify business value

Optimize cloud usage and cost

Manage the FinOps practice

FOCUS

Cost optimization best practices

FinOps toolkit

FinOps hubs

Alerts

Bicep registry

Optimization engine

Power BI

Workbooks

Fabric

PowerShell commands

Cost Management commands

Open data commands

FinOps hubs commands

Toolkit commands

Help and support

File	Description
references/finops-hubs.md	Analysis guide: KQL execution, query catalog protocol, tool matrix, performance rules. Read before any cost query.
references/finops-hubs-deployment.md	Deployment and configuration: ADX clusters, Fabric, Data Factory, exports, Key Vault, 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 the shipped pre-built KQL queries.
references/queries/finops-hub-database-guide.md	Hub database schema: all four functions, column definitions, enrichment columns, and query best practices. Read before writing custom KQL.

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	Usage 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	Usage 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
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

finops-toolkit

Source facts

Install options

Review the source files

FinOps Toolkit

Task routing

FinOps Toolkit

Task routing

Database functions

Query execution

Query catalog

Infrastructure deployment

Reference files

Microsoft Learn documentation

FinOps overview

FinOps Framework

Understand Usage & Cost

Quantify business value

Optimize cloud usage and cost

Manage the FinOps practice

FOCUS

Cost optimization best practices

FinOps toolkit

FinOps hubs

Alerts

Bicep registry

Optimization engine

Power BI

Workbooks

Fabric

PowerShell commands

Cost Management commands

Open data commands

FinOps hubs commands

Toolkit commands

Help and support